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 8 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 = 7466 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0809.8+5218_daily_bin1773 RA = 122.462, Dec = 52.3143 tmin = 698889601, tmax = 699148801 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='808563', job_status='RUN', time_executed='2023-02-27 10:45:34.308999', time_epoch_executed='1677523534.31' WHERE source_name='4FGL J0809.8+5218' and cadence='daily' and bin_id='1773' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/808563 Creating custom pfile directory: /scratch/kocevski/808563/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=698889601.0 && nMetStart<699148801.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=698889601.0 && nMetStart<699148801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/808563/ft1_4FGL_J0809.8+5218_daily_bin1773.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=698889601.0 && nMetStart<699148801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/808563/ft1_4FGL_J0809.8+5218_daily_bin1773.fits outfile=/scratch/kocevski/808563/ft1_filteredMKT_4FGL_J0809.8+5218_daily_bin1773.fits ra=122.462 dec=52.3143 rad=12.0 tmin=698889601.0 tmax=699148801.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.97 user 2.74 sys 0.20 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.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/808563/ft1_filteredMKT_4FGL_J0809.8+5218_daily_bin1773.fits evtable="EVENTS" outfile="/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.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.54 user 0.32 sys 0.18 Number of photons that the gtmktime cut: 406 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits" evtable="EVENTS" scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits sctable="SC_DATA" outfile=/scratch/kocevski/808563/ltcube_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.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/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits .....................! real 14.87 user 14.47 sys 0.35 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits evtable="EVENTS" scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits sctable="SC_DATA" expcube=/scratch/kocevski/808563/ltcube_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits outfile=/scratch/kocevski/808563/expmap_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.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/808563/ltcube_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits .....................! real 192.82 user 186.41 sys 5.92 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 226 point sources and 0 extended sources Setting source of interest to: 4FGL J0809.8+5218 @ 122.462 52.3143 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits outfile=/scratch/kocevski/808563/cmap_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.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=122.462 yref=52.3143 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.39 sys 0.13 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits outfile=/scratch/kocevski/808563/cmap_HighResolution_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.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=122.462 yref=52.3143 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.54 user 0.38 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits evtable="EVENTS" scfile=/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/808563/Model_4FGL_J0809.8+5218_daily_bin1773.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/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits.....................! real 52.86 user 50.97 sys 1.33 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits', '/scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits', expMap='/scratch/kocevski/808563/expmap_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits', expCube='/scratch/kocevski/808563/ltcube_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/808563/Model_4FGL_J0809.8+5218_daily_bin1773.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0809.8+5218' 4FGL J0809.8+5218 Spectrum: LogParabola 330 norm: 2.044e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 331 alpha: 1.811e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 332 beta: 3.259e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 333 Eb: 1.346e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/808563/ft1_filtered_4FGL_J0809.8+5218_daily_bin1773.fits Spacecraft file(s): /scratch/kocevski/808563/ft2_4FGL_J0809.8+5218_daily_bin1773.fits Exposure map: /scratch/kocevski/808563/expmap_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits Exposure cube: /scratch/kocevski/808563/ltcube_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/808563/Model_4FGL_J0809.8+5218_daily_bin1773.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) = 4495.89405231 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 4495.55891636 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .90372E-07 1.0000 .0000 .10000E+07 2 'norm ' .12775E-03 1.0000 .0000 .10000E+07 3 'Prefactor ' .18747E-03 1.0000 .0000 .10000E+07 4 'Prefactor ' 5.3860 1.0000 .0000 .10000E+07 5 'Prefactor ' 16.799 1.0000 .0000 .10000E+07 6 'Prefactor ' 17.810 1.0000 .0000 .10000E+07 7 'norm ' .16187E-01 1.0000 .0000 .10000E+07 8 'Prefactor ' .78196E-01 1.0000 .0000 .10000E+07 9 'Prefactor ' .64833E-02 1.0000 .0000 .10000E+07 10 'norm ' 6.6610 1.0000 .0000 .10000E+07 11 'Prefactor ' 24.079 1.0000 .0000 .10000E+07 12 'Prefactor ' 39.397 1.0000 .0000 .10000E+07 13 'norm ' 3.5111 1.0000 .0000 .10000E+07 14 'Prefactor ' .67983E-03 1.0000 .0000 .10000E+07 15 'norm ' 6.0314 1.0000 .0000 .10000E+07 16 'Prefactor ' .98939E-03 1.0000 .0000 .10000E+07 17 'Prefactor ' 14.328 1.0000 .0000 .10000E+07 18 'norm ' .15131E-03 1.0000 .0000 .10000E+07 19 'norm ' .73230E-06 1.0000 .0000 .10000E+07 20 'Prefactor ' .30735E-03 1.0000 .0000 .10000E+07 21 'norm ' .52069E-07 1.0000 .0000 .10000E+07 22 'Prefactor ' .16465E-02 1.0000 .0000 .10000E+07 23 'Prefactor ' 2.6704 1.0000 .0000 .10000E+07 24 'Prefactor ' .72178E-05 1.0000 .0000 .10000E+07 25 'Prefactor ' 72.237 1.0000 .0000 .10000E+07 26 'Prefactor ' .25102E-02 1.0000 .0000 .10000E+07 27 'norm ' 8.1905 1.0000 .0000 .10000E+07 28 'norm ' 9.7458 1.0000 .0000 .10000E+07 29 'Prefactor ' .19931E-02 1.0000 .0000 .10000E+07 30 'Prefactor ' 121.14 1.0000 .0000 .10000E+07 31 'Normalizat' .49917 1.0000 .10000E-01 10.000 32 'Prefactor ' .89178 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7240E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 4495.551 FROM MIGRAD STATUS=CONVERGED 237 CALLS 3195 TOTAL EDM= .88E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.6% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .0000 1.0452 -.11180E-07** at limit ** 2 norm .55511E-10 2.4335 .18057E-05** at limit ** 3 Prefactor .34972E-08 7.4849 .38050E-06** at limit ** 4 Prefactor 5.4284 7.2570 -.55036E-06 -.36556E-02 5 Prefactor 16.911 1.7661 .69617E-06 .75507E-01 6 Prefactor 18.066 5.9879 -.29071E-05 -.11104E-01 7 norm .15543E-08 32.699 -.33415E-05** at limit ** 8 Prefactor .32361E-05 4.0996 .13297E-05** at limit ** 9 Prefactor .13445E-06 59.771 -.18195E-04** at limit ** 10 norm 6.6675 1.5070 .28151E-06 .12521E-03 11 Prefactor 23.835 18.076 -.82600E-05 -.40110E-01 12 Prefactor 38.860 14.879 -.44885E-05 .83888E-01 13 norm 3.5579 4.7419 .23914E-05 -.32471E-03 14 Prefactor .29032E-07 14.585 -.85155E-05** at limit ** 15 norm 6.0438 2.9858 -.33951E-06 .86432E-03 16 Prefactor .89262E-07 77.683 .19066E-04** at limit ** 17 Prefactor 14.319 10.331 .45567E-06 .15921E-03 18 norm .0000 2.7448 -.17656E-05** at limit ** 19 norm .11102E-09 3.8681 .12766E-05** at limit ** 20 Prefactor .11768E-07 7.6275 -.20489E-05** at limit ** 21 norm .0000 .35471 -.25226E-06** at limit ** 22 Prefactor .30587E-06 10.238 .97603E-06** at limit ** 23 Prefactor 2.6719 6.6976 .21277E-05 -.66874E-03 24 Prefactor .85765E-07 36.828 .57127E-05** at limit ** 25 Prefactor 72.549 3.1216 .49003E-06 -.11729E-01 26 Prefactor .47251E-06 5.9062 .13644E-05** at limit ** 27 norm 8.0687 11.275 .47537E-06 .13707E-02 28 norm 9.4885 12.415 -.13910E-05 -.21244E-02 29 Prefactor .55511E-10 8.9207 -.52739E-06** at limit ** 30 Prefactor 133.27 107.50 -.13576E-05 -.20418E-02 31 Normalizat .49421 .27919 .58986E-04 -.16122E-03 32 Prefactor .89361 .17414 .40072E-04 -.46434E-04 ERR DEF= .500 Final values: norm = 0 norm = 5.55112e-11 Prefactor = 3.4972e-09 Prefactor = 5.4284 Prefactor = 16.9107 Prefactor = 18.0665 norm = 1.55431e-09 Prefactor = 3.23613e-06 Prefactor = 1.34448e-07 norm = 6.66754 Prefactor = 23.8353 Prefactor = 38.8604 norm = 3.55794 Prefactor = 2.90323e-08 norm = 6.04377 Prefactor = 8.92619e-08 Prefactor = 14.3193 norm = 0 norm = 1.11022e-10 Prefactor = 1.17684e-08 norm = 0 Prefactor = 3.05866e-07 Prefactor = 2.67192 Prefactor = 8.57647e-08 Prefactor = 72.549 Prefactor = 4.72511e-07 norm = 8.0687 norm = 9.4885 Prefactor = 5.55112e-11 Prefactor = 133.269 Normalizat = 0.49421 Prefactor = 0.893614 ********** ** 18 **HESSE ********** FCN= 4495.551 FROM HESSE STATUS=OK 731 CALLS 3926 TOTAL EDM= .55E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .0000 1.0460 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 norm .55511E-10 2.4355 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor .34972E-08 7.5394 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor 5.4284 7.8225 .43278E-03 -1.5661 5 Prefactor 16.911 15.296 .24409E-03 -1.5626 6 Prefactor 18.066 21.309 .23705E-03 -1.5623 7 norm .15543E-08 5.7204 .96482E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor .32361E-05 19.184 .14557E-01 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 Prefactor .13445E-06 60.304 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 norm 6.6675 1.5342 .38857E-03 -1.5656 11 Prefactor 23.835 23.710 .20383E-03 -1.5610 12 Prefactor 38.860 25.221 .15934E-03 -1.5583 13 norm 3.5579 5.0158 .53929E-03 -1.5670 14 Prefactor .29032E-07 14.879 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm 6.0438 3.0030 .40860E-03 -1.5659 16 Prefactor .89262E-07 77.977 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Prefactor 14.319 10.396 .26435E-03 -1.5632 18 norm .0000 2.7475 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 19 norm .11102E-09 3.8308 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 20 Prefactor .11768E-07 7.8300 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 21 norm .0000 .35506 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 22 Prefactor .30587E-06 15.627 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 23 Prefactor 2.6719 6.7652 .62339E-03 -1.5675 24 Prefactor .85765E-07 37.117 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 25 Prefactor 72.549 36.986 .11766E-03 -1.5538 26 Prefactor .47251E-06 15.266 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 27 norm 8.0687 11.298 .35008E-03 -1.5651 28 norm 9.4885 12.439 .32075E-03 -1.5646 29 Prefactor .55511E-10 8.8947 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 30 Prefactor 133.27 107.31 .90862E-04 -1.5477 31 Normalizat .49421 .26461 .85950E-01 -1.1268 32 Prefactor .89361 .15735 .44900E-01 -.96365 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 5.47588e-07 Minuit parameter uncertainties: 1 1.94992e-06 2 2.28259e-05 3 0.000324249 4 7.82248 5 15.2956 6 21.3091 7 0.000188919 8 0.0157587 9 0.00569526 10 1.53422 11 23.7099 12 25.2214 13 5.01576 14 0.00131446 15 3.00303 16 0.00527735 17 10.396 18 8.80136e-06 19 4.46093e-05 20 0.000606723 21 5.57167e-06 22 0.00437243 23 6.76525 24 0.00356821 25 36.986 26 0.00537153 27 11.2981 28 12.4389 29 3.90382e-05 30 107.307 31 0.265283 32 0.157434 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 4495.55070004 Extracting fit parameters... 4FGL J0809.8+5218 Spectrum: LogParabola 330 norm: 1.110e-10 4.461e-05 0.000e+00 1.000e+06 ( 1.000e-12) 331 alpha: 1.811e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 332 beta: 3.259e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 333 Eb: 1.346e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 721 Prefactor: 8.936e-01 1.574e-01 0.000e+00 1.000e+01 ( 1.000e+00) 722 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 723 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 720 Normalization: 4.942e-01 2.653e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 122.462 52.314 Photon Flux Upper Limit: 8.11e-08 ph cm-2 s-1 Energy Flux Upper Limit: 8.66e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/808563/likelihoodResults_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.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) = 4494.51289154 delta logL = 1.03780849797 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 4494.47032977 delta logL = 1.08037026971 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .32185 1.0000 .0000 .10000E+07 2 'alpha ' 3.5078 1.0000 .0000 5.0000 3 'Normalizat' .38728 1.0000 .10000E-01 10.000 4 'Prefactor ' .93108 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7240E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 4494.470 FROM MIGRAD STATUS=CONVERGED 51 CALLS 248 TOTAL EDM= .16E-08 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .31990 4.3204 .62814E-03 -.12673E-02 2 alpha 3.5107 3.9937 .22799 .25342E-04 3 Normalizat .38807 .60741E-01 .96252E-01 -.89303E-04 4 Prefactor .93066 .40443E-01 .45400E-01 -.39906E-03 ERR DEF= .500 Final values: norm = 0.319904 alpha = 3.51067 Normalizat = 0.388067 Prefactor = 0.930656 ********** ** 18 **HESSE ********** FCN= 4494.470 FROM HESSE STATUS=NOT POSDEF 33 CALLS 281 TOTAL EDM= .20E-09 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .31990 9.2943 .28485E-04 -1.5697 2 alpha 3.5107 4.2187 .90977E-02 .41618 3 Normalizat .38807 .23951 .42641E-03 -1.1792 4 Prefactor .93066 .16086 .18761E-03 -.95078 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 1.96413e-10 Minuit parameter uncertainties: 1 3.44864 2 5.09837 3 0.240141 4 0.160941 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/808563': 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): 102 logL (Free Index) = 4494.47032071 delta logL = 1.08037933524 Extracting fit parameters... 4FGL J0809.8+5218 Spectrum: LogParabola 330 norm: 3.199e-01 3.449e+00 0.000e+00 1.000e+06 ( 1.000e-12) 331 alpha: 3.511e+00 5.098e+00 0.000e+00 5.000e+00 ( 1.000e+00) 332 beta: 3.259e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 333 Eb: 1.346e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 721 Prefactor: 9.307e-01 1.609e-01 0.000e+00 1.000e+01 ( 1.000e+00) 722 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 723 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 720 Normalization: 3.881e-01 2.401e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): 2.31 Ra Dec: 122.462 52.314 Photon Index (Free Index): 3.51 +/- 5.10 Photon Flux (Free Index): 9.99e-08 +/- 8.49e-08 Energy Flux (Free Index): 1.70e-05 +/- 2.23e-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/808563/cmap_HighResolution_698889601_699148801_4FGL_J0809.8+5218_daily_bin1773.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/808563 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='8.66e-05', comment='SUCCESS', energy_flux2='1.70e-05', dlogl='1.08e+00', photon_flux2='9.99e-08', job_status='DONE', time_completed='2023-02-27 10:59:04.415882', photon_index_error2='5.10', photon_index2='3.51', ts='-0.00', fit_tolerance='1e-08', GAL='0.89', photon_index_error='0.00', photon_flux_upper_limit='8.11e-08', energy_flux_error2='2.23e-05', EG='0.49', time_epoch_completed='1677524344.42', return_code='0', job_id='808563', GAL2='0.93', EG2='0.39', return_code2='102', photon_flux_error2='8.49e-08', ts2='2.31', photon_index='1.81' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; Database successfully updated. Analysis Complete. Mon Feb 27 10:59:04 PST 2023 MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91' at line 1 Command execution failed. Waiting 24.946700614 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 8.51267207887 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 26.6715133861 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 19.9973254271 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 2.74658296379 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 29.8544137817 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 0.00374997074038 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 17.1652729672 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 28.7665907814 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 29.2956472301 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 21.4406236818 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 25.0040820742 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 26.861921134 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 28.6473913148 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 6.80004515772 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 19.0035537707 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 0.226227830557 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 4.91865031231 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 16.2690686407 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 11.0870064445 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 27.6377854093 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 18.3992898937 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 27.5571815059 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 0.7396286022 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 5.3140523288 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 22.6590309713 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 20.6256146168 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 15.0496941026 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 9.32967977816 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 23.0406979788 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 4.93253492774 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 27.1507487958 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 6.92403230228 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 23.4420390778 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1677523248.91', time_completed='2023-02-27 10:40:48.914260', job_id='803233' WHERE bin_id='1773' AND source_name='4FGL J0809.8+5218' 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='1677523248.91' 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='1677523248.91' at line 1 Command execution failed. Waiting 16.4879927337 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Mon Feb 27 10:51:05 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 803233: <4FGL_J0809.8+5218_daily_bin1773> in cluster Done Job <4FGL_J0809.8+5218_daily_bin1773> was submitted from host by user in cluster at Mon Feb 27 10:25:11 2023 Job was executed on host(s) , in queue , as user in cluster at Mon Feb 27 10:25:16 2023 was used as the home directory. was used as the working directory. Started at Mon Feb 27 10:25:16 2023 Terminated at Mon Feb 27 10:51:10 2023 Results reported at Mon Feb 27 10:51:10 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0809.8+5218_daily_bin1773 122.462 52.3143 698889601 699148801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0809.8+5218 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 791.30 sec. Max Memory : 617 MB Average Memory : 290.36 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1554 sec. Turnaround time : 1559 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 808563: <4FGL_J0809.8+5218_daily_bin1773> in cluster Done Job <4FGL_J0809.8+5218_daily_bin1773> was submitted from host by user in cluster at Mon Feb 27 10:45:12 2023 Job was executed on host(s) , in queue , as user in cluster at Mon Feb 27 10:45:13 2023 was used as the home directory. was used as the working directory. Started at Mon Feb 27 10:45:13 2023 Terminated at Mon Feb 27 10:59:05 2023 Results reported at Mon Feb 27 10:59:05 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0809.8+5218_daily_bin1773 122.462 52.3143 698889601 699148801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0809.8+5218 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 808.13 sec. Max Memory : 1257 MB Average Memory : 334.78 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 831 sec. Turnaround time : 833 sec. The output (if any) is above this job summary.