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 163 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 = 73923 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0654.3+5042_monthly_bin172 RA = 103.596, Dec = 50.7027 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='972120', job_status='RUN', time_executed='2022-09-21 08:13:37.259020', time_epoch_executed='1663773217.26' WHERE source_name='4FGL J0654.3+5042' and cadence='monthly' and bin_id='172' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/972120 Creating custom pfile directory: /scratch/kocevski/972120/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/972120/ft1_4FGL_J0654.3+5042_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/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/972120/ft1_4FGL_J0654.3+5042_monthly_bin172.fits outfile=/scratch/kocevski/972120/ft1_filteredMKT_4FGL_J0654.3+5042_monthly_bin172.fits ra=103.596 dec=50.7027 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 34.11 user 33.36 sys 0.62 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_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/972120/ft1_filteredMKT_4FGL_J0654.3+5042_monthly_bin172.fits evtable="EVENTS" outfile="/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_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 0.85 user 0.65 sys 0.19 Number of photons that the gtmktime cut: 11473 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits" evtable="EVENTS" scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits sctable="SC_DATA" outfile=/scratch/kocevski/972120/ltcube_682819201_685411201_4FGL_J0654.3+5042_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/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits .....................! real 137.28 user 136.45 sys 0.36 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits evtable="EVENTS" scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits sctable="SC_DATA" expcube=/scratch/kocevski/972120/ltcube_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits outfile=/scratch/kocevski/972120/expmap_682819201_685411201_4FGL_J0654.3+5042_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/972120/ltcube_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits .....................! real 197.10 user 190.88 sys 5.47 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 9 in ROI, make sure /nfs/farm/g/glast/g/LCRepository/Likelihood/ExtendedSources/Extended_8years/Templates/HB9.fits is the correct path to the extended template. Added 191 point sources and 1 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 J0654.3+5042 @ 103.596 50.7027 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits outfile=/scratch/kocevski/972120/cmap_682819201_685411201_4FGL_J0654.3+5042_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=103.596 yref=50.7027 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.92 user 0.61 sys 0.17 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits outfile=/scratch/kocevski/972120/cmap_HighResolution_682819201_685411201_4FGL_J0654.3+5042_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=103.596 yref=50.7027 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.64 sys 0.17 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits evtable="EVENTS" scfile=/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/972120/Model_4FGL_J0654.3+5042_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 EG_v02 adding source GAL_V02 adding source HB 9 Working on... /scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits.....................! real 1466.36 user 1461.19 sys 1.29 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits', '/scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits', expMap='/scratch/kocevski/972120/expmap_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits', expCube='/scratch/kocevski/972120/ltcube_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/972120/Model_4FGL_J0654.3+5042_monthly_bin172.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0654.3+5042' 4FGL J0654.3+5042 Spectrum: LogParabola 250 norm: 2.530e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 251 alpha: 2.128e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 252 beta: 8.007e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 253 Eb: 8.361e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/972120/ft1_filtered_4FGL_J0654.3+5042_monthly_bin172.fits Spacecraft file(s): /scratch/kocevski/972120/ft2_4FGL_J0654.3+5042_monthly_bin172.fits Exposure map: /scratch/kocevski/972120/expmap_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits Exposure cube: /scratch/kocevski/972120/ltcube_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/972120/Model_4FGL_J0654.3+5042_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) = 121557.512772 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 121556.69312 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' 20.094 1.0000 .0000 .10000E+07 2 'norm ' 1.6725 1.0000 .0000 .10000E+07 3 'norm ' .62917 1.0000 .0000 .10000E+07 4 'Prefactor ' 11.729 1.0000 .0000 .10000E+07 5 'Prefactor ' 2.3080 1.0000 .0000 .10000E+07 6 'Prefactor ' .14027E-04 1.0000 .0000 .10000E+07 7 'Prefactor ' 9.9369 1.0000 .0000 .10000E+07 8 'norm ' .14883E-03 1.0000 .0000 .10000E+07 9 'norm ' .45860 1.0000 .0000 .10000E+07 10 'norm ' .46750 1.0000 .0000 .10000E+07 11 'Prefactor ' 2.3977 1.0000 .0000 .10000E+07 12 'Prefactor ' .42703E-05 1.0000 .0000 .10000E+07 13 'Prefactor ' 21.147 1.0000 .0000 .10000E+07 14 'Prefactor ' .91891E-05 1.0000 .0000 .10000E+07 15 'norm ' 2.1916 1.0000 .0000 .10000E+07 16 'Prefactor ' 9.5510 1.0000 .0000 .10000E+07 17 'Prefactor ' 7.7262 1.0000 .0000 .10000E+07 18 'norm ' .31118 1.0000 .0000 .10000E+07 19 'Prefactor ' .18535 1.0000 .0000 .10000E+07 20 'Prefactor ' 6.6450 1.0000 .0000 .10000E+07 21 'norm ' 3.1550 1.0000 .0000 .10000E+07 22 'norm ' .13323E-08 1.0000 .0000 .10000E+07 23 'norm ' 2.3726 1.0000 .0000 .10000E+07 24 'Normalizat' 1.1038 1.0000 .10000E-01 10.000 25 'Prefactor ' .97898 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6290E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 121556.7 FROM MIGRAD STATUS=CONVERGED 113 CALLS 1674 TOTAL EDM= .50E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 2.8% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor 20.107 1.0529 -.97050E-08 .87128E-02 2 norm 1.6723 .54373 -.30626E-07 -.27050E-01 3 norm .62908 .42302 .53323E-07 .32212E-01 4 Prefactor 11.719 2.5014 -.18747E-07 -.66944E-02 5 Prefactor 2.3056 1.4454 -.61189E-08 -.13839E-04 6 Prefactor .0000 5.5477 -.18824E-06** at limit ** 7 Prefactor 9.9037 1.2088 .43505E-07 -.81287E-02 8 norm .55511E-10 3.9930 -.12847E-06** at limit ** 9 norm .45870 .58263 .55745E-07 -.65596E-02 10 norm .46648 .88007 .62724E-07 .26352E-02 11 Prefactor 2.4017 2.0060 -.21317E-08 .34545E-03 12 Prefactor .0000 2.1122 .10863E-06** at limit ** 13 Prefactor 21.153 4.5823 -.46278E-07 .69488E-02 14 Prefactor .16653E-09 2.1910 .38172E-08** at limit ** 15 norm 2.1897 1.5943 -.64732E-08 .20702E-02 16 Prefactor 9.5473 4.4774 -.14004E-06 -.32275E-02 17 Prefactor 7.7225 1.7307 .73827E-07 -.41853E-02 18 norm .31111 .15422 .36723E-08 .15910E-01 19 Prefactor .19741 2.8267 .48294E-06** at limit ** 20 Prefactor 6.6518 4.5350 -.34763E-06 .39759E-02 21 norm 3.1544 .74969 -.21321E-07 -.13471E-01 22 norm .55511E-10 .74231 -.21997E-07** at limit ** 23 norm 2.3727 .54723 -.14569E-07 .32109E-02 24 Normalizat 1.1038 .56735E-01 .69189E-06 .80917E-03 25 Prefactor .97901 .25674E-01 -.21770E-06 .10683E-02 ERR DEF= .500 Final values: Prefactor = 20.1075 norm = 1.67235 norm = 0.629082 Prefactor = 11.719 Prefactor = 2.30563 Prefactor = 0 Prefactor = 9.90371 norm = 5.55112e-11 norm = 0.4587 norm = 0.466481 Prefactor = 2.40173 Prefactor = 0 Prefactor = 21.1531 Prefactor = 1.66533e-10 norm = 2.18973 Prefactor = 9.54728 Prefactor = 7.72254 norm = 0.311108 Prefactor = 0.197408 Prefactor = 6.65177 norm = 3.15437 norm = 5.55112e-11 norm = 2.37269 Normalizat = 1.10379 Prefactor = 0.979007 ********** ** 18 **HESSE ********** FCN= 121556.7 FROM HESSE STATUS=OK 511 CALLS 2185 TOTAL EDM= .43E-04 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor 20.107 7.3777 .22316E-03 -1.5618 2 norm 1.6723 .54650 .81473E-03 -1.5682 3 norm .62908 .42771 .66654E-03 -1.5692 4 Prefactor 11.719 2.5118 .29226E-03 -1.5639 5 Prefactor 2.3056 1.4500 .67511E-03 -1.5678 6 Prefactor .0000 5.5319 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 7 Prefactor 9.9037 6.2077 .31764E-03 -1.5645 8 norm .55511E-10 .20250 .54761E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 norm .45870 .60647 .82989E-03 -1.5694 10 norm .46648 .91414 .82049E-03 -1.5694 11 Prefactor 2.4017 2.0116 .66104E-03 -1.5677 12 Prefactor .0000 .29581 .58512E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 13 Prefactor 21.153 4.6584 .21752E-03 -1.5616 14 Prefactor .16653E-09 2.1978 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm 2.1897 1.6245 .69490E-03 -1.5678 16 Prefactor 9.5473 5.3336 .32402E-03 -1.5646 17 Prefactor 7.7225 6.4632 .36052E-03 -1.5652 18 norm .31111 .18187 .21934E-02 -1.5697 19 Prefactor .19741 .66202 .12043E-01 -1.5699 WARNING - - ABOVE PARAMETER IS AT LIMIT. 20 Prefactor 6.6518 4.5979 .38904E-03 -1.5656 21 norm 3.1544 .77003 .57039E-03 -1.5672 22 norm .55511E-10 .73469 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 23 norm 2.3727 .54805 .66488E-03 -1.5677 24 Normalizat 1.1038 .53267E-01 .77679E-01 -.89630 25 Prefactor .97901 .22799E-01 .46004E-01 -.93433 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 4.27711e-05 Minuit parameter uncertainties: 1 7.37775 2 0.546498 3 0.427709 4 2.51183 5 1.44999 6 2.00115e-05 7 6.20774 8 4.81642e-06 9 0.606467 10 0.914136 11 2.0116 12 4.07012e-06 13 4.65842 14 3.81342e-05 15 1.6245 16 5.33357 17 6.46325 18 0.181872 19 0.662023 20 4.59792 21 0.770031 22 1.13352e-05 23 0.548049 24 0.0532695 25 0.0227993 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 121556.693058 Extracting fit parameters... 4FGL J0654.3+5042 Spectrum: LogParabola 250 norm: 5.551e-11 4.816e-06 0.000e+00 1.000e+06 ( 1.000e-12) 251 alpha: 2.128e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 252 beta: 8.007e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 253 Eb: 8.361e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 622 Prefactor: 9.790e-01 2.280e-02 0.000e+00 1.000e+01 ( 1.000e+00) 623 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 624 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 621 Normalization: 1.104e+00 5.327e-02 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 103.596 50.703 Photon Flux Upper Limit: 1.36e-08 ph cm-2 s-1 Energy Flux Upper Limit: 6.32e-06 MeV cm-2 s-1 Saving results to: /scratch/kocevski/972120/likelihoodResults_682819201_685411201_4FGL_J0654.3+5042_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): 0 logL (Free Index) = 121556.420589 delta logL = 0.272468677736 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 121556.393032 delta logL = 0.300025667224 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .18244 1.0000 .0000 .10000E+07 2 'alpha ' 3.5179 1.0000 .0000 5.0000 3 'Normalizat' 1.0925 1.0000 .10000E-01 10.000 4 'Prefactor ' .98121 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .6290E+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= 121556.4 FROM MIGRAD STATUS=FAILED 103 CALLS 366 TOTAL EDM= .48E-07 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .18227 12.009 .13079E-03** at limit ** 2 alpha 3.5180 2.5686 .74835E-01 .15382E-03 3 Normalizat 1.0925 .26708E-01 .34542E-03 .30595E-03 4 Prefactor .98121 .12394E-01 .16542E-03 .71803E-03 ERR DEF= .500 START SIMPLEX MINIMIZATION. CONVERGENCE WHEN EDM .LT. .20E-04 SIMPLEX MINIMIZATION HAS CONVERGED. FCN= 121556.4 FROM SIMPLEX STATUS=UNCHANGED 80 CALLS 446 TOTAL EDM= .18E-04 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .18227 12.009 .79530E-05** at limit ** 2 alpha 3.5180 2.5686 .35304E-02 .15382E-03 3 Normalizat 1.0925 .26708E-01 .43726E-04 .30595E-03 4 Prefactor .98121 .12394E-01 .11564E-04 .71803E-03 ERR DEF= .500 MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 121556.4 FROM MIGRAD STATUS=CONVERGED 35 CALLS 481 TOTAL EDM= .28E-10 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .18227 .61832 .52318E-05** at limit ** 2 alpha 3.5180 1.7242 .29934E-02 .13004E-04 3 Normalizat 1.0925 .57186E-01 .13817E-04 .30806E-03 4 Prefactor .98121 .25575E-01 .33085E-04 .71913E-03 ERR DEF= .500 Final values: norm = 0.18227 alpha = 3.51799 Normalizat = 1.09249 Prefactor = 0.981206 ********** ** 18 **HESSE ********** FCN= 121556.4 FROM HESSE STATUS=OK 23 CALLS 504 TOTAL EDM= .29E-10 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .18227 .53051 .20927E-06 -1.5699 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 3.5180 1.5297 .11974E-03 .41938 3 Normalizat 1.0925 .57209E-01 .27634E-05 -.89993 4 Prefactor .98121 .25563E-01 .66170E-05 -.93359 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 2.85283e-11 Minuit parameter uncertainties: 1 0.530507 2 1.6763 3 0.0572124 4 0.0255638 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/972120': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 121556.393032 delta logL = 0.300025883247 Extracting fit parameters... 4FGL J0654.3+5042 Spectrum: LogParabola 250 norm: 1.823e-01 5.305e-01 0.000e+00 1.000e+06 ( 1.000e-12) 251 alpha: 3.518e+00 1.676e+00 0.000e+00 5.000e+00 ( 1.000e+00) 252 beta: 8.007e-02 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 253 Eb: 8.361e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 622 Prefactor: 9.812e-01 2.556e-02 0.000e+00 1.000e+01 ( 1.000e+00) 623 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 624 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 621 Normalization: 1.092e+00 5.721e-02 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 103.596 50.703 Creating a high resolution counts map... INFO: Auto-setting vmin to -2.000e-01 [aplpy.core] INFO: Auto-setting vmax to 2.220e+00 [aplpy.core] Saving /scratch/kocevski/972120/cmap_HighResolution_682819201_685411201_4FGL_J0654.3+5042_monthly_bin172.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/972120 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='6.32e-06', job_status='DONE', photon_flux_upper_limit='1.36e-08', time_completed='2022-09-21 10:25:15.117601', job_id='972120', GAL2='0.98', fit_tolerance='1e-08', EG2='1.09', EG='1.10', time_epoch_completed='1663781115.12', return_code2='0', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.98', dlogl='3.00e-01', ts2='0.64', photon_index_error='0.00', photon_index='2.13' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; Database successfully updated. Analysis Complete. Wed Sep 21 10:25:15 PDT 2022 mt)) 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='1663772882.84' at line 1 Command execution failed. Waiting 1.81906153284 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 28.0455680268 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 6.37466989997 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 25.6101434203 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 20.3327229774 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 16.0975233791 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 23.0354989369 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 15.741413512 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 17.9593377818 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 12.9153350607 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 17.7435193292 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 19.0465710604 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 6.18280469276 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 3.71390699668 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 4.99214822264 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 19.889161141 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 11.0210341145 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 8.32340611225 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 16.4394816288 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 16.2684236635 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 23.1580933209 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 28.8394960483 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 6.87604712368 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 23.1004183384 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 14.8735654254 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 8.74990374126 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 11.0358551802 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 2.87742986933 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 12.0459522657 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 21.3712404391 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 15.8055492462 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 15.2436412698 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 24.5743261012 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 19.9468820068 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 26.2256095278 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 13.4610100347 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 5.60401343041 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' AND cadence='monthly'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1663772882.84', time_completed='2022-09-21 08:08:02.837256', job_id='922254' WHERE bin_id='172' AND source_name='4FGL J0654.3+5042' 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='1663772882.84' 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='1663772882.84' at line 1 Command execution failed. Waiting 18.8769368933 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Wed Sep 21 08:18:12 PDT 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 922254: <4FGL_J0654.3+5042_monthly_bin172> in cluster Done Job <4FGL_J0654.3+5042_monthly_bin172> was submitted from host by user in cluster at Wed Sep 21 05:20:26 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 06:05:32 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 06:05:32 2022 Terminated at Wed Sep 21 08:18:13 2022 Results reported at Wed Sep 21 08:18:13 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0654.3+5042_monthly_bin172 103.596 50.7027 682819201 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0654.3+5042 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 7124.00 sec. Max Memory : 1265 MB Average Memory : 482.13 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 7962 sec. Turnaround time : 10667 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 972120: <4FGL_J0654.3+5042_monthly_bin172> in cluster Done Job <4FGL_J0654.3+5042_monthly_bin172> was submitted from host by user in cluster at Wed Sep 21 08:10:39 2022 Job was executed on host(s) , in queue , as user in cluster at Wed Sep 21 08:10:40 2022 was used as the home directory. was used as the working directory. Started at Wed Sep 21 08:10:40 2022 Terminated at Wed Sep 21 10:25:17 2022 Results reported at Wed Sep 21 10:25:17 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0654.3+5042_monthly_bin172 103.596 50.7027 682819201 685411201 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0654.3+5042 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 7846.00 sec. Max Memory : 1265 MB Average Memory : 477.95 MB Total Requested Memory : - Delta Memory : - Max Swap : 3 MB Max Processes : 5 Max Threads : 21 Run time : 8076 sec. Turnaround time : 8078 sec. The output (if any) is above this job summary.