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: Dan/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 121 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 = 17375 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0047.0+5657_weekly_bin740 RA = 11.7535, Dec = 56.9601 tmin = 686534401, tmax = 687139201 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='820534', job_status='RUN', time_executed='2022-10-11 03:22:41.352201', time_epoch_executed='1665483761.35' WHERE source_name='4FGL J0047.0+5657' and cadence='weekly' and bin_id='740' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/820534 Creating custom pfile directory: /scratch/kocevski/820534/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Level1/LPA Retrieving 107 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/820534/ft1_4FGL_J0047.0+5657_weekly_bin740.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Level1/LPA Retrieving 107 files... Done. Merging files... Merged file saved to: /scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/820534/ft1_4FGL_J0047.0+5657_weekly_bin740.fits outfile=/scratch/kocevski/820534/ft1_filteredMKT_4FGL_J0047.0+5657_weekly_bin740.fits ra=11.7535 dec=56.9601 rad=12.0 tmin=686534401.0 tmax=687139201.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 7.33 user 6.92 sys 0.32 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.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/820534/ft1_filteredMKT_4FGL_J0047.0+5657_weekly_bin740.fits evtable="EVENTS" outfile="/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.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.58 user 0.36 sys 0.21 Number of photons that the gtmktime cut: 3352 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits" evtable="EVENTS" scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits sctable="SC_DATA" outfile=/scratch/kocevski/820534/ltcube_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.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/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits .....................! real 27.63 user 27.07 sys 0.41 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits evtable="EVENTS" scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits sctable="SC_DATA" expcube=/scratch/kocevski/820534/ltcube_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits outfile=/scratch/kocevski/820534/expmap_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.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/820534/ltcube_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits .....................! real 192.40 user 186.24 sys 5.78 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 CTB 109 in ROI with RadialDisk spatial model. Extended source FHES J2304.0+5406 in ROI with RadialGaussian spatial model. Extended source FHES J2208.4+6443 in ROI with RadialGaussian spatial model. Added 197 point sources and 5 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 J0047.0+5657 @ 11.7535 56.9601 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits outfile=/scratch/kocevski/820534/cmap_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.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=11.7535 yref=56.9601 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.63 user 0.41 sys 0.19 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits outfile=/scratch/kocevski/820534/cmap_HighResolution_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.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=11.7535 yref=56.9601 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.62 user 0.42 sys 0.19 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits evtable="EVENTS" scfile=/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/820534/Model_4FGL_J0047.0+5657_weekly_bin740.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 CTB 109 adding source EG_v02 adding source FHES J2208.4+6443 adding source FHES J2304.0+5406 adding source GAL_V02 adding source HB 3 adding source W 3 Working on... /scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits.....................! real 469.77 user 467.39 sys 1.38 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits', '/scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits', expMap='/scratch/kocevski/820534/expmap_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits', expCube='/scratch/kocevski/820534/ltcube_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/820534/Model_4FGL_J0047.0+5657_weekly_bin740.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0047.0+5657' 4FGL J0047.0+5657 Spectrum: LogParabola 137 norm: 3.670e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 138 alpha: 2.017e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 139 beta: 1.171e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 140 Eb: 1.707e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/820534/ft1_filtered_4FGL_J0047.0+5657_weekly_bin740.fits Spacecraft file(s): /scratch/kocevski/820534/ft2_4FGL_J0047.0+5657_weekly_bin740.fits Exposure map: /scratch/kocevski/820534/expmap_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits Exposure cube: /scratch/kocevski/820534/ltcube_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/820534/Model_4FGL_J0047.0+5657_weekly_bin740.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) = 32446.2495716 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 32446.1129792 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' 4.3082 1.0000 .0000 .10000E+07 2 'Prefactor ' .36897 1.0000 .0000 .10000E+07 3 'Prefactor ' .53530E-02 1.0000 .0000 .10000E+07 4 'norm ' 3.8228 1.0000 .0000 .10000E+07 5 'norm ' .49548E-02 1.0000 .0000 .10000E+07 6 'norm ' .46873E-03 1.0000 .0000 .10000E+07 7 'norm ' .21230 1.0000 .0000 .10000E+07 8 'norm ' 32.012 1.0000 .0000 .10000E+07 9 'norm ' .29151E-05 1.0000 .0000 .10000E+07 10 'Prefactor ' 5.1401 1.0000 .0000 .10000E+07 11 'norm ' .23088E-05 1.0000 .0000 .10000E+07 12 'norm ' .68689E-06 1.0000 .0000 .10000E+07 13 'Prefactor ' 1.3502 1.0000 .0000 .10000E+07 14 'norm ' 14.768 1.0000 .0000 .10000E+07 15 'Normalizat' .65586 1.0000 .10000E-01 10.000 16 'Prefactor ' .95651 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6850E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 32446.11 FROM MIGRAD STATUS=CONVERGED 141 CALLS 952 TOTAL EDM= .14E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 2.5% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm 4.3105 2.6333 -.17832E-06 -.12630E-02 2 Prefactor .11702E-03 81.784 .17071E-05** at limit ** 3 Prefactor .11343E-05 61.160 -.22627E-05** at limit ** 4 norm 3.9541 5.9206 -.38037E-07 .50629E-04 5 norm .97294E-06 25.052 .48500E-06** at limit ** 6 norm .86042E-07 22.320 -.52897E-07** at limit ** 7 norm .81490E-07 73.048 .22985E-06** at limit ** 8 norm 32.123 11.550 .21922E-06 .19169 9 norm .55511E-10 3.4687 -.19136E-06** at limit ** 10 Prefactor 5.2674 5.8343 .17347E-06 .50327E-01 11 norm .27756E-09 3.7168 .29581E-06** at limit ** 12 norm .77716E-09 8.1622 .50008E-06** at limit ** 13 Prefactor 1.4274 6.0475 -.11451E-05 -.10520E-02 14 norm 14.696 11.212 -.18064E-06 -.13703E-01 15 Normalizat .65656 .24615 .85370E-05 .41410E-04 16 Prefactor .95634 .26286E-01 .83777E-06 .36638E-03 ERR DEF= .500 Final values: norm = 4.31051 Prefactor = 0.000117022 Prefactor = 1.13426e-06 norm = 3.95406 norm = 9.72944e-07 norm = 8.60423e-08 norm = 8.14904e-08 norm = 32.1231 norm = 5.55112e-11 Prefactor = 5.26735 norm = 2.77556e-10 norm = 7.77156e-10 Prefactor = 1.42743 norm = 14.6964 Normalizat = 0.656561 Prefactor = 0.956342 ********** ** 18 **HESSE ********** FCN= 32446.11 FROM HESSE STATUS=OK 249 CALLS 1201 TOTAL EDM= .19E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm 4.3105 2.6456 .48511E-03 -1.5666 2 Prefactor .11702E-03 12.909 .19253E-01 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor .11343E-05 62.228 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 norm 3.9541 5.9231 .51597E-03 -1.5668 5 norm .97294E-06 26.090 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 norm .86042E-07 22.043 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm .81490E-07 78.939 .11561E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 norm 32.123 15.883 .17677E-03 -1.5595 9 norm .55511E-10 3.4757 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor 5.2674 14.940 .44320E-03 -1.5662 11 norm .27756E-09 3.7312 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 norm .77716E-09 .94602 .62994E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 Prefactor 1.4274 6.0915 .94127E-03 -1.5684 14 norm 14.696 11.248 .26037E-03 -1.5631 15 Normalizat .65656 .29447 .28080 -1.0563 16 Prefactor .95634 .29575E-01 .25108E-01 -.94199 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.88863e-06 Minuit parameter uncertainties: 1 2.64558 2 0.0777337 3 0.016803 4 5.92312 5 0.0100766 6 0.00275464 7 0.00507256 8 15.8833 9 3.03049e-05 10 14.94 11 6.6199e-05 12 5.5146e-05 13 5.89754 14 11.2483 15 0.295174 16 0.0295756 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 32446.1100377 Extracting fit parameters... 4FGL J0047.0+5657 Spectrum: LogParabola 137 norm: 9.729e-07 1.008e-02 0.000e+00 1.000e+06 ( 1.000e-13) 138 alpha: 2.017e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 139 beta: 1.171e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 140 Eb: 1.707e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 674 Prefactor: 9.563e-01 2.958e-02 0.000e+00 1.000e+01 ( 1.000e+00) 675 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 676 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 665 Normalization: 6.566e-01 2.952e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 11.754 56.960 Photon Flux Upper Limit: 8.70e-08 ph cm-2 s-1 Energy Flux Upper Limit: 6.21e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/820534/likelihoodResults_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 32446.1100439 delta logL = -6.16916440777e-06 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 32446.1100393 delta logL = -1.55877569341e-06 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .29772E-04 1.0000 .0000 .10000E+07 2 'alpha ' 1.7442 1.0000 .0000 5.0000 3 'Normalizat' .65626 1.0000 .10000E-01 10.000 4 'Prefactor ' .95635 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6850E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 32446.11 FROM MIGRAD STATUS=CONVERGED 65 CALLS 272 TOTAL EDM= .20E-11 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .26645E-08 2.2392 .42118E-03** at limit ** 2 alpha 2.5773 3.5069 .43824 .20753E-09 3 Normalizat .65657 .26917E-02 .28080 .34523E-03 4 Prefactor .95634 .28495E-03 .25108E-01 -.27855E-02 ERR DEF= .500 Final values: norm = 2.66454e-09 alpha = 2.57728 Normalizat = 0.656567 Prefactor = 0.956341 ********** ** 18 **HESSE ********** FCN= 32446.11 FROM HESSE STATUS=NOT POSDEF 27 CALLS 299 TOTAL EDM= .19E-11 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .26645E-08 18.668 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 2.5773 3.6464 .50000 .30917E-01 3 Normalizat .65657 .76746E-02 .12543E-02 -1.0563 4 Prefactor .95634 .82148E-03 .11098E-03 -.94199 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 1.90902e-12 Minuit parameter uncertainties: 1 0.000444912 2 122522 3 0.00767459 4 0.000821477 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/820534': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 32446.1100377 delta logL = 1.7971615307e-08 Extracting fit parameters... 4FGL J0047.0+5657 Spectrum: LogParabola 137 norm: 2.665e-09 4.449e-04 0.000e+00 1.000e+06 ( 1.000e-13) 138 alpha: 2.577e+00 1.225e+05 0.000e+00 5.000e+00 ( 1.000e+00) 139 beta: 1.171e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 140 Eb: 1.707e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 674 Prefactor: 9.563e-01 8.215e-04 0.000e+00 1.000e+01 ( 1.000e+00) 675 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 676 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 665 Normalization: 6.566e-01 7.675e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 11.754 56.960 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/820534/cmap_HighResolution_686534401_687139201_4FGL_J0047.0+5657_weekly_bin740.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/820534 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='6.21e-05', job_status='DONE', photon_flux_upper_limit='8.70e-08', time_completed='2022-10-11 03:55:34.207956', job_id='820534', GAL2='0.96', fit_tolerance='1e-08', EG2='0.66', EG='0.66', time_epoch_completed='1665485734.21', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.96', dlogl='1.80e-08', ts2='-0.00', photon_index_error='0.00', photon_index='2.02' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; Database successfully updated. Analysis Complete. Tue Oct 11 03:55:34 PDT 2022 76727.79' at line 1 Command execution failed. Waiting 24.6366186687 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 23.6730862857 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 18.5346631771 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 20.7244529519 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 8.14036638947 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 3.44193374976 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 19.785260532 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 22.8158899249 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 13.7493055289 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 15.5115444173 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 11.602301989 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 8.69616140448 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 1.99138402773 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 26.9265847743 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 15.6030559958 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 15.7681981062 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 3.15463365407 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 10.6730758688 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 24.7986267207 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 16.904186801 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 11.2767450399 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 11.1416195766 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 25.0216485907 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 26.300053853 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 11.1260994605 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 5.517956794 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 2.36240647808 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 13.6656741821 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 26.5277712088 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 22.0737785845 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 14.2811572762 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 16.9307348404 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 1.47296954664 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 28.1913608326 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 2.7852355097 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 28.1003941609 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 17.8595751211 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79', time_completed='2022-10-11 01:25:27.791669', job_id='834290' WHERE bin_id='740' AND source_name='4FGL J0047.0+5657' AND cadence='weekly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665476727.79' 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='1665476727.79' at line 1 Command execution failed. Waiting 29.9177697971 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Oct 11 01:35:32 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 834290: <4FGL_J0047.0+5657_weekly_bin740> in cluster Done Job <4FGL_J0047.0+5657_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 00:50:18 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 00:50:19 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 00:50:19 2022 Terminated at Tue Oct 11 01:35:33 2022 Results reported at Tue Oct 11 01:35:33 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0047.0+5657_weekly_bin740 11.7535 56.9601 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0047.0+5657 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 2004.00 sec. Max Memory : 625 MB Average Memory : 385.84 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 2713 sec. Turnaround time : 2715 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 844171: <4FGL_J0047.0+5657_weekly_bin740> in cluster Done Job <4FGL_J0047.0+5657_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 01:30:22 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 01:30:24 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 01:30:24 2022 Terminated at Tue Oct 11 01:59:23 2022 Results reported at Tue Oct 11 01:59:23 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0047.0+5657_weekly_bin740 11.7535 56.9601 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0047.0+5657 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1651.00 sec. Max Memory : 1096 MB Average Memory : 393.19 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1739 sec. Turnaround time : 1741 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 820534: <4FGL_J0047.0+5657_weekly_bin740> in cluster Done Job <4FGL_J0047.0+5657_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 00:05:39 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 00:05:40 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 00:05:40 2022 Terminated at Tue Oct 11 03:55:35 2022 Results reported at Tue Oct 11 03:55:35 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0047.0+5657_weekly_bin740 11.7535 56.9601 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0047.0+5657 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1978.00 sec. Max Memory : 626 MB Average Memory : 100.30 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 13794 sec. Turnaround time : 13796 sec. The output (if any) is above this job summary.