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 69 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 = 7444 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1119.0+1235_daily_bin1738 RA = 169.766, Dec = 12.5866 tmin = 689817601, tmax = 690076801 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='415567', job_status='RUN', time_executed='2022-11-14 01:02:07.707481', time_epoch_executed='1668416527.71' WHERE source_name='4FGL J1119.0+1235' and cadence='daily' and bin_id='1738' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/415567 Creating custom pfile directory: /scratch/kocevski/415567/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/415567/ft1_4FGL_J1119.0+1235_daily_bin1738.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/415567/ft1_4FGL_J1119.0+1235_daily_bin1738.fits outfile=/scratch/kocevski/415567/ft1_filteredMKT_4FGL_J1119.0+1235_daily_bin1738.fits ra=169.766 dec=12.5866 rad=12.0 tmin=689817601.0 tmax=690076801.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 4.11 user 3.87 sys 0.22 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.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/415567/ft1_filteredMKT_4FGL_J1119.0+1235_daily_bin1738.fits evtable="EVENTS" outfile="/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.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.51 user 0.35 sys 0.15 Number of photons that the gtmktime cut: 491 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits" evtable="EVENTS" scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits sctable="SC_DATA" outfile=/scratch/kocevski/415567/ltcube_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.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/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits .....................! real 16.75 user 16.23 sys 0.39 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits sctable="SC_DATA" expcube=/scratch/kocevski/415567/ltcube_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits outfile=/scratch/kocevski/415567/expmap_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.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/415567/ltcube_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits .....................! real 192.99 user 186.43 sys 5.80 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Added 189 point sources and 0 extended sources Setting source of interest to: 4FGL J1119.0+1235 @ 169.766 12.5866 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits outfile=/scratch/kocevski/415567/cmap_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.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=169.766 yref=12.5866 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.38 sys 0.16 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits outfile=/scratch/kocevski/415567/cmap_HighResolution_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.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=169.766 yref=12.5866 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.58 user 0.39 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/415567/Model_4FGL_J1119.0+1235_daily_bin1738.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/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits.....................! real 51.12 user 49.54 sys 1.38 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits', '/scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits', expMap='/scratch/kocevski/415567/expmap_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits', expCube='/scratch/kocevski/415567/ltcube_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/415567/Model_4FGL_J1119.0+1235_daily_bin1738.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1119.0+1235' 4FGL J1119.0+1235 Spectrum: LogParabola 287 norm: 3.793e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 288 alpha: 2.405e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 289 beta: 2.294e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 290 Eb: 5.376e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/415567/ft1_filtered_4FGL_J1119.0+1235_daily_bin1738.fits Spacecraft file(s): /scratch/kocevski/415567/ft2_4FGL_J1119.0+1235_daily_bin1738.fits Exposure map: /scratch/kocevski/415567/expmap_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits Exposure cube: /scratch/kocevski/415567/ltcube_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/415567/Model_4FGL_J1119.0+1235_daily_bin1738.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) = 5470.25754892 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 5469.71645836 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .17818E-03 1.0000 .0000 .10000E+07 2 'Prefactor ' 12.390 1.0000 .0000 .10000E+07 3 'Prefactor ' .16990E-02 1.0000 .0000 .10000E+07 4 'Prefactor ' 7.3526 1.0000 .0000 .10000E+07 5 'Prefactor ' 3.2829 1.0000 .0000 .10000E+07 6 'Prefactor ' 9.4158 1.0000 .0000 .10000E+07 7 'norm ' 1.1034 1.0000 .0000 .10000E+07 8 'Prefactor ' 13.139 1.0000 .0000 .10000E+07 9 'Prefactor ' .11346E-06 1.0000 .0000 .10000E+07 10 'norm ' .79601E-05 1.0000 .0000 .10000E+07 11 'Prefactor ' 4.1221 1.0000 .0000 .10000E+07 12 'Prefactor ' .71080E-05 1.0000 .0000 .10000E+07 13 'Prefactor ' .55667E-02 1.0000 .0000 .10000E+07 14 'Prefactor ' 4.5288 1.0000 .0000 .10000E+07 15 'Prefactor ' 5.4655 1.0000 .0000 .10000E+07 16 'Prefactor ' 5.9870 1.0000 .0000 .10000E+07 17 'Normalizat' .43040 1.0000 .10000E-01 10.000 18 'Prefactor ' 1.6438 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5960E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 5469.713 FROM MIGRAD STATUS=CONVERGED 198 CALLS 1110 TOTAL EDM= .41E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 3.2% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .26645E-08 25.640 .41726E-07** at limit ** 2 Prefactor 12.375 7.2833 .35796E-08 .46224E-03 3 Prefactor .48554E-01 284.46 .48148E-05** at limit ** 4 Prefactor 7.2258 9.2826 -.10739E-06 -.24782E-02 5 Prefactor 3.4537 10.738 .82320E-08 -.13077E-03 6 Prefactor 9.3975 10.817 .26396E-07 -.58359E-03 7 norm 1.1017 1.1802 -.21354E-07 -.30503E-02 8 Prefactor 13.269 18.086 .35912E-07 .39591E-03 9 Prefactor .0000 3.3254 -.24102E-07** at limit ** 10 norm .55511E-10 3.3567 -.10101E-06** at limit ** 11 Prefactor 4.1313 9.8700 -.11615E-06 .10288E-05 12 Prefactor .0000 10.417 .29657E-07** at limit ** 13 Prefactor .18319E-08 108.70 .27134E-06** at limit ** 14 Prefactor 4.6488 8.5879 .15808E-06 -.10085E-02 15 Prefactor 5.9434 12.659 -.11023E-06 -.14352E-02 16 Prefactor .10751E-05 2479.6 .84878E-05** at limit ** 17 Normalizat .43126 .21466 .61377E-06 -.52963E-04 18 Prefactor 1.6433 .21667 .13087E-05 .54791E-04 ERR DEF= .500 Final values: Prefactor = 2.66454e-09 Prefactor = 12.375 Prefactor = 0.0485539 Prefactor = 7.22584 Prefactor = 3.4537 Prefactor = 9.39747 norm = 1.10169 Prefactor = 13.2692 Prefactor = 0 norm = 5.55112e-11 Prefactor = 4.13129 Prefactor = 0 Prefactor = 1.83187e-09 Prefactor = 4.6488 Prefactor = 5.94341 Prefactor = 1.07508e-06 Normalizat = 0.43126 Prefactor = 1.64328 ********** ** 18 **HESSE ********** FCN= 5469.713 FROM HESSE STATUS=OK 296 CALLS 1406 TOTAL EDM= .12E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .26645E-08 2.6309 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor 12.375 7.3164 .28433E-03 -1.5638 3 Prefactor .48554E-01 8.7670 .56961E-02 -1.5712 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor 7.2258 9.4273 .36965E-03 -1.5654 5 Prefactor 3.4537 10.933 .55859E-03 -1.5671 6 Prefactor 9.3975 10.875 .32635E-03 -1.5647 7 norm 1.1017 1.2126 .11288E-02 -1.5687 8 Prefactor 13.269 18.211 .27608E-03 -1.5635 9 Prefactor .0000 3.3438 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 norm .55511E-10 3.3965 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Prefactor 4.1313 9.9289 .49626E-03 -1.5667 12 Prefactor .0000 10.395 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 Prefactor .18319E-08 112.06 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor 4.6488 8.5967 .47283E-03 -1.5665 15 Prefactor 5.9434 12.747 .42956E-03 -1.5659 16 Prefactor .10751E-05 2588.2 .41014E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Normalizat .43126 .19808 .81009E-01 -1.1572 18 Prefactor 1.6433 .19614 .46486E-01 -.73602 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.16413e-07 Minuit parameter uncertainties: 1 0.000167613 2 7.31643 3 1.30487 4 9.42736 5 10.933 6 10.8747 7 1.21263 8 18.2115 9 1.88913e-06 10 2.9802e-05 11 9.9289 12 1.11302e-05 13 0.000906263 14 8.59677 15 12.7468 16 0.105546 17 0.198405 18 0.196233 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 5469.71315348 Extracting fit parameters... 4FGL J1119.0+1235 Spectrum: LogParabola 287 norm: 5.551e-11 2.980e-05 0.000e+00 1.000e+06 ( 1.000e-12) 288 alpha: 2.405e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 289 beta: 2.294e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 290 Eb: 5.376e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 593 Prefactor: 1.643e+00 1.962e-01 0.000e+00 1.000e+01 ( 1.000e+00) 594 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 595 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 592 Normalization: 4.313e-01 1.984e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 169.766 12.587 Photon Flux Upper Limit: 4.89e-08 ph cm-2 s-1 Energy Flux Upper Limit: 1.47e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/415567/likelihoodResults_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 5469.71324241 delta logL = -8.8928731202e-05 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 5469.71315362 delta logL = -1.41542841448e-07 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .47296E-07 1.0000 .0000 .10000E+07 2 'alpha ' .89966 1.0000 .0000 5.0000 3 'Normalizat' .43122 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.6434 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5960E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 5469.713 FROM MIGRAD STATUS=CONVERGED 69 CALLS 270 TOTAL EDM= .40E-10 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .38858E-09 .51855E-01 .42118E-03** at limit ** 2 alpha 4.2500 4.3755 .50000 .15461E-09 3 Normalizat .43125 .83399E-03 .81010E-01 -.72084E-03 4 Prefactor 1.6433 .88151E-03 .46486E-01 -.55747E-03 ERR DEF= .500 Final values: norm = 3.88578e-10 alpha = 4.24996 Normalizat = 0.431252 Prefactor = 1.64328 ********** ** 18 **HESSE ********** FCN= 5469.713 FROM HESSE STATUS=NOT POSDEF 27 CALLS 297 TOTAL EDM= .24E-09 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .38858E-09 .31527 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 4.2500 2.8449 .50000 .77538 3 Normalizat .43125 .20291E-02 .35880E-03 -1.1572 4 Prefactor 1.6433 .21503E-02 .20547E-03 -.73602 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 2.43007e-10 Minuit parameter uncertainties: 1 2.20986e-05 2 95541.6 3 0.00202909 4 0.00215032 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/415567': 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) = 5469.71315348 delta logL = -1.41062628245e-09 Extracting fit parameters... 4FGL J1119.0+1235 Spectrum: LogParabola 287 norm: 3.886e-10 2.210e-05 0.000e+00 1.000e+06 ( 1.000e-12) 288 alpha: 4.250e+00 9.554e+04 0.000e+00 5.000e+00 ( 1.000e+00) 289 beta: 2.294e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 290 Eb: 5.376e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 593 Prefactor: 1.643e+00 2.150e-03 0.000e+00 1.000e+01 ( 1.000e+00) 594 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 595 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 592 Normalization: 4.313e-01 2.029e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 169.766 12.587 Creating a high resolution counts map... INFO: Auto-setting vmin to 0.000e+00 [aplpy.core] INFO: Auto-setting vmax to 0.000e+00 [aplpy.core] Saving /scratch/kocevski/415567/cmap_HighResolution_689817601_690076801_4FGL_J1119.0+1235_daily_bin1738.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/415567 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='1.47e-05', job_status='DONE', photon_flux_upper_limit='4.89e-08', time_completed='2022-11-14 01:11:01.837309', job_id='415567', GAL2='1.64', fit_tolerance='1e-08', EG2='0.43', EG='0.43', time_epoch_completed='1668417061.84', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='1.64', dlogl='-1.41e-09', ts2='-0.00', photon_index_error='0.00', photon_index='2.41' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; Database successfully updated. Analysis Complete. Mon Nov 14 01:11:01 PST 2022 r/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='1668416160.24' at line 1 Command execution failed. Waiting 5.49409195134 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 10.023660893 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 26.5090937495 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 0.393282851195 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 28.8268505661 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 7.64245382684 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 23.8085907654 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 26.0649825997 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 21.7730661106 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 10.6493893092 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 24.2935943939 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 25.6202166659 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 21.4996094852 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 14.7063817181 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 26.4244750631 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 23.6267063056 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 1.00680925014 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 11.2707578138 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 9.74005042125 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 0.668773044251 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 16.6092270115 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 2.07287256034 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 17.6600270645 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 19.7691707913 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 23.9320336129 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 13.0476092551 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 24.7431219913 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 21.929519734 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 18.0813976545 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 6.0903536588 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 19.9911101861 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 23.6012445172 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 23.0163808568 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 17.0055099598 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 2.03095451695 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416160.24', time_completed='2022-11-14 00:56:00.235900', job_id='410422' WHERE bin_id='1738' AND source_name='4FGL J1119.0+1235' 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='1668416160.24' 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='1668416160.24' at line 1 Command execution failed. Waiting 16.4793273793 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Mon Nov 14 01:06:07 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 410422: <4FGL_J1119.0+1235_daily_bin1738> in cluster Done Job <4FGL_J1119.0+1235_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 00:45:17 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 00:45:57 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 00:45:57 2022 Terminated at Mon Nov 14 01:06:08 2022 Results reported at Mon Nov 14 01:06:08 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1119.0+1235_daily_bin1738 169.766 12.5866 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1119.0+1235 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 511.10 sec. Max Memory : 1256 MB Average Memory : 321.08 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1210 sec. Turnaround time : 1251 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 415567: <4FGL_J1119.0+1235_daily_bin1738> in cluster Done Job <4FGL_J1119.0+1235_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 01:00:24 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 01:00:49 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 01:00:49 2022 Terminated at Mon Nov 14 01:11:02 2022 Results reported at Mon Nov 14 01:11:02 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1119.0+1235_daily_bin1738 169.766 12.5866 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1119.0+1235 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 534.63 sec. Max Memory : 1256 MB Average Memory : 342.95 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 613 sec. Turnaround time : 638 sec. The output (if any) is above this job summary.