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 212 seconds before starting... Proceeding. Importing modules... This is make3FGLxml version 01r0. The default diffuse model files and names are for pass 8 and assume you have v10r00p05 of the Fermi Science Tools or higher. This is make4FGLDR3xml version 01r09. The default diffuse model files and names are for P8R3, 4FGL DRs, and the default fermitools directory locations. WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/matplotlib/cbook/deprecation.py:106: MatplotlibDeprecationWarning: The mpl_toolkits.axes_grid module was deprecated in version 2.1. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist provies the same functionality instead. warnings.warn(message, mplDeprecation, stacklevel=1) WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). number of points = 7444 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0704.8+4907_daily_bin1738 RA = 106.207, Dec = 49.1318 tmin = 689817601, tmax = 690076801 emin = 100.0, emax = 100000.0 irfs = P8R3_SOURCE_V2 ROI = 12 zmax = 90 Fitting strategies: Fix sources to their catalog values = True Leave variable source normalizations free = True Perform pre-fit where ALL sources are frozen to catalog values = False Perform secondary fit with a free spectral index = True Remove all catalog sources = False Remove weak (TS < 2) catalog sources = False Freeze Galactic component = False Likelihood fit parameters: Statistic: UNBINNED Optimizer: MINUIT Catalog: 4FGL Repository job = True LAT data source: Data catalog Updating database... UPDATE lightcurve_data_v2 SET job_id='416831', job_status='RUN', time_executed='2022-11-14 01:09:21.539481', time_epoch_executed='1668416961.54' WHERE source_name='4FGL J0704.8+4907' and cadence='daily' and bin_id='1738' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/416831 Creating custom pfile directory: /scratch/kocevski/416831/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/416831/ft1_4FGL_J0704.8+4907_daily_bin1738.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/416831/ft1_4FGL_J0704.8+4907_daily_bin1738.fits outfile=/scratch/kocevski/416831/ft1_filteredMKT_4FGL_J0704.8+4907_daily_bin1738.fits ra=106.207 dec=49.1318 rad=12.0 tmin=689817601.0 tmax=690076801.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 4.15 user 3.89 sys 0.25 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits sctable="SC_DATA" filter="IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2))" roicut=no evfile=/scratch/kocevski/416831/ft1_filteredMKT_4FGL_J0704.8+4907_daily_bin1738.fits evtable="EVENTS" outfile="/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits" apply_filter=yes overwrite=yes header_obstimes=yes tstart=0.0 tstop=0.0 gtifile="default" chatter=3 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtmktime version HEAD Applying GTI filter: IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2)) real 0.51 user 0.34 sys 0.16 Number of photons that the gtmktime cut: 849 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits" evtable="EVENTS" scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits sctable="SC_DATA" outfile=/scratch/kocevski/416831/ltcube_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits dcostheta=0.025 binsz=1.0 phibins=0 tmin=0.0 tmax=0.0 file_version="1" zmin=0.0 zmax=90.0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Working on file /scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits .....................! real 15.69 user 15.27 sys 0.39 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits sctable="SC_DATA" expcube=/scratch/kocevski/416831/ltcube_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits outfile=/scratch/kocevski/416831/expmap_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits irfs="P8R3_SOURCE_V2" evtype="INDEF" srcrad=30.0 nlong=88 nlat=88 nenergies=10 submap=no nlongmin=0 nlongmax=0 nlatmin=0 nlatmax=0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). The exposure maps generated by this tool are meant to be used for *unbinned* likelihood analysis only. Do not use them for binned analyses. Computing the ExposureMap using /scratch/kocevski/416831/ltcube_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits .....................! real 193.38 user 187.06 sys 5.86 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 HB 9 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/HB9.fits is the correct path to the extended template. Added 191 point sources and 1 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 J0704.8+4907 @ 106.207 49.1318 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits outfile=/scratch/kocevski/416831/cmap_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=160 nypix=160 binsz=0.25 coordsys="CEL" xref=106.207 yref=49.1318 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.59 user 0.40 sys 0.16 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits outfile=/scratch/kocevski/416831/cmap_HighResolution_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=500 nypix=500 binsz=0.1 coordsys="CEL" xref=106.207 yref=49.1318 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.60 user 0.39 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/416831/Model_4FGL_J0704.8+4907_daily_bin1738.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source GAL_V02 adding source HB 9 Working on... /scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits.....................! real 121.33 user 119.52 sys 1.39 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits', '/scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits', expMap='/scratch/kocevski/416831/expmap_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits', expCube='/scratch/kocevski/416831/ltcube_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/416831/Model_4FGL_J0704.8+4907_daily_bin1738.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0704.8+4907' 4FGL J0704.8+4907 Spectrum: LogParabola 265 norm: 1.520e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 266 alpha: 2.321e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 267 beta: 1.530e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 268 Eb: 7.828e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/416831/ft1_filtered_4FGL_J0704.8+4907_daily_bin1738.fits Spacecraft file(s): /scratch/kocevski/416831/ft2_4FGL_J0704.8+4907_daily_bin1738.fits Exposure map: /scratch/kocevski/416831/expmap_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits Exposure cube: /scratch/kocevski/416831/ltcube_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/416831/Model_4FGL_J0704.8+4907_daily_bin1738.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 8913.00415512 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 8913.00354115 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 63.786 1.0000 .0000 .10000E+07 2 'norm ' 2.0555 1.0000 .0000 .10000E+07 3 'norm ' 4.7443 1.0000 .0000 .10000E+07 4 'Prefactor ' 10.791 1.0000 .0000 .10000E+07 5 'Prefactor ' 11.619 1.0000 .0000 .10000E+07 6 'Prefactor ' 49.708 1.0000 .0000 .10000E+07 7 'Prefactor ' 8.8465 1.0000 .0000 .10000E+07 8 'norm ' .87226E-05 1.0000 .0000 .10000E+07 9 'norm ' .95757E-06 1.0000 .0000 .10000E+07 10 'norm ' .20819E-04 1.0000 .0000 .10000E+07 11 'Prefactor ' .56127E-02 1.0000 .0000 .10000E+07 12 'Prefactor ' 8.3736 1.0000 .0000 .10000E+07 13 'Prefactor ' .20645E-01 1.0000 .0000 .10000E+07 14 'Prefactor ' .29021E-02 1.0000 .0000 .10000E+07 15 'norm ' 3.8585 1.0000 .0000 .10000E+07 16 'Prefactor ' .13340E-01 1.0000 .0000 .10000E+07 17 'Prefactor ' .52442E-03 1.0000 .0000 .10000E+07 18 'norm ' .72664E-07 1.0000 .0000 .10000E+07 19 'Prefactor ' 6.3363 1.0000 .0000 .10000E+07 20 'Prefactor ' .15502E-02 1.0000 .0000 .10000E+07 21 'norm ' 1.8937 1.0000 .0000 .10000E+07 22 'Prefactor ' .22319E-03 1.0000 .0000 .10000E+07 23 'Prefactor ' .19861E-01 1.0000 .0000 .10000E+07 24 'norm ' 3.7057 1.0000 .0000 .10000E+07 25 'norm ' .50060E-06 1.0000 .0000 .10000E+07 26 'Normalizat' .78393 1.0000 .10000E-01 10.000 27 'Prefactor ' .98404 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6280E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 8913.002 FROM MIGRAD STATUS=CONVERGED 163 CALLS 2487 TOTAL EDM= .81E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .8% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 63.411 32.092 -.20380E-05 -.23763E-02 2 norm 2.0550 1.5413 .10446E-07 .10461E-01 3 norm 4.7462 4.6760 -.57982E-07 .16281E-02 4 Prefactor 10.791 8.5729 -.20801E-05 -.73944E-02 5 Prefactor 11.611 4.4780 .28479E-07 .10735E-01 6 Prefactor 49.582 15.959 -.12090E-05 .69820E-02 7 Prefactor 8.9162 4.5381 .71961E-06 .94726E-03 8 norm .0000 1.1234 -.18303E-07** at limit ** 9 norm .0000 .96511 -.95244E-08** at limit ** 10 norm .27756E-09 1.6227 -.11911E-06** at limit ** 11 Prefactor .27756E-09 8.6117 -.44534E-06** at limit ** 12 Prefactor 8.3867 5.3636 -.93649E-08 .96890E-02 13 Prefactor .65115E-07 1.3737 .10548E-05** at limit ** 14 Prefactor .11102E-08 11.569 .31255E-05** at limit ** 15 norm 3.8553 6.5111 -.12051E-06 -.23213E-02 16 Prefactor .36637E-08 20.053 .12917E-05** at limit ** 17 Prefactor .55511E-10 13.140 -.38515E-05** at limit ** 18 norm .55511E-10 .24767 -.54049E-07** at limit ** 19 Prefactor 6.3309 2.2644 -.30396E-06 .30520E-01 20 Prefactor .22204E-09 4.3113 -.32195E-07** at limit ** 21 norm 1.8942 1.8521 -.95507E-08 -.70336E-02 22 Prefactor .55511E-09 2.6362 -.20952E-06** at limit ** 23 Prefactor .55511E-10 20.626 -.23882E-07** at limit ** 24 norm 3.7057 3.5028 -.43775E-07 .28646E-02 25 norm .55511E-10 .89506 .24764E-07** at limit ** 26 Normalizat .78419 .18711 .47629E-05 .51816E-04 27 Prefactor .98408 .94963E-01 .20703E-05 -.10435E-03 ERR DEF= .500 Final values: Prefactor = 63.4115 norm = 2.05498 norm = 4.74623 Prefactor = 10.7914 Prefactor = 11.6115 Prefactor = 49.5817 Prefactor = 8.9162 norm = 0 norm = 0 norm = 2.77556e-10 Prefactor = 2.77556e-10 Prefactor = 8.38665 Prefactor = 6.51146e-08 Prefactor = 1.11022e-09 norm = 3.85531 Prefactor = 3.66374e-09 Prefactor = 5.55112e-11 norm = 5.55112e-11 Prefactor = 6.33094 Prefactor = 2.22045e-10 norm = 1.89416 Prefactor = 5.55112e-10 Prefactor = 5.55112e-11 norm = 3.70568 norm = 5.55112e-11 Normalizat = 0.784188 Prefactor = 0.984085 ********** ** 18 **HESSE ********** FCN= 8913.002 FROM HESSE STATUS=OK 546 CALLS 3033 TOTAL EDM= .10E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 63.411 36.001 .12522E-03 -1.5549 2 norm 2.0550 1.5373 .72062E-03 -1.5679 3 norm 4.7462 4.6811 .46171E-03 -1.5664 4 Prefactor 10.791 8.7692 .30474E-03 -1.5642 5 Prefactor 11.611 7.7901 .29365E-03 -1.5640 6 Prefactor 49.582 36.368 .14185E-03 -1.5567 7 Prefactor 8.9162 32.211 .33675E-03 -1.5648 8 norm .0000 1.1242 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 norm .0000 .96440 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 norm .27756E-09 1.6220 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Prefactor .27756E-09 8.6236 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 Prefactor 8.3867 5.6599 .34620E-03 -1.5650 13 Prefactor .65115E-07 9.4894 .92265E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor .11102E-08 11.639 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm 3.8553 7.7102 .51349E-03 -1.5669 16 Prefactor .36637E-08 20.031 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 17 Prefactor .55511E-10 13.204 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 18 norm .55511E-10 .24595 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 19 Prefactor 6.3309 9.9652 .39852E-03 -1.5658 20 Prefactor .22204E-09 4.3129 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 21 norm 1.8942 1.9074 .75574E-03 -1.5680 22 Prefactor .55511E-09 2.6391 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 23 Prefactor .55511E-10 20.527 .17046E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 24 norm 3.7057 3.5047 .52436E-03 -1.5669 25 norm .55511E-10 .88949 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 26 Normalizat .78419 .17175 .78420E-01 -1.0066 27 Prefactor .98408 .84380E-01 .46067E-01 -.93262 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.02566e-07 Minuit parameter uncertainties: 1 36.0011 2 1.53734 3 4.68112 4 8.76918 5 7.79014 6 36.3679 7 32.2113 8 5.06689e-06 9 6.79163e-06 10 4.30877e-05 11 9.34577e-05 12 5.65988 13 0.00157197 14 0.000229837 15 7.71017 16 0.00054263 17 5.55193e-05 18 7.25794e-06 19 9.96526 20 6.33674e-05 21 1.90741 22 7.6643e-05 23 7.57637e-05 24 3.5047 25 1.43944e-05 26 0.17187 27 0.084391 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 8913.00189455 Extracting fit parameters... 4FGL J0704.8+4907 Spectrum: LogParabola 265 norm: 2.776e-10 4.309e-05 0.000e+00 1.000e+06 ( 1.000e-12) 266 alpha: 2.321e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 267 beta: 1.530e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 268 Eb: 7.828e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 621 Prefactor: 9.841e-01 8.439e-02 0.000e+00 1.000e+01 ( 1.000e+00) 622 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 623 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 620 Normalization: 7.842e-01 1.719e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 106.207 49.132 Photon Flux Upper Limit: 4.67e-08 ph cm-2 s-1 Energy Flux Upper Limit: 1.68e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/416831/likelihoodResults_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 8913.00259757 delta logL = -0.00070302084896 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 8913.00189456 delta logL = -1.18961906992e-08 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .34417E-08 1.0000 .0000 .10000E+07 2 'alpha ' 2.3319 1.0000 .0000 5.0000 3 'Normalizat' .78420 1.0000 .10000E-01 10.000 4 'Prefactor ' .98407 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6280E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 8913.002 FROM MIGRAD STATUS=CONVERGED 53 CALLS 268 TOTAL EDM= .32E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .49960E-09 1.8896 .42118E-03** at limit ** 2 alpha 2.9566 3.6529 .41270 -.13223E-09 3 Normalizat .78419 .15970 .78420E-01 .81006E-04 4 Prefactor .98409 .82374E-01 .46068E-01 -.46694E-04 ERR DEF= .500 Final values: norm = 4.996e-10 alpha = 2.9566 Normalizat = 0.784188 Prefactor = 0.984085 ********** ** 18 **HESSE ********** FCN= 8913.002 FROM HESSE STATUS=OK 29 CALLS 297 TOTAL EDM= .30E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .49960E-09 1.8542 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 2.9566 3.6403 .50000 .18367 3 Normalizat .78419 .17931 .34716E-03 -1.0066 4 Prefactor .98409 .92712E-01 .16046E-03 -.93262 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 2.99502e-10 Minuit parameter uncertainties: 1 6.21392e-05 2 2.46143 3 0.179443 4 0.0927271 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/416831': 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) = 8913.00189455 delta logL = -3.81987774745e-11 Extracting fit parameters... 4FGL J0704.8+4907 Spectrum: LogParabola 265 norm: 4.996e-10 6.214e-05 0.000e+00 1.000e+06 ( 1.000e-12) 266 alpha: 2.957e+00 2.461e+00 0.000e+00 5.000e+00 ( 1.000e+00) 267 beta: 1.530e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 268 Eb: 7.828e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 621 Prefactor: 9.841e-01 9.273e-02 0.000e+00 1.000e+01 ( 1.000e+00) 622 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 623 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 620 Normalization: 7.842e-01 1.794e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 106.207 49.132 Creating a high resolution counts map... INFO: Auto-setting vmin to -1.000e-01 [aplpy.core] INFO: Auto-setting vmax to 1.110e+00 [aplpy.core] Saving /scratch/kocevski/416831/cmap_HighResolution_689817601_690076801_4FGL_J0704.8+4907_daily_bin1738.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/416831 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='1.68e-05', job_status='DONE', photon_flux_upper_limit='4.67e-08', time_completed='2022-11-14 01:25:45.706701', job_id='416831', GAL2='0.98', fit_tolerance='1e-08', EG2='0.78', EG='0.78', time_epoch_completed='1668417945.71', return_code2='0', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.98', dlogl='-3.82e-11', ts2='-0.00', photon_index_error='0.00', photon_index='2.32' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; Database successfully updated. Analysis Complete. Mon Nov 14 01:25:45 PST 2022 _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='1668416566.91' at line 1 Command execution failed. Waiting 28.6827478647 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 17.0337235583 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 22.2797040706 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 13.5343328977 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 11.7385910095 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 4.29807069038 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 25.6897918005 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 27.3710114053 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 23.6452261375 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 0.0145227514061 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 29.1183747433 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 24.9110212346 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 9.94491102345 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 5.90771942966 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 26.2466964202 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 3.00944617976 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 5.83826471213 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 8.05797229631 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 1.22918299052 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 20.8963924256 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 9.73049081712 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 4.94752894299 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 17.7001647413 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 11.204603746 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 29.9466313823 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 7.11065956167 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 14.8141851755 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 27.5749390473 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 19.8005264215 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 2.54918802599 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 16.1515928081 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 5.99385694809 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 8.44460552468 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 5.70326153137 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 25.5984345696 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 15.5628678027 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 4.95237507519 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 18.1913408901 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 3.1503212351 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416566.91', time_completed='2022-11-14 01:02:46.905517', job_id='410392' WHERE bin_id='1738' AND source_name='4FGL J0704.8+4907' 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='1668416566.91' 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='1668416566.91' at line 1 Command execution failed. Waiting 24.9538112954 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Mon Nov 14 01:12:51 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 410392: <4FGL_J0704.8+4907_daily_bin1738> in cluster Done Job <4FGL_J0704.8+4907_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 00:45:15 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 00:45:44 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 00:45:44 2022 Terminated at Mon Nov 14 01:12:52 2022 Results reported at Mon Nov 14 01:12:52 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0704.8+4907_daily_bin1738 106.207 49.1318 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0704.8+4907 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 930.46 sec. Max Memory : 1257 MB Average Memory : 352.23 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1628 sec. Turnaround time : 1657 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 416831: <4FGL_J0704.8+4907_daily_bin1738> in cluster Done Job <4FGL_J0704.8+4907_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 01:05:12 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 01:05:38 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 01:05:38 2022 Terminated at Mon Nov 14 01:25:46 2022 Results reported at Mon Nov 14 01:25:46 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0704.8+4907_daily_bin1738 106.207 49.1318 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0704.8+4907 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 984.25 sec. Max Memory : 618 MB Average Memory : 277.46 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1209 sec. Turnaround time : 1234 sec. The output (if any) is above this job summary.