aklog: Couldn't determine realm of user:aklog: No credentials cache found while getting realm /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: Daniel Kocevski (daniel.kocevski@nasa.gov) Waiting 171 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 = 7720 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1604.5-4441_daily_bin1720 RA = 241.128, Dec = -44.6903 tmin = 685152001, tmax = 685411201 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='17158', job_status='RUN', time_executed='2022-09-21 10:53:29.871580', time_epoch_executed='1663782809.87' WHERE source_name='4FGL J1604.5-4441' and cadence='daily' and bin_id='1720' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/17158 Creating custom pfile directory: /scratch/kocevski/17158/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=685152001.0 && nMetStart<685411201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=685152001.0 && nMetStart<685411201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/17158/ft1_4FGL_J1604.5-4441_daily_bin1720.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=685152001.0 && nMetStart<685411201.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Merged file saved to: /scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/17158/ft1_4FGL_J1604.5-4441_daily_bin1720.fits outfile=/scratch/kocevski/17158/ft1_filteredMKT_4FGL_J1604.5-4441_daily_bin1720.fits ra=241.128 dec=-44.6903 rad=12.0 tmin=685152001.0 tmax=685411201.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.86 user 3.56 sys 0.25 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.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/17158/ft1_filteredMKT_4FGL_J1604.5-4441_daily_bin1720.fits evtable="EVENTS" outfile="/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.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.52 user 0.35 sys 0.16 Number of photons that the gtmktime cut: 10699 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits" evtable="EVENTS" scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits sctable="SC_DATA" outfile=/scratch/kocevski/17158/ltcube_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.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/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits .....................! real 15.35 user 14.98 sys 0.32 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits evtable="EVENTS" scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits sctable="SC_DATA" expcube=/scratch/kocevski/17158/ltcube_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits outfile=/scratch/kocevski/17158/expmap_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.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/17158/ltcube_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits .....................! real 191.63 user 186.17 sys 5.02 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 Extended source HESS J1614-518 in ROI with RadialDisk spatial model. Extended source HESS J1616-508 in ROI with RadialDisk spatial model. Extended source FGES J1631.6-4756 in ROI with RadialDisk spatial model. Extended source FGES J1633.0-4746 in ROI with RadialDisk spatial model. Extended source G337.0-0.1 in ROI with RadialDisk spatial model. Extended source FGES J1652.2-4633 in ROI with RadialDisk spatial model. Extended source MSH 15-56 PWN in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/MSH15-56_PWN.fits is the correct path to the extended template. Extended source MSH 15-56 SNR in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/MSH15-56_SNRmask.fits is the correct path to the extended template. Extended source FGES J1553.8-5325 in ROI with RadialDisk spatial model. Extended source FHES J1642.1-5428 in ROI with RadialDisk spatial model. Extended source FGES J1655.5-4737 in ROI with RadialDisk spatial model. Extended source MSH 15-52 in ROI with RadialDisk spatial model. Extended source HESS J1534-571 in ROI with RadialDisk spatial model. Extended source RX J1713.7-3946 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/RXJ1713_2016_250GeV.fits is the correct path to the extended template. Extended source RCW 86 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/RCW86.fits is the correct path to the extended template. Extended source FHES J1501.0-6310 in ROI with RadialGaussian spatial model. Extended source HESS J1507-622 in ROI with RadialDisk spatial model. Extended source FHES J1626.9-2431 in ROI with RadialGaussian spatial model. Extended source FHES J1741.6-3917 in ROI with RadialDisk spatial model. Added 457 point sources and 19 extended sources If using unbinned likelihood you will need to rerun gtdiffrsp for the extended sources or rerun the makeModel function with optional argument psForce=True Setting source of interest to: 4FGL J1604.5-4441 @ 241.128 -44.6903 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits outfile=/scratch/kocevski/17158/cmap_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.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=241.128 yref=-44.6903 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.68 user 0.40 sys 0.16 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits outfile=/scratch/kocevski/17158/cmap_HighResolution_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.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=241.128 yref=-44.6903 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.57 user 0.41 sys 0.15 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits evtable="EVENTS" scfile=/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/17158/Model_4FGL_J1604.5-4441_daily_bin1720.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 FGES J1553.8-5325 adding source FGES J1631.6-4756 adding source FGES J1633.0-4746 adding source FGES J1652.2-4633 adding source FGES J1655.5-4737 adding source FHES J1501.0-6310 adding source FHES J1626.9-2431 adding source FHES J1642.1-5428 adding source FHES J1741.6-3917 adding source G337.0-0.1 adding source GAL_V02 adding source HESS J1507-622 adding source HESS J1534-571 adding source HESS J1614-518 adding source HESS J1616-508 adding source MSH 15-52 adding source MSH 15-56 PWN adding source MSH 15-56 SNR adding source RCW 86 adding source RX J1713.7-3946 Working on... /scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits.....................! real 6763.44 user 6748.93 sys 1.49 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits', '/scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits', expMap='/scratch/kocevski/17158/expmap_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits', expCube='/scratch/kocevski/17158/ltcube_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/17158/Model_4FGL_J1604.5-4441_daily_bin1720.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1604.5-4441' 4FGL J1604.5-4441 Spectrum: LogParabola 563 norm: 9.826e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 564 alpha: 2.381e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 565 beta: 8.528e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 566 Eb: 1.546e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/17158/ft1_filtered_4FGL_J1604.5-4441_daily_bin1720.fits Spacecraft file(s): /scratch/kocevski/17158/ft2_4FGL_J1604.5-4441_daily_bin1720.fits Exposure map: /scratch/kocevski/17158/expmap_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits Exposure cube: /scratch/kocevski/17158/ltcube_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/17158/Model_4FGL_J1604.5-4441_daily_bin1720.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) = 87318.2469629 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 87318.2271586 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .85537E-04 1.0000 .0000 .10000E+07 2 'norm ' .29300 1.0000 .0000 .10000E+07 3 'Prefactor ' 23.231 1.0000 .0000 .10000E+07 4 'norm ' .71942E-06 1.0000 .0000 .10000E+07 5 'norm ' 19.957 1.0000 .0000 .10000E+07 6 'norm ' .36038E-03 1.0000 .0000 .10000E+07 7 'Prefactor ' 4.7857 1.0000 .0000 .10000E+07 8 'Prefactor ' 6.3098 1.0000 .0000 .10000E+07 9 'Prefactor ' .26381 1.0000 .0000 .10000E+07 10 'Normalizat' .97380 1.0000 .10000E-01 10.000 11 'Prefactor ' 1.0207 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .1697E+06 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 87318.23 FROM MIGRAD STATUS=CONVERGED 82 CALLS 781 TOTAL EDM= .44E-10 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .4% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .55511E-10 6.1232 .67020E-07** at limit ** 2 norm .29314 1.8063 -.15485E-06 .62293E-03 3 Prefactor 23.207 1.0896 -.25343E-08 .43437E-01 4 norm .0000 11.001 -.29960E-06** at limit ** 5 norm 20.106 7.4880 .17292E-07 -.44091E-03 6 norm .11102E-09 12.267 .15140E-06** at limit ** 7 Prefactor 4.7844 3.1668 .94109E-07 .61265E-03 8 Prefactor 6.3655 5.0429 -.48517E-07 -.84500E-04 9 Prefactor .26301 1.4895 -.10365E-06 -.70894E-04 10 Normalizat .97388 .27595 .29733E-05 .16556E-05 11 Prefactor 1.0207 .15416E-01 -.15775E-07 .49775E-04 ERR DEF= .500 Final values: norm = 5.55112e-11 norm = 0.293135 Prefactor = 23.2073 norm = 0 norm = 20.1055 norm = 1.11022e-10 Prefactor = 4.78436 Prefactor = 6.36552 Prefactor = 0.263008 Normalizat = 0.973878 Prefactor = 1.02067 ********** ** 18 **HESSE ********** FCN= 87318.23 FROM HESSE STATUS=OK 146 CALLS 927 TOTAL EDM= .33E-04 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .55511E-10 6.1085 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 norm .29314 1.8491 .10311E-02 -1.5697 3 Prefactor 23.207 18.431 .20753E-03 -1.5612 4 norm .0000 10.501 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 norm 20.106 7.4834 .22392E-03 -1.5618 6 norm .11102E-09 12.222 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 Prefactor 4.7844 3.2072 .45966E-03 -1.5664 8 Prefactor 6.3655 5.0729 .39936E-03 -1.5658 9 Prefactor .26301 .47053 .75765E-02 -1.5698 10 Normalizat .97388 .32961 .45838 -.93911 11 Prefactor 1.0207 .17081E-01 .25358E-01 -.92044 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 3.27556e-05 Minuit parameter uncertainties: 1 2.61166e-05 2 1.47246 3 18.431 4 2.33624e-05 5 7.48338 6 7.44974e-05 7 3.20725 8 5.07289 9 0.47053 10 0.330297 11 0.0170811 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 87318.226879 Extracting fit parameters... 4FGL J1604.5-4441 Spectrum: LogParabola 563 norm: 1.110e-10 7.450e-05 0.000e+00 1.000e+06 ( 1.000e-13) 564 alpha: 2.381e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 565 beta: 8.528e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 566 Eb: 1.546e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 1663 Prefactor: 1.021e+00 1.708e-02 0.000e+00 1.000e+01 ( 1.000e+00) 1664 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 1665 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 1627 Normalization: 9.739e-01 3.303e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 241.128 -44.690 Photon Flux Upper Limit: 1.06e-07 ph cm-2 s-1 Energy Flux Upper Limit: 4.01e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/17158/likelihoodResults_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.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) = 87318.2273374 delta logL = -0.000458387003164 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 87318.2166314 delta logL = 0.0102476026514 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .66006 1.0000 .0000 .10000E+07 2 'alpha ' .94481 1.0000 .0000 5.0000 3 'Normalizat' .97407 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.0206 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .1697E+06 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD TERMINATED WITHOUT CONVERGENCE. FCN= 87318.22 FROM MIGRAD STATUS=FAILED 97 CALLS 317 TOTAL EDM= .12E-03 STRATEGY= 1 ERR MATRIX APPROXIMATE EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .65939 9.9974 .25605E-04 .19892E-03 2 alpha .94088 1.5781 .50000 -.11824E-01 3 Normalizat .97372 .27018 .20878E-02 -.15247E-04 4 Prefactor 1.0207 .15262E-01 .11207E-03 .28891E-03 ERR DEF= .500 START SIMPLEX MINIMIZATION. CONVERGENCE WHEN EDM .LT. .20E-04 SIMPLEX MINIMIZATION HAS CONVERGED. FCN= 87318.22 FROM SIMPLEX STATUS=UNCHANGED 72 CALLS 389 TOTAL EDM= .13E-04 STRATEGY= 1 ERR MATRIX APPROXIMATE EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .65939 9.9974 .18500E-04 -1.5692 2 alpha .94088 1.5781 .36444E-02 -.67340 3 Normalizat .97372 .27018 .35508E-03 -.93916 4 Prefactor 1.0207 .15262E-01 .21509E-04 -.92044 ERR DEF= .500 MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MACHINE ACCURACY LIMITS FURTHER IMPROVEMENT. MIGRAD MINIMIZATION HAS CONVERGED. FCN= 87318.22 FROM MIGRAD STATUS=CONVERGED 42 CALLS 431 TOTAL EDM= .63E-04 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .65952 10.008 .0000 .97630E-02 2 alpha .94074 1.5781 .0000 -.11915E-01 3 Normalizat .97372 .27004 .0000 .21781E-05 4 Prefactor 1.0207 .15254E-01 .0000 .16231E-03 ERR DEF= .500 Final values: norm = 0.659524 alpha = 0.94074 Normalizat = 0.973721 Prefactor = 1.02065 ********** ** 18 **HESSE ********** FCN= 87318.22 FROM HESSE STATUS=OK 27 CALLS 458 TOTAL EDM= .13E-03 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .65952 10.005 .37412E-06 -1.5692 2 alpha .94074 1.5781 .50000 -.67347 3 Normalizat .97372 .27003 .16702E-04 -.93916 4 Prefactor 1.0207 .15253E-01 .89656E-06 -.92044 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 0.000125908 Minuit parameter uncertainties: 1 5.1376 2 1.83689 3 0.270406 4 0.0152527 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/17158': 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) = 87318.2166284 delta logL = 0.0102506548428 Extracting fit parameters... 4FGL J1604.5-4441 Spectrum: LogParabola 563 norm: 6.595e-01 5.138e+00 0.000e+00 1.000e+06 ( 1.000e-13) 564 alpha: 9.407e-01 1.837e+00 0.000e+00 5.000e+00 ( 1.000e+00) 565 beta: 8.528e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 566 Eb: 1.546e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 1663 Prefactor: 1.021e+00 1.525e-02 0.000e+00 1.000e+01 ( 1.000e+00) 1664 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 1665 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 1627 Normalization: 9.737e-01 2.704e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 241.128 -44.690 Creating a high resolution counts map... INFO: Auto-setting vmin to -2.000e-01 [aplpy.core] INFO: Auto-setting vmax to 2.220e+00 [aplpy.core] Saving /scratch/kocevski/17158/cmap_HighResolution_685152001_685411201_4FGL_J1604.5-4441_daily_bin1720.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/17158 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='4.01e-05', job_status='DONE', photon_flux_upper_limit='1.06e-07', time_completed='2022-09-21 14:43:13.598216', job_id='17158', GAL2='1.02', fit_tolerance='1e-08', EG2='0.97', EG='0.97', time_epoch_completed='1663796593.6', return_code2='0', ts='-0.00', comment='SUCCESS', return_code='0', GAL='1.02', dlogl='1.03e-02', ts2='0.02', photon_index_error='0.00', photon_index='2.38' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; Database successfully updated. Analysis Complete. Wed Sep 21 14:43:13 PDT 2022 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='1663782393.01' at line 1 Command execution failed. Waiting 6.38907492068 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 7.32340511847 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 21.1026494842 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 24.5391221482 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 15.479805515 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 21.6525946014 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 15.207756905 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 17.7749136809 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 17.9453175869 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 21.8185957391 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 29.6856830391 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 21.9695468664 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 8.51349258323 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 1.23584866615 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 25.2214045687 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 7.51001443696 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 20.9990136991 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 27.6246794461 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 15.4978197437 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 11.0555122291 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 9.80976879569 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 24.109213232 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 23.3800705934 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 14.4576447739 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 19.2896858921 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 10.6814489079 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 26.195951821 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 23.3643558884 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 4.4953194303 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 17.0650860453 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 8.92373966444 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 3.12690965005 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 17.939046703 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 3.25349703618 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 0.743332363479 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 6.49984748274 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 1.17177702423 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 7.18869076203 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663782393.01', time_completed='2022-09-21 10:46:33.012414', job_id='957755' WHERE bin_id='1720' AND source_name='4FGL J1604.5-4441' 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='1663782393.01' 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='1663782393.01' at line 1 Command execution failed. Waiting 17.3161493554 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Wed Sep 21 10:56:44 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 957755: <4FGL_J1604.5-4441_daily_bin1720> in cluster Done Job <4FGL_J1604.5-4441_daily_bin1720> was submitted from host by user in cluster at Wed Sep 21 07:15:12 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 08:04:13 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 08:04:13 2022 Terminated at Wed Sep 21 10:56:45 2022 Results reported at Wed Sep 21 10:56:45 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1604.5-4441_daily_bin1720 241.128 -44.6903 685152001 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1604.5-4441 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 9483.00 sec. Max Memory : 779 MB Average Memory : 680.19 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 10352 sec. Turnaround time : 13293 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 17158: <4FGL_J1604.5-4441_daily_bin1720> in cluster Done Job <4FGL_J1604.5-4441_daily_bin1720> was submitted from host by user in cluster at Wed Sep 21 10:50:26 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 10:50:27 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 10:50:27 2022 Terminated at Wed Sep 21 14:43:15 2022 Results reported at Wed Sep 21 14:43:15 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1604.5-4441_daily_bin1720 241.128 -44.6903 685152001 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1604.5-4441 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 13770.00 sec. Max Memory : 789 MB Average Memory : 691.26 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 13968 sec. Turnaround time : 13969 sec. The output (if any) is above this job summary.