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 190 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_J0243.4+7119_daily_bin1757 RA = 40.8679, Dec = 71.3249 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='203677', job_status='RUN', time_executed='2023-01-10 01:25:24.328620', time_epoch_executed='1673342724.33' WHERE source_name='4FGL J0243.4+7119' and cadence='daily' and bin_id='1757' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/203677 Creating custom pfile directory: /scratch/kocevski/203677/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/203677/ft1_4FGL_J0243.4+7119_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/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/203677/ft1_4FGL_J0243.4+7119_daily_bin1757.fits outfile=/scratch/kocevski/203677/ft1_filteredMKT_4FGL_J0243.4+7119_daily_bin1757.fits ra=40.8679 dec=71.3249 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.59 user 2.22 sys 0.24 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_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/203677/ft1_filteredMKT_4FGL_J0243.4+7119_daily_bin1757.fits evtable="EVENTS" outfile="/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_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.44 user 0.29 sys 0.14 Number of photons that the gtmktime cut: 4278 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits" evtable="EVENTS" scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits sctable="SC_DATA" outfile=/scratch/kocevski/203677/ltcube_694742401_695001601_4FGL_J0243.4+7119_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/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits .....................! real 15.59 user 15.26 sys 0.29 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits sctable="SC_DATA" expcube=/scratch/kocevski/203677/ltcube_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits outfile=/scratch/kocevski/203677/expmap_694742401_695001601_4FGL_J0243.4+7119_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/203677/ltcube_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits .....................! real 155.98 user 151.10 sys 4.62 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Extended source HB 3 in ROI with RadialDisk spatial model. Extended source W 3 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/W3.fits is the correct path to the extended template. Extended source G150.3+4.5 in ROI with RadialDisk spatial model. Added 193 point sources and 3 extended sources If using unbinned likelihood you will need to rerun gtdiffrsp for the extended sources or rerun the makeModel function with optional argument psForce=True Setting source of interest to: 4FGL J0243.4+7119 @ 40.8679 71.3249 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits outfile=/scratch/kocevski/203677/cmap_694742401_695001601_4FGL_J0243.4+7119_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=40.8679 yref=71.3249 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.48 user 0.31 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits outfile=/scratch/kocevski/203677/cmap_HighResolution_694742401_695001601_4FGL_J0243.4+7119_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=40.8679 yref=71.3249 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.50 user 0.33 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits evtable="EVENTS" scfile=/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/203677/Model_4FGL_J0243.4+7119_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 G150.3+4.5 adding source GAL_V02 adding source HB 3 adding source W 3 Working on... /scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits.....................! real 448.66 user 446.80 sys 1.10 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits', '/scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits', expMap='/scratch/kocevski/203677/expmap_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits', expCube='/scratch/kocevski/203677/ltcube_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/203677/Model_4FGL_J0243.4+7119_daily_bin1757.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0243.4+7119' 4FGL J0243.4+7119 Spectrum: LogParabola 270 norm: 2.219e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 271 alpha: 2.022e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 272 beta: 1.458e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 273 Eb: 2.193e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/203677/ft1_filtered_4FGL_J0243.4+7119_daily_bin1757.fits Spacecraft file(s): /scratch/kocevski/203677/ft2_4FGL_J0243.4+7119_daily_bin1757.fits Exposure map: /scratch/kocevski/203677/expmap_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits Exposure cube: /scratch/kocevski/203677/ltcube_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/203677/Model_4FGL_J0243.4+7119_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) = 40802.5141327 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 40802.4743938 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .31069E-02 1.0000 .0000 .10000E+07 2 'Prefactor ' .24953E-02 1.0000 .0000 .10000E+07 3 'Prefactor ' 20.335 1.0000 .0000 .10000E+07 4 'Prefactor ' 1.5155 1.0000 .10000E-03 10000. 5 'norm ' .52047E-03 1.0000 .0000 .10000E+07 6 'Prefactor ' .16559E-06 1.0000 .0000 .10000E+07 7 'Prefactor ' .44094E-03 1.0000 .0000 .10000E+07 8 'norm ' 2.5376 1.0000 .0000 .10000E+07 9 'norm ' .13011E-03 1.0000 .0000 .10000E+07 10 'norm ' .68533 1.0000 .0000 .10000E+07 11 'Prefactor ' .78110E-01 1.0000 .0000 .10000E+07 12 'Prefactor ' .18770E-04 1.0000 .0000 .10000E+07 13 'Prefactor ' .34583E-06 1.0000 .0000 .10000E+07 14 'Prefactor ' .78280E-03 1.0000 .0000 .10000E+07 15 'Prefactor ' 21.965 1.0000 .0000 .10000E+07 16 'Normalizat' 1.2138 1.0000 .10000E-01 10.000 17 'Prefactor ' .94543 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6590E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 40802.47 FROM MIGRAD STATUS=CONVERGED 106 CALLS 979 TOTAL EDM= .19E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.3% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .30254E-07 1.1701 -.34302E-06** at limit ** 2 Prefactor .11718E-06 22.461 -.11180E-05** at limit ** 3 Prefactor 20.189 1.3732 -.44167E-08 .80578E-01 4 Prefactor 1.5151 .69133 .12601E-06 -.11627E-03 5 norm .16098E-08 2.9813 .16370E-06** at limit ** 6 Prefactor .55511E-10 2.2859 -.12389E-06** at limit ** 7 Prefactor .52569E-07 4.5018 -.29566E-06** at limit ** 8 norm 2.5378 .44459 .15180E-07 .51097E-02 9 norm .55511E-10 2.5721 -.25207E-06** at limit ** 10 norm .67797 2.1198 -.27156E-07 .21747E-03 11 Prefactor .85725E-05 3.1742 -.22809E-06** at limit ** 12 Prefactor .44464E-07 4.1268 .32824E-06** at limit ** 13 Prefactor .0000 .78815 .15839E-07** at limit ** 14 Prefactor .46074E-07 6.7113 -.10841E-05** at limit ** 15 Prefactor 22.358 2.5860 .13485E-07 .22523 16 Normalizat 1.2135 .18623 -.45327E-06 -.24291E-03 17 Prefactor .94549 .26834E-01 -.17191E-05 -.17567E-02 ERR DEF= .500 Final values: Prefactor = 3.02536e-08 Prefactor = 1.17184e-07 Prefactor = 20.1887 Prefactor = 1.51508 norm = 1.60982e-09 Prefactor = 5.55112e-11 Prefactor = 5.25691e-08 norm = 2.53776 norm = 5.55112e-11 norm = 0.677974 Prefactor = 8.57248e-06 Prefactor = 4.44644e-08 Prefactor = 0 Prefactor = 4.60743e-08 Prefactor = 22.3577 Normalizat = 1.21349 Prefactor = 0.945488 ********** ** 18 **HESSE ********** FCN= 40802.47 FROM HESSE STATUS=OK 269 CALLS 1248 TOTAL EDM= .98E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .30254E-07 .76252 .52423E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor .11718E-06 23.076 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor 20.189 16.409 .22183E-03 -1.5618 4 Prefactor 1.5151 .69407 .86817E-02 -1.5462 5 norm .16098E-08 2.9886 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 Prefactor .55511E-10 2.2356 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 Prefactor .52569E-07 4.5837 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 norm 2.5378 .44529 .64085E-03 -1.5676 9 norm .55511E-10 2.5801 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 norm .67797 2.1288 .61907E-03 -1.5691 11 Prefactor .85725E-05 7.5594 .18927E-01 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 Prefactor .44464E-07 4.1502 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 Prefactor .0000 .78738 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor .46074E-07 6.7910 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 Prefactor 22.358 19.309 .21343E-03 -1.5613 16 Normalizat 1.2135 .18764 .17627 -.86187 17 Prefactor .94549 .26092E-01 .27404E-01 -.94569 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 9.81938e-07 Minuit parameter uncertainties: 1 0.000303796 2 0.00328894 3 16.4091 4 0.69407 5 0.000139616 6 1.59949e-05 7 0.000981886 8 0.445286 9 2.02327e-05 10 2.12883 11 0.0161 12 0.000859171 13 2.64824e-06 14 0.00111861 15 19.3093 16 0.187746 17 0.0260919 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 40802.4734073 Extracting fit parameters... 4FGL J0243.4+7119 Spectrum: LogParabola 270 norm: 5.551e-11 2.023e-05 0.000e+00 1.000e+06 ( 1.000e-13) 271 alpha: 2.022e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 272 beta: 1.458e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 273 Eb: 2.193e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 648 Prefactor: 9.455e-01 2.609e-02 0.000e+00 1.000e+01 ( 1.000e+00) 649 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 650 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 643 Normalization: 1.213e+00 1.877e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 40.868 71.325 Photon Flux Upper Limit: 2.93e-08 ph cm-2 s-1 Energy Flux Upper Limit: 2.43e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/203677/likelihoodResults_694742401_695001601_4FGL_J0243.4+7119_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): 0 logL (Free Index) = 40802.4736813 delta logL = -0.000273994002782 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 40802.4734084 delta logL = -1.11255940283e-06 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .59869E-06 1.0000 .0000 .10000E+07 2 'alpha ' .31946 1.0000 .0000 5.0000 3 'Normalizat' 1.2136 1.0000 .10000E-01 10.000 4 'Prefactor ' .94550 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6590E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 40802.47 FROM MIGRAD STATUS=CONVERGED 41 CALLS 268 TOTAL EDM= .13E-11 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .0000 .30619 .42118E-02** at limit ** 2 alpha 3.3681 1.2024 -.72504E-05 .0000 3 Normalizat 1.2135 1.1018 -.60274E-05 -.34996E-04 4 Prefactor .94549 1.2880 .77941E-06 -.18739E-03 ERR DEF= .500 Final values: norm = 0 alpha = 3.36814 Normalizat = 1.21349 Prefactor = 0.945488 ********** ** 18 **HESSE ********** MNHESS FAILS AND WILL RETURN DIAGONAL MATRIX. FCN= 40802.47 FROM HESSE STATUS=FAILED 7 CALLS 275 TOTAL EDM= .13E-11 STRATEGY=1 ERROR MATRIX UNCERTAINTY=100.0% EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .0000 .30619 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 2.1132 1.2024 -.72504E-05 .35464 3 Normalizat 1.2135 1.1018 -.60274E-05 -.86187 4 Prefactor .94549 1.2880 .77941E-06 -.94569 ERR DEF= .500 Minuit fit quality: 1 estimated distance: 1.27284e-12 Minuit parameter uncertainties: 1 3.7503e-08 2 1.26252 3 1.12406 4 1.3337 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/203677': 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): 101 logL (Free Index) = 40802.4734073 delta logL = 7.27595761418e-11 Extracting fit parameters... 4FGL J0243.4+7119 Spectrum: LogParabola 270 norm: 0.000e+00 3.750e-08 0.000e+00 1.000e+06 ( 1.000e-13) 271 alpha: 3.368e+00 1.263e+00 0.000e+00 5.000e+00 ( 1.000e+00) 272 beta: 1.458e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 273 Eb: 2.193e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 648 Prefactor: 9.455e-01 1.334e+00 0.000e+00 1.000e+01 ( 1.000e+00) 649 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 650 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 643 Normalization: 1.213e+00 1.124e+00 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 40.868 71.325 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/203677/cmap_HighResolution_694742401_695001601_4FGL_J0243.4+7119_daily_bin1757.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/203677 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.43e-05', job_status='DONE', photon_flux_upper_limit='2.93e-08', time_completed='2023-01-10 01:55:30.097207', job_id='203677', GAL2='0.95', fit_tolerance='1e-08', EG2='1.21', EG='1.21', time_epoch_completed='1673344530.1', return_code2='101', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.95', dlogl='7.28e-11', ts2='0.00', photon_index_error='0.00', photon_index='2.02' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; Database successfully updated. Analysis Complete. Tue Jan 10 01:55:30 PST 2023 t) 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='1673342385.31' at line 1 Command execution failed. Waiting 19.5944566752 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 7.08264810054 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 14.0640469417 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 26.9641488644 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 2.59731791561 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 29.854999223 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 8.08445069264 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 10.8238407891 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 10.9009973183 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 28.5193324864 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 21.9569916934 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 13.0684727822 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 29.3942761523 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 14.0704615175 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 13.1676542707 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 19.5202673197 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 7.5652467449 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 23.242982851 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 5.18857538544 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 18.7920756484 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 6.15874096907 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 22.7067301652 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 4.19128256853 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 14.9858332265 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 25.0611360091 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 28.8585219612 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 18.37004067 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 16.4503720213 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 5.84460830805 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 3.8854220762 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 10.0667734798 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 0.259018005691 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 28.6875641947 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 10.2300173381 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 12.6184018182 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 19.0418402467 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 29.2915054463 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 10.8811004673 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673342385.31', time_completed='2023-01-10 01:19:45.305718', job_id='194252' WHERE bin_id='1757' AND source_name='4FGL J0243.4+7119' 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='1673342385.31' 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='1673342385.31' at line 1 Command execution failed. Waiting 20.6380706487 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Jan 10 01:30:03 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 194252: <4FGL_J0243.4+7119_daily_bin1757> in cluster Done Job <4FGL_J0243.4+7119_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 00:45:11 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 00:47:26 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 00:47:26 2023 Terminated at Tue Jan 10 01:30:04 2023 Results reported at Tue Jan 10 01:30:04 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0243.4+7119_daily_bin1757 40.8679 71.3249 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0243.4+7119 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1872.38 sec. Max Memory : 1262 MB Average Memory : 420.69 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 2558 sec. Turnaround time : 2693 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 203677: <4FGL_J0243.4+7119_daily_bin1757> in cluster Done Job <4FGL_J0243.4+7119_daily_bin1757> was submitted from host by user in cluster at Tue Jan 10 01:20:15 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 01:22:07 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 01:22:07 2023 Terminated at Tue Jan 10 01:55:30 2023 Results reported at Tue Jan 10 01:55:30 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0243.4+7119_daily_bin1757 40.8679 71.3249 694742401 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0243.4+7119 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1804.78 sec. Max Memory : 1268 MB Average Memory : 401.24 MB Total Requested Memory : - Delta Memory : - Max Swap : 2937 MB Max Processes : 6 Max Threads : 21 Run time : 2003 sec. Turnaround time : 2115 sec. The output (if any) is above this job summary.