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: Daniel Kocevski (daniel.kocevski@nasa.gov) Waiting 113 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). nnumber of points = 17510 number of fields = 31 RA_SUN column already exists. File will not be modified.Done. Performing analysis on: 4FGL_J1802.6-3940_weekly_bin759 RA = 270.671, Dec = -39.6687 tmin = 698025601, tmax = 698630401 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='727144', job_status='RUN', time_executed='2023-02-21 12:56:03.030624', time_epoch_executed='1677012963.03' WHERE source_name='4FGL J1802.6-3940' and cadence='weekly' and bin_id='759' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/727144 Creating custom pfile directory: /scratch/kocevski/727144/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=698025601.0 && nMetStart<698630401.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=698025601.0 && nMetStart<698630401.0' /Data/Flight/Level1/LPA Retrieving 108 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/727144/ft1_4FGL_J1802.6-3940_weekly_bin759.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=698025601.0 && nMetStart<698630401.0' /Data/Flight/Level1/LPA Retrieving 108 files... Done. Merging files... Merged file saved to: /scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/727144/ft1_4FGL_J1802.6-3940_weekly_bin759.fits outfile=/scratch/kocevski/727144/ft1_filteredMKT_4FGL_J1802.6-3940_weekly_bin759.fits ra=270.671 dec=-39.6687 rad=12.0 tmin=698025601.0 tmax=698630401.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 8.97 user 8.38 sys 0.30 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.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/727144/ft1_filteredMKT_4FGL_J1802.6-3940_weekly_bin759.fits evtable="EVENTS" outfile="/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.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.57 user 0.38 sys 0.16 Number of photons that the gtmktime cut: 12517 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits" evtable="EVENTS" scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits sctable="SC_DATA" outfile=/scratch/kocevski/727144/ltcube_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.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/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits .....................! real 26.42 user 26.01 sys 0.31 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits evtable="EVENTS" scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits sctable="SC_DATA" expcube=/scratch/kocevski/727144/ltcube_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits outfile=/scratch/kocevski/727144/expmap_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.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/727144/ltcube_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits .....................! real 190.78 user 185.68 sys 4.76 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 FHES J1741.6-3917 in ROI with RadialDisk spatial model. Extended source RX J1713.7-3946 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/RXJ1713_2016_250GeV.fits is the correct path to the extended template. Extended source FGES J1745.8-3028 in ROI with RadialDisk spatial model. Extended source G337.0-0.1 in ROI with RadialDisk spatial model. Extended source FGES J1652.2-4633 in ROI with RadialDisk spatial model. Extended source FGES J1655.5-4737 in ROI with RadialDisk spatial model. Extended source W 28 in ROI with RadialDisk spatial model. Extended source HESS J1616-508 in ROI with RadialDisk spatial model. Extended source FGES J1631.6-4756 in ROI with RadialDisk spatial model. Extended source FGES J1633.0-4746 in ROI with RadialDisk spatial model. Extended source FHES J1642.1-5428 in ROI with RadialDisk spatial model. Extended source HESS J1804-216 in ROI with RadialDisk spatial model. Extended source W 30 in ROI with RadialDisk spatial model. Extended source HESS J1808-204 in ROI with RadialDisk spatial model. Extended source HESS J1809-193 in ROI with RadialDisk spatial model. Added 563 point sources and 15 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 J1802.6-3940 @ 270.671 -39.6687 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits outfile=/scratch/kocevski/727144/cmap_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.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=270.671 yref=-39.6687 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.73 user 0.44 sys 0.13 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits outfile=/scratch/kocevski/727144/cmap_HighResolution_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.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=270.671 yref=-39.6687 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.59 user 0.43 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits evtable="EVENTS" scfile=/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/727144/Model_4FGL_J1802.6-3940_weekly_bin759.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 EG_v02 adding source FGES J1631.6-4756 adding source FGES J1633.0-4746 adding source FGES J1652.2-4633 adding source FGES J1655.5-4737 adding source FGES J1745.8-3028 adding source FHES J1642.1-5428 adding source FHES J1741.6-3917 adding source G337.0-0.1 adding source GAL_V02 adding source HESS J1616-508 adding source HESS J1804-216 adding source HESS J1808-204 adding source HESS J1809-193 adding source RX J1713.7-3946 adding source W 28 adding source W 30 Working on... /scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits.....................! real 3816.86 user 3802.07 sys 5.45 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits', '/scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits', expMap='/scratch/kocevski/727144/expmap_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits', expCube='/scratch/kocevski/727144/ltcube_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/727144/Model_4FGL_J1802.6-3940_weekly_bin759.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1802.6-3940' 4FGL J1802.6-3940 Spectrum: LogParabola 1478 norm: 1.038e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-11) 1479 alpha: 2.264e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 1480 beta: 1.290e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 1481 Eb: 8.469e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/727144/ft1_filtered_4FGL_J1802.6-3940_weekly_bin759.fits Spacecraft file(s): /scratch/kocevski/727144/ft2_4FGL_J1802.6-3940_weekly_bin759.fits Exposure map: /scratch/kocevski/727144/expmap_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits Exposure cube: /scratch/kocevski/727144/ltcube_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/727144/Model_4FGL_J1802.6-3940_weekly_bin759.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) = 107938.382688 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 107937.767368 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .32286 1.0000 .0000 .10000E+07 2 'norm ' .80667E-04 1.0000 .0000 .10000E+07 3 'norm ' 1.9045 1.0000 .0000 .10000E+07 4 'Prefactor ' 4.1066 1.0000 .0000 .10000E+07 5 'norm ' .94369E-09 1.0000 .0000 .10000E+07 6 'Prefactor ' .72848E-03 1.0000 .0000 .10000E+07 7 'norm ' 7.6237 1.0000 .0000 .10000E+07 8 'norm ' 3.3278 1.0000 .0000 .10000E+07 9 'norm ' 50.216 1.0000 .0000 .10000E+07 10 'norm ' .57060E-04 1.0000 .0000 .10000E+07 11 'Normalizat' 1.4151 1.0000 .10000E-01 10.000 12 'Prefactor ' .93634 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .2087E+06 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 107937.8 FROM MIGRAD STATUS=CONVERGED 77 CALLS 641 TOTAL EDM= .13E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.2% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .51380 1.5844 -.97864E-08 .42999E-02 2 norm .86042E-08 9.6662 .18914E-06** at limit ** 3 norm 1.4189 1.8084 .42715E-08 .16227E-01 4 Prefactor 4.1558 9.9155 .56799E-06 .82237E-03 5 norm .0000 .27760 .13042E-06** at limit ** 6 Prefactor .77716E-09 11.143 .95079E-07** at limit ** 7 norm 7.6220 2.9496 -.62883E-07 .11860E-03 8 norm 3.3307 3.1547 -.27547E-07 .19045E-04 9 norm 50.584 2.3703 -.86181E-08 .56836E-01 10 norm .16098E-08 5.4844 .29773E-06** at limit ** 11 Normalizat 1.4138 .19013 .11869E-04 .64532E-05 12 Prefactor .93634 .13131E-01 -.39011E-06 .20432E-03 ERR DEF= .500 Final values: norm = 0.513796 norm = 8.60423e-09 norm = 1.41893 Prefactor = 4.15579 norm = 0 Prefactor = 7.77156e-10 norm = 7.62204 norm = 3.33072 norm = 50.5837 norm = 1.60982e-09 Normalizat = 1.41383 Prefactor = 0.936341 ********** ** 18 **HESSE ********** FCN= 107937.8 FROM HESSE STATUS=OK 165 CALLS 806 TOTAL EDM= .73E-07 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .51380 2.9089 .16418E-01 -1.5694 2 norm .86042E-08 9.7237 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 norm 1.4189 42.638 .75320E-03 -1.5684 4 Prefactor 4.1558 10.052 .49722E-03 -1.5667 5 norm .0000 .68577E-01 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 Prefactor .77716E-09 11.342 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm 7.6220 2.9545 .36296E-03 -1.5653 8 norm 3.3307 3.1557 .55463E-03 -1.5671 9 norm 50.584 14.434 .14113E-03 -1.5566 10 norm .16098E-08 5.5672 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Normalizat 1.4138 .20622 .31010 -.80229 12 Prefactor .93634 .13512E-01 .26535E-01 -.94883 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 7.33599e-08 Minuit parameter uncertainties: 1 2.44507 2 0.000578433 3 15.5565 4 10.0518 5 3.43324e-07 6 0.000187454 7 2.95448 8 3.15569 9 14.4343 10 0.000189406 11 0.206338 12 0.013512 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/727144': 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 (Fixed Index): 0 logL (Fixed Index) = 107937.7663 Extracting fit parameters... 4FGL J1802.6-3940 Spectrum: LogParabola 1478 norm: 0.000e+00 3.433e-07 0.000e+00 1.000e+06 ( 1.000e-11) 1479 alpha: 2.264e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 1480 beta: 1.290e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 1481 Eb: 8.469e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 2058 Prefactor: 9.363e-01 1.351e-02 0.000e+00 1.000e+01 ( 1.000e+00) 2059 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 2060 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 2031 Normalization: 1.414e+00 2.063e-01 1.000e-02 1.000e+01 ( 1.000e+00) float division by zero Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py", line 3506, in sourceAnalysis photonFluxUpperLimit95, energyFluxUpperLimit95 = calculateBayesianUpperLimits(like, sourceOfInterest, emin=emin, emax=emax) File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py", line 383, in calculateBayesianUpperLimits conversionFactor = energyFlux_tmp/photonFlux_tmp ZeroDivisionError: float division by zero UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='float division by zero', time_epoch_completed='1677023356.75', time_completed='2023-02-21 15:49:16.753234', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; Database successfully updated. Creating a high resolution counts map... INFO: Auto-setting vmin to -3.000e-01 [aplpy.core] INFO: Auto-setting vmax to 3.330e+00 [aplpy.core] Saving /scratch/kocevski/727144/cmap_HighResolution_698025601_698630401_4FGL_J1802.6-3940_weekly_bin759.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/727144 Updating database... local variable 'ts_freeIndex' referenced before assignment Traceback (most recent call last): File "/nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py", line 4352, in sourceAnalysis if ts_freeIndex == 0: UnboundLocalError: local variable 'ts_freeIndex' referenced before assignment UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 15.3417068706 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 3.1905552104 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 27.671744244 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 28.9462643594 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 0.770608838624 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 2.29190427862 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 28.794639095 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 22.2060256655 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 4.23513930211 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 24.2035207482 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 0.140044393819 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 18.7242716437 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 2.87723372116 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 9.56170489072 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 25.0177862736 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 28.2409082892 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 16.6902456288 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 0.81665218315 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 26.4833504426 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 27.5919591641 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 10.3145806905 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 14.0461672204 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 0.95939058819 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 22.2087601884 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 22.1869119854 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 2.31414152786 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 10.1469065842 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 13.3330868629 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 4.70589492352 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 0.175190985788 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 23.6911182797 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 3.24567457783 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 20.1416420609 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 16.7855036342 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 12.0402238414 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 8.18976879994 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 27.7819545133 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 20.0379379227 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 12.9980492354 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 5.64265041559 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 6.24096381156 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 3.21704798799 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 15.3526447494 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677023359.1', time_completed='2023-02-21 15:49:19.098075', job_id='727144' WHERE bin_id='759' AND source_name='4FGL J1802.6-3940' AND cadence='weekly'; 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='1677023359.1'' 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='1677023359.1'' at line 1 Command execution failed. Waiting 21.9952099659 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Feb 21 15:59:32 PST 2023 b 727140: <4FGL_J1802.6-3940_weekly_bin759> in cluster Done Job <4FGL_J1802.6-3940_weekly_bin759> was submitted from host by user in cluster at Tue Feb 21 12:53:54 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Feb 21 12:53:55 2023 was used as the home directory. was used as the working directory. Started at Tue Feb 21 12:53:55 2023 Terminated at Tue Feb 21 15:58:31 2023 Results reported at Tue Feb 21 15:58:31 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1802.6-3940_weekly_bin759 270.671 -39.6687 698025601 698630401 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1802.6-3940 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 10307.00 sec. Max Memory : 1294 MB Average Memory : 816.96 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 11076 sec. Turnaround time : 11077 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 727141: <4FGL_J1802.6-3940_weekly_bin759> in cluster Done Job <4FGL_J1802.6-3940_weekly_bin759> was submitted from host by user in cluster at Tue Feb 21 12:53:54 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Feb 21 12:53:55 2023 was used as the home directory. was used as the working directory. Started at Tue Feb 21 12:53:55 2023 Terminated at Tue Feb 21 15:59:20 2023 Results reported at Tue Feb 21 15:59:20 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1802.6-3940_weekly_bin759 270.671 -39.6687 698025601 698630401 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1802.6-3940 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 10357.00 sec. Max Memory : 957 MB Average Memory : 811.30 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 11124 sec. Turnaround time : 11126 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 727144: <4FGL_J1802.6-3940_weekly_bin759> in cluster Done Job <4FGL_J1802.6-3940_weekly_bin759> was submitted from host by user in cluster at Tue Feb 21 12:53:55 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Feb 21 12:53:57 2023 was used as the home directory. was used as the working directory. Started at Tue Feb 21 12:53:57 2023 Terminated at Tue Feb 21 15:59:35 2023 Results reported at Tue Feb 21 15:59:35 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1802.6-3940_weekly_bin759 270.671 -39.6687 698025601 698630401 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1802.6-3940 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 10385.00 sec. Max Memory : 1104 MB Average Memory : 817.73 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 11137 sec. Turnaround time : 11140 sec. The output (if any) is above this job summary.