aklog: Couldn't determine realm of user:aklog: No credentials cache found while getting realm /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: Daniel Kocevski (daniel.kocevski@nasa.gov) Waiting 154 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 = 17384 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0905.6+1358_weekly_bin753 RA = 136.402, Dec = 13.975 tmin = 694396801, tmax = 695001601 emin = 100.0, emax = 100000.0 irfs = P8R3_SOURCE_V2 ROI = 12 zmax = 90 Fitting strategies: Fix sources to their catalog values = True Leave variable source normalizations free = True Perform pre-fit where ALL sources are frozen to catalog values = False Perform secondary fit with a free spectral index = True Remove all catalog sources = False Remove weak (TS < 2) catalog sources = False Freeze Galactic component = False Likelihood fit parameters: Statistic: UNBINNED Optimizer: MINUIT Catalog: 4FGL Repository job = True LAT data source: Data catalog Updating database... UPDATE lightcurve_data_v2 SET job_id='240424', job_status='RUN', time_executed='2023-01-10 03:28:19.784407', time_epoch_executed='1673350099.78' WHERE source_name='4FGL J0905.6+1358' and cadence='weekly' and bin_id='753' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/240424 Creating custom pfile directory: /scratch/kocevski/240424/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=694396801.0 && nMetStart<695001601.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=694396801.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 106 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/240424/ft1_4FGL_J0905.6+1358_weekly_bin753.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=694396801.0 && nMetStart<695001601.0' /Data/Flight/Level1/LPA Retrieving 107 files... Done. Merging files... Merged file saved to: /scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/240424/ft1_4FGL_J0905.6+1358_weekly_bin753.fits outfile=/scratch/kocevski/240424/ft1_filteredMKT_4FGL_J0905.6+1358_weekly_bin753.fits ra=136.402 dec=13.975 rad=12.0 tmin=694396801.0 tmax=695001601.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 11.09 user 10.65 sys 0.34 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.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/240424/ft1_filteredMKT_4FGL_J0905.6+1358_weekly_bin753.fits evtable="EVENTS" outfile="/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.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.94 user 0.67 sys 0.19 Number of photons that the gtmktime cut: 161 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits" evtable="EVENTS" scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits sctable="SC_DATA" outfile=/scratch/kocevski/240424/ltcube_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.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/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits .....................! real 60.95 user 60.05 sys 0.52 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits evtable="EVENTS" scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits sctable="SC_DATA" expcube=/scratch/kocevski/240424/ltcube_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits outfile=/scratch/kocevski/240424/expmap_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.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/240424/ltcube_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits .....................! real 352.92 user 342.93 sys 9.14 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Added 160 point sources and 0 extended sources Setting source of interest to: 4FGL J0905.6+1358 @ 136.402 13.975 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits outfile=/scratch/kocevski/240424/cmap_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.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=136.402 yref=13.975 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.98 user 0.70 sys 0.21 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits outfile=/scratch/kocevski/240424/cmap_HighResolution_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.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=136.402 yref=13.975 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.94 user 0.73 sys 0.19 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits evtable="EVENTS" scfile=/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/240424/Model_4FGL_J0905.6+1358_weekly_bin753.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source GAL_V02 Working on... /scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits.....................! real 54.49 user 51.91 sys 2.24 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits', '/scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits', expMap='/scratch/kocevski/240424/expmap_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits', expCube='/scratch/kocevski/240424/ltcube_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/240424/Model_4FGL_J0905.6+1358_weekly_bin753.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0905.6+1358' 4FGL J0905.6+1358 Spectrum: LogParabola 282 norm: 1.799e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 283 alpha: 1.592e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 284 beta: 1.283e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 285 Eb: 2.458e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/240424/ft1_filtered_4FGL_J0905.6+1358_weekly_bin753.fits Spacecraft file(s): /scratch/kocevski/240424/ft2_4FGL_J0905.6+1358_weekly_bin753.fits Exposure map: /scratch/kocevski/240424/expmap_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits Exposure cube: /scratch/kocevski/240424/ltcube_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/240424/Model_4FGL_J0905.6+1358_weekly_bin753.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) = 1953.36232265 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 1953.37094261 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 119.91 1.0000 .0000 .10000E+07 2 'Prefactor ' 97.804 1.0000 .0000 .10000E+07 3 'Prefactor ' .58337 1.0000 .0000 .10000E+07 4 'norm ' .19734E-06 1.0000 .0000 .10000E+07 5 'Prefactor ' .27385 1.0000 .0000 .10000E+07 6 'norm ' .15841E-02 1.0000 .0000 .10000E+07 7 'norm ' .50251 1.0000 .0000 .10000E+07 8 'Prefactor ' .10658E-01 1.0000 .0000 .10000E+07 9 'norm ' .35766 1.0000 .0000 .10000E+07 10 'Prefactor ' 14.005 1.0000 .0000 .10000E+07 11 'Normalizat' .95761 1.0000 .10000E-01 10.000 12 'Prefactor ' 1.2828 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5120E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 1953.360 FROM MIGRAD STATUS=CONVERGED 128 CALLS 832 TOTAL EDM= .47E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.3% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 119.61 11.306 -.41831E-07 .24164 2 Prefactor 101.38 91.817 .78952E-07 .52263E-02 3 Prefactor .23648E-05 93.311 -.84581E-06** at limit ** 4 norm .0000 .75047 .40152E-07** at limit ** 5 Prefactor .94369E-08 44.392 .48117E-06** at limit ** 6 norm .45519E-06 18.104 .14422E-06** at limit ** 7 norm .52280E-06 75.278 .51374E-07** at limit ** 8 Prefactor .39774E-06 20.655 .73224E-06** at limit ** 9 norm .35312 2.2913 -.30428E-06 .62706E-02 10 Prefactor 14.356 10.795 -.82423E-07 .56450E-01 11 Normalizat .95623 .40719 -.12277E-04 .59881E-04 12 Prefactor 1.2831 .34409 .51385E-05 .11238E-03 ERR DEF= .500 Final values: Prefactor = 119.612 Prefactor = 101.38 Prefactor = 2.36478e-06 norm = 0 Prefactor = 9.4369e-09 norm = 4.55191e-07 norm = 5.22804e-07 Prefactor = 3.97737e-07 norm = 0.353119 Prefactor = 14.3563 Normalizat = 0.956231 Prefactor = 1.28309 ********** ** 18 **HESSE ********** FCN= 1953.360 FROM HESSE STATUS=OK 151 CALLS 983 TOTAL EDM= .18E-04 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 119.61 184.34 .91328E-04 -1.5489 2 Prefactor 101.38 91.773 .10112E-03 -1.5507 3 Prefactor .23648E-05 93.720 .70731E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 norm .0000 .74510 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor .94369E-08 44.072 .10586E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 norm .45519E-06 18.182 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm .52280E-06 75.246 .78457E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor .39774E-06 20.627 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 norm .35312 1.3945 .27588E-02 -1.5720 10 Prefactor 14.356 59.257 .26739E-03 -1.5632 11 Normalizat .95623 .34587 .67438E-01 -.94511 12 Prefactor 1.2831 .28938 .50108E-01 -.83811 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.75307e-05 Minuit parameter uncertainties: 1 184.346 2 91.7738 3 0.0297747 4 6.8995e-06 5 0.00128976 6 0.0057537 7 0.012544 8 0.00572851 9 1.39449 10 58.335 11 0.346684 12 0.289738 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 1953.36030905 Extracting fit parameters... 4FGL J0905.6+1358 Spectrum: LogParabola 282 norm: 4.552e-07 5.754e-03 0.000e+00 1.000e+06 ( 1.000e-13) 283 alpha: 1.592e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 284 beta: 1.283e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 285 Eb: 2.458e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 509 Prefactor: 1.283e+00 2.897e-01 0.000e+00 1.000e+01 ( 1.000e+00) 510 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 511 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 508 Normalization: 9.562e-01 3.467e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 136.402 13.975 Photon Flux Upper Limit: 1.01e-07 ph cm-2 s-1 Energy Flux Upper Limit: 2.18e-04 MeV cm-2 s-1 Saving results to: /scratch/kocevski/240424/likelihoodResults_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.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) = 1953.38673907 delta logL = -0.0264300244401 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 1952.02229959 delta logL = 1.3380094619 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .42141E-01 1.0000 .0000 .10000E+07 2 'alpha ' 5.0000 1.0000 .0000 5.0000 3 'Normalizat' .72511 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.3887 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .5120E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 1952.022 FROM MIGRAD STATUS=CONVERGED 91 CALLS 397 TOTAL EDM= .36E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .42127E-01 .35932E-01 .63906E-06** at limit ** 2 alpha 5.0000 .51597 .50000 ** at limit ** 3 Normalizat .72568 .42821 .33581E-03 -.20907E-03 4 Prefactor 1.3884 .35203 .21361E-03 -.37769E-03 ERR DEF= .500 Final values: norm = 0.0421271 alpha = 5 Normalizat = 0.725682 Prefactor = 1.38842 ********** ** 18 **HESSE ********** FCN= 1952.022 FROM HESSE STATUS=OK 33 CALLS 430 TOTAL EDM= .36E-09 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .42127E-01 .35891E-01 .74882E-07 -1.5704 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 5.0000 .51486 .50000 1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Normalizat .72568 .42858 .67162E-04 -1.0289 4 Prefactor 1.3884 .35231 .42723E-04 -.80714 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 3.55953e-10 Minuit parameter uncertainties: 1 0.0358914 2 3.04461e-05 3 0.430577 4 0.352926 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/240424': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 1952.02229785 delta logL = 1.33801120261 Extracting fit parameters... 4FGL J0905.6+1358 Spectrum: LogParabola 282 norm: 4.213e-02 3.589e-02 0.000e+00 1.000e+06 ( 1.000e-13) 283 alpha: 5.000e+00 3.045e-05 0.000e+00 5.000e+00 ( 1.000e+00) 284 beta: 1.283e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 285 Eb: 2.458e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 509 Prefactor: 1.388e+00 3.529e-01 0.000e+00 1.000e+01 ( 1.000e+00) 510 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 511 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 508 Normalization: 7.257e-01 4.306e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): 2.93 Ra Dec: 136.402 13.975 Photon Index (Free Index): 5.00 +/- 0.00 Photon Flux (Free Index): 3.13e-07 +/- 2.65e-07 Energy Flux (Free Index): 4.45e-05 +/- 3.78e-05 Creating a high resolution counts map... INFO: Auto-setting vmin to 0.000e+00 [aplpy.core] INFO: Auto-setting vmax to 0.000e+00 [aplpy.core] Saving /scratch/kocevski/240424/cmap_HighResolution_694396801_695001601_4FGL_J0905.6+1358_weekly_bin753.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/240424 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='2.18e-04', comment='SUCCESS', energy_flux2='4.45e-05', dlogl='1.34e+00', photon_flux2='3.13e-07', job_status='DONE', time_completed='2023-01-10 03:40:42.192822', photon_index_error2='0.00', photon_index2='5.00', ts='-0.00', fit_tolerance='1e-08', GAL='1.28', photon_index_error='0.00', photon_flux_upper_limit='1.01e-07', energy_flux_error2='3.78e-05', EG='0.96', time_epoch_completed='1673350842.19', return_code='0', job_id='240424', GAL2='1.39', EG2='0.73', return_code2='0', photon_flux_error2='2.65e-07', ts2='2.93', photon_index='1.59' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; Database successfully updated. Analysis Complete. Tue Jan 10 03:40:42 PST 2023 comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 10.6552539968 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 6.67366828226 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 15.167952134 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 23.4580367901 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 5.38620736934 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 25.6200307347 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 17.3199434152 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 25.7746258573 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 15.5193874509 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 0.632167288405 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 29.5873669064 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 7.39518404224 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 8.5670867201 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 28.9257741728 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 6.02564014665 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 14.4753438825 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 6.49351628203 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 14.805648214 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 29.990104466 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 4.31208716258 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 15.7275132617 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 8.6032987119 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 14.9005779833 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 7.85538470511 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 9.95366172702 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 24.1523891068 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 26.5980950836 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 26.1903096114 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 7.04685951874 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 22.5884669865 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 26.5022265824 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 11.6896029713 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 21.6704254772 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 8.37813747662 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 25.8349800147 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 8.49646064102 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1673349813.66', time_completed='2023-01-10 03:23:33.661136', job_id='232398' WHERE bin_id='753' AND source_name='4FGL J0905.6+1358' 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='1673349813.66' 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='1673349813.66' at line 1 Command execution failed. Waiting 29.7551360781 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Jan 10 03:33:43 PST 2023 ------------------------------------------------------------ Sender: LSF System Subject: Job 232398: <4FGL_J0905.6+1358_weekly_bin753> in cluster Done Job <4FGL_J0905.6+1358_weekly_bin753> was submitted from host by user in cluster at Tue Jan 10 02:55:33 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 03:16:13 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 03:16:13 2023 Terminated at Tue Jan 10 03:33:44 2023 Results reported at Tue Jan 10 03:33:44 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0905.6+1358_weekly_bin753 136.402 13.975 694396801 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0905.6+1358 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 403.00 sec. Max Memory : 1256 MB Average Memory : 317.88 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1051 sec. Turnaround time : 2291 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 240424: <4FGL_J0905.6+1358_weekly_bin753> in cluster Done Job <4FGL_J0905.6+1358_weekly_bin753> was submitted from host by user in cluster at Tue Jan 10 03:25:16 2023 Job was executed on host(s) , in queue , as user in cluster at Tue Jan 10 03:25:28 2023 was used as the home directory. was used as the working directory. Started at Tue Jan 10 03:25:28 2023 Terminated at Tue Jan 10 03:40:43 2023 Results reported at Tue Jan 10 03:40:43 2023 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0905.6+1358_weekly_bin753 136.402 13.975 694396801 695001601 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0905.6+1358 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 747.00 sec. Max Memory : 1256 MB Average Memory : 256.06 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 915 sec. Turnaround time : 927 sec. The output (if any) is above this job summary.