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 151 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 = 7639 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0706.8+7742_daily_bin1730 RA = 106.725, Dec = 77.7002 tmin = 687744001, tmax = 688003201 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='467625', job_status='RUN', time_executed='2022-10-21 00:32:57.683964', time_epoch_executed='1666337577.68' WHERE source_name='4FGL J0706.8+7742' and cadence='daily' and bin_id='1730' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/467625 Creating custom pfile directory: /scratch/kocevski/467625/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/467625/ft1_4FGL_J0706.8+7742_daily_bin1730.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=687744001.0 && nMetStart<688003201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Merged file saved to: /scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/467625/ft1_4FGL_J0706.8+7742_daily_bin1730.fits outfile=/scratch/kocevski/467625/ft1_filteredMKT_4FGL_J0706.8+7742_daily_bin1730.fits ra=106.725 dec=77.7002 rad=12.0 tmin=687744001.0 tmax=688003201.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 4.93 user 4.69 sys 0.20 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.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/467625/ft1_filteredMKT_4FGL_J0706.8+7742_daily_bin1730.fits evtable="EVENTS" outfile="/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.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.50 user 0.33 sys 0.15 Number of photons that the gtmktime cut: 1041 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits" evtable="EVENTS" scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits sctable="SC_DATA" outfile=/scratch/kocevski/467625/ltcube_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.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/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits .....................! real 11.93 user 11.50 sys 0.40 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits evtable="EVENTS" scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits sctable="SC_DATA" expcube=/scratch/kocevski/467625/ltcube_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits outfile=/scratch/kocevski/467625/expmap_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.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/467625/ltcube_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits .....................! real 192.18 user 187.45 sys 4.35 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 214 point sources and 0 extended sources Setting source of interest to: 4FGL J0706.8+7742 @ 106.725 77.7002 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits outfile=/scratch/kocevski/467625/cmap_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.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=106.725 yref=77.7002 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.54 user 0.37 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits outfile=/scratch/kocevski/467625/cmap_HighResolution_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.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=106.725 yref=77.7002 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.55 user 0.37 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits evtable="EVENTS" scfile=/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/467625/Model_4FGL_J0706.8+7742_daily_bin1730.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/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits.....................! real 131.09 user 129.49 sys 1.29 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits', '/scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits', expMap='/scratch/kocevski/467625/expmap_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits', expCube='/scratch/kocevski/467625/ltcube_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/467625/Model_4FGL_J0706.8+7742_daily_bin1730.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0706.8+7742' 4FGL J0706.8+7742 Spectrum: LogParabola 253 norm: 6.953e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 254 alpha: 1.861e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 255 beta: 1.188e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 256 Eb: 1.302e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/467625/ft1_filtered_4FGL_J0706.8+7742_daily_bin1730.fits Spacecraft file(s): /scratch/kocevski/467625/ft2_4FGL_J0706.8+7742_daily_bin1730.fits Exposure map: /scratch/kocevski/467625/expmap_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits Exposure cube: /scratch/kocevski/467625/ltcube_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/467625/Model_4FGL_J0706.8+7742_daily_bin1730.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) = 11034.206007 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 11034.1290972 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .51537E-05 1.0000 .0000 .10000E+07 2 'Prefactor ' .50707E-02 1.0000 .0000 .10000E+07 3 'Prefactor ' .46850E-02 1.0000 .0000 .10000E+07 4 'Prefactor ' .11616E-02 1.0000 .0000 .10000E+07 5 'Prefactor ' 34.332 1.0000 .0000 .10000E+07 6 'norm ' .50339E-03 1.0000 .0000 .10000E+07 7 'norm ' 2.0668 1.0000 .0000 .10000E+07 8 'norm ' 25.697 1.0000 .0000 .10000E+07 9 'Prefactor ' .10586E-01 1.0000 .0000 .10000E+07 10 'Prefactor ' 6.1187 1.0000 .0000 .10000E+07 11 'norm ' 1.3512 1.0000 .0000 .10000E+07 12 'Prefactor ' 24.972 1.0000 .0000 .10000E+07 13 'Prefactor ' 11.796 1.0000 .0000 .10000E+07 14 'Prefactor ' 9.0305 1.0000 .0000 .10000E+07 15 'norm ' 9.7253 1.0000 .0000 .10000E+07 16 'Prefactor ' .76015E-02 1.0000 .0000 .10000E+07 17 'Normalizat' .92435 1.0000 .10000E-01 10.000 18 'Prefactor ' .98659 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6940E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 11034.13 FROM MIGRAD STATUS=CONVERGED 115 CALLS 1238 TOTAL EDM= .12E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.0% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .27756E-09 2.2801 .60161E-06** at limit ** 2 Prefactor .94369E-09 9.1508 .85465E-07** at limit ** 3 Prefactor .0000 9.9519 .20548E-05** at limit ** 4 Prefactor .39137E-05 9.2554 .38377E-05** at limit ** 5 Prefactor 35.682 9.8691 -.11302E-05 .11793 6 norm .27756E-09 5.9941 -.12345E-05** at limit ** 7 norm 2.0650 .63765 .72991E-07 -.37599E-02 8 norm 25.481 17.677 -.50741E-05 -.83786E-01 9 Prefactor .36009E-05 33.278 -.74656E-05** at limit ** 10 Prefactor 6.1250 4.0161 .32154E-06 .10541E-01 11 norm 1.2931 2.0058 -.13157E-05 .39455E-03 12 Prefactor 26.161 5.6206 .47121E-06 .15221E-01 13 Prefactor 11.622 8.2044 .15601E-06 .30559E-02 14 Prefactor 8.9755 8.1452 -.37740E-07 .18994E-02 15 norm 9.6936 4.6550 .17064E-05 -.10327E-02 16 Prefactor .31500E-05 13.576 .41002E-06** at limit ** 17 Normalizat .92209 .17463 .10385E-04 .79199E-03 18 Prefactor .98716 .89832E-01 -.99083E-05 .10383E-02 ERR DEF= .500 Final values: Prefactor = 2.77556e-10 Prefactor = 9.4369e-10 Prefactor = 0 Prefactor = 3.9137e-06 Prefactor = 35.6821 norm = 2.77556e-10 norm = 2.06501 norm = 25.4808 Prefactor = 3.6009e-06 Prefactor = 6.12502 norm = 1.29315 Prefactor = 26.1607 Prefactor = 11.6219 Prefactor = 8.97554 norm = 9.69358 Prefactor = 3.15004e-06 Normalizat = 0.92209 Prefactor = 0.987161 ********** ** 18 **HESSE ********** FCN= 11034.13 FROM HESSE STATUS=OK 282 CALLS 1520 TOTAL EDM= .70E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .27756E-09 2.2911 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor .94369E-09 9.1733 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor .0000 28.641 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor .39137E-05 29.119 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor 35.682 25.691 .17069E-03 -1.5588 6 norm .27756E-09 6.0422 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm 2.0650 .63895 .71836E-03 -1.5679 8 norm 25.481 19.129 .19731E-03 -1.5607 9 Prefactor .36009E-05 39.200 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor 6.1250 4.0156 .40564E-03 -1.5658 11 norm 1.2931 2.6342 .94076E-03 -1.5685 12 Prefactor 26.161 30.082 .20016E-03 -1.5606 13 Prefactor 11.622 8.1937 .29143E-03 -1.5640 14 Prefactor 8.9755 8.1472 .33329E-03 -1.5648 15 norm 9.6936 4.6711 .32109E-03 -1.5646 16 Prefactor .31500E-05 28.814 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Normalizat .92209 .15814 .74543E-01 -.95688 18 Prefactor .98716 .79439E-01 .46099E-01 -.93159 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 7.04436e-07 Minuit parameter uncertainties: 1 5.17534e-05 2 0.000186663 3 6.4856e-06 4 0.0213509 5 25.6911 6 7.96528e-05 7 0.638945 8 19.1289 9 0.0237618 10 4.01561 11 2.63416 12 30.0824 13 8.19367 14 8.1472 15 4.67108 16 0.0190542 17 0.158223 18 0.0794482 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 11034.1257836 Extracting fit parameters... 4FGL J0706.8+7742 Spectrum: LogParabola 253 norm: 2.776e-10 7.965e-05 0.000e+00 1.000e+06 ( 1.000e-13) 254 alpha: 1.861e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 255 beta: 1.188e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 256 Eb: 1.302e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 691 Prefactor: 9.872e-01 7.945e-02 0.000e+00 1.000e+01 ( 1.000e+00) 692 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 693 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 690 Normalization: 9.221e-01 1.582e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 106.725 77.700 Photon Flux Upper Limit: 2.65e-08 ph cm-2 s-1 Energy Flux Upper Limit: 2.25e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/467625/likelihoodResults_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.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) = 11034.2054231 delta logL = -0.0796394548433 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 11034.1257863 delta logL = -2.62952016783e-06 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .24441E-04 1.0000 .0000 .10000E+07 2 'alpha ' 2.9558 1.0000 .0000 5.0000 3 'Normalizat' .92199 1.0000 .10000E-01 10.000 4 'Prefactor ' .98718 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6940E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 11034.13 FROM MIGRAD STATUS=CONVERGED 76 CALLS 231 TOTAL EDM= .77E-13 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .11102E-09 .14152 .42118E-03** at limit ** 2 alpha .68585 2.7521 .42051 -.97328E-10 3 Normalizat .92209 .11155E-02 .74543E-01 .21905E-03 4 Prefactor .98716 .60676E-03 .46107E-01 .11562E-03 ERR DEF= .500 Final values: norm = 1.11022e-10 alpha = 0.685845 Normalizat = 0.922088 Prefactor = 0.987161 ********** ** 18 **HESSE ********** FCN= 11034.13 FROM HESSE STATUS=NOT POSDEF 27 CALLS 258 TOTAL EDM= .54E-12 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .11102E-09 .76529 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha .68585 3.7503 .50000 -.81200 3 Normalizat .92209 .25894E-02 .32988E-03 -.95688 4 Prefactor .98716 .14108E-02 .17309E-03 -.93159 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 5.42056e-13 Minuit parameter uncertainties: 1 1.6805e-05 2 68602.2 3 0.00258937 4 0.00141078 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/467625': 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) = 11034.1257836 delta logL = 3.03771230392e-10 Extracting fit parameters... 4FGL J0706.8+7742 Spectrum: LogParabola 253 norm: 1.110e-10 1.680e-05 0.000e+00 1.000e+06 ( 1.000e-13) 254 alpha: 6.858e-01 6.860e+04 0.000e+00 5.000e+00 ( 1.000e+00) 255 beta: 1.188e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 256 Eb: 1.302e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 691 Prefactor: 9.872e-01 1.411e-03 0.000e+00 1.000e+01 ( 1.000e+00) 692 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 693 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 690 Normalization: 9.221e-01 2.589e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 106.725 77.700 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/467625/cmap_HighResolution_687744001_688003201_4FGL_J0706.8+7742_daily_bin1730.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/467625 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.25e-05', job_status='DONE', photon_flux_upper_limit='2.65e-08', time_completed='2022-10-21 00:46:27.764940', job_id='467625', GAL2='0.99', fit_tolerance='1e-08', EG2='0.92', EG='0.92', time_epoch_completed='1666338387.77', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.99', dlogl='3.04e-10', ts2='-0.00', photon_index_error='0.00', photon_index='1.86' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; Database successfully updated. Analysis Complete. Fri Oct 21 00:46:27 PDT 2022 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='1666337276.83' at line 1 Command execution failed. Waiting 1.08296946454 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 0.0688618756718 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 9.42342709689 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 12.2434391964 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 28.53404981 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 22.7390341863 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 6.41138425763 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 2.31017738686 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 12.5279482893 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 29.1839614135 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 0.271099025775 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 24.0772252917 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 13.5145730202 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 25.4103329303 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 21.9284542865 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 22.6398926248 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 21.6301287535 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 21.576355211 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 16.5269062266 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 2.69714412493 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 6.56723952422 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 12.9516506125 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 28.4633340915 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 7.23055489053 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 14.4251098248 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 19.8190929688 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 9.54442282216 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 18.6546295883 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 4.74958924994 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 6.75443045084 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 3.67634245663 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 13.3637507306 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 10.4889352642 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 25.4456296601 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 4.51468991456 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 3.94652474683 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 0.576051651961 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 17.8104103694 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 10.4637865432 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 3.13518687488 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 13.4120117546 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 27.3048987852 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1666337276.83', time_completed='2022-10-21 00:27:56.827419', job_id='460754' WHERE bin_id='1730' AND source_name='4FGL J0706.8+7742' 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='1666337276.83' 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='1666337276.83' at line 1 Command execution failed. Waiting 28.4817332774 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Fri Oct 21 00:38:04 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 460754: <4FGL_J0706.8+7742_daily_bin1730> in cluster Done Job <4FGL_J0706.8+7742_daily_bin1730> was submitted from host by user in cluster at Fri Oct 21 00:06:35 2022 Job was executed on host(s) , in queue , as user in cluster at Fri Oct 21 00:06:37 2022 was used as the home directory. was used as the working directory. Started at Fri Oct 21 00:06:37 2022 Terminated at Fri Oct 21 00:38:05 2022 Results reported at Fri Oct 21 00:38:05 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0706.8+7742_daily_bin1730 106.725 77.7002 687744001 688003201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0706.8+7742 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 793.00 sec. Max Memory : 1094 MB Average Memory : 265.41 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1887 sec. Turnaround time : 1890 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 467625: <4FGL_J0706.8+7742_daily_bin1730> in cluster Done Job <4FGL_J0706.8+7742_daily_bin1730> was submitted from host by user in cluster at Fri Oct 21 00:30:13 2022 Job was executed on host(s) , in queue , as user in cluster at Fri Oct 21 00:30:15 2022 was used as the home directory. was used as the working directory. Started at Fri Oct 21 00:30:15 2022 Terminated at Fri Oct 21 00:46:29 2022 Results reported at Fri Oct 21 00:46:29 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0706.8+7742_daily_bin1730 106.725 77.7002 687744001 688003201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0706.8+7742 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 812.00 sec. Max Memory : 1094 MB Average Memory : 318.35 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 973 sec. Turnaround time : 976 sec. The output (if any) is above this job summary.