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 181 seconds before starting... Proceeding. Importing modules... This is make3FGLxml version 01r0. The default diffuse model files and names are for pass 8 and assume you have v10r00p05 of the Fermi Science Tools or higher. This is make4FGLDR3xml version 01r09. The default diffuse model files and names are for P8R3, 4FGL DRs, and the default fermitools directory locations. WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/matplotlib/cbook/deprecation.py:106: MatplotlibDeprecationWarning: The mpl_toolkits.axes_grid module was deprecated in version 2.1. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist provies the same functionality instead. warnings.warn(message, mplDeprecation, stacklevel=1) WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). number of points = 7582 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1103.0+1157_daily_bin1757 RA = 165.772, Dec = 11.9654 tmin = 694742401, tmax = 695001601 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='198187', job_status='RUN', time_executed='2023-01-10 01:06:29.030773', time_epoch_executed='1673341589.03' WHERE source_name='4FGL J1103.0+1157' and cadence='daily' and bin_id='1757' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/198187 Creating custom pfile directory: /scratch/kocevski/198187/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/198187/ft1_4FGL_J1103.0+1157_daily_bin1757.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Merged file saved to: /scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/198187/ft1_4FGL_J1103.0+1157_daily_bin1757.fits outfile=/scratch/kocevski/198187/ft1_filteredMKT_4FGL_J1103.0+1157_daily_bin1757.fits ra=165.772 dec=11.9654 rad=12.0 tmin=694742401.0 tmax=695001601.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 2.92 user 2.71 sys 0.20 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.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/198187/ft1_filteredMKT_4FGL_J1103.0+1157_daily_bin1757.fits evtable="EVENTS" outfile="/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.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.52 user 0.34 sys 0.14 Number of photons that the gtmktime cut: 421 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits" evtable="EVENTS" scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits sctable="SC_DATA" outfile=/scratch/kocevski/198187/ltcube_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.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/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits .....................! real 15.72 user 15.21 sys 0.34 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits sctable="SC_DATA" expcube=/scratch/kocevski/198187/ltcube_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits outfile=/scratch/kocevski/198187/expmap_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.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/198187/ltcube_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits .....................! real 192.68 user 186.23 sys 5.18 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 Added 185 point sources and 0 extended sources Setting source of interest to: 4FGL J1103.0+1157 @ 165.772 11.9654 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits outfile=/scratch/kocevski/198187/cmap_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.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=165.772 yref=11.9654 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.57 user 0.38 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits outfile=/scratch/kocevski/198187/cmap_HighResolution_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.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=165.772 yref=11.9654 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.57 user 0.38 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/198187/Model_4FGL_J1103.0+1157_daily_bin1757.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 GAL_V02 Working on... /scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits.....................! real 49.79 user 48.26 sys 1.18 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits', '/scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits', expMap='/scratch/kocevski/198187/expmap_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits', expCube='/scratch/kocevski/198187/ltcube_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/198187/Model_4FGL_J1103.0+1157_daily_bin1757.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1103.0+1157' 4FGL J1103.0+1157 Spectrum: LogParabola 267 norm: 1.011e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-11) 268 alpha: 2.297e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 269 beta: 9.765e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 270 Eb: 4.926e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/198187/ft1_filtered_4FGL_J1103.0+1157_daily_bin1757.fits Spacecraft file(s): /scratch/kocevski/198187/ft2_4FGL_J1103.0+1157_daily_bin1757.fits Exposure map: /scratch/kocevski/198187/expmap_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits Exposure cube: /scratch/kocevski/198187/ltcube_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/198187/Model_4FGL_J1103.0+1157_daily_bin1757.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) = 4717.58878764 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 4717.0392923 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .11349E-05 1.0000 .0000 .10000E+07 2 'Prefactor ' 3.3519 1.0000 .0000 .10000E+07 3 'Prefactor ' .43085E-01 1.0000 .0000 .10000E+07 4 'Prefactor ' 15.170 1.0000 .0000 .10000E+07 5 'Prefactor ' 1.5520 1.0000 .0000 .10000E+07 6 'Prefactor ' 15.181 1.0000 .0000 .10000E+07 7 'norm ' .13101E-07 1.0000 .0000 .10000E+07 8 'Prefactor ' 14.133 1.0000 .0000 .10000E+07 9 'norm ' .16653E-09 1.0000 .0000 .10000E+07 10 'Prefactor ' .11356 1.0000 .0000 .10000E+07 11 'Prefactor ' .42247E-03 1.0000 .0000 .10000E+07 12 'norm ' 4.5760 1.0000 .0000 .10000E+07 13 'Prefactor ' 2.0355 1.0000 .0000 .10000E+07 14 'Normalizat' 1.2661 1.0000 .10000E-01 10.000 15 'Prefactor ' .85248 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5840E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 4717.037 FROM MIGRAD STATUS=CONVERGED 115 CALLS 827 TOTAL EDM= .11E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .7% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .11657E-08 5.8930 -.14906E-05** at limit ** 2 Prefactor 3.3663 4.3913 -.40648E-06 .99122E-02 3 Prefactor .17942E-02 9.8205 -.14316E-05** at limit ** 4 Prefactor 15.175 3.8328 -.38234E-06 -.55482E-01 5 Prefactor 1.8771 14.056 .20518E-05 -.36174E-02 6 Prefactor 14.951 10.362 .43765E-06 .17006E-02 7 norm .0000 .17472 .43165E-06** at limit ** 8 Prefactor 13.971 9.3382 .30498E-06 .17074E-01 9 norm .44409E-09 3.7858 -.15202E-05** at limit ** 10 Prefactor .16820E-07 43.521 .41375E-05** at limit ** 11 Prefactor .59532E-01 182.66 -.30351E-06** at limit ** 12 norm 4.7481 3.7342 -.52725E-06 .12905E-01 13 Prefactor 2.2463 9.8016 .26627E-06 -.13504E-02 14 Normalizat 1.2646 .23189 .21571E-05 .17080E-03 15 Prefactor .85280 .21421 -.18264E-05 .15497E-03 ERR DEF= .500 Final values: Prefactor = 1.16573e-09 Prefactor = 3.36627 Prefactor = 0.00179417 Prefactor = 15.1745 Prefactor = 1.87705 Prefactor = 14.9514 norm = 0 Prefactor = 13.971 norm = 4.44089e-10 Prefactor = 1.68199e-08 Prefactor = 0.0595322 norm = 4.74812 Prefactor = 2.24627 Normalizat = 1.26462 Prefactor = 0.852802 ********** ** 18 **HESSE ********** FCN= 4717.037 FROM HESSE STATUS=OK 236 CALLS 1063 TOTAL EDM= .85E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .11657E-08 5.9739 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor 3.3663 4.5102 .55253E-03 -1.5671 3 Prefactor .17942E-02 4.6463 .11528E-01 -1.5707 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor 15.175 9.8340 .25689E-03 -1.5630 5 Prefactor 1.8771 15.810 .85455E-03 -1.5681 6 Prefactor 14.951 16.214 .25680E-03 -1.5631 7 norm .0000 .17414 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor 13.971 16.837 .26617E-03 -1.5633 9 norm .44409E-09 3.6412 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor .16820E-07 12.450 .88392E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Prefactor .59532E-01 7.8053 .57937E-02 -1.5703 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 norm 4.7481 11.485 .47032E-03 -1.5664 13 Prefactor 2.2463 10.175 .72467E-03 -1.5678 14 Normalizat 1.2646 .20765 .52369E-01 -.84629 15 Prefactor .85280 .18410 .44396E-01 -.97810 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 8.54818e-07 Minuit parameter uncertainties: 1 0.000166826 2 4.51022 3 0.182607 4 9.834 5 10.8951 6 16.2136 7 3.68046e-06 8 16.8374 9 8.01054e-05 10 0.00091521 11 1.36333 12 11.4849 13 9.5618 14 0.207784 15 0.184233 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 4717.03726561 Extracting fit parameters... 4FGL J1103.0+1157 Spectrum: LogParabola 267 norm: 4.441e-10 8.011e-05 0.000e+00 1.000e+06 ( 1.000e-11) 268 alpha: 2.297e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 269 beta: 9.765e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 270 Eb: 4.926e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 581 Prefactor: 8.528e-01 1.842e-01 0.000e+00 1.000e+01 ( 1.000e+00) 582 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 583 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 580 Normalization: 1.265e+00 2.078e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 165.772 11.965 Photon Flux Upper Limit: 1.09e-07 ph cm-2 s-1 Energy Flux Upper Limit: 3.60e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/198187/likelihoodResults_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 4715.20050009 delta logL = 1.83676551573 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 4715.06185846 delta logL = 1.97540714705 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .20993 1.0000 .0000 .10000E+07 2 'alpha ' 5.0000 1.0000 .0000 5.0000 3 'Normalizat' 1.0990 1.0000 .10000E-01 10.000 4 'Prefactor ' .95152 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5840E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 4715.062 FROM MIGRAD STATUS=CONVERGED 90 CALLS 333 TOTAL EDM= .48E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .20996 .13186 .18232E-05** at limit ** 2 alpha 5.0000 3.1668 .46096E-01** at limit ** 3 Normalizat 1.0989 .24180 .24541E-03 .23162E-06 4 Prefactor .95160 .22093 .24539E-03 -.48183E-05 ERR DEF= .500 Final values: norm = 0.209959 alpha = 5 Normalizat = 1.09888 Prefactor = 0.951599 ********** ** 18 **HESSE ********** FCN= 4715.062 FROM HESSE STATUS=OK 25 CALLS 358 TOTAL EDM= .48E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .20996 .13083 .74858E-07 -1.5699 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 5.0000 3.1674 .92192E-02 1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Normalizat 1.0989 .24203 .98165E-05 -.89788 4 Prefactor .95160 .22114 .98155E-05 -.94361 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 4.80139e-10 Minuit parameter uncertainties: 1 0.13083 2 6.46131e-05 3 0.242279 4 0.221348 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/198187': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 4715.06185834 delta logL = 1.97540726514 Extracting fit parameters... 4FGL J1103.0+1157 Spectrum: LogParabola 267 norm: 2.100e-01 1.308e-01 0.000e+00 1.000e+06 ( 1.000e-11) 268 alpha: 5.000e+00 6.461e-05 0.000e+00 5.000e+00 ( 1.000e+00) 269 beta: 9.765e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 270 Eb: 4.926e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 581 Prefactor: 9.516e-01 2.213e-01 0.000e+00 1.000e+01 ( 1.000e+00) 582 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 583 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 580 Normalization: 1.099e+00 2.423e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): 4.33 Ra Dec: 165.772 11.965 Photon Index (Free Index): 5.00 +/- 0.00 Photon Flux (Free Index): 1.28e-07 +/- 7.91e-08 Energy Flux (Free Index): 1.73e-05 +/- 1.07e-05 Creating a high resolution counts map... INFO: Auto-setting vmin to 0.000e+00 [aplpy.core] INFO: Auto-setting vmax to 0.000e+00 [aplpy.core] Saving /scratch/kocevski/198187/cmap_HighResolution_694742401_695001601_4FGL_J1103.0+1157_daily_bin1757.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/198187 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='3.60e-05', comment='SUCCESS', energy_flux2='1.73e-05', dlogl='1.98e+00', photon_flux2='1.28e-07', job_status='DONE', time_completed='2023-01-10 01:14:09.596438', photon_index_error2='0.00', photon_index2='5.00', ts='-0.00', fit_tolerance='1e-08', GAL='0.85', photon_index_error='0.00', photon_flux_upper_limit='1.09e-07', energy_flux_error2='1.07e-05', EG='1.26', time_epoch_completed='1673342049.6', return_code='0', job_id='198187', GAL2='0.95', EG2='1.10', return_code2='0', photon_flux_error2='7.91e-08', ts2='4.33', photon_index='2.30' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Jan 10 01:14:09 PST 2023 dex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 11.6987231749 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 2.46651043846 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 28.0813496793 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 22.0791171855 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 20.4934664792 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 24.227427477 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 22.1189148589 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 21.6576138211 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 15.8328502904 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 21.9069632237 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 21.9495877057 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 14.2510268945 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 18.7143181241 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 16.2901825181 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 8.46218004132 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 1.99668815383 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 9.14350913815 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 16.4698489628 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 12.1086031841 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 21.0754904399 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 7.24469717796 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 28.257269749 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 13.4991641341 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 9.20270823607 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 26.1446577007 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 8.82541858818 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 28.7206636346 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 23.980360238 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 26.7993928739 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 27.0126118734 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 4.67831974399 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 0.23009338914 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 5.71464241601 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 27.3543979449 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 3.08087694832 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 1.48520826282 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 7.92388170929 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5', time_completed='2023-01-10 00:57:31.502543', job_id='194287' WHERE bin_id='1757' AND source_name='4FGL J1103.0+1157' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673341051.5'' 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='1673341051.5'' at line 1 Command execution failed. Waiting 25.5325434429 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Jan 10 01:07:55 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 194287: <4FGL_J1103.0+1157_daily_bin1757> in cluster Done Job <4FGL_J1103.0+1157_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 00:45:14 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 00:48:11 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 00:48:11 2023 Terminated at Tue Jan 10 01:07:56 2023 Results reported at Tue Jan 10 01:07:56 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1103.0+1157_daily_bin1757 165.772 11.9654 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1103.0+1157 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 438.00 sec. Max Memory : 617 MB Average Memory : 279.27 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1185 sec. Turnaround time : 1362 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 198187: <4FGL_J1103.0+1157_daily_bin1757> in cluster Done Job <4FGL_J1103.0+1157_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 01:00:15 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 01:03:19 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 01:03:19 2023 Terminated at Tue Jan 10 01:14:10 2023 Results reported at Tue Jan 10 01:14:10 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1103.0+1157_daily_bin1757 165.772 11.9654 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1103.0+1157 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 461.00 sec. Max Memory : 1256 MB Average Memory : 281.22 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 650 sec. Turnaround time : 835 sec. The output (if any) is above this job summary.