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 129 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 = 7381 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1253.2+5301_daily_bin1750 RA = 193.307, Dec = 53.0173 tmin = 692928001, tmax = 693187201 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='20026', job_status='RUN', time_executed='2022-12-20 01:22:40.441915', time_epoch_executed='1671528160.44' WHERE source_name='4FGL J1253.2+5301' and cadence='daily' and bin_id='1750' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/20026 Creating custom pfile directory: /scratch/kocevski/20026/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/20026/ft1_4FGL_J1253.2+5301_daily_bin1750.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/20026/ft1_4FGL_J1253.2+5301_daily_bin1750.fits outfile=/scratch/kocevski/20026/ft1_filteredMKT_4FGL_J1253.2+5301_daily_bin1750.fits ra=193.307 dec=53.0173 rad=12.0 tmin=692928001.0 tmax=693187201.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 3.50 user 3.26 sys 0.20 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.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/20026/ft1_filteredMKT_4FGL_J1253.2+5301_daily_bin1750.fits evtable="EVENTS" outfile="/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.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.48 user 0.33 sys 0.14 Number of photons that the gtmktime cut: 573 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits" evtable="EVENTS" scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits sctable="SC_DATA" outfile=/scratch/kocevski/20026/ltcube_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.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/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits .....................! real 11.81 user 11.45 sys 0.33 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits sctable="SC_DATA" expcube=/scratch/kocevski/20026/ltcube_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits outfile=/scratch/kocevski/20026/expmap_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.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/20026/ltcube_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits .....................! real 189.79 user 184.99 sys 4.45 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 210 point sources and 0 extended sources Setting source of interest to: 4FGL J1253.2+5301 @ 193.307 53.0173 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits outfile=/scratch/kocevski/20026/cmap_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.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=193.307 yref=53.0173 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.37 sys 0.15 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits outfile=/scratch/kocevski/20026/cmap_HighResolution_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.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=193.307 yref=53.0173 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.15 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/20026/Model_4FGL_J1253.2+5301_daily_bin1750.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/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits.....................! real 51.76 user 50.41 sys 1.23 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits', '/scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits', expMap='/scratch/kocevski/20026/expmap_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits', expCube='/scratch/kocevski/20026/ltcube_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/20026/Model_4FGL_J1253.2+5301_daily_bin1750.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1253.2+5301' 4FGL J1253.2+5301 Spectrum: LogParabola 333 norm: 3.003e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 334 alpha: 1.931e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 335 beta: 8.810e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 336 Eb: 1.175e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/20026/ft1_filtered_4FGL_J1253.2+5301_daily_bin1750.fits Spacecraft file(s): /scratch/kocevski/20026/ft2_4FGL_J1253.2+5301_daily_bin1750.fits Exposure map: /scratch/kocevski/20026/expmap_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits Exposure cube: /scratch/kocevski/20026/ltcube_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/20026/Model_4FGL_J1253.2+5301_daily_bin1750.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) = 6221.64374903 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 6221.64114335 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 2.0737 1.0000 .0000 .10000E+07 2 'norm ' .59794E-04 1.0000 .0000 .10000E+07 3 'Prefactor ' 38.649 1.0000 .0000 .10000E+07 4 'Prefactor ' .29520E-04 1.0000 .0000 .10000E+07 5 'Prefactor ' .14191E-03 1.0000 .0000 .10000E+07 6 'norm ' .71497 1.0000 .0000 .10000E+07 7 'norm ' 5.8320 1.0000 .0000 .10000E+07 8 'Prefactor ' 11.139 1.0000 .0000 .10000E+07 9 'Prefactor ' 1.6819 1.0000 .0000 .10000E+07 10 'norm ' 2.6115 1.0000 .0000 .10000E+07 11 'Prefactor ' 7.8203 1.0000 .0000 .10000E+07 12 'norm ' .17758E-06 1.0000 .0000 .10000E+07 13 'Prefactor ' .27508E-02 1.0000 .0000 .10000E+07 14 'Prefactor ' .11532E-01 1.0000 .0000 .10000E+07 15 'norm ' 31.443 1.0000 .0000 .10000E+07 16 'norm ' 3.9850 1.0000 .0000 .10000E+07 17 'Prefactor ' 66.613 1.0000 .0000 .10000E+07 18 'Prefactor ' .92623E-01 1.0000 .0000 .10000E+07 19 'norm ' 4.3919 1.0000 .0000 .10000E+07 20 'Prefactor ' 105.22 1.0000 .0000 .10000E+07 21 'norm ' .27223E-06 1.0000 .0000 .10000E+07 22 'norm ' .40777E-05 1.0000 .0000 .10000E+07 23 'Prefactor ' 39.962 1.0000 .0000 .10000E+07 24 'Normalizat' .87803 1.0000 .10000E-01 10.000 25 'Prefactor ' .89843 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6680E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 6221.639 FROM MIGRAD STATUS=CONVERGED 182 CALLS 3280 TOTAL EDM= .15E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .6% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 2.0781 3.4136 .75222E-07 .72378E-02 2 norm .0000 1.9314 -.16479E-07** at limit ** 3 Prefactor 38.606 20.181 .40833E-07 -.97160E-01 4 Prefactor .11102E-09 1.7957 -.61285E-07** at limit ** 5 Prefactor .11102E-09 4.4059 -.55259E-07** at limit ** 6 norm .70995 1.8452 -.46328E-07 -.38945E-02 7 norm 5.8187 6.9531 -.67684E-07 -.11881E-01 8 Prefactor 11.115 10.649 -.10427E-07 .44647E-01 9 Prefactor 1.6665 4.8986 .99870E-07 .19850E-02 10 norm 2.6121 1.6413 -.16836E-08 .86022E-03 11 Prefactor 7.8059 14.935 .28815E-07 -.18114E-01 12 norm .55511E-10 .57163 .32834E-07** at limit ** 13 Prefactor .61011E-04 536.70 .14502E-05** at limit ** 14 Prefactor .55511E-10 12.370 .57125E-07** at limit ** 15 norm 31.441 17.376 .81174E-07 .68982E-01 16 norm 3.9112 3.9375 .45064E-07 .36003E-02 17 Prefactor 66.895 37.893 -.60919E-07 -.94622E-01 18 Prefactor .24980E-08 28.400 .33487E-06** at limit ** 19 norm 4.4123 4.4734 .69909E-08 -.14484E-03 20 Prefactor 105.49 11.049 -.34687E-07 .24567 21 norm .0000 .76779 .62281E-08** at limit ** 22 norm .0000 1.3699 .87373E-08** at limit ** 23 Prefactor 39.586 14.249 .71860E-07 -.15260 24 Normalizat .87816 .17672 .55215E-06 -.14796E-03 25 Prefactor .89869 .21257 -.15597E-05 -.18709E-03 ERR DEF= .500 Final values: Prefactor = 2.07808 norm = 0 Prefactor = 38.6063 Prefactor = 1.11022e-10 Prefactor = 1.11022e-10 norm = 0.709949 norm = 5.81874 Prefactor = 11.1152 Prefactor = 1.66647 norm = 2.61214 Prefactor = 7.80586 norm = 5.55112e-11 Prefactor = 6.1011e-05 Prefactor = 5.55112e-11 norm = 31.4406 norm = 3.91123 Prefactor = 66.8954 Prefactor = 2.498e-09 norm = 4.41229 Prefactor = 105.489 norm = 0 norm = 0 Prefactor = 39.5864 Normalizat = 0.878156 Prefactor = 0.89869 ********** ** 18 **HESSE ********** FCN= 6221.639 FROM HESSE STATUS=OK 475 CALLS 3755 TOTAL EDM= .41E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 2.0781 3.5451 .71700E-03 -1.5679 2 norm .0000 1.9253 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor 38.606 22.293 .16087E-03 -1.5584 4 Prefactor .11102E-09 1.7953 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor .11102E-09 4.4342 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 norm .70995 1.8633 .59501E-03 -1.5691 7 norm 5.8187 9.3388 .41563E-03 -1.5660 8 Prefactor 11.115 24.671 .29992E-03 -1.5641 9 Prefactor 1.6665 4.9508 .81188E-03 -1.5682 10 norm 2.6121 1.6439 .63094E-03 -1.5676 11 Prefactor 7.8059 15.160 .35833E-03 -1.5652 12 norm .55511E-10 .57071 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 Prefactor .61011E-04 539.49 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor .55511E-10 12.222 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm 31.441 17.628 .17836E-03 -1.5596 16 norm 3.9112 3.9653 .50500E-03 -1.5668 17 Prefactor 66.895 39.558 .12253E-03 -1.5544 18 Prefactor .24980E-08 28.541 .14132E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 19 norm 4.4123 4.4987 .48034E-03 -1.5666 20 Prefactor 105.49 55.254 .97492E-04 -1.5503 21 norm .0000 .76420 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 22 norm .0000 1.3685 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 23 Prefactor 39.586 53.317 .15820E-03 -1.5582 24 Normalizat .87816 .15400 .44620E-01 -.97232 25 Prefactor .89869 .18300 .44985E-01 -.96187 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 4.1115e-06 Minuit parameter uncertainties: 1 3.54507 2 6.23113e-06 3 22.293 4 2.76936e-05 5 4.44614e-05 6 1.86335 7 9.33878 8 24.671 9 4.95077 10 1.64394 11 15.1605 12 8.3305e-06 13 0.362882 14 4.76097e-05 15 17.6278 16 3.9653 17 39.5578 18 0.000536613 19 4.4987 20 55.254 21 1.92419e-06 22 3.19535e-06 23 53.318 24 0.154077 25 0.183127 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 6221.63879329 Extracting fit parameters... 4FGL J1253.2+5301 Spectrum: LogParabola 333 norm: 5.551e-11 8.330e-06 0.000e+00 1.000e+06 ( 1.000e-12) 334 alpha: 1.931e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 335 beta: 8.810e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 336 Eb: 1.175e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 665 Prefactor: 8.987e-01 1.831e-01 0.000e+00 1.000e+01 ( 1.000e+00) 666 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 667 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 664 Normalization: 8.782e-01 1.541e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 193.307 53.017 Photon Flux Upper Limit: 2.87e-08 ph cm-2 s-1 Energy Flux Upper Limit: 2.07e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/20026/likelihoodResults_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.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) = 6221.63943684 delta logL = -0.000643544932245 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 6221.63879334 delta logL = -4.97411747347e-08 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .49627E-07 1.0000 .0000 .10000E+07 2 'alpha ' 1.9625 1.0000 .0000 5.0000 3 'Normalizat' .87815 1.0000 .10000E-01 10.000 4 'Prefactor ' .89871 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6680E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 6221.639 FROM MIGRAD STATUS=CONVERGED 41 CALLS 223 TOTAL EDM= .46E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .0000 .46397E-01 .42118E-04** at limit ** 2 alpha .93295E-01 .27849 -.46814E-03 .0000 3 Normalizat .87816 1.2144 .15499E-03 -.58647E-03 4 Prefactor .89869 1.2437 -.19973E-03 -.56117E-03 ERR DEF= .500 Final values: norm = 0 alpha = 0.0932947 Normalizat = 0.878156 Prefactor = 0.898689 ********** ** 18 **HESSE ********** MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 6221.639 FROM HESSE STATUS=FAILED 9 CALLS 232 TOTAL EDM= .46E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .0000 .46397E-01 .42118E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha .69267E-01 .27849 -.46814E-03 -1.2967 3 Normalizat .87816 1.2144 .15499E-03 -.97232 4 Prefactor .89869 1.2437 -.19973E-03 -.96187 ERR DEF= .500 Minuit fit quality: 1 estimated distance: 4.59349e-10 Minuit parameter uncertainties: 1 1.70561e-06 2 0.287027 3 1.2557 4 1.28665 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/20026': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 101 logL (Free Index) = 6221.63879329 delta logL = -1.19143805932e-10 Extracting fit parameters... 4FGL J1253.2+5301 Spectrum: LogParabola 333 norm: 0.000e+00 1.706e-06 0.000e+00 1.000e+06 ( 1.000e-12) 334 alpha: 9.329e-02 2.870e-01 0.000e+00 5.000e+00 ( 1.000e+00) 335 beta: 8.810e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 336 Eb: 1.175e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 665 Prefactor: 8.987e-01 1.287e+00 0.000e+00 1.000e+01 ( 1.000e+00) 666 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 667 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 664 Normalization: 8.782e-01 1.256e+00 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 193.307 53.017 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/20026/cmap_HighResolution_692928001_693187201_4FGL_J1253.2+5301_daily_bin1750.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/20026 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.07e-05', job_status='DONE', photon_flux_upper_limit='2.87e-08', time_completed='2022-12-20 01:35:40.167674', job_id='20026', GAL2='0.90', fit_tolerance='1e-08', EG2='0.88', EG='0.88', time_epoch_completed='1671528940.17', return_code2='101', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.90', dlogl='-1.19e-10', ts2='0.00', photon_index_error='0.00', photon_index='1.93' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Dec 20 01:35:40 PST 2022 ion(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='1671527819.81' at line 1 Command execution failed. Waiting 27.0894638226 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 1.92742991215 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 21.5121226464 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 2.70380849473 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 27.6669316898 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 21.3266609577 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 20.8086175021 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 2.41636348574 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 29.6890233766 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 4.97621185816 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 12.3096475564 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 22.2858558555 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 25.0052565446 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 11.8256207216 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 3.08189392946 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 21.321008102 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 25.2262778541 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 29.711432983 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 9.83863930465 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 16.3689816615 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 9.01928883671 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 22.4860336665 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 27.0321765861 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 26.4349956384 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 15.66176747 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 10.4117470971 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 1.39642651169 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 26.6465089596 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 6.67612613963 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 18.7766664277 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 2.15823244908 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 0.351681717168 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 4.73357781247 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 23.8079718958 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 3.15691162267 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 6.80142442275 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 23.0582454812 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 6.78144144955 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 3.63609118611 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 0.318800564655 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 0.152427046476 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671527819.81', time_completed='2022-12-20 01:16:59.809105', job_id='16137' WHERE bin_id='1750' AND source_name='4FGL J1253.2+5301' 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='1671527819.81' 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='1671527819.81' at line 1 Command execution failed. Waiting 26.245208993 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Dec 20 01:27:24 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 16137: <4FGL_J1253.2+5301_daily_bin1750> in cluster Done Job <4FGL_J1253.2+5301_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:05:14 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:05:15 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:05:15 2022 Terminated at Tue Dec 20 01:27:25 2022 Results reported at Tue Dec 20 01:27:25 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1253.2+5301_daily_bin1750 193.307 53.0173 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1253.2+5301 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 659.00 sec. Max Memory : 1257 MB Average Memory : 334.90 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1329 sec. Turnaround time : 1331 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 20026: <4FGL_J1253.2+5301_daily_bin1750> in cluster Done Job <4FGL_J1253.2+5301_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:20:19 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:20:20 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:20:20 2022 Terminated at Tue Dec 20 01:35:40 2022 Results reported at Tue Dec 20 01:35:40 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1253.2+5301_daily_bin1750 193.307 53.0173 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1253.2+5301 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 781.00 sec. Max Memory : 617 MB Average Memory : 264.71 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 920 sec. Turnaround time : 921 sec. The output (if any) is above this job summary.