aklog: Couldn't determine realm of user:aklog: No credentials cache found while getting realm /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: DanUser defined signal 2 ocevski@nasa.gov) Waiting 166 seconds before starting... Proceeding. Importing modules... This is make3FGLxml version 01r0. The default diffuse model files and names are for pass 8 and assume you have v10r00p05 of the Fermi Science Tools or higher. This is make4FGLDR3xml version 01r09. The default diffuse model files and names are for P8R3, 4FGL DRs, and the default fermitools directory locations. WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/matplotlib/cbook/deprecation.py:106: MatplotlibDeprecationWarning: The mpl_toolkits.axes_grid module was deprecated in version 2.1. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist provies the same functionality instead. warnings.warn(message, mplDeprecation, stacklevel=1) WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). number of points = 7639 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0102.8+5824_daily_bin1730 RA = 15.701, Dec = 58.4092 tmin = 687744001, tmax = 688003201 emin = 100.0, emax = 100000.0 irfs = P8R3_SOURCE_V2 ROI = 12 zmax = 90 Fitting strategies: Fix sources to their catalog values = True Leave variable source normalizations free = True Perform pre-fit where ALL sources are frozen to catalog values = False Perform secondary fit with a free spectral index = True Remove all catalog sources = False Remove weak (TS < 2) catalog sources = False Freeze Galactic component = False Likelihood fit parameters: Statistic: UNBINNED Optimizer: MINUIT Catalog: 4FGL Repository job = True LAT data source: Data catalog Updating database... UPDATE lightcurve_data_v2 SET job_id='471695', job_status='RUN', time_executed='2022-10-21 00:48:14.938757', time_epoch_executed='1666338494.94' WHERE source_name='4FGL J0102.8+5824' and cadence='daily' and bin_id='1730' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/471695 Creating custom pfile directory: /scratch/kocevski/471695/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/471695/ft1_4FGL_J0102.8+5824_daily_bin1730.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Merged file saved to: /scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/471695/ft1_4FGL_J0102.8+5824_daily_bin1730.fits outfile=/scratch/kocevski/471695/ft1_filteredMKT_4FGL_J0102.8+5824_daily_bin1730.fits ra=15.701 dec=58.4092 rad=12.0 tmin=687744001.0 tmax=688003201.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 4.93 user 4.67 sys 0.24 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits sctable="SC_DATA" filter="IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2))" roicut=no evfile=/scratch/kocevski/471695/ft1_filteredMKT_4FGL_J0102.8+5824_daily_bin1730.fits evtable="EVENTS" outfile="/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits" apply_filter=yes overwrite=yes header_obstimes=yes tstart=0.0 tstop=0.0 gtifile="default" chatter=3 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtmktime version HEAD Applying GTI filter: IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2)) real 0.50 user 0.33 sys 0.15 Number of photons that the gtmktime cut: 3228 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits" evtable="EVENTS" scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits sctable="SC_DATA" outfile=/scratch/kocevski/471695/ltcube_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits dcostheta=0.025 binsz=1.0 phibins=0 tmin=0.0 tmax=0.0 file_version="1" zmin=0.0 zmax=90.0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Working on file /scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits .....................! real 11.93 user 11.57 sys 0.33 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits evtable="EVENTS" scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits sctable="SC_DATA" expcube=/scratch/kocevski/471695/ltcube_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits outfile=/scratch/kocevski/471695/expmap_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits irfs="P8R3_SOURCE_V2" evtype="INDEF" srcrad=30.0 nlong=88 nlat=88 nenergies=10 submap=no nlongmin=0 nlongmax=0 nlatmin=0 nlatmax=0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). The exposure maps generated by this tool are meant to be used for *unbinned* likelihood analysis only. Do not use them for binned analyses. Computing the ExposureMap using /scratch/kocevski/471695/ltcube_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits .....................! real 191.51 user 185.92 sys 5.25 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Extended source HB 3 in ROI with RadialDisk spatial model. Extended source W 3 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/W3.fits is the correct path to the extended template. Extended source CTB 109 in ROI with RadialDisk spatial model. Extended source FHES J2304.0+5406 in ROI with RadialGaussian spatial model. Extended source FHES J2208.4+6443 in ROI with RadialGaussian spatial model. Added 196 point sources and 5 extended sources If using unbinned likelihood you will need to rerun gtdiffrsp for the extended sources or rerun the makeModel function with optional argument psForce=True Setting source of interest to: 4FGL J0102.8+5824 @ 15.701 58.4092 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits outfile=/scratch/kocevski/471695/cmap_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=160 nypix=160 binsz=0.25 coordsys="CEL" xref=15.701 yref=58.4092 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.55 user 0.37 sys 0.15 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits outfile=/scratch/kocevski/471695/cmap_HighResolution_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=500 nypix=500 binsz=0.1 coordsys="CEL" xref=15.701 yref=58.4092 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.55 user 0.38 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits evtable="EVENTS" scfile=/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/471695/Model_4FGL_J0102.8+5824_daily_bin1730.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source CTB 109 adding source EG_v02 adding source FHES J2208.4+6443 adding source FHES J2304.0+5406 adding source GAL_V02 adding source HB 3 adding source W 3 Working on... /scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits.....................! real 429.76 user 427.86 sys 1.17 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits', '/scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits', expMap='/scratch/kocevski/471695/expmap_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits', expCube='/scratch/kocevski/471695/ltcube_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/471695/Model_4FGL_J0102.8+5824_daily_bin1730.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0102.8+5824' 4FGL J0102.8+5824 Spectrum: LogParabola 172 norm: 7.100e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 173 alpha: 2.218e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 174 beta: 6.508e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 175 Eb: 9.007e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/471695/ft1_filtered_4FGL_J0102.8+5824_daily_bin1730.fits Spacecraft file(s): /scratch/kocevski/471695/ft2_4FGL_J0102.8+5824_daily_bin1730.fits Exposure map: /scratch/kocevski/471695/expmap_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits Exposure cube: /scratch/kocevski/471695/ltcube_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/471695/Model_4FGL_J0102.8+5824_daily_bin1730.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 30125.4107905 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 30125.3533073 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .68915 1.0000 .0000 .10000E+07 2 'Prefactor ' 16.481 1.0000 .0000 .10000E+07 3 'norm ' .38983E-05 1.0000 .0000 .10000E+07 4 'norm ' .52265E-02 1.0000 .0000 .10000E+07 5 'norm ' .46124E-06 1.0000 .0000 .10000E+07 6 'norm ' .17547E-01 1.0000 .0000 .10000E+07 7 'norm ' .73735E-06 1.0000 .0000 .10000E+07 8 'norm ' .24417E-05 1.0000 .0000 .10000E+07 9 'Prefactor ' .90027E-02 1.0000 .0000 .10000E+07 10 'norm ' 1.4847 1.0000 .0000 .10000E+07 11 'norm ' .64947 1.0000 .0000 .10000E+07 12 'Prefactor ' 3.6811 1.0000 .0000 .10000E+07 13 'Prefactor ' 1.2396 1.0000 .10000E-03 10000. 14 'Normalizat' 1.1495 1.0000 .10000E-01 10.000 15 'Prefactor ' .97852 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6830E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 30125.35 FROM MIGRAD STATUS=CONVERGED 104 CALLS 845 TOTAL EDM= .74E-10 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.1% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .69217 1.2925 -.18232E-06 -.27246E-02 2 Prefactor 19.648 32.609 .23253E-05 .10279E-02 3 norm .0000 1.9265 .17875E-06** at limit ** 4 norm .0000 5.4260 .42080E-06** at limit ** 5 norm .55511E-10 3.0486 .12129E-06** at limit ** 6 norm .0000 12.115 -.31385E-06** at limit ** 7 norm .0000 4.1241 -.90391E-07** at limit ** 8 norm .0000 1.4050 -.28522E-06** at limit ** 9 Prefactor .0000 7.2101 .10354E-06** at limit ** 10 norm 1.4852 1.5656 .45838E-07 .77415E-03 11 norm .65160 .78017 -.84154E-07 -.29680E-02 12 Prefactor 3.6908 3.5596 .75603E-10 -.35634E-03 13 Prefactor 1.2414 .69633 .59134E-06 .23025E-03 14 Normalizat 1.1473 .22871 -.10964E-04 -.66222E-04 15 Prefactor .97817 .29714E-01 .47341E-07 -.16202E-03 ERR DEF= .500 Final values: norm = 0.692175 Prefactor = 19.6484 norm = 0 norm = 0 norm = 5.55112e-11 norm = 0 norm = 0 norm = 0 Prefactor = 0 norm = 1.48523 norm = 0.651601 Prefactor = 3.69076 Prefactor = 1.24144 Normalizat = 1.14731 Prefactor = 0.978166 ********** ** 18 **HESSE ********** FCN= 30125.35 FROM HESSE STATUS=OK 212 CALLS 1057 TOTAL EDM= .25E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .69217 1.3078 .61594E-03 -1.5691 2 Prefactor 19.648 32.617 .24644E-03 -1.5619 3 norm .0000 1.9164 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 norm .0000 5.4176 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 norm .55511E-10 3.0210 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 norm .0000 12.116 .17204E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm .0000 4.0812 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 norm .0000 1.4023 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 Prefactor .0000 7.1905 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 norm 1.4852 1.5511 .88009E-03 -1.5684 11 norm .65160 .79176 .64909E-03 -1.5692 12 Prefactor 3.6908 3.5755 .52618E-03 -1.5670 13 Prefactor 1.2414 .70415 .10072E-01 -1.5485 14 Normalizat 1.1473 .22977 .19097 -.88247 15 Prefactor .97817 .29325E-01 .26572E-01 -.93461 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 2.50435e-06 Minuit parameter uncertainties: 1 1.30781 2 32.6168 3 8.13619e-06 4 2.36142e-05 5 2.15796e-05 6 2.54808e-05 7 6.56642e-06 8 7.85796e-06 9 5.0316e-06 10 1.55107 11 0.791764 12 3.57546 13 0.704159 14 0.229968 15 0.0293254 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 30125.3467104 Extracting fit parameters... 4FGL J0102.8+5824 Spectrum: LogParabola 172 norm: 5.551e-11 2.158e-05 0.000e+00 1.000e+06 ( 1.000e-12) 173 alpha: 2.218e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 174 beta: 6.508e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 175 Eb: 9.007e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 672 Prefactor: 9.782e-01 2.933e-02 0.000e+00 1.000e+01 ( 1.000e+00) 673 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 674 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 663 Normalization: 1.147e+00 2.300e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 15.701 58.409 Photon Flux Upper Limit: 7.80e-08 ph cm-2 s-1 Energy Flux Upper Limit: 3.26e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/471695/likelihoodResults_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 30125.346864 delta logL = -0.000153533692355 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 30125.3467113 delta logL = -8.68967617862e-07 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .59408E-06 1.0000 .0000 .10000E+07 2 'alpha ' 1.5202 1.0000 .0000 5.0000 3 'Normalizat' 1.1471 1.0000 .10000E-01 10.000 4 'Prefactor ' .97818 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6830E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 30125.35 FROM MIGRAD STATUS=CONVERGED 39 CALLS 241 TOTAL EDM= .59E-11 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .0000 2.1134 .42118E-03** at limit ** 2 alpha 2.5998 1.1113 .10432E-04 .0000 3 Normalizat 1.1473 1.1279 -.15299E-04 .10085E-04 4 Prefactor .97817 1.3187 .22883E-05 .34791E-03 ERR DEF= .500 Final values: norm = 0 alpha = 2.5998 Normalizat = 1.14732 Prefactor = 0.978166 ********** ** 18 **HESSE ********** MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 30125.35 FROM HESSE STATUS=FAILED 9 CALLS 250 TOTAL EDM= .59E-11 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .0000 2.1134 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 1.3676 1.2218 .10432E-04 .39932E-01 3 Normalizat 1.1473 1.1279 -.15299E-04 -.88247 4 Prefactor .97817 1.3187 .22883E-05 -.93461 ERR DEF= .500 Minuit fit quality: 1 estimated distance: 5.86039e-12 Minuit parameter uncertainties: 1 1.24167e-06 2 1.15162 3 1.15316 4 1.36632 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/471695': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 101 logL (Free Index) = 30125.3467104 delta logL = 1.45519152284e-11 Extracting fit parameters... 4FGL J0102.8+5824 Spectrum: LogParabola 172 norm: 0.000e+00 1.242e-06 0.000e+00 1.000e+06 ( 1.000e-12) 173 alpha: 2.600e+00 1.152e+00 0.000e+00 5.000e+00 ( 1.000e+00) 174 beta: 6.508e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 175 Eb: 9.007e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 672 Prefactor: 9.782e-01 1.366e+00 0.000e+00 1.000e+01 ( 1.000e+00) 673 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 674 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 663 Normalization: 1.147e+00 1.153e+00 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 15.701 58.409 Creating a high resolution counts map... INFO: Auto-setting vmin to -1.000e-01 [aplpy.core] INFO: Auto-setting vmax to 1.110e+00 [aplpy.core] Saving /scratch/kocevski/471695/cmap_HighResolution_687744001_688003201_4FGL_J0102.8+5824_daily_bin1730.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/471695 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='3.26e-05', job_status='DONE', photon_flux_upper_limit='7.80e-08', time_completed='2022-10-21 01:14:00.701507', job_id='471695', GAL2='0.98', fit_tolerance='1e-08', EG2='1.15', EG='1.15', time_epoch_completed='1666340040.7', return_code2='101', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.98', dlogl='1.46e-11', ts2='0.00', photon_index_error='0.00', photon_index='2.22' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; Database successfully updated. Analysis Complete. Fri Oct 21 01:14:00 PDT 2022 r/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 23.5479540073 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 3.99142565029 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 14.8309006922 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 25.5347868032 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 24.1659137614 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 0.24986936248 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 6.62378783621 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 16.0684690318 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 24.2422074133 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 21.966071167 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 18.6474043399 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 18.4186378536 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 6.53513351243 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 28.2952057181 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 9.5209556422 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 4.25753271981 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 23.7175367092 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 19.6753709874 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 26.132155817 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 8.08143208645 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 20.4757731808 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 12.4023741509 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 5.54450271675 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 8.89319696616 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 11.0305287633 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 24.2147481607 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 20.9118739645 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 14.5300604509 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 29.442995693 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 16.9766668999 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 2.32378071191 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 12.6416087975 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 2.54116747589 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 23.9814281135 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 22.3889684389 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 9.53226569348 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 3.6608035169 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 13.3151609167 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 10.8569057807 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 2.04772786101 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17', time_completed='2022-10-21 00:39:19.169721', job_id='459649' WHERE bin_id='1730' AND source_name='4FGL J0102.8+5824' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/DatabaseTools.py", line 120, in executeCommand cursor.execute(command) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/cursor.py", line 554, in execute self._handle_result(self._connection.cmd_query(stmt)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 495, in cmd_query result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query)) File "/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/mysql/connector/connection.py", line 397, in _handle_result raise errors.get_exception(packet) ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337959.17' at line 1 Command execution failed. Waiting 16.2617520383 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Fri Oct 21 00:49:35 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 459649: <4FGL_J0102.8+5824_daily_bin1730> in cluster Done Job <4FGL_J0102.8+5824_daily_bin1730> was submitted from host by user in cluster at Fri Oct 21 00:05:31 2022 Job was executed on host(s) , in queue , as user in cluster at Fri Oct 21 00:05:33 2022 was used as the home directory. was used as the working directory. Started at Fri Oct 21 00:05:33 2022 Terminated at Fri Oct 21 00:49:36 2022 Results reported at Fri Oct 21 00:49:36 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0102.8+5824_daily_bin1730 15.701 58.4092 687744001 688003201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0102.8+5824 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1407.01 sec. Max Memory : 1094 MB Average Memory : 310.61 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 2642 sec. Turnaround time : 2645 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 471695: <4FGL_J0102.8+5824_daily_bin1730> in cluster Done Job <4FGL_J0102.8+5824_daily_bin1730> was submitted from host by user in cluster at Fri Oct 21 00:45:19 2022 Job was executed on host(s) , in queue , as user in cluster at Fri Oct 21 00:45:20 2022 was used as the home directory. was used as the working directory. Started at Fri Oct 21 00:45:20 2022 Terminated at Fri Oct 21 01:14:01 2022 Results reported at Fri Oct 21 01:14:01 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0102.8+5824_daily_bin1730 15.701 58.4092 687744001 688003201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0102.8+5824 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1544.59 sec. Max Memory : 646 MB Average Memory : 378.76 MB Total Requested Memory : - Delta Memory : - Max Swap : 2937 MB Max Processes : 6 Max Threads : 21 Run time : 1721 sec. Turnaround time : 1722 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 459868: <4FGL_J0102.8+5824_daily_bin1730> in cluster Exited Job <4FGL_J0102.8+5824_daily_bin1730> was submitted from host by user in cluster at Fri Oct 21 00:05:48 2022 Job was executed on host(s) , in queue , as user in cluster at Fri Oct 21 00:05:49 2022 was used as the home directory. was used as the working directory. Started at Fri Oct 21 00:05:49 2022 Terminated at Fri Oct 21 08:25:52 2022 Results reported at Fri Oct 21 08:25:52 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0102.8+5824_daily_bin1730 15.701 58.4092 687744001 688003201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0102.8+5824 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ TERM_RUNLIMIT: job killed after reaching LSF run time limit. Exited with exit code 140. Resource usage summary: CPU time : 14.20 sec. Max Memory : 47 MB Average Memory : 46.87 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 4 Max Threads : 19 Run time : 30003 sec. Turnaround time : 30004 sec. The output (if any) is above this job summary.