aklog: Couldn't determine realm of user:aklog: No credentials cache found while getting realm /nfs/farm/g/glast/g/LCRepository/bin/miniconda2/envs/fermitools_v1.0.5/lib/python2.7/site-packages/pyfits/__init__.py:22: PyFITSDeprecationWarning: PyFITS is deprecated, please use astropy.io.fits PyFITSDeprecationWarning) # noqa Likelihood Analysis Tool Support Contact: Daniel Kocevski (daniel.kocevski@nasa.gov) Waiting 110 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 = 74088 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0109.7+6133_monthly_bin172 RA = 17.445, Dec = 61.5615 tmin = 682819201, tmax = 685411201 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='25912', job_status='RUN', time_executed='2022-09-21 11:28:00.052543', time_epoch_executed='1663784880.05' WHERE source_name='4FGL J0109.7+6133' and cadence='monthly' and bin_id='172' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/25912 Creating custom pfile directory: /scratch/kocevski/25912/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=682819201.0 && nMetStart<685411201.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=682819201.0 && nMetStart<685411201.0' /Data/Flight/Level1/LPA Retrieving 455 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/25912/ft1_4FGL_J0109.7+6133_monthly_bin172.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=682819201.0 && nMetStart<685411201.0' /Data/Flight/Level1/LPA Retrieving 455 files... Done. Merging files... Merged file saved to: /scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/25912/ft1_4FGL_J0109.7+6133_monthly_bin172.fits outfile=/scratch/kocevski/25912/ft1_filteredMKT_4FGL_J0109.7+6133_monthly_bin172.fits ra=17.445 dec=61.5615 rad=12.0 tmin=682819201.0 tmax=685411201.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 31.67 user 27.48 sys 0.83 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.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/25912/ft1_filteredMKT_4FGL_J0109.7+6133_monthly_bin172.fits evtable="EVENTS" outfile="/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.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 1.07 user 0.56 sys 0.18 Number of photons that the gtmktime cut: 49178 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits" evtable="EVENTS" scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits sctable="SC_DATA" outfile=/scratch/kocevski/25912/ltcube_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.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/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits .....................! real 140.56 user 134.73 sys 0.32 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits evtable="EVENTS" scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits sctable="SC_DATA" expcube=/scratch/kocevski/25912/ltcube_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits outfile=/scratch/kocevski/25912/expmap_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.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/25912/ltcube_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits .....................! real 167.63 user 155.18 sys 4.82 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Extended source HB 3 in ROI with RadialDisk spatial model. Extended source W 3 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/W3.fits is the correct path to the extended template. Extended source CTB 109 in ROI with RadialDisk spatial model. Extended source FHES J2208.4+6443 in ROI with RadialGaussian spatial model. Extended source FHES J2304.0+5406 in ROI with RadialGaussian spatial model. Added 202 point sources and 5 extended sources If using unbinned likelihood you will need to rerun gtdiffrsp for the extended sources or rerun the makeModel function with optional argument psForce=True Setting source of interest to: 4FGL J0109.7+6133 @ 17.445 61.5615 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits outfile=/scratch/kocevski/25912/cmap_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.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=17.445 yref=61.5615 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 1.12 user 0.58 sys 0.16 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits outfile=/scratch/kocevski/25912/cmap_HighResolution_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.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=17.445 yref=61.5615 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.81 user 0.59 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits evtable="EVENTS" scfile=/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/25912/Model_4FGL_J0109.7+6133_monthly_bin172.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source CTB 109 adding source EG_v02 adding source FHES J2208.4+6443 adding source FHES J2304.0+5406 adding source GAL_V02 adding source HB 3 adding source W 3 Working on... /scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits.....................! real 5474.61 user 5286.83 sys 1.77 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits', '/scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits', expMap='/scratch/kocevski/25912/expmap_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits', expCube='/scratch/kocevski/25912/ltcube_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/25912/Model_4FGL_J0109.7+6133_monthly_bin172.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0109.7+6133' 4FGL J0109.7+6133 Spectrum: LogParabola 170 norm: 8.138e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 171 alpha: 2.565e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 172 beta: 1.581e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 173 Eb: 7.679e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/25912/ft1_filtered_4FGL_J0109.7+6133_monthly_bin172.fits Spacecraft file(s): /scratch/kocevski/25912/ft2_4FGL_J0109.7+6133_monthly_bin172.fits Exposure map: /scratch/kocevski/25912/expmap_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits Exposure cube: /scratch/kocevski/25912/ltcube_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/25912/Model_4FGL_J0109.7+6133_monthly_bin172.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) = 457427.191827 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 457426.800173 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .27806 1.0000 .0000 .10000E+07 2 'norm ' 1.2464 1.0000 .0000 .10000E+07 3 'norm ' 4.2119 1.0000 .0000 .10000E+07 4 'norm ' 2.8998 1.0000 .0000 .10000E+07 5 'norm ' 4.9270 1.0000 .0000 .10000E+07 6 'norm ' .83061E-06 1.0000 .0000 .10000E+07 7 'norm ' .59397E-08 1.0000 .0000 .10000E+07 8 'Prefactor ' .26660E-04 1.0000 .0000 .10000E+07 9 'norm ' .15216E-06 1.0000 .0000 .10000E+07 10 'Prefactor ' 1.6165 1.0000 .0000 .10000E+07 11 'Prefactor ' 1.6244 1.0000 .10000E-03 10000. 12 'norm ' 4.0956 1.0000 .0000 .10000E+07 13 'Normalizat' 1.3118 1.0000 .10000E-01 10.000 14 'Prefactor ' .97992 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7050E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 457426.8 FROM MIGRAD STATUS=CONVERGED 79 CALLS 735 TOTAL EDM= .84E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 6.9% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .29399 20.349 .63965E-05 .63512E-03 2 norm 1.2469 .74557 -.28376E-07 .10456E-01 3 norm 4.2074 2.7473 .41320E-07 -.99733E-03 4 norm 2.8991 1.0202 .16643E-07 -.35141E-02 5 norm 4.9600 4.1541 -.76063E-07 .39179E-02 6 norm .44409E-09 3.6089 -.25487E-06** at limit ** 7 norm .11102E-09 .37568 .11675E-07** at limit ** 8 Prefactor .33307E-09 1.4506 .10169E-06** at limit ** 9 norm .0000 .13312 -.25044E-07** at limit ** 10 Prefactor 1.6165 .69485 -.81345E-07 -.41330E-01 11 Prefactor 1.6244 .23000 .18315E-06 .43035E-02 12 norm 4.0956 .16141 .49210E-08 -.19810E-03 13 Normalizat 1.3118 .77122E-01 -.40471E-05 .55904E-03 14 Prefactor .97993 .83604E-02 .11627E-06 .59832E-02 ERR DEF= .500 Final values: Prefactor = 0.293992 norm = 1.24687 norm = 4.2074 norm = 2.89913 norm = 4.95996 norm = 4.44089e-10 norm = 1.11022e-10 Prefactor = 3.33067e-10 norm = 0 Prefactor = 1.61647 Prefactor = 1.62441 norm = 4.09565 Normalizat = 1.31184 Prefactor = 0.979926 ********** ** 18 **HESSE ********** FCN= 457426.8 FROM HESSE STATUS=OK 210 CALLS 945 TOTAL EDM= .69E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .29399 1.0143 .16993E-01 -1.5697 2 norm 1.2469 .75799 .10024E-02 -1.5686 3 norm 4.2074 2.7564 .49078E-03 -1.5667 4 norm 2.8991 1.0445 .59646E-04 -1.5674 5 norm 4.9600 4.1538 .45288E-03 -1.5663 6 norm .44409E-09 .24537 .80869E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 norm .11102E-09 .36972 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor .33307E-09 1.4606 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 norm .0000 .13399 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor 1.6165 .70103 .83240E-03 -1.5683 11 Prefactor 1.6244 .23255 .82992E-02 -1.5453 12 norm 4.0956 .16326 .49791E-03 -1.5667 13 Normalizat 1.3118 .78111E-01 .22005 -.83214 14 Prefactor .97993 .82709E-02 .26944E-01 -.93402 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 6.91713e-06 Minuit parameter uncertainties: 1 1.01427 2 0.757994 3 2.7564 4 1.04447 5 4.15377 6 2.02516e-05 7 1.38877e-05 8 4.53117e-05 9 1.92343e-06 10 0.701032 11 0.232545 12 0.163256 13 0.0781177 14 0.0082709 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 457426.800123 Extracting fit parameters... 4FGL J0109.7+6133 Spectrum: LogParabola 170 norm: 4.441e-10 2.025e-05 0.000e+00 1.000e+06 ( 1.000e-12) 171 alpha: 2.565e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 172 beta: 1.581e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 173 Eb: 7.679e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 694 Prefactor: 9.799e-01 8.271e-03 0.000e+00 1.000e+01 ( 1.000e+00) 695 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 696 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 685 Normalization: 1.312e+00 7.812e-02 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 17.445 61.562 Photon Flux Upper Limit: 2.67e-08 ph cm-2 s-1 Energy Flux Upper Limit: 7.72e-06 MeV cm-2 s-1 Saving results to: /scratch/kocevski/25912/likelihoodResults_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.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) = 457426.737671 delta logL = 0.0624527900945 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 457426.725568 delta logL = 0.0745554724708 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .97427E-01 1.0000 .0000 .10000E+07 2 'alpha ' 4.1490 1.0000 .0000 5.0000 3 'Normalizat' 1.3060 1.0000 .10000E-01 10.000 4 'Prefactor ' .97995 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7050E+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= 457426.7 FROM MIGRAD STATUS=FAILED 111 CALLS 342 TOTAL EDM= .12E-01 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .96088E-01 10.330 .15124E-03** at limit ** 2 alpha 4.1609 2.8733 .50000 .20813E-01 3 Normalizat 1.3058 .20420E-01 .98422E-03 -.34006E-04 4 Prefactor .97996 .21907E-02 .11908E-03 -.19553E-03 ERR DEF= .500 START SIMPLEX MINIMIZATION. CONVERGENCE WHEN EDM .LT. .20E-04 SIMPLEX MINIMIZATION HAS CONVERGED. FCN= 457426.7 FROM SIMPLEX STATUS=UNCHANGED 89 CALLS 431 TOTAL EDM= .55E-05 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .96088E-01 10.330 .52562E-05** at limit ** 2 alpha 4.1609 2.8733 .36399E-02 .20813E-01 3 Normalizat 1.3058 .20420E-01 .27040E-04 -.34006E-04 4 Prefactor .97996 .21907E-02 .15235E-05 -.19553E-03 ERR DEF= .500 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= 457426.7 FROM MIGRAD STATUS=FAILED 76 CALLS 507 TOTAL EDM= .19E-01 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .96088E-01 14.235 .12099E-05** at limit ** 2 alpha 4.1609 2.9135 .50000 .20813E-01 3 Normalizat 1.3058 .25986E-01 .78737E-05 -.36963E-04 4 Prefactor .97996 .26750E-02 .95263E-06 -.13070E-03 ERR DEF= .500 Final values: norm = 0.0960878 alpha = 4.16086 Normalizat = 1.30584 Prefactor = 0.979964 ********** ** 18 **HESSE ********** FCN= 457426.7 FROM HESSE STATUS=NOT POSDEF 27 CALLS 534 TOTAL EDM= .19E-01 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .96088E-01 14.258 .37436E-06 -1.5702 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 4.1609 2.9203 .50000 .72662 3 Normalizat 1.3058 .25981E-01 .15747E-05 -.83392 4 Prefactor .97996 .26797E-02 .22268E-06 -.93400 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 0.0193113 Minuit parameter uncertainties: 1 2.34099 2 12.4736 3 0.0259808 4 0.00267968 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/25912': 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): 1 logL (Free Index) = 457426.725558 delta logL = 0.0745656492072 Extracting fit parameters... 4FGL J0109.7+6133 Spectrum: LogParabola 170 norm: 9.609e-02 2.341e+00 0.000e+00 1.000e+06 ( 1.000e-12) 171 alpha: 4.161e+00 1.247e+01 0.000e+00 5.000e+00 ( 1.000e+00) 172 beta: 1.581e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 173 Eb: 7.679e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 694 Prefactor: 9.800e-01 2.680e-03 0.000e+00 1.000e+01 ( 1.000e+00) 695 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 696 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 685 Normalization: 1.306e+00 2.598e-02 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 17.445 61.562 Creating a high resolution counts map... INFO: Auto-setting vmin to -5.000e-01 [aplpy.core] INFO: Auto-setting vmax to 5.550e+00 [aplpy.core] Saving /scratch/kocevski/25912/cmap_HighResolution_682819201_685411201_4FGL_J0109.7+6133_monthly_bin172.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/25912 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='7.72e-06', job_status='DONE', photon_flux_upper_limit='2.67e-08', time_completed='2022-09-21 16:18:52.649248', job_id='25912', GAL2='0.98', fit_tolerance='1e-08', EG2='1.31', EG='1.31', time_epoch_completed='1663802332.65', return_code2='1', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.98', dlogl='7.46e-02', ts2='0.16', photon_index_error='0.00', photon_index='2.56' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; Database successfully updated. Analysis Complete. Wed Sep 21 16:18:53 PDT 2022 , 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='1663784515.78' at line 1 Command execution failed. Waiting 5.66070620824 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 16.3490185423 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 0.694792904417 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 22.5996724052 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 23.8412711285 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 24.0560057929 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 0.660036295231 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 5.20390869352 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 12.0607285851 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 9.72761251209 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 28.9752169409 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 16.337948085 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 23.7938142133 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 2.8051841666 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 27.5057346336 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 28.2636437867 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 13.1622207875 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 6.24676872555 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 9.15669657976 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 25.6702645696 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 10.2255715386 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 4.46851024723 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 6.62807675551 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 23.940081248 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 11.7848316631 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 28.8267611115 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 4.76796374793 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 25.7127326678 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 5.05977964593 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 2.02934789598 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 8.75510601419 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 27.3305836009 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 0.56386871339 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 23.0512808238 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 5.7467427052 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 20.3358567924 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 2.54860579839 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 25.7151891778 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 2.87871064726 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 28.7008454394 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78', time_completed='2022-09-21 11:21:55.780465', job_id='938362' WHERE bin_id='172' AND source_name='4FGL J0109.7+6133' AND cadence='monthly'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663784515.78' 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='1663784515.78' at line 1 Command execution failed. Waiting 9.5642943716 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Wed Sep 21 11:32:06 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 938362: <4FGL_J0109.7+6133_monthly_bin172> in cluster Done Job <4FGL_J0109.7+6133_monthly_bin172> was submitted from host by user in cluster at Wed Sep 21 06:10:25 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 06:10:26 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 06:10:26 2022 Terminated at Wed Sep 21 11:32:09 2022 Results reported at Wed Sep 21 11:32:09 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0109.7+6133_monthly_bin172 17.445 61.5615 682819201 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0109.7+6133 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 18411.00 sec. Max Memory : 1219 MB Average Memory : 969.62 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 7 Max Threads : 21 Run time : 19304 sec. Turnaround time : 19304 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 25912: <4FGL_J0109.7+6133_monthly_bin172> in cluster Done Job <4FGL_J0109.7+6133_monthly_bin172> was submitted from host by user in cluster at Wed Sep 21 11:25:36 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 11:25:37 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 11:25:37 2022 Terminated at Wed Sep 21 16:18:58 2022 Results reported at Wed Sep 21 16:18:58 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0109.7+6133_monthly_bin172 17.445 61.5615 682819201 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0109.7+6133 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 17170.00 sec. Max Memory : 1193 MB Average Memory : 969.37 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 7 Max Threads : 21 Run time : 17600 sec. Turnaround time : 17602 sec. The output (if any) is above this job summary.