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 96 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_J1736.0+2033_daily_bin1750 RA = 264.019, Dec = 20.5559 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='22281', job_status='RUN', time_executed='2022-12-20 01:32:04.532590', time_epoch_executed='1671528724.53' WHERE source_name='4FGL J1736.0+2033' and cadence='daily' and bin_id='1750' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/22281 Creating custom pfile directory: /scratch/kocevski/22281/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/22281/ft1_4FGL_J1736.0+2033_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/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/22281/ft1_4FGL_J1736.0+2033_daily_bin1750.fits outfile=/scratch/kocevski/22281/ft1_filteredMKT_4FGL_J1736.0+2033_daily_bin1750.fits ra=264.019 dec=20.5559 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 2.86 user 2.60 sys 0.18 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_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/22281/ft1_filteredMKT_4FGL_J1736.0+2033_daily_bin1750.fits evtable="EVENTS" outfile="/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_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.43 user 0.27 sys 0.15 Number of photons that the gtmktime cut: 807 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits" evtable="EVENTS" scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits sctable="SC_DATA" outfile=/scratch/kocevski/22281/ltcube_692928001_693187201_4FGL_J1736.0+2033_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/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits .....................! real 9.36 user 9.06 sys 0.28 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits sctable="SC_DATA" expcube=/scratch/kocevski/22281/ltcube_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits outfile=/scratch/kocevski/22281/expmap_692928001_693187201_4FGL_J1736.0+2033_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/22281/ltcube_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits .....................! real 152.80 user 148.59 sys 3.91 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 189 point sources and 0 extended sources Setting source of interest to: 4FGL J1736.0+2033 @ 264.019 20.5559 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits outfile=/scratch/kocevski/22281/cmap_692928001_693187201_4FGL_J1736.0+2033_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=264.019 yref=20.5559 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.46 user 0.31 sys 0.14 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits outfile=/scratch/kocevski/22281/cmap_HighResolution_692928001_693187201_4FGL_J1736.0+2033_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=264.019 yref=20.5559 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.46 user 0.30 sys 0.15 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/22281/Model_4FGL_J1736.0+2033_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/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits.....................! real 56.34 user 55.10 sys 1.00 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits', '/scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits', expMap='/scratch/kocevski/22281/expmap_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits', expCube='/scratch/kocevski/22281/ltcube_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/22281/Model_4FGL_J1736.0+2033_daily_bin1750.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1736.0+2033' 4FGL J1736.0+2033 Spectrum: LogParabola 284 norm: 9.104e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-14) 285 alpha: 1.744e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 286 beta: 1.473e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 287 Eb: 2.550e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/22281/ft1_filtered_4FGL_J1736.0+2033_daily_bin1750.fits Spacecraft file(s): /scratch/kocevski/22281/ft2_4FGL_J1736.0+2033_daily_bin1750.fits Exposure map: /scratch/kocevski/22281/expmap_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits Exposure cube: /scratch/kocevski/22281/ltcube_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/22281/Model_4FGL_J1736.0+2033_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) = 8333.07165426 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 8332.97998553 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .50870E-03 1.0000 .0000 .10000E+07 2 'Prefactor ' .89711E-01 1.0000 .0000 .10000E+07 3 'Prefactor ' 6.2100 1.0000 .0000 .10000E+07 4 'Prefactor ' 1.4464 1.0000 .0000 .10000E+07 5 'Prefactor ' 10.284 1.0000 .0000 .10000E+07 6 'norm ' .13201E-06 1.0000 .0000 .10000E+07 7 'Prefactor ' .65805E-04 1.0000 .0000 .10000E+07 8 'norm ' 5.4071 1.0000 .0000 .10000E+07 9 'Prefactor ' 4.5748 1.0000 .0000 .10000E+07 10 'norm ' .24610E-02 1.0000 .0000 .10000E+07 11 'Prefactor ' .68340E-01 1.0000 .0000 .10000E+07 12 'norm ' .57145 1.0000 .0000 .10000E+07 13 'Prefactor ' .18322E-04 1.0000 .0000 .10000E+07 14 'Prefactor ' 19.962 1.0000 .0000 .10000E+07 15 'Prefactor ' 1.6491 1.0000 .0000 .10000E+07 16 'norm ' .11093E-04 1.0000 .0000 .10000E+07 17 'Prefactor ' .35362E-02 1.0000 .0000 .10000E+07 18 'Normalizat' 1.0993 1.0000 .10000E-01 10.000 19 'Prefactor ' .91337 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6350E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 8332.969 FROM MIGRAD STATUS=CONVERGED 168 CALLS 1192 TOTAL EDM= .25E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 5.4% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .94369E-09 28.538 .23509E-06** at limit ** 2 Prefactor .0000 46.784 .12612E-06** at limit ** 3 Prefactor 6.2331 1.2928 -.21631E-08 .60109E-02 4 Prefactor .71110E-07 1690.8 -.47165E-04** at limit ** 5 Prefactor 10.014 12.383 -.16345E-06 .11174E-02 6 norm .0000 .69329 .20952E-07** at limit ** 7 Prefactor .44409E-09 9.0385 .66465E-06** at limit ** 8 norm 5.5159 8.4425 -.10491E-06 -.19099E-03 9 Prefactor 4.5554 3.8061 .33362E-07 .15061E-02 10 norm .38858E-09 58.379 .11117E-05** at limit ** 11 Prefactor .88818E-09 30.956 .13819E-05** at limit ** 12 norm .57053 .72875 -.54661E-07 -.14885E-02 13 Prefactor .16653E-09 9.4888 .71674E-06** at limit ** 14 Prefactor 14.278 44.605 -.18621E-05 -.76725E-03 15 Prefactor 1.7738 7.3206 .27080E-07 -.27626E-03 16 norm .55511E-10 10.809 .24141E-06** at limit ** 17 Prefactor .0000 22.564 .21712E-06** at limit ** 18 Normalizat 1.1021 .27392 -.69747E-05 .17586E-03 19 Prefactor .91334 .98385E-01 .15730E-05 .62951E-03 ERR DEF= .500 Final values: Prefactor = 9.4369e-10 Prefactor = 0 Prefactor = 6.23308 Prefactor = 7.11098e-08 Prefactor = 10.0135 norm = 0 Prefactor = 4.44089e-10 norm = 5.51588 Prefactor = 4.5554 norm = 3.88578e-10 Prefactor = 8.88178e-10 norm = 0.570534 Prefactor = 1.66533e-10 Prefactor = 14.2781 Prefactor = 1.77377 norm = 5.55112e-11 Prefactor = 0 Normalizat = 1.10206 Prefactor = 0.91334 ********** ** 18 **HESSE ********** FCN= 8332.969 FROM HESSE STATUS=OK 312 CALLS 1504 TOTAL EDM= .68E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .94369E-09 28.060 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor .0000 45.730 .14214E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor 6.2331 27.569 .40260E-03 -1.5658 4 Prefactor .71110E-07 64.381 .17537E-01 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor 10.014 12.394 .31220E-03 -1.5645 6 norm .0000 .69362 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 Prefactor .44409E-09 9.0726 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 norm 5.5159 8.4584 .43192E-03 -1.5661 9 Prefactor 4.5554 3.8296 .47039E-03 -1.5665 10 norm .38858E-09 58.592 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Prefactor .88818E-09 31.088 .14873E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 norm .57053 .74232 .71825E-03 -1.5693 13 Prefactor .16653E-09 9.5412 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor 14.278 44.689 .22389E-03 -1.5632 15 Prefactor 1.7738 7.3760 .82195E-03 -1.5681 16 norm .55511E-10 10.779 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Prefactor .0000 22.650 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 18 Normalizat 1.1021 .23798 .86895E-01 -.89686 19 Prefactor .91334 .84672E-01 .33730E-01 -.95677 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 6.78701e-07 Minuit parameter uncertainties: 1 0.000323782 2 1.61101e-05 3 26.2177 4 0.00427856 5 12.3944 6 3.24305e-06 7 0.000127297 8 8.45838 9 3.82963 10 0.000308504 11 0.000327892 12 0.742319 13 8.00823e-05 14 44.6898 15 7.23418 16 3.46301e-05 17 4.58333e-06 18 0.238213 19 0.0846846 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 8332.96903914 Extracting fit parameters... 4FGL J1736.0+2033 Spectrum: LogParabola 284 norm: 3.886e-10 3.085e-04 0.000e+00 1.000e+06 ( 1.000e-14) 285 alpha: 1.744e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 286 beta: 1.473e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 287 Eb: 2.550e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 632 Prefactor: 9.133e-01 8.468e-02 0.000e+00 1.000e+01 ( 1.000e+00) 633 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 634 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 631 Normalization: 1.102e+00 2.382e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 264.019 20.556 Photon Flux Upper Limit: 3.75e-08 ph cm-2 s-1 Energy Flux Upper Limit: 5.94e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/22281/likelihoodResults_692928001_693187201_4FGL_J1736.0+2033_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) = 8332.9772114 delta logL = -0.00817226118852 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 8332.83442345 delta logL = 0.134615693198 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' 1.2398 1.0000 .0000 .10000E+07 2 'alpha ' 3.7590 1.0000 .0000 5.0000 3 'Normalizat' 1.0736 1.0000 .10000E-01 10.000 4 'Prefactor ' .91720 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6350E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 8332.834 FROM MIGRAD STATUS=CONVERGED 57 CALLS 252 TOTAL EDM= .93E-08 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm 1.2421 54.555 .10069E-02 .15591E-01 2 alpha 3.7587 4.1541 .38075 .89924E-04 3 Normalizat 1.0738 .43069E-01 .87890E-01 -.58511E-04 4 Prefactor .91715 .15265E-01 .33664E-01 -.20585E-03 ERR DEF= .500 Final values: norm = 1.24209 alpha = 3.75875 Normalizat = 1.07378 Prefactor = 0.917152 ********** ** 18 **HESSE ********** FCN= 8332.834 FROM HESSE STATUS=NOT POSDEF 31 CALLS 283 TOTAL EDM= .86E-08 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm 1.2421 242.69 .19593E-04 -1.5686 2 alpha 3.7587 3.0693 .19739E-01 .52764 3 Normalizat 1.0738 .22513 .38921E-03 -.90598 4 Prefactor .91715 .76366E-01 .14875E-03 -.95544 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 8.61107e-09 Minuit parameter uncertainties: 1 34.7255 2 10.6976 3 0.225333 4 0.0763752 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/22281': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 8332.83442311 delta logL = 0.134616035044 Extracting fit parameters... 4FGL J1736.0+2033 Spectrum: LogParabola 284 norm: 1.242e+00 3.473e+01 0.000e+00 1.000e+06 ( 1.000e-14) 285 alpha: 3.759e+00 1.070e+01 0.000e+00 5.000e+00 ( 1.000e+00) 286 beta: 1.473e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 287 Eb: 2.550e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 632 Prefactor: 9.172e-01 7.638e-02 0.000e+00 1.000e+01 ( 1.000e+00) 633 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 634 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 631 Normalization: 1.074e+00 2.253e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 264.019 20.556 Creating a high resolution counts map... INFO: Auto-setting vmin to -1.000e-01 [aplpy.core] INFO: Auto-setting vmax to 1.110e+00 [aplpy.core] Saving /scratch/kocevski/22281/cmap_HighResolution_692928001_693187201_4FGL_J1736.0+2033_daily_bin1750.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/22281 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='5.94e-05', job_status='DONE', photon_flux_upper_limit='3.75e-08', time_completed='2022-12-20 01:40:42.676632', job_id='22281', GAL2='0.92', fit_tolerance='1e-08', EG2='1.07', EG='1.10', time_epoch_completed='1671529242.68', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.91', dlogl='1.35e-01', ts2='0.29', photon_index_error='0.00', photon_index='1.74' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Dec 20 01:40:42 PST 2022 andle_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='1671528608.49' at line 1 Command execution failed. Waiting 7.42889733402 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 26.9519769484 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 6.59879652269 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 18.0951535023 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 21.2852937458 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 24.2474226378 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 21.8739406949 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 22.3016861959 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 9.32411916762 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 16.2460809466 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 11.4080591972 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 5.11156164188 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 4.97257735527 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 19.9799064891 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 16.185754373 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 10.3155920956 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 8.66591497319 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 14.1371647047 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 10.8505999879 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 22.5917974593 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 28.0893111405 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 14.8545852354 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 28.3662217398 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 6.51932733177 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 12.691056505 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 14.4176335648 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 1.57546723485 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 4.87652536057 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 14.7256458141 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 13.3399507765 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 24.1049751545 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 19.5280165729 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 27.411054642 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 25.9492327456 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 22.0570070117 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 19.7073717033 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 1.73481753769 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 15.1416611118 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528608.49', time_completed='2022-12-20 01:30:08.490986', job_id='20049' WHERE bin_id='1750' AND source_name='4FGL J1736.0+2033' 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='1671528608.49' 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='1671528608.49' at line 1 Command execution failed. Waiting 12.7894179802 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Dec 20 01:40:23 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 20049: <4FGL_J1736.0+2033_daily_bin1750> in cluster Done Job <4FGL_J1736.0+2033_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:20:20 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:20:22 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:20:22 2022 Terminated at Tue Dec 20 01:40:23 2022 Results reported at Tue Dec 20 01:40:23 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1736.0+2033_daily_bin1750 264.019 20.5559 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1736.0+2033 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 524.00 sec. Max Memory : 1257 MB Average Memory : 327.56 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1201 sec. Turnaround time : 1203 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 22281: <4FGL_J1736.0+2033_daily_bin1750> in cluster Done Job <4FGL_J1736.0+2033_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:30:19 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:30:20 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:30:20 2022 Terminated at Tue Dec 20 01:40:43 2022 Results reported at Tue Dec 20 01:40:43 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1736.0+2033_daily_bin1750 264.019 20.5559 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1736.0+2033 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 519.00 sec. Max Memory : 1257 MB Average Memory : 317.74 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 622 sec. Turnaround time : 624 sec. The output (if any) is above this job summary.