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 202 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 = 7321 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J2334.8+1432_daily_bin1760 RA = 353.723, Dec = 14.5346 tmin = 695520001, tmax = 695779201 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='773185', job_status='RUN', time_executed='2023-01-19 02:59:28.145446', time_epoch_executed='1674125968.15' WHERE source_name='4FGL J2334.8+1432' and cadence='daily' and bin_id='1760' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/773185 Creating custom pfile directory: /scratch/kocevski/773185/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=695520001.0 && nMetStart<695779201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=695520001.0 && nMetStart<695779201.0' /Data/Flight/Level1/LPA Retrieving 45 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/773185/ft1_4FGL_J2334.8+1432_daily_bin1760.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=695520001.0 && nMetStart<695779201.0' /Data/Flight/Level1/LPA Retrieving 45 files... Done. Merging files... Merged file saved to: /scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/773185/ft1_4FGL_J2334.8+1432_daily_bin1760.fits outfile=/scratch/kocevski/773185/ft1_filteredMKT_4FGL_J2334.8+1432_daily_bin1760.fits ra=353.723 dec=14.5346 rad=12.0 tmin=695520001.0 tmax=695779201.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 2.45 user 2.21 sys 0.19 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.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/773185/ft1_filteredMKT_4FGL_J2334.8+1432_daily_bin1760.fits evtable="EVENTS" outfile="/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.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.53 user 0.34 sys 0.16 Number of photons that the gtmktime cut: 1147 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits" evtable="EVENTS" scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits sctable="SC_DATA" outfile=/scratch/kocevski/773185/ltcube_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.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/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits .....................! real 16.65 user 16.05 sys 0.39 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits evtable="EVENTS" scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits sctable="SC_DATA" expcube=/scratch/kocevski/773185/ltcube_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits outfile=/scratch/kocevski/773185/expmap_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.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/773185/ltcube_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits .....................! real 201.22 user 196.03 sys 4.63 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 161 point sources and 0 extended sources Setting source of interest to: 4FGL J2334.8+1432 @ 353.723 14.5346 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits outfile=/scratch/kocevski/773185/cmap_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.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=353.723 yref=14.5346 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.39 sys 0.15 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits outfile=/scratch/kocevski/773185/cmap_HighResolution_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.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=353.723 yref=14.5346 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.56 user 0.41 sys 0.14 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits evtable="EVENTS" scfile=/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/773185/Model_4FGL_J2334.8+1432_daily_bin1760.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/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits.....................! real 127.17 user 125.48 sys 1.31 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits', '/scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits', expMap='/scratch/kocevski/773185/expmap_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits', expCube='/scratch/kocevski/773185/ltcube_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/773185/Model_4FGL_J2334.8+1432_daily_bin1760.xml', optimizer='MINUIT') Using source of interest name: '4FGL J2334.8+1432' 4FGL J2334.8+1432 Spectrum: LogParabola 449 norm: 4.331e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 450 alpha: 1.902e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 451 beta: 8.816e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 452 Eb: 1.535e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/773185/ft1_filtered_4FGL_J2334.8+1432_daily_bin1760.fits Spacecraft file(s): /scratch/kocevski/773185/ft2_4FGL_J2334.8+1432_daily_bin1760.fits Exposure map: /scratch/kocevski/773185/expmap_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits Exposure cube: /scratch/kocevski/773185/ltcube_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/773185/Model_4FGL_J2334.8+1432_daily_bin1760.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) = 12058.3525601 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 12058.2812157 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .24662E-03 1.0000 .0000 .10000E+07 2 'Prefactor ' 44.018 1.0000 .0000 .10000E+07 3 'Prefactor ' 1.5717 1.0000 .0000 .10000E+07 4 'Prefactor ' .53465E-02 1.0000 .0000 .10000E+07 5 'Prefactor ' 1.4023 1.0000 .10000E-03 10000. 6 'Prefactor ' 1.5466 1.0000 .0000 .10000E+07 7 'Prefactor ' 3.5508 1.0000 .0000 .10000E+07 8 'Prefactor ' 4.9716 1.0000 .0000 .10000E+07 9 'Prefactor ' 3.9653 1.0000 .0000 .10000E+07 10 'Prefactor ' .26111E-03 1.0000 .0000 .10000E+07 11 'norm ' .56570 1.0000 .0000 .10000E+07 12 'Prefactor ' .61738 1.0000 .0000 .10000E+07 13 'Prefactor ' 18.383 1.0000 .0000 .10000E+07 14 'norm ' .31253E-04 1.0000 .0000 .10000E+07 15 'Prefactor ' .34446E-02 1.0000 .0000 .10000E+07 16 'Prefactor ' .46243E-03 1.0000 .0000 .10000E+07 17 'Prefactor ' .32953E-04 1.0000 .0000 .10000E+07 18 'Normalizat' 1.3162 1.0000 .10000E-01 10.000 19 'Prefactor ' .69041 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5270E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 12058.28 FROM MIGRAD STATUS=CONVERGED 146 CALLS 1177 TOTAL EDM= .57E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .9% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .61062E-09 7.6621 -.25889E-06** at limit ** 2 Prefactor 43.988 4.6271 .58825E-08 -.16097 3 Prefactor 1.5613 5.3079 .22745E-07 .27933E-02 4 Prefactor .13411E-06 10.667 .21112E-08** at limit ** 5 Prefactor 1.4026 .16240 .16890E-07 .32865E-03 6 Prefactor 1.5877 2.0635 -.19869E-07 .20545E-01 7 Prefactor 3.5242 3.9417 -.58107E-07 -.87976E-03 8 Prefactor 5.0138 4.0899 -.51942E-07 -.14125E-02 9 Prefactor 3.9377 5.1846 -.13909E-08 -.39255E-03 10 Prefactor .13323E-08 3.1445 .62855E-07** at limit ** 11 norm .53839 4.4809 -.20502E-06 -.58776E-03 12 Prefactor .64366 6.7774 -.28463E-06 -.41767E-02 13 Prefactor 18.552 1.8360 -.57206E-08 -.47656E-02 14 norm .11102E-09 3.5004 -.10380E-07** at limit ** 15 Prefactor .13711E-07 7.1719 .43974E-08** at limit ** 16 Prefactor .10425E-06 10.690 .25337E-07** at limit ** 17 Prefactor .10325E-07 77.110 -.68381E-06** at limit ** 18 Normalizat 1.3157 .17103 -.50296E-06 -.96637E-04 19 Prefactor .69061 .10115 .28233E-06 -.88629E-04 ERR DEF= .500 Final values: norm = 6.10623e-10 Prefactor = 43.9883 Prefactor = 1.56128 Prefactor = 1.34115e-07 Prefactor = 1.40262 Prefactor = 1.58766 Prefactor = 3.52422 Prefactor = 5.01381 Prefactor = 3.9377 Prefactor = 1.33227e-09 norm = 0.53839 Prefactor = 0.643659 Prefactor = 18.5523 norm = 1.11022e-10 Prefactor = 1.37113e-08 Prefactor = 1.0425e-07 Prefactor = 1.03251e-08 Normalizat = 1.31575 Prefactor = 0.69061 ********** ** 18 **HESSE ********** FCN= 12058.28 FROM HESSE STATUS=OK 320 CALLS 1497 TOTAL EDM= .28E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .61062E-09 .97849 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor 43.988 11.431 .15074E-03 -1.5575 3 Prefactor 1.5613 5.4649 .84756E-03 -1.5683 4 Prefactor .13411E-06 11.795 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor 1.4026 .16267 .32668E-02 -1.5471 6 Prefactor 1.5877 16.324 .85647E-03 -1.5683 7 Prefactor 3.5242 3.9645 .53614E-03 -1.5670 8 Prefactor 5.0138 4.0955 .45080E-03 -1.5663 9 Prefactor 3.9377 5.2560 .50629E-03 -1.5668 10 Prefactor .13323E-08 3.1654 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 norm .53839 4.7803 .72358E-03 -1.5693 12 Prefactor .64366 7.0961 .67685E-03 -1.5692 13 Prefactor 18.552 17.195 .23333E-03 -1.5622 14 norm .11102E-09 3.5146 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 Prefactor .13711E-07 7.3213 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 Prefactor .10425E-06 11.613 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Prefactor .10325E-07 1.9339 .57799E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 18 Normalizat 1.3157 .14919 .60921E-01 -.83098 19 Prefactor .69061 .86566E-01 .42273E-01 -1.0390 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 2.82225e-06 Minuit parameter uncertainties: 1 4.8996e-05 2 11.4306 3 5.46492 4 0.00251567 5 0.162673 6 10.1819 7 3.96454 8 4.09554 9 5.25597 10 0.000130111 11 3.20854 12 4.27433 13 17.1954 14 4.31671e-05 15 0.000633697 16 0.00220058 17 0.000282482 18 0.149235 19 0.0865833 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 12058.2804756 Extracting fit parameters... 4FGL J2334.8+1432 Spectrum: LogParabola 449 norm: 1.110e-10 4.317e-05 0.000e+00 1.000e+06 ( 1.000e-13) 450 alpha: 1.902e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 451 beta: 8.816e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 452 Eb: 1.535e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 524 Prefactor: 6.906e-01 8.658e-02 0.000e+00 1.000e+01 ( 1.000e+00) 525 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 526 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 523 Normalization: 1.316e+00 1.492e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 353.723 14.535 Photon Flux Upper Limit: 2.40e-08 ph cm-2 s-1 Energy Flux Upper Limit: 2.03e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/773185/likelihoodResults_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.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): 102 logL (Free Index) = 12058.2805287 delta logL = -5.3131570894e-05 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 12058.2804765 delta logL = -9.63222191785e-07 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .53774E-06 1.0000 .0000 .10000E+07 2 'alpha ' .83697 1.0000 .0000 5.0000 3 'Normalizat' 1.3158 1.0000 .10000E-01 10.000 4 'Prefactor ' .69066 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5270E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 12058.28 FROM MIGRAD STATUS=CONVERGED 73 CALLS 264 TOTAL EDM= .25E-10 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .27756E-09 .75099E-02 .42118E-03** at limit ** 2 alpha 3.5863 3.0998 .50000 .12733E-08 3 Normalizat 1.3157 .47784E-03 .60921E-01 .15813E-02 4 Prefactor .69061 .28823E-03 .42277E-01 .21107E-02 ERR DEF= .500 Final values: norm = 2.77556e-10 alpha = 3.58626 Normalizat = 1.31575 Prefactor = 0.690611 ********** ** 18 **HESSE ********** FCN= 12058.28 FROM HESSE STATUS=NOT POSDEF 29 CALLS 293 TOTAL EDM= .94E-09 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .27756E-09 .28418 .14707E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 3.5863 3.2296 .50000 .44949 3 Normalizat 1.3157 .28978E-02 .26944E-03 -.83098 4 Prefactor .69061 .17484E-02 .21584E-03 -1.0390 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 9.39237e-10 Minuit parameter uncertainties: 1 1.79061e-05 2 21336.1 3 0.0028978 4 0.00174836 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/773185': 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) = 12058.2804756 delta logL = -1.16597220767e-09 Extracting fit parameters... 4FGL J2334.8+1432 Spectrum: LogParabola 449 norm: 2.776e-10 1.791e-05 0.000e+00 1.000e+06 ( 1.000e-13) 450 alpha: 3.586e+00 2.134e+04 0.000e+00 5.000e+00 ( 1.000e+00) 451 beta: 8.816e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 452 Eb: 1.535e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 524 Prefactor: 6.906e-01 1.748e-03 0.000e+00 1.000e+01 ( 1.000e+00) 525 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 526 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 523 Normalization: 1.316e+00 2.898e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 353.723 14.535 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/773185/cmap_HighResolution_695520001_695779201_4FGL_J2334.8+1432_daily_bin1760.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/773185 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.03e-05', job_status='DONE', photon_flux_upper_limit='2.40e-08', time_completed='2023-01-19 03:11:53.821116', job_id='773185', GAL2='0.69', fit_tolerance='1e-08', EG2='1.32', EG='1.32', time_epoch_completed='1674126713.82', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.69', dlogl='-1.17e-09', ts2='-0.00', photon_index_error='0.00', photon_index='1.90' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; Database successfully updated. Analysis Complete. Thu Jan 19 03:11:53 PST 2023 f._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='1674125466.46' at line 1 Command execution failed. Waiting 2.55391434063 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 29.028249923 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 15.2323591861 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 5.4211883291 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 3.09826841731 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 20.152700922 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 4.43176559159 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 22.1416651278 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 9.66749236888 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 5.19410331771 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 6.60779783042 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 15.7941550371 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 4.96973901992 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 9.98216163561 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 1.50342723735 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 27.5786246395 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 14.6838774666 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 9.23410347451 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 6.95147473335 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 18.3504261831 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 5.43560629404 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 24.4342195241 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 24.2588369222 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 17.4702426901 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 17.1178005727 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 12.0796461421 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 20.6125021858 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 9.37219207315 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 17.3537671145 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 26.889000098 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 8.76379922831 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 25.2106164501 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 15.898684551 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 21.2129404958 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 19.4260772886 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 16.7497684756 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 19.3776686302 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 28.6422878069 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 0.207574447089 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 7.94952508953 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 1.37862732783 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1674125466.46', time_completed='2023-01-19 02:51:06.463674', job_id='767473' WHERE bin_id='1760' AND source_name='4FGL J2334.8+1432' 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='1674125466.46' 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='1674125466.46' at line 1 Command execution failed. Waiting 14.3790979025 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Thu Jan 19 03:01:10 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 767473: <4FGL_J2334.8+1432_daily_bin1760> in cluster Done Job <4FGL_J2334.8+1432_daily_bin1760> was submitted from host by user in cluster at Thu Jan 19 02:35:12 2023 Job was executed on host(s) , in queue , as user in cluster at Thu Jan 19 02:35:24 2023 was used as the home directory. was used as the working directory. Started at Thu Jan 19 02:35:24 2023 Terminated at Thu Jan 19 03:01:11 2023 Results reported at Thu Jan 19 03:01:11 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J2334.8+1432_daily_bin1760 353.723 14.5346 695520001 695779201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J2334.8+1432 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 735.12 sec. Max Memory : 1093 MB Average Memory : 303.17 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1546 sec. Turnaround time : 1559 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 773185: <4FGL_J2334.8+1432_daily_bin1760> in cluster Done Job <4FGL_J2334.8+1432_daily_bin1760> was submitted from host by user in cluster at Thu Jan 19 02:55:19 2023 Job was executed on host(s) , in queue , as user in cluster at Thu Jan 19 02:55:57 2023 was used as the home directory. was used as the working directory. Started at Thu Jan 19 02:55:57 2023 Terminated at Thu Jan 19 03:11:54 2023 Results reported at Thu Jan 19 03:11:54 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J2334.8+1432_daily_bin1760 353.723 14.5346 695520001 695779201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J2334.8+1432 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 746.01 sec. Max Memory : 1256 MB Average Memory : 320.68 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 957 sec. Turnaround time : 995 sec. The output (if any) is above this job summary.