/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 217 seconds before starting... Proceeding. Importing modules... This is make3FGLxml version 01r0. The default diffuse model files and names are for pass 8 and assume you have v10r00p05 of the Fermi Science Tools or higher. This is make4FGLDR3xml version 01r09. The default diffuse model files and names are for P8R3, 4FGL DRs, and the default fermitools directory locations. WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/matplotlib/cbook/deprecation.py:106: MatplotlibDeprecationWarning: The mpl_toolkits.axes_grid module was deprecated in version 2.1. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist provies the same functionality instead. warnings.warn(message, mplDeprecation, stacklevel=1) WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). number of points = 7381 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1345.5+4453_daily_bin1750 RA = 206.394, Dec = 44.8844 tmin = 692928001, tmax = 693187201 emin = 100.0, emax = 100000.0 irfs = P8R3_SOURCE_V2 ROI = 12 zmax = 90 Fitting strategies: Fix sources to their catalog values = True Leave variable source normalizations free = True Perform pre-fit where ALL sources are frozen to catalog values = False Perform secondary fit with a free spectral index = True Remove all catalog sources = False Remove weak (TS < 2) catalog sources = False Freeze Galactic component = False Likelihood fit parameters: Statistic: UNBINNED Optimizer: MINUIT Catalog: 4FGL Repository job = True LAT data source: Data catalog Updating database... UPDATE lightcurve_data_v2 SET job_id='21266', job_status='RUN', time_executed='2022-12-20 01:28:57.561991', time_epoch_executed='1671528537.56' WHERE source_name='4FGL J1345.5+4453' and cadence='daily' and bin_id='1750' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/21266 Creating custom pfile directory: /scratch/kocevski/21266/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/21266/ft1_4FGL_J1345.5+4453_daily_bin1750.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=692928001.0 && nMetStart<693187201.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/21266/ft1_4FGL_J1345.5+4453_daily_bin1750.fits outfile=/scratch/kocevski/21266/ft1_filteredMKT_4FGL_J1345.5+4453_daily_bin1750.fits ra=206.394 dec=44.8844 rad=12.0 tmin=692928001.0 tmax=693187201.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 3.52 user 3.30 sys 0.20 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits sctable="SC_DATA" filter="IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2))" roicut=no evfile=/scratch/kocevski/21266/ft1_filteredMKT_4FGL_J1345.5+4453_daily_bin1750.fits evtable="EVENTS" outfile="/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits" apply_filter=yes overwrite=yes header_obstimes=yes tstart=0.0 tstop=0.0 gtifile="default" chatter=3 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtmktime version HEAD Applying GTI filter: IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2)) real 0.49 user 0.31 sys 0.17 Number of photons that the gtmktime cut: 564 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits" evtable="EVENTS" scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits sctable="SC_DATA" outfile=/scratch/kocevski/21266/ltcube_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits dcostheta=0.025 binsz=1.0 phibins=0 tmin=0.0 tmax=0.0 file_version="1" zmin=0.0 zmax=90.0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Working on file /scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits .....................! real 11.88 user 11.49 sys 0.34 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits sctable="SC_DATA" expcube=/scratch/kocevski/21266/ltcube_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits outfile=/scratch/kocevski/21266/expmap_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits irfs="P8R3_SOURCE_V2" evtype="INDEF" srcrad=30.0 nlong=88 nlat=88 nenergies=10 submap=no nlongmin=0 nlongmax=0 nlatmin=0 nlatmax=0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). The exposure maps generated by this tool are meant to be used for *unbinned* likelihood analysis only. Do not use them for binned analyses. Computing the ExposureMap using /scratch/kocevski/21266/ltcube_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits .....................! real 191.89 user 186.03 sys 5.37 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 200 point sources and 0 extended sources Setting source of interest to: 4FGL J1345.5+4453 @ 206.394 44.8844 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits outfile=/scratch/kocevski/21266/cmap_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=160 nypix=160 binsz=0.25 coordsys="CEL" xref=206.394 yref=44.8844 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.52 user 0.36 sys 0.14 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits outfile=/scratch/kocevski/21266/cmap_HighResolution_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=500 nypix=500 binsz=0.1 coordsys="CEL" xref=206.394 yref=44.8844 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.54 user 0.38 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits evtable="EVENTS" scfile=/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/21266/Model_4FGL_J1345.5+4453_daily_bin1750.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source GAL_V02 Working on... /scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits.....................! real 50.00 user 48.64 sys 1.20 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits', '/scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits', expMap='/scratch/kocevski/21266/expmap_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits', expCube='/scratch/kocevski/21266/ltcube_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/21266/Model_4FGL_J1345.5+4453_daily_bin1750.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1345.5+4453' 4FGL J1345.5+4453 Spectrum: LogParabola 339 norm: 6.795e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-11) 340 alpha: 2.171e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 341 beta: 7.801e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 342 Eb: 4.556e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/21266/ft1_filtered_4FGL_J1345.5+4453_daily_bin1750.fits Spacecraft file(s): /scratch/kocevski/21266/ft2_4FGL_J1345.5+4453_daily_bin1750.fits Exposure map: /scratch/kocevski/21266/expmap_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits Exposure cube: /scratch/kocevski/21266/ltcube_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/21266/Model_4FGL_J1345.5+4453_daily_bin1750.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 6072.51201572 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 6071.99278159 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 6.5477 1.0000 .0000 .10000E+07 2 'norm ' .39457E-06 1.0000 .0000 .10000E+07 3 'Prefactor ' .19795E-02 1.0000 .0000 .10000E+07 4 'norm ' .34259E-04 1.0000 .0000 .10000E+07 5 'norm ' 30.038 1.0000 .0000 .10000E+07 6 'norm ' 3.5646 1.0000 .0000 .10000E+07 7 'Prefactor ' .28451E-03 1.0000 .0000 .10000E+07 8 'Prefactor ' 52.136 1.0000 .0000 .10000E+07 9 'Prefactor ' .70081E-02 1.0000 .0000 .10000E+07 10 'Prefactor ' .90760E-02 1.0000 .0000 .10000E+07 11 'norm ' 3.4912 1.0000 .0000 .10000E+07 12 'Prefactor ' 95.577 1.0000 .0000 .10000E+07 13 'norm ' .96502 1.0000 .0000 .10000E+07 14 'norm ' .18568E-06 1.0000 .0000 .10000E+07 15 'norm ' .10914E-04 1.0000 .0000 .10000E+07 16 'Prefactor ' 3.6656 1.0000 .0000 .10000E+07 17 'Prefactor ' 42.361 1.0000 .0000 .10000E+07 18 'Prefactor ' .92656 1.0000 .0000 .10000E+07 19 'Prefactor ' 25.254 1.0000 .0000 .10000E+07 20 'norm ' .69833E-07 1.0000 .0000 .10000E+07 21 'Prefactor ' .69869E-05 1.0000 .0000 .10000E+07 22 'Prefactor ' 3.9754 1.0000 .0000 .10000E+07 23 'Prefactor ' .69242 1.0000 .0000 .10000E+07 24 'norm ' .14680E-03 1.0000 .0000 .10000E+07 25 'Prefactor ' .39567E-02 1.0000 .0000 .10000E+07 26 'Prefactor ' .60966E-02 1.0000 .0000 .10000E+07 27 'Prefactor ' 5.9657 1.0000 .0000 .10000E+07 28 'Normalizat' 1.1303 1.0000 .10000E-01 10.000 29 'Prefactor ' .71792 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6350E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 6071.990 FROM MIGRAD STATUS=CONVERGED 180 CALLS 2725 TOTAL EDM= .15E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .9% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 6.2394 4.8790 -.80274E-08 .55283E-01 2 norm .0000 .85007 .33072E-07** at limit ** 3 Prefactor .12950E-05 12.408 -.77592E-07** at limit ** 4 norm .77716E-09 3.3885 -.35664E-07** at limit ** 5 norm 30.197 2.9204 -.17139E-07 -.20314E-01 6 norm 3.5533 3.6974 -.10942E-07 -.13343E-02 7 Prefactor .16807E-04 8.7791 .11966E-06** at limit ** 8 Prefactor 53.064 28.194 .39077E-07 -.65124E-01 9 Prefactor .77716E-09 16.319 .85173E-07** at limit ** 10 Prefactor .42005E-06 7.6677 .10346E-06** at limit ** 11 norm 3.4703 4.2418 .95365E-07 .49814E-02 12 Prefactor 97.520 47.264 -.10550E-06 -.12345 13 norm .96596 1.1014 .21383E-07 .39757E-02 14 norm .55511E-10 .98277 .33220E-07** at limit ** 15 norm .12212E-08 3.5965 -.31633E-07** at limit ** 16 Prefactor 3.0405 13.438 .18232E-06 -.13370E-01 17 Prefactor 44.267 32.242 -.53725E-07 .11012 18 Prefactor .89651 4.0747 .14229E-06 .10712E-02 19 Prefactor 25.405 3.6268 .34909E-07 -.25724E-01 20 norm .11102E-09 1.3339 .32497E-07** at limit ** 21 Prefactor .16653E-09 10.867 -.15734E-06** at limit ** 22 Prefactor 3.9777 2.5143 -.35461E-07 -.77169E-02 23 Prefactor .78289 28.662 -.43564E-06 -.15346E-01 24 norm .31086E-08 3.9360 .50619E-07** at limit ** 25 Prefactor .13933E-07 9.0257 .10527E-06** at limit ** 26 Prefactor .22649E-06 7.6629 -.70246E-08** at limit ** 27 Prefactor 5.6999 12.958 -.14511E-07 .14646E-01 28 Normalizat 1.1275 .18470 -.10713E-05 -.43317E-03 29 Prefactor .71991 .21930 -.70617E-07 -.24558E-03 ERR DEF= .500 Final values: Prefactor = 6.23938 norm = 0 Prefactor = 1.29502e-06 norm = 7.77156e-10 norm = 30.1975 norm = 3.55333 Prefactor = 1.68074e-05 Prefactor = 53.0643 Prefactor = 7.77156e-10 Prefactor = 4.20053e-07 norm = 3.47028 Prefactor = 97.5198 norm = 0.965959 norm = 5.55112e-11 norm = 1.22125e-09 Prefactor = 3.04047 Prefactor = 44.2668 Prefactor = 0.896513 Prefactor = 25.4055 norm = 1.11022e-10 Prefactor = 1.66533e-10 Prefactor = 3.97769 Prefactor = 0.782888 norm = 3.10862e-09 Prefactor = 1.39333e-08 Prefactor = 2.26485e-07 Prefactor = 5.69993 Normalizat = 1.12752 Prefactor = 0.719906 ********** ** 18 **HESSE ********** FCN= 6071.990 FROM HESSE STATUS=OK 617 CALLS 3342 TOTAL EDM= .16E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 6.2394 14.724 .39195E-03 -1.5658 2 norm .0000 .84929 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor .12950E-05 21.824 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 norm .77716E-09 3.3889 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 norm 30.197 17.101 .18249E-03 -1.5598 6 norm 3.5533 3.7563 .53506E-03 -1.5670 7 Prefactor .16807E-04 2.9330 .48221E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor 53.064 37.071 .13850E-03 -1.5562 9 Prefactor .77716E-09 24.605 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor .42005E-06 22.841 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 norm 3.4703 4.2964 .54089E-03 -1.5671 12 Prefactor 97.520 55.344 .10229E-03 -1.5510 13 norm .96596 1.1091 .42523E-03 -1.5688 14 norm .55511E-10 .98075 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm .12212E-08 3.5970 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 Prefactor 3.0405 138.39 .52733E-03 -1.5673 17 Prefactor 44.267 44.915 .15366E-03 -1.5575 18 Prefactor .89651 4.4452 .43941E-03 -1.5689 19 Prefactor 25.405 21.346 .19903E-03 -1.5607 20 norm .11102E-09 1.3324 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 21 Prefactor .16653E-09 11.187 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 22 Prefactor 3.9777 2.6357 .50563E-03 -1.5668 23 Prefactor .78289 32.757 .61325E-03 -1.5690 24 norm .31086E-08 3.9387 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 25 Prefactor .13933E-07 9.0455 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 26 Prefactor .22649E-06 21.461 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 27 Prefactor 5.6999 13.364 .41088E-03 -1.5660 28 Normalizat 1.1275 .16481 .36881E-01 -.88873 29 Prefactor .71991 .19097 .69222E-01 -1.0275 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.62486e-06 Minuit parameter uncertainties: 1 14.7236 2 8.37178e-06 3 0.0106327 4 0.000102638 5 17.1009 6 3.75633 7 0.0140422 8 37.0707 9 0.000276856 10 0.00619513 11 4.29642 12 55.3447 13 1.10905 14 1.45934e-05 15 0.000132803 16 41.0268 17 44.9154 18 3.9926 19 21.3458 20 2.14208e-05 21 7.95294e-05 22 2.6357 23 10.1282 24 0.000220591 25 0.000709362 26 0.0044095 27 13.3637 28 0.164885 29 0.191148 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 6071.98964063 Extracting fit parameters... 4FGL J1345.5+4453 Spectrum: LogParabola 339 norm: 9.660e-01 1.109e+00 0.000e+00 1.000e+06 ( 1.000e-11) 340 alpha: 2.171e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 341 beta: 7.801e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 342 Eb: 4.556e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 632 Prefactor: 7.199e-01 1.911e-01 0.000e+00 1.000e+01 ( 1.000e+00) 633 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 634 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 631 Normalization: 1.128e+00 1.649e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): 1.17 Ra Dec: 206.394 44.884 Photon Index (Fixed Index): 2.17 +/- 0.00 Photon Flux (Fixed Index): 2.04e-08 +/- 2.34e-08 Energy Flux (Fixed Index): 7.83e-06 +/- 8.99e-06 TS (Fixed Index): 1.17 Ra Dec: 206.394 44.884 Photon Flux Upper Limit: 7.55e-08 ph cm-2 s-1 Energy Flux Upper Limit: 2.90e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/21266/likelihoodResults_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 6071.97434942 delta logL = 0.0152912030844 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 6071.97382569 delta logL = 0.0158149386461 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .95159 1.0000 .0000 .10000E+07 2 'alpha ' 2.3630 1.0000 .0000 5.0000 3 'Normalizat' 1.1230 1.0000 .10000E-01 10.000 4 'Prefactor ' .72403 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6350E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 6071.974 FROM MIGRAD STATUS=CONVERGED 95 CALLS 244 TOTAL EDM= .25E-10 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .95156 1.1049 .81506E-05 .46532E-02 2 alpha 2.3629 1.0865 .26571E-01 .50711E-05 3 Normalizat 1.1230 .17960 .20522E-03 .26370E-04 4 Prefactor .72407 .21864 .30550E-03 .15555E-04 ERR DEF= .500 Final values: norm = 0.951563 alpha = 2.36295 Normalizat = 1.12298 Prefactor = 0.724069 ********** ** 18 **HESSE ********** FCN= 6071.974 FROM HESSE STATUS=OK 25 CALLS 269 TOTAL EDM= .25E-10 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .95156 1.0887 .32602E-06 -1.5688 2 alpha 2.3629 1.0717 .10628E-02 -.54849E-01 3 Normalizat 1.1230 .17972 .82087E-05 -.89017 4 Prefactor .72407 .21872 .12220E-04 -1.0259 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 2.53427e-11 Minuit parameter uncertainties: 1 1.08873 2 1.10775 3 0.179818 4 0.218982 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/21266': 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): 0 logL (Free Index) = 6071.97382567 delta logL = 0.0158149565359 Extracting fit parameters... 4FGL J1345.5+4453 Spectrum: LogParabola 339 norm: 9.516e-01 1.089e+00 0.000e+00 1.000e+06 ( 1.000e-11) 340 alpha: 2.363e+00 1.108e+00 0.000e+00 5.000e+00 ( 1.000e+00) 341 beta: 7.801e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 342 Eb: 4.556e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 632 Prefactor: 7.241e-01 2.190e-01 0.000e+00 1.000e+01 ( 1.000e+00) 633 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 634 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 631 Normalization: 1.123e+00 1.798e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): 1.19 Ra Dec: 206.394 44.884 Photon Index (Free Index): 2.36 +/- 1.11 Photon Flux (Free Index): 2.30e-08 +/- 2.92e-08 Energy Flux (Free Index): 7.14e-06 +/- 8.71e-06 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/21266/cmap_HighResolution_692928001_693187201_4FGL_J1345.5+4453_daily_bin1750.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/21266 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.90e-05', comment='SUCCESS', photon_flux='2.04e-08', energy_flux2='7.14e-06', photon_flux_error='2.34e-08', dlogl='1.58e-02', energy_flux='7.83e-06', photon_flux2='2.30e-08', job_status='DONE', time_completed='2022-12-20 01:41:26.168398', photon_index_error2='1.11', photon_index2='2.36', ts='1.17', fit_tolerance='1e-08', GAL='0.72', photon_index_error='0.00', photon_flux_upper_limit='7.55e-08', energy_flux_error2='8.71e-06', EG='1.13', time_epoch_completed='1671529286.17', return_code='0', job_id='21266', GAL2='0.72', EG2='1.12', return_code2='0', energy_flux_error='8.99e-06', photon_flux_error2='2.92e-08', ts2='1.19', photon_index='2.17' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Dec 20 01:41:26 PST 2022 variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 8.42628532185 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 27.8556216473 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 0.912263912731 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 28.8972010317 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 4.10977684454 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 25.1731939556 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 9.33581786322 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 4.53135609994 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 26.3836642404 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 8.79632207355 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 12.4768010964 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 5.15319535646 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 2.4745553232 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 2.74453843034 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 27.8392693542 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 18.8867736313 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 7.56308307772 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 7.30815599323 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 23.65477115 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 10.6218310356 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 25.7578875034 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 9.87805084953 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 2.75524912529 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 15.655889997 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 10.7801982952 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 14.8841186439 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 24.2166085418 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 25.1851770129 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 21.2868835861 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 5.47480550151 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 28.5929011168 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 17.5661223547 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 9.28387904239 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 9.99657097902 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 8.46102297842 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 23.3198296626 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 27.8374700724 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1671528230.42', time_completed='2022-12-20 01:23:50.420494', job_id='17490' WHERE bin_id='1750' AND source_name='4FGL J1345.5+4453' 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='1671528230.42' 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='1671528230.42' at line 1 Command execution failed. Waiting 16.6139312233 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Dec 20 01:34:01 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 17490: <4FGL_J1345.5+4453_daily_bin1750> in cluster Done Job <4FGL_J1345.5+4453_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:10:20 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:10:21 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:10:21 2022 Terminated at Tue Dec 20 01:34:02 2022 Results reported at Tue Dec 20 01:34:02 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1345.5+4453_daily_bin1750 206.394 44.8844 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1345.5+4453 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 706.00 sec. Max Memory : 1257 MB Average Memory : 314.49 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 7 Max Threads : 21 Run time : 1420 sec. Turnaround time : 1422 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 21266: <4FGL_J1345.5+4453_daily_bin1750> in cluster Done Job <4FGL_J1345.5+4453_daily_bin1750> was submitted from host by user in cluster at Tue Dec 20 01:25:11 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Dec 20 01:25:12 2022 was used as the home directory. was used as the working directory. Started at Tue Dec 20 01:25:12 2022 Terminated at Tue Dec 20 01:41:26 2022 Results reported at Tue Dec 20 01:41:26 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1345.5+4453_daily_bin1750 206.394 44.8844 692928001 693187201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1345.5+4453 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 750.44 sec. Max Memory : 1257 MB Average Memory : 270.56 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 974 sec. Turnaround time : 975 sec. The output (if any) is above this job summary.