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 198 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 = 7582 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0629.3-1959_daily_bin1757 RA = 97.3478, Dec = -19.9999 tmin = 694742401, tmax = 695001601 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='195507', job_status='RUN', time_executed='2023-01-10 00:54:01.540971', time_epoch_executed='1673340841.54' WHERE source_name='4FGL J0629.3-1959' and cadence='daily' and bin_id='1757' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/195507 Creating custom pfile directory: /scratch/kocevski/195507/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/195507/ft1_4FGL_J0629.3-1959_daily_bin1757.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=694742401.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 47 files... Done. Merging files... Merged file saved to: /scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/195507/ft1_4FGL_J0629.3-1959_daily_bin1757.fits outfile=/scratch/kocevski/195507/ft1_filteredMKT_4FGL_J0629.3-1959_daily_bin1757.fits ra=97.3478 dec=-19.9999 rad=12.0 tmin=694742401.0 tmax=695001601.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 2.97 user 2.75 sys 0.19 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.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/195507/ft1_filteredMKT_4FGL_J0629.3-1959_daily_bin1757.fits evtable="EVENTS" outfile="/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits" apply_filter=yes overwrite=yes header_obstimes=yes tstart=0.0 tstop=0.0 gtifile="default" chatter=3 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtmktime version HEAD Applying GTI filter: IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2)) real 0.52 user 0.35 sys 0.16 Number of photons that the gtmktime cut: 670 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits" evtable="EVENTS" scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits sctable="SC_DATA" outfile=/scratch/kocevski/195507/ltcube_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.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/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits .....................! real 16.60 user 16.20 sys 0.35 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits sctable="SC_DATA" expcube=/scratch/kocevski/195507/ltcube_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits outfile=/scratch/kocevski/195507/expmap_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.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/195507/ltcube_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits .....................! real 192.86 user 186.48 sys 5.88 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Added 153 point sources and 0 extended sources Setting source of interest to: 4FGL J0629.3-1959 @ 97.3478 -19.9999 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits outfile=/scratch/kocevski/195507/cmap_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.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=97.3478 yref=-19.9999 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.58 user 0.39 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits outfile=/scratch/kocevski/195507/cmap_HighResolution_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.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=97.3478 yref=-19.9999 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.58 user 0.40 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/195507/Model_4FGL_J0629.3-1959_daily_bin1757.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source GAL_V02 Working on... /scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits.....................! real 113.37 user 111.01 sys 1.23 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits', '/scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits', expMap='/scratch/kocevski/195507/expmap_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits', expCube='/scratch/kocevski/195507/ltcube_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/195507/Model_4FGL_J0629.3-1959_daily_bin1757.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0629.3-1959' 4FGL J0629.3-1959 Spectrum: LogParabola 274 norm: 3.772e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 275 alpha: 2.148e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 276 beta: 7.038e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 277 Eb: 8.389e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/195507/ft1_filtered_4FGL_J0629.3-1959_daily_bin1757.fits Spacecraft file(s): /scratch/kocevski/195507/ft2_4FGL_J0629.3-1959_daily_bin1757.fits Exposure map: /scratch/kocevski/195507/expmap_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits Exposure cube: /scratch/kocevski/195507/ltcube_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/195507/Model_4FGL_J0629.3-1959_daily_bin1757.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) = 7447.25311815 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 7447.07528435 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .27966E-03 1.0000 .0000 .10000E+07 2 'Prefactor ' .18877E-02 1.0000 .0000 .10000E+07 3 'Prefactor ' 3.2970 1.0000 .0000 .10000E+07 4 'Prefactor ' 107.46 1.0000 .0000 .10000E+07 5 'Prefactor ' 8.3413 1.0000 .0000 .10000E+07 6 'Prefactor ' 17.038 1.0000 .0000 .10000E+07 7 'Prefactor ' .24680E-01 1.0000 .0000 .10000E+07 8 'Prefactor ' .52381E-01 1.0000 .0000 .10000E+07 9 'norm ' .50467E-03 1.0000 .0000 .10000E+07 10 'Prefactor ' 12.591 1.0000 .0000 .10000E+07 11 'Prefactor ' 30.249 1.0000 .0000 .10000E+07 12 'norm ' .82768E-05 1.0000 .0000 .10000E+07 13 'norm ' .53740 1.0000 .0000 .10000E+07 14 'norm ' .40780E-01 1.0000 .0000 .10000E+07 15 'Prefactor ' .27815E-04 1.0000 .0000 .10000E+07 16 'norm ' 16.773 1.0000 .0000 .10000E+07 17 'norm ' 18.011 1.0000 .0000 .10000E+07 18 'Prefactor ' 3.1312 1.0000 .0000 .10000E+07 19 'norm ' 7.2752 1.0000 .0000 .10000E+07 20 'norm ' .18062E-03 1.0000 .0000 .10000E+07 21 'norm ' .17183E-02 1.0000 .0000 .10000E+07 22 'Normalizat' .98770 1.0000 .10000E-01 10.000 23 'Prefactor ' 1.0442 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5240E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 7447.067 FROM MIGRAD STATUS=CONVERGED 229 CALLS 1952 TOTAL EDM= .13E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.5% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .55511E-10 9.9927 .19416E-06** at limit ** 2 Prefactor .0000 4.7189 -.87803E-07** at limit ** 3 Prefactor 3.3990 10.366 .52058E-07 -.23003E-04 4 Prefactor 114.87 99.650 .95299E-05 -.18516E-02 5 Prefactor 8.3994 13.492 -.47411E-06 .12441E-02 6 Prefactor 21.048 54.915 .59839E-05 .58280E-03 7 Prefactor .83267E-09 36.605 -.52725E-06** at limit ** 8 Prefactor .55511E-10 170.74 -.28444E-05** at limit ** 9 norm .0000 3.4316 -.91990E-07** at limit ** 10 Prefactor 12.428 7.9843 -.38744E-06 .52363E-02 11 Prefactor 29.323 28.772 -.33980E-05 .20078E-02 12 norm .55511E-10 2.8904 .27301E-06** at limit ** 13 norm .54042 1.1752 -.14446E-06 .65130E-02 14 norm .13323E-08 38.540 -.97996E-06** at limit ** 15 Prefactor .16653E-09 2.8554 -.14399E-06** at limit ** 16 norm 16.806 16.812 .41088E-05 .14623E-02 17 norm 17.619 25.465 .32502E-05 .17160E-02 18 Prefactor 3.2868 9.9718 -.26248E-05 .17240E-02 19 norm 9.9554 138.73 -.45837E-04 .16844E-02 20 norm .34417E-08 63.117 .46742E-05** at limit ** 21 norm .22204E-09 6.9335 .30140E-06** at limit ** 22 Normalizat .97669 .30994 -.20789E-04 .20096E-03 23 Prefactor 1.0451 .79914E-01 .43565E-05 .60293E-03 ERR DEF= .500 Final values: norm = 5.55112e-11 Prefactor = 0 Prefactor = 3.39902 Prefactor = 114.872 Prefactor = 8.39939 Prefactor = 21.0482 Prefactor = 8.32667e-10 Prefactor = 5.55112e-11 norm = 0 Prefactor = 12.4278 Prefactor = 29.3233 norm = 5.55112e-11 norm = 0.540424 norm = 1.33227e-09 Prefactor = 1.66533e-10 norm = 16.8062 norm = 17.6187 Prefactor = 3.28682 norm = 9.95543 norm = 3.44169e-09 norm = 2.22045e-10 Normalizat = 0.976694 Prefactor = 1.04514 ********** ** 18 **HESSE ********** FCN= 7447.067 FROM HESSE STATUS=OK 424 CALLS 2376 TOTAL EDM= .56E-07 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .55511E-10 9.9848 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor .0000 4.6775 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor 3.3990 10.404 .55734E-03 -1.5671 4 Prefactor 114.87 99.789 .96472E-04 -1.5494 5 Prefactor 8.3994 13.501 .34687E-03 -1.5650 6 Prefactor 21.048 54.378 .24237E-03 -1.5616 7 Prefactor .83267E-09 36.441 .16746E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor .55511E-10 167.15 .15447E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 norm .0000 3.4102 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor 12.428 7.9966 .28204E-03 -1.5637 11 Prefactor 29.323 28.689 .18185E-03 -1.5600 12 norm .55511E-10 2.8863 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 norm .54042 1.2078 .75033E-03 -1.5693 14 norm .13323E-08 5.8892 .11133E-01 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 Prefactor .16653E-09 2.8527 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 norm 16.806 16.856 .24428E-03 -1.5626 17 norm 17.619 27.239 .23573E-03 -1.5624 18 Prefactor 3.2868 10.701 .57267E-03 -1.5672 19 norm 9.9554 142.03 .37163E-03 -1.5645 20 norm .34417E-08 63.191 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 21 norm .22204E-09 6.8977 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 22 Normalizat .97669 .29472 .11927 -.93815 23 Prefactor 1.0451 .75148E-01 .40264E-01 -.91239 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 5.56156e-08 Minuit parameter uncertainties: 1 5.52696e-05 2 1.80139e-05 3 10.4045 4 99.79 5 13.501 6 54.3796 7 0.000351413 8 0.000207634 9 1.56817e-06 10 7.99664 11 28.6891 12 2.70538e-05 13 1.2078 14 0.000177313 15 4.04407e-05 16 16.8565 17 27.2397 18 10.7008 19 75.2088 20 0.000929291 21 7.54755e-05 22 0.295214 23 0.0751558 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 7447.06723031 Extracting fit parameters... 4FGL J0629.3-1959 Spectrum: LogParabola 274 norm: 5.551e-11 2.705e-05 0.000e+00 1.000e+06 ( 1.000e-12) 275 alpha: 2.148e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 276 beta: 7.038e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 277 Eb: 8.389e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 521 Prefactor: 1.045e+00 7.516e-02 0.000e+00 1.000e+01 ( 1.000e+00) 522 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 523 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 520 Normalization: 9.767e-01 2.952e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 97.348 -20.000 Photon Flux Upper Limit: 9.71e-08 ph cm-2 s-1 Energy Flux Upper Limit: 4.42e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/195507/likelihoodResults_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.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) = 7447.06724081 delta logL = -1.05031176645e-05 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 7447.06723065 delta logL = -3.39604412147e-07 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .67835E-07 1.0000 .0000 .10000E+07 2 'alpha ' 1.3822 1.0000 .0000 5.0000 3 'Normalizat' .97651 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.0452 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5240E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 7447.067 FROM MIGRAD STATUS=CONVERGED 59 CALLS 254 TOTAL EDM= .11E-12 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .55511E-10 .49559E-01 .42118E-03** at limit ** 2 alpha 2.2738 3.4632 .48170 .14161E-10 3 Normalizat .97669 .11158E-02 .11926 .71250E-04 4 Prefactor 1.0451 .32081E-03 .40199E-01 .65570E-03 ERR DEF= .500 Final values: norm = 5.55112e-11 alpha = 2.2738 Normalizat = 0.97669 Prefactor = 1.04514 ********** ** 18 **HESSE ********** FCN= 7447.067 FROM HESSE STATUS=NOT POSDEF 27 CALLS 281 TOTAL EDM= .58E-12 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .55511E-10 .23725 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 2.2738 3.6108 .51000 -.90604E-01 3 Normalizat .97669 .24296E-02 .52912E-03 -.93815 4 Prefactor 1.0451 .70166E-03 .14686E-03 -.91239 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 5.76224e-13 Minuit parameter uncertainties: 1 5.83836e-06 2 60506.7 3 0.0024296 4 0.000701657 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/195507': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 7447.06723031 delta logL = -1.72803993337e-11 Extracting fit parameters... 4FGL J0629.3-1959 Spectrum: LogParabola 274 norm: 5.551e-11 5.838e-06 0.000e+00 1.000e+06 ( 1.000e-12) 275 alpha: 2.274e+00 6.051e+04 0.000e+00 5.000e+00 ( 1.000e+00) 276 beta: 7.038e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 277 Eb: 8.389e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 521 Prefactor: 1.045e+00 7.017e-04 0.000e+00 1.000e+01 ( 1.000e+00) 522 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 523 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 520 Normalization: 9.767e-01 2.430e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 97.348 -20.000 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/195507/cmap_HighResolution_694742401_695001601_4FGL_J0629.3-1959_daily_bin1757.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/195507 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='4.42e-05', job_status='DONE', photon_flux_upper_limit='9.71e-08', time_completed='2023-01-10 01:05:26.830326', job_id='195507', GAL2='1.05', fit_tolerance='1e-08', EG2='0.98', EG='0.98', time_epoch_completed='1673341526.83', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='1.05', dlogl='-1.73e-11', ts2='-0.00', photon_index_error='0.00', photon_index='2.15' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Jan 10 01:05:26 PST 2023 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='1673340587.4'' at line 1 Command execution failed. Waiting 22.1235150879 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 12.7202370591 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 16.3342328685 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 5.25545821835 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 19.8748753938 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 21.5955331269 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 16.3403074725 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 8.60053562137 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 22.1926137074 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 10.0604402971 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 27.6580324445 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 24.0264353315 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 18.44010885 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 11.9471389777 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 29.9158663011 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 5.07109849724 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 20.9819566633 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 13.8815694449 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 18.0822062876 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 9.42556910038 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 0.421595520279 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 28.4525615409 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 4.67796353494 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 16.4651338554 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 18.6013399414 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 10.6374077821 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 8.58188017135 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 26.9720070862 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 0.856479649765 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 28.2427619576 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 15.2276256803 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 5.83482290312 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 10.1519378257 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 11.9590353457 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 18.1941738387 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 19.8564998107 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 13.0886932199 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673340587.4', time_completed='2023-01-10 00:49:47.396946', job_id='191684' WHERE bin_id='1757' AND source_name='4FGL J0629.3-1959' 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='1673340587.4'' 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='1673340587.4'' at line 1 Command execution failed. Waiting 6.75009966577 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Jan 10 00:59:50 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 191684: <4FGL_J0629.3-1959_daily_bin1757> in cluster Done Job <4FGL_J0629.3-1959_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 00:35:12 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 00:35:31 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 00:35:31 2023 Terminated at Tue Jan 10 00:59:51 2023 Results reported at Tue Jan 10 00:59:51 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0629.3-1959_daily_bin1757 97.3478 -19.9999 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0629.3-1959 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 637.11 sec. Max Memory : 1093 MB Average Memory : 280.04 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1461 sec. Turnaround time : 1479 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 195507: <4FGL_J0629.3-1959_daily_bin1757> in cluster Done Job <4FGL_J0629.3-1959_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 00:50:11 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 00:50:34 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 00:50:34 2023 Terminated at Tue Jan 10 01:05:27 2023 Results reported at Tue Jan 10 01:05:27 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0629.3-1959_daily_bin1757 97.3478 -19.9999 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0629.3-1959 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 684.95 sec. Max Memory : 631 MB Average Memory : 286.73 MB Total Requested Memory : - Delta Memory : - Max Swap : 2929 MB Max Processes : 6 Max Threads : 21 Run time : 893 sec. Turnaround time : 916 sec. The output (if any) is above this job summary.