aklog: Couldn't determine realm of user:aklog: No credentials cache found while getting realm /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: Dan/nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: Daniel Kocevski (daniel.kocevski@nasa.gov) Waiting 230 seconds before starting... Proceeding. Importing modules... This is make3FGLxml version 01r0. The default diffuse model files and names are for pass 8 and assume you have v10r00p05 of the Fermi Science Tools or higher. This is make4FGLDR3xml version 01r09. The default diffuse model files and names are for P8R3, 4FGL DRs, and the default fermitools directory locations. WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/matplotlib/cbook/deprecation.py:106: MatplotlibDeprecationWarning: The mpl_toolkits.axes_grid module was deprecated in version 2.1. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist provies the same functionality instead. warnings.warn(message, mplDeprecation, stacklevel=1) WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). number of points = 17375 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J1728.4+0427_weekly_bin740 RA = 262.122, Dec = 4.4606 tmin = 686534401, tmax = 687139201 emin = 100.0, emax = 100000.0 irfs = P8R3_SOURCE_V2 ROI = 12 zmax = 90 Fitting strategies: Fix sources to their catalog values = True Leave variable source normalizations free = True Perform pre-fit where ALL sources are frozen to catalog values = False Perform secondary fit with a free spectral index = True Remove all catalog sources = False Remove weak (TS < 2) catalog sources = False Freeze Galactic component = False Likelihood fit parameters: Statistic: UNBINNED Optimizer: MINUIT Catalog: 4FGL Repository job = True LAT data source: Data catalog Updating database... UPDATE lightcurve_data_v2 SET job_id='823156', job_status='RUN', time_executed='2022-10-11 11:21:16.086994', time_epoch_executed='1665512476.09' WHERE source_name='4FGL J1728.4+0427' and cadence='weekly' and bin_id='740' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/823156 Creating custom pfile directory: /scratch/kocevski/823156/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Level1/LPA Retrieving 107 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/823156/ft1_4FGL_J1728.4+0427_weekly_bin740.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=686534401.0 && nMetStart<687139201.0' /Data/Flight/Level1/LPA Retrieving 107 files... Done. Merging files... Merged file saved to: /scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/823156/ft1_4FGL_J1728.4+0427_weekly_bin740.fits outfile=/scratch/kocevski/823156/ft1_filteredMKT_4FGL_J1728.4+0427_weekly_bin740.fits ra=262.122 dec=4.4606 rad=12.0 tmin=686534401.0 tmax=687139201.0 emin=100.0 emax=100000.0 zmin=0.0 zmax=90.0 evclass=128 evtype="INDEF" convtype=-1 phasemin=0.0 phasemax=1.0 evtable="EVENTS" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Done. real 7.32 user 6.93 sys 0.31 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits sctable="SC_DATA" filter="IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2))" roicut=no evfile=/scratch/kocevski/823156/ft1_filteredMKT_4FGL_J1728.4+0427_weekly_bin740.fits evtable="EVENTS" outfile="/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits" apply_filter=yes overwrite=yes header_obstimes=yes tstart=0.0 tstop=0.0 gtifile="default" chatter=3 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtmktime version HEAD Applying GTI filter: IN_SAA!=T && LIVETIME>0 && gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nogrb.gti',(START+STOP)/2) && (angsep(RA_SUN,DEC_SUN,RA_ZENITH,DEC_ZENITH)>115 || gtifilter('/nfs/farm/g/glast/g/LCRepository/Likelihood/GTIs/nosolarflares.gti',(START+STOP)/2)) real 0.60 user 0.38 sys 0.19 Number of photons that the gtmktime cut: 5354 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits" evtable="EVENTS" scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits sctable="SC_DATA" outfile=/scratch/kocevski/823156/ltcube_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits dcostheta=0.025 binsz=1.0 phibins=0 tmin=0.0 tmax=0.0 file_version="1" zmin=0.0 zmax=90.0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). Working on file /scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits .....................! real 34.96 user 34.34 sys 0.36 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits evtable="EVENTS" scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits sctable="SC_DATA" expcube=/scratch/kocevski/823156/ltcube_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits outfile=/scratch/kocevski/823156/expmap_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits irfs="P8R3_SOURCE_V2" evtype="INDEF" srcrad=30.0 nlong=88 nlat=88 nenergies=10 submap=no nlongmin=0 nlongmax=0 nlatmin=0 nlatmax=0 chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). The exposure maps generated by this tool are meant to be used for *unbinned* likelihood analysis only. Do not use them for binned analyses. Computing the ExposureMap using /scratch/kocevski/823156/ltcube_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits .....................! real 191.57 user 185.86 sys 4.44 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Extended source FHES J1723.5-0501 in ROI with RadialGaussian spatial model. Extended source G24.7+0.6 in ROI with RadialDisk spatial model. Extended source W 41 in ROI with RadialGaussian spatial model. Extended source FGES J1836.5-0651 in ROI with RadialDisk spatial model. Extended source FGES J1838.9-0704 in ROI with RadialDisk spatial model. Extended source Kes 73 in ROI with RadialDisk spatial model. Extended source HESS J1841-055 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/HESSJ1841-055.fits is the correct path to the extended template. Extended source Kes 79 in ROI with RadialDisk spatial model. Added 240 point sources and 8 extended sources If using unbinned likelihood you will need to rerun gtdiffrsp for the extended sources or rerun the makeModel function with optional argument psForce=True Setting source of interest to: 4FGL J1728.4+0427 @ 262.122 4.4606 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits outfile=/scratch/kocevski/823156/cmap_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=160 nypix=160 binsz=0.25 coordsys="CEL" xref=262.122 yref=4.4606 axisrot=0.0 rafield="RA" decfield="DEC" proj="AIT" hpx_ordering_scheme="RING" hpx_order=3 hpx_ebin=yes hpx_region="" evtable="EVENTS" sctable="SC_DATA" efield="ENERGY" tfield="TIME" chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). This is gtbin version HEAD real 0.63 user 0.43 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits outfile=/scratch/kocevski/823156/cmap_HighResolution_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits algorithm="CMAP" ebinalg="LOG" emin=30.0 emax=200000.0 ebinfile=NONE tbinalg="LIN" tbinfile=NONE nxpix=500 nypix=500 binsz=0.1 coordsys="CEL" xref=262.122 yref=4.4606 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.61 user 0.43 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits evtable="EVENTS" scfile=/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/823156/Model_4FGL_J1728.4+0427_weekly_bin740.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source FGES J1836.5-0651 adding source FGES J1838.9-0704 adding source FHES J1723.5-0501 adding source G24.7+0.6 adding source GAL_V02 adding source HESS J1841-055 adding source Kes 73 adding source Kes 79 adding source W 41 Working on... /scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits.....................! real 736.55 user 730.14 sys 1.43 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits', '/scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits', expMap='/scratch/kocevski/823156/expmap_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits', expCube='/scratch/kocevski/823156/ltcube_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/823156/Model_4FGL_J1728.4+0427_weekly_bin740.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1728.4+0427' 4FGL J1728.4+0427 Spectrum: LogParabola 261 norm: 3.299e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 262 alpha: 2.434e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 263 beta: 2.465e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 264 Eb: 6.843e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/823156/ft1_filtered_4FGL_J1728.4+0427_weekly_bin740.fits Spacecraft file(s): /scratch/kocevski/823156/ft2_4FGL_J1728.4+0427_weekly_bin740.fits Exposure map: /scratch/kocevski/823156/expmap_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits Exposure cube: /scratch/kocevski/823156/ltcube_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/823156/Model_4FGL_J1728.4+0427_weekly_bin740.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 53567.1772606 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 53566.3496041 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 2.0189 1.0000 .0000 .10000E+07 2 'Prefactor ' .16653E-09 1.0000 .0000 .10000E+07 3 'Prefactor ' .53009E-02 1.0000 .0000 .10000E+07 4 'Prefactor ' 11.259 1.0000 .0000 .10000E+07 5 'Prefactor ' 3.2251 1.0000 .0000 .10000E+07 6 'Prefactor ' 7.0942 1.0000 .0000 .10000E+07 7 'Prefactor ' 2.9948 1.0000 .0000 .10000E+07 8 'norm ' 11.591 1.0000 .0000 .10000E+07 9 'Prefactor ' 20.019 1.0000 .0000 .10000E+07 10 'Prefactor ' 1.9977 1.0000 .0000 .10000E+07 11 'norm ' .82754E-05 1.0000 .0000 .10000E+07 12 'norm ' .28255E-07 1.0000 .0000 .10000E+07 13 'norm ' .68930 1.0000 .0000 .10000E+07 14 'norm ' 1.9138 1.0000 .0000 .10000E+07 15 'norm ' .44757E-05 1.0000 .0000 .10000E+07 16 'Normalizat' 1.3799 1.0000 .10000E-01 10.000 17 'Prefactor ' 1.0287 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .8810E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. FCN= 53566.35 FROM MIGRAD STATUS=CONVERGED 397 CALLS 1248 TOTAL EDM= .19E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= .8% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 2.0177 2.1450 .58931E-06 -.24307E-02 2 Prefactor .0000 .89802 -.70460E-08** at limit ** 3 Prefactor .55511E-10 31.034 -.22367E-07** at limit ** 4 Prefactor 10.693 14.304 .25079E-07 -.96328E-04 5 Prefactor 3.2185 3.9084 .61822E-07 .98111E-03 6 Prefactor 3.7036 198.23 .91972E-07 -.14209E-03 7 Prefactor 2.8756 7.4525 .14812E-06 .21724E-02 8 norm 11.567 5.8001 -.17716E-07 -.37759E-03 9 Prefactor 19.878 31.965 -.18073E-06 .73860E-02 10 Prefactor 2.0026 1.6405 .43032E-07 .10687E-02 11 norm .18319E-08 4.9461 .14631E-06** at limit ** 12 norm .0000 1.3486 -.49703E-08** at limit ** 13 norm .68872 .38177 .85832E-08 .21109E-03 14 norm 1.9127 2.6673 .88089E-08 -.51469E-03 15 norm .0000 1.9720 -.18070E-08** at limit ** 16 Normalizat 1.3808 .16970 -.52029E-05 -.21712E-03 17 Prefactor 1.0287 .29263E-01 .70451E-06 .77270E-03 ERR DEF= .500 Final values: Prefactor = 2.01772 Prefactor = 0 Prefactor = 5.55112e-11 Prefactor = 10.693 Prefactor = 3.21848 Prefactor = 3.70361 Prefactor = 2.87562 norm = 11.5666 Prefactor = 19.878 Prefactor = 2.00255 norm = 1.83187e-09 norm = 0 norm = 0.688717 norm = 1.91271 norm = 0 Normalizat = 1.38084 Prefactor = 1.02874 ********** ** 18 **HESSE ********** FCN= 53566.35 FROM HESSE STATUS=OK 227 CALLS 1475 TOTAL EDM= .66E-08 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 2.0177 2.1485 .14562E-03 -1.5680 2 Prefactor .0000 .89970 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor .55511E-10 31.091 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor 10.693 14.305 .59663E-04 -1.5643 5 Prefactor 3.2185 3.9105 .22553E-04 -1.5672 6 Prefactor 3.7036 198.63 .15056E-04 -1.5669 7 Prefactor 2.8756 7.4020 .23453E-04 -1.5674 8 norm 11.567 5.7699 .11760E-04 -1.5640 9 Prefactor 19.878 32.444 .89429E-05 -1.5619 10 Prefactor 2.0026 1.6157 .23653E-04 -1.5680 11 norm .18319E-08 5.0115 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 norm .0000 1.3878 .16847E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 norm .68872 .37942 .10247E-04 -1.5691 14 norm 1.9127 2.6528 .30043E-04 -1.5680 15 norm .0000 1.9737 .84235E-04 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 Normalizat 1.3808 .18209 .63409E-03 -.81185 17 Prefactor 1.0287 .31782E-01 .13410E-03 -.91778 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 6.56702e-09 Minuit parameter uncertainties: 1 2.14846 2 4.30387e-06 3 8.04815e-05 4 14.3055 5 3.91048 6 54.2473 7 7.40199 8 5.76988 9 32.4446 10 1.61569 11 0.000193021 12 4.21198e-06 13 0.379423 14 2.65282 15 4.97868e-07 16 0.182174 17 0.0317827 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 53566.3467169 Extracting fit parameters... 4FGL J1728.4+0427 Spectrum: LogParabola 261 norm: 1.832e-09 1.930e-04 0.000e+00 1.000e+06 ( 1.000e-12) 262 alpha: 2.434e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 263 beta: 2.465e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 264 Eb: 6.843e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 864 Prefactor: 1.029e+00 3.178e-02 0.000e+00 1.000e+01 ( 1.000e+00) 865 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 866 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 850 Normalization: 1.381e+00 1.822e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 262.122 4.461 Photon Flux Upper Limit: 4.34e-08 ph cm-2 s-1 Energy Flux Upper Limit: 1.40e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/823156/likelihoodResults_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 53566.3319576 delta logL = 0.0147593057845 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 53566.3294036 delta logL = 0.0173132377822 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .44185E-01 1.0000 .0000 .10000E+07 2 'alpha ' 4.9999 1.0000 .0000 5.0000 3 'Normalizat' 1.3716 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.0295 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .8810E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MACHINE ACCURACY LIMITS FURTHER IMPROVEMENT. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD TERMINATED WITHOUT CONVERGENCE. FCN= 53566.33 FROM MIGRAD STATUS=FAILED 111 CALLS 463 TOTAL EDM= .60E-05 STRATEGY= 1 ERR MATRIX APPROXIMATE EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .44170E-01 5.9363 .11321E-03** at limit ** 2 alpha 5.0000 2.6989 .50000 ** at limit ** 3 Normalizat 1.3717 .18179 .63589E-03 -.30693E-03 4 Prefactor 1.0295 .31599E-01 .13406E-03 -.11703E-02 ERR DEF= .500 START SIMPLEX MINIMIZATION. CONVERGENCE WHEN EDM .LT. .20E-04 SIMPLEX MINIMIZATION HAS CONVERGED. FCN= 53566.12 FROM SIMPLEX STATUS=PROGRESS 178 CALLS 641 TOTAL EDM= .15E-04 STRATEGY= 1 ERR MATRIX APPROXIMATE EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .11965 5.9363 .20904E-05 -1.5701 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha .25912E-05 2.6989 .15725E-01 9391.8 3 Normalizat 1.3722 .18179 .20882E-06 -.81436 4 Prefactor 1.0302 .31599E-01 .20651E-07 -.91729 ERR DEF= .500 MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 53566.11 FROM MIGRAD STATUS=CONVERGED 48 CALLS 689 TOTAL EDM= .11E-08 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .11838 .26284 .22643E-03** at limit ** 2 alpha .19429E-14 3.3941 .50000 ** at limit ** 3 Normalizat 1.3793 .16520 .25436E-04 .28605E-05 4 Prefactor 1.0288 .31046E-01 .53624E-05 .16961E-04 ERR DEF= .500 Final values: norm = 0.118377 alpha = 1.94289e-15 Normalizat = 1.37929 Prefactor = 1.0288 ********** ** 18 **HESSE ********** FCN= 53566.11 FROM HESSE STATUS=OK 31 CALLS 720 TOTAL EDM= .48E-13 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .11838 .22655 .90572E-05 -1.5701 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha .19429E-14 3.2050 .50000 9391.8 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Normalizat 1.3793 .16511 .50872E-05 -.81229 4 Prefactor 1.0288 .31029E-01 .10725E-05 -.91776 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 4.82232e-14 Minuit parameter uncertainties: 1 0.22655 2 1.08278e-07 3 0.165177 4 0.0310292 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/823156': 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) = 53566.1147919 delta logL = 0.231924992186 Extracting fit parameters... 4FGL J1728.4+0427 Spectrum: LogParabola 261 norm: 1.184e-01 2.265e-01 0.000e+00 1.000e+06 ( 1.000e-12) 262 alpha: 1.943e-15 1.083e-07 0.000e+00 5.000e+00 ( 1.000e+00) 263 beta: 2.465e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 264 Eb: 6.843e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 864 Prefactor: 1.029e+00 3.103e-02 0.000e+00 1.000e+01 ( 1.000e+00) 865 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 866 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 850 Normalization: 1.379e+00 1.652e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 262.122 4.461 Creating a high resolution counts map... INFO: Auto-setting vmin to -1.000e-01 [aplpy.core] INFO: Auto-setting vmax to 1.110e+00 [aplpy.core] Saving /scratch/kocevski/823156/cmap_HighResolution_686534401_687139201_4FGL_J1728.4+0427_weekly_bin740.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/823156 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='1.40e-05', job_status='DONE', photon_flux_upper_limit='4.34e-08', time_completed='2022-10-11 12:23:31.602797', job_id='823156', GAL2='1.03', fit_tolerance='1e-08', EG2='1.38', EG='1.38', time_epoch_completed='1665516211.6', return_code2='0', ts='-0.00', comment='SUCCESS', return_code='0', GAL='1.03', dlogl='2.32e-01', ts2='0.46', photon_index_error='0.00', photon_index='2.43' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; Database successfully updated. Analysis Complete. Tue Oct 11 12:23:31 PDT 2022 ponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28' at line 1 Command execution failed. Waiting 16.5228759961 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 0.944239558547 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 0.0817195131841 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 29.3947702642 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 13.896828268 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 0.218153641773 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 0.152354503614 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 18.3116389765 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 21.0398540513 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 12.0567604859 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 15.2576661243 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 24.4056229794 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 3.61297021764 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 25.5528111537 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 10.583477265 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 22.9240845769 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 21.5410737867 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 2.53247105424 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 28.7084951064 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 23.730919016 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 17.38919382 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 25.1365865031 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 18.6696140898 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 22.9163191934 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 16.1599485504 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 25.6314752633 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 22.0043026098 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 22.2872843756 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 8.01694931318 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 18.2897802558 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 24.9591662202 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 25.1753308172 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 25.9734501817 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' AND cadence='weekly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1665475596.28', time_completed='2022-10-11 01:06:36.279659', job_id='823376' WHERE bin_id='740' AND source_name='4FGL J1728.4+0427' 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='1665475596.28' 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='1665475596.28' at line 1 Command execution failed. Waiting 11.2266180752 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Tue Oct 11 01:16:41 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 823376: <4FGL_J1728.4+0427_weekly_bin740> in cluster Done Job <4FGL_J1728.4+0427_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 00:08:07 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 00:15:57 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 00:15:57 2022 Terminated at Tue Oct 11 01:16:42 2022 Results reported at Tue Oct 11 01:16:42 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1728.4+0427_weekly_bin740 262.122 4.4606 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1728.4+0427 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 2788.71 sec. Max Memory : 1101 MB Average Memory : 431.32 MB Total Requested Memory : - Delta Memory : - Max Swap : 3411 MB Max Processes : 6 Max Threads : 21 Run time : 3646 sec. Turnaround time : 4115 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 839479: <4FGL_J1728.4+0427_weekly_bin740> in cluster Done Job <4FGL_J1728.4+0427_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 01:10:20 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 01:10:21 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 01:10:21 2022 Terminated at Tue Oct 11 02:13:08 2022 Results reported at Tue Oct 11 02:13:08 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1728.4+0427_weekly_bin740 262.122 4.4606 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1728.4+0427 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 3652.00 sec. Max Memory : 987 MB Average Memory : 443.92 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 3767 sec. Turnaround time : 3768 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 823156: <4FGL_J1728.4+0427_weekly_bin740> in cluster Done Job <4FGL_J1728.4+0427_weekly_bin740> was submitted from host by user in cluster at Tue Oct 11 00:07:48 2022 Job was executed on host(s) , in queue , as user in cluster at Tue Oct 11 00:09:28 2022 was used as the home directory. was used as the working directory. Started at Tue Oct 11 00:09:28 2022 Terminated at Tue Oct 11 12:23:33 2022 Results reported at Tue Oct 11 12:23:33 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1728.4+0427_weekly_bin740 262.122 4.4606 686534401 687139201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1728.4+0427 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 3722.00 sec. Max Memory : 1266 MB Average Memory : 83.34 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 44044 sec. Turnaround time : 44145 sec. The output (if any) is above this job summary.