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 145 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 = 7444 number of fields = 31 RA_SUN column already exists. File will not be modified. Done. Performing analysis on: 4FGL_J0945.7+5759_daily_bin1738 RA = 146.432, Dec = 57.9871 tmin = 689817601, tmax = 690076801 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='416843', job_status='RUN', time_executed='2022-11-14 01:08:24.065715', time_epoch_executed='1668416904.07' WHERE source_name='4FGL J0945.7+5759' and cadence='daily' and bin_id='1738' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/416843 Creating custom pfile directory: /scratch/kocevski/416843/pfiles/ Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Reprocess/P305 Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT1 --filter 'nMetStart>564945418 && nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Checksum keywords updated successfully. Merged file saved to: /scratch/kocevski/416843/ft1_4FGL_J0945.7+5759_daily_bin1738.fits Retrieving the FT1 file... Issuing command: /afs/slac.stanford.edu/g/glast/ground/bin/datacat find --group FT2 --filter 'nMetStop>=689817601.0 && nMetStart<690076801.0' /Data/Flight/Level1/LPA Retrieving 46 files... Done. Merging files... Merged file saved to: /scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/416843/ft1_4FGL_J0945.7+5759_daily_bin1738.fits outfile=/scratch/kocevski/416843/ft1_filteredMKT_4FGL_J0945.7+5759_daily_bin1738.fits ra=146.432 dec=57.9871 rad=12.0 tmin=689817601.0 tmax=690076801.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 4.10 user 3.84 sys 0.24 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.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/416843/ft1_filteredMKT_4FGL_J0945.7+5759_daily_bin1738.fits evtable="EVENTS" outfile="/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.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.51 user 0.34 sys 0.16 Number of photons that the gtmktime cut: 550 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits" evtable="EVENTS" scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits sctable="SC_DATA" outfile=/scratch/kocevski/416843/ltcube_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.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/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits .....................! real 15.29 user 14.91 sys 0.34 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits sctable="SC_DATA" expcube=/scratch/kocevski/416843/ltcube_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits outfile=/scratch/kocevski/416843/expmap_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.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/416843/ltcube_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits .....................! real 192.56 user 186.24 sys 5.56 Generating the xml model: radLim = 0.001 maxRad = 12 normsOnly = True freeVariableSources = True Fixing all sources to their catalog values, except variable sources Creating file and adding sources from 4FGL Added 239 point sources and 0 extended sources Setting source of interest to: 4FGL J0945.7+5759 @ 146.432 57.9871 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits outfile=/scratch/kocevski/416843/cmap_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.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=146.432 yref=57.9871 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.56 user 0.38 sys 0.16 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits outfile=/scratch/kocevski/416843/cmap_HighResolution_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.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=146.432 yref=57.9871 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.59 user 0.40 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/416843/Model_4FGL_J0945.7+5759_daily_bin1738.xml irfs="P8R3_SOURCE_V2" evclsmin=0 evclass="INDEF" evtype="INDEF" convert=yes chatter=2 clobber=yes debug=no gui=no mode="ql" WARNING: version mismatch between CFITSIO header (v3.43) and linked library (v3.41). adding source EG_v02 adding source GAL_V02 Working on... /scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits.....................! real 62.29 user 60.87 sys 1.26 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits', '/scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits', expMap='/scratch/kocevski/416843/expmap_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits', expCube='/scratch/kocevski/416843/ltcube_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/416843/Model_4FGL_J0945.7+5759_daily_bin1738.xml', optimizer='MINUIT') Using source of interest name: '4FGL J0945.7+5759' 4FGL J0945.7+5759 Spectrum: LogParabola 394 norm: 1.030e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-13) 395 alpha: 1.875e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 396 beta: 2.282e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 397 Eb: 1.978e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/416843/ft1_filtered_4FGL_J0945.7+5759_daily_bin1738.fits Spacecraft file(s): /scratch/kocevski/416843/ft2_4FGL_J0945.7+5759_daily_bin1738.fits Exposure map: /scratch/kocevski/416843/expmap_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits Exposure cube: /scratch/kocevski/416843/ltcube_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/416843/Model_4FGL_J0945.7+5759_daily_bin1738.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 102 logL (Fixed Index) = 5959.73087147 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 102 logL (Fixed Index) = 5956.81163085 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .32474E-07 1.0000 .0000 .10000E+07 2 'Prefactor ' .48226E-04 1.0000 .0000 .10000E+07 3 'Prefactor ' 4.4692 1.0000 .0000 .10000E+07 4 'Prefactor ' .51645E-04 1.0000 .0000 .10000E+07 5 'norm ' .25734E-04 1.0000 .0000 .10000E+07 6 'Prefactor ' 8.3549 1.0000 .0000 .10000E+07 7 'Prefactor ' 5.7453 1.0000 .0000 .10000E+07 8 'norm ' 1.2045 1.0000 .0000 .10000E+07 9 'Prefactor ' 3.3155 1.0000 .0000 .10000E+07 10 'Prefactor ' .43794E-03 1.0000 .0000 .10000E+07 11 'Prefactor ' 3.7216 1.0000 .0000 .10000E+07 12 'Prefactor ' 1.8655 1.0000 .0000 .10000E+07 13 'Prefactor ' 7.0303 1.0000 .0000 .10000E+07 14 'Prefactor ' .20670E-03 1.0000 .0000 .10000E+07 15 'norm ' .68867E-03 1.0000 .0000 .10000E+07 16 'Prefactor ' 54.953 1.0000 .0000 .10000E+07 17 'norm ' .32258 1.0000 .0000 .10000E+07 18 'norm ' 10.212 1.0000 .0000 .10000E+07 19 'Prefactor ' .46257E-06 1.0000 .0000 .10000E+07 20 'norm ' 1.7585 1.0000 .0000 .10000E+07 21 'norm ' 9.4412 1.0000 .0000 .10000E+07 22 'Prefactor ' 20.295 1.0000 .0000 .10000E+07 23 'norm ' 28.002 1.0000 .0000 .10000E+07 24 'Prefactor ' .14544E-01 1.0000 .0000 .10000E+07 25 'norm ' .34805E-04 1.0000 .0000 .10000E+07 26 'norm ' .24989 1.0000 .0000 .10000E+07 27 'Prefactor ' 6.9258 1.0000 .0000 .10000E+07 28 'Prefactor ' 7.1311 1.0000 .0000 .10000E+07 29 'norm ' 7.4159 1.0000 .0000 .10000E+07 30 'Prefactor ' .33198E-02 1.0000 .0000 .10000E+07 31 'Normalizat' .59596 1.0000 .10000E-01 10.000 32 'Prefactor ' 1.2553 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7650E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 5956.794 FROM MIGRAD STATUS=CONVERGED 304 CALLS 1938 TOTAL EDM= .29E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.5% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .0000 3.5642 .13392E-06** at limit ** 2 Prefactor .96034E-08 15.107 .60280E-06** at limit ** 3 Prefactor 4.4365 7.1383 -.26332E-06 -.17079E-02 4 Prefactor .0000 11.185 -.75975E-06** at limit ** 5 norm .0000 2.9980 -.30872E-07** at limit ** 6 Prefactor 8.2924 10.125 -.63972E-06 -.25885E-02 7 Prefactor 6.0332 4.9454 -.36498E-06 .13205E-01 8 norm 1.2059 .95292 -.10543E-06 -.97364E-03 9 Prefactor 3.2428 5.5757 -.25761E-06 -.50563E-03 10 Prefactor .33307E-09 12.402 -.32980E-06** at limit ** 11 Prefactor 3.7241 2.9549 -.30995E-06 -.37747E-02 12 Prefactor 2.5085 41.434 .18659E-05 -.12099E-03 13 Prefactor 7.1474 11.938 .13908E-06 .52655E-03 14 Prefactor .14988E-08 30.214 .71450E-05** at limit ** 15 norm .55511E-10 6.7665 -.60682E-06** at limit ** 16 Prefactor 54.339 44.303 -.16641E-07 -.91704E-03 17 norm .31779 .46560 -.20075E-06 -.13368E-02 18 norm 10.201 8.9622 -.46112E-06 .15106E-02 19 Prefactor .0000 1.7488 .48524E-06** at limit ** 20 norm 1.7627 .81966 -.19660E-07 .79416E-02 21 norm 9.4492 3.7370 -.69007E-07 -.79429E-04 22 Prefactor 22.941 43.553 -.34963E-06 -.10171E-02 23 norm 28.464 23.716 -.13399E-05 -.29569E-03 24 Prefactor .27756E-09 14.032 .70088E-06** at limit ** 25 norm .0000 10.852 -.37759E-06** at limit ** 26 norm .24643 1.5401 .14220E-06** at limit ** 27 Prefactor .10003E-06 2961.9 -.24777E-04** at limit ** 28 Prefactor 32.472 199.41 .23886E-05 .24716E-03 29 norm 7.1987 3.4953 -.50612E-08 .16059E-02 30 Prefactor .33307E-09 16.986 .85052E-06** at limit ** 31 Normalizat .58976 .19715 .85962E-05 .16462E-03 32 Prefactor 1.2582 .18660 .16437E-05 .19215E-03 ERR DEF= .500 Final values: Prefactor = 0 Prefactor = 9.60343e-09 Prefactor = 4.43649 Prefactor = 0 norm = 0 Prefactor = 8.29237 Prefactor = 6.03317 norm = 1.20589 Prefactor = 3.24281 Prefactor = 3.33067e-10 Prefactor = 3.72409 Prefactor = 2.50848 Prefactor = 7.14738 Prefactor = 1.4988e-09 norm = 5.55112e-11 Prefactor = 54.3386 norm = 0.317789 norm = 10.2011 Prefactor = 0 norm = 1.76267 norm = 9.44924 Prefactor = 22.9409 norm = 28.4643 Prefactor = 2.77556e-10 norm = 0 norm = 0.246427 Prefactor = 1.00031e-07 Prefactor = 32.4716 norm = 7.19875 Prefactor = 3.33067e-10 Normalizat = 0.589761 Prefactor = 1.25822 ********** ** 18 **HESSE ********** FCN= 5956.794 FROM HESSE STATUS=OK 739 CALLS 2677 TOTAL EDM= .16E-06 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .0000 3.5622 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor .96034E-08 15.272 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Prefactor 4.4365 7.1517 .47606E-03 -1.5666 4 Prefactor .0000 11.165 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 norm .0000 2.9973 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 6 Prefactor 8.2924 10.140 .34659E-03 -1.5650 7 Prefactor 6.0332 20.317 .41880E-03 -1.5659 8 norm 1.2059 .97296 .10325E-02 -1.5686 9 Prefactor 3.2428 5.6172 .55570E-03 -1.5672 10 Prefactor .33307E-09 12.406 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 Prefactor 3.7241 2.9745 .52320E-03 -1.5669 12 Prefactor 2.5085 43.356 .76246E-03 -1.5676 13 Prefactor 7.1474 12.147 .37811E-03 -1.5654 14 Prefactor .14988E-08 29.569 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 15 norm .55511E-10 6.7628 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 Prefactor 54.339 44.502 .13491E-03 -1.5561 17 norm .31779 .52235 .14283E-02 -1.5697 18 norm 10.201 8.9560 .31331E-03 -1.5644 19 Prefactor .0000 1.7505 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 20 norm 1.7627 .82836 .78996E-03 -1.5681 21 norm 9.4492 3.7380 .32591E-03 -1.5646 22 Prefactor 22.941 43.957 .22205E-03 -1.5612 23 norm 28.464 23.775 .18901E-03 -1.5601 24 Prefactor .27756E-09 14.146 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 25 norm .0000 1.4151 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 26 norm .24643 1.5646 .10948E-02 -1.5698 WARNING - - ABOVE PARAMETER IS AT LIMIT. 27 Prefactor .10003E-06 2956.0 .38099E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 28 Prefactor 32.472 201.31 .37540E-03 -1.5594 29 norm 7.1987 3.4997 .36806E-03 -1.5654 30 Prefactor .33307E-09 17.020 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 31 Normalizat .58976 .17762 .67507E-01 -1.0842 32 Prefactor 1.2582 .16471 .50148E-01 -.84558 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.59619e-07 Minuit parameter uncertainties: 1 7.63946e-06 2 0.00076587 3 7.15167 4 9.6366e-06 5 1.29504e-05 6 10.1402 7 20.3169 8 0.972961 9 5.61723 10 0.000133195 11 2.97447 12 20.8575 13 12.1469 14 0.000420335 15 4.24012e-05 16 44.5021 17 0.522353 18 8.95603 19 7.44647e-06 20 0.828361 21 3.73803 22 43.9578 23 23.7752 24 0.000125345 25 1.15637e-05 26 1.24189 27 0.0344046 28 161.708 29 3.49972 30 0.000145002 31 0.177797 32 0.164778 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 5956.79380467 Extracting fit parameters... 4FGL J0945.7+5759 Spectrum: LogParabola 394 norm: 5.551e-11 4.240e-05 0.000e+00 1.000e+06 ( 1.000e-13) 395 alpha: 1.875e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 396 beta: 2.282e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 397 Eb: 1.978e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 762 Prefactor: 1.258e+00 1.648e-01 0.000e+00 1.000e+01 ( 1.000e+00) 763 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 764 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 761 Normalization: 5.898e-01 1.778e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 146.432 57.987 Photon Flux Upper Limit: 3.10e-08 ph cm-2 s-1 Energy Flux Upper Limit: 3.45e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/416843/likelihoodResults_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.txt Performing a free index iterative likelihood fit... Freezing all point sources, except source of interest... Done. Freeing candidate source... Done. Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 5956.793883 delta logL = -7.8326403127e-05 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 5956.79380469 delta logL = -2.18115019379e-08 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .24147E-07 1.0000 .0000 .10000E+07 2 'alpha ' .23663 1.0000 .0000 5.0000 3 'Normalizat' .58976 1.0000 .10000E-01 10.000 4 'Prefactor ' 1.2582 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7650E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 5956.794 FROM MIGRAD STATUS=CONVERGED 30 CALLS 243 TOTAL EDM= .15E-08 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.7% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .28866E-08 6.7241 -.11660E-04** at limit ** 2 alpha 2.0291 3.5048 .36371E-03 .72626E-10 3 Normalizat .58975 .16659 -.50501E-04 -.25656E-03 4 Prefactor 1.2582 .17632 .56101E-04 .60875E-03 ERR DEF= .500 Final values: norm = 2.88658e-09 alpha = 2.02909 Normalizat = 0.589753 Prefactor = 1.25823 ********** ** 18 **HESSE ********** FCN= 5956.794 FROM HESSE STATUS=NOT POSDEF 37 CALLS 280 TOTAL EDM= .49E-10 STRATEGY= 1 ERR MATRIX NOT POS-DEF EXT PARAMETER APPROXIMATE INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .28866E-08 .86709 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 2.0291 3.3204 .50000 -.18950 3 Normalizat .58975 .14850E-02 .67507E-01 -1.0842 4 Prefactor 1.2582 .15646E-02 .50148E-01 -.84558 ERR DEF= .500 Minuit fit quality: 2 estimated distance: 4.86202e-11 Minuit parameter uncertainties: 1 0.000100159 2 16520.4 3 0.00148501 4 0.0015646 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/416843': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 102 logL (Free Index) = 5956.79380467 delta logL = -1.40698830364e-09 Extracting fit parameters... 4FGL J0945.7+5759 Spectrum: LogParabola 394 norm: 2.887e-09 1.002e-04 0.000e+00 1.000e+06 ( 1.000e-13) 395 alpha: 2.029e+00 1.652e+04 0.000e+00 5.000e+00 ( 1.000e+00) 396 beta: 2.282e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 397 Eb: 1.978e+03 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 762 Prefactor: 1.258e+00 1.565e-03 0.000e+00 1.000e+01 ( 1.000e+00) 763 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 764 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 761 Normalization: 5.898e-01 1.485e-03 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 146.432 57.987 Creating a high resolution counts map... INFO: Auto-setting vmin to 0.000e+00 [aplpy.core] INFO: Auto-setting vmax to 0.000e+00 [aplpy.core] Saving /scratch/kocevski/416843/cmap_HighResolution_689817601_690076801_4FGL_J0945.7+5759_daily_bin1738.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/416843 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='3.45e-05', job_status='DONE', photon_flux_upper_limit='3.10e-08', time_completed='2022-11-14 01:21:58.034813', job_id='416843', GAL2='1.26', fit_tolerance='1e-08', EG2='0.59', EG='0.59', time_epoch_completed='1668417718.03', return_code2='102', ts='-0.00', comment='SUCCESS', return_code='0', GAL='1.26', dlogl='-1.41e-09', ts2='-0.00', photon_index_error='0.00', photon_index='1.87' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; Database successfully updated. Analysis Complete. Mon Nov 14 01:21:58 PST 2022 b/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='1668416508.38' at line 1 Command execution failed. Waiting 26.415371917 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 23.9917478433 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 24.8722468848 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 21.7619787202 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 17.9061112466 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 10.4580030971 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 21.4068165789 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 19.5950526137 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 2.12657167271 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 5.68231434706 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 12.1884847239 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 25.0630064757 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 19.4107068703 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 7.59056270981 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 26.3377756957 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 28.833548859 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 24.4947620654 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 8.45129220195 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 6.78547420282 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 21.1856384965 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 3.74827885279 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 3.84599981458 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 12.7350657237 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 9.82817145854 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 23.7546745481 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 23.9606508062 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 11.3665105605 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 25.6475646132 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 18.9754317281 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 13.9230925091 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 27.865193757 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 0.494226990149 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 21.8886661037 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 22.0487145948 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38', time_completed='2022-11-14 01:01:48.377934', job_id='410410' WHERE bin_id='1738' AND source_name='4FGL J0945.7+5759' AND cadence='daily'; 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416508.38' 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='1668416508.38' at line 1 Command execution failed. Waiting 17.4352813748 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Mon Nov 14 01:11:58 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 410410: <4FGL_J0945.7+5759_daily_bin1738> in cluster Done Job <4FGL_J0945.7+5759_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 00:45:16 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 00:45:51 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 00:45:51 2022 Terminated at Mon Nov 14 01:11:59 2022 Results reported at Mon Nov 14 01:11:59 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0945.7+5759_daily_bin1738 146.432 57.9871 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0945.7+5759 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 787.00 sec. Max Memory : 618 MB Average Memory : 271.64 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1568 sec. Turnaround time : 1603 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 416843: <4FGL_J0945.7+5759_daily_bin1738> in cluster Done Job <4FGL_J0945.7+5759_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 01:05:13 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 01:05:49 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 01:05:49 2022 Terminated at Mon Nov 14 01:21:58 2022 Results reported at Mon Nov 14 01:21:58 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J0945.7+5759_daily_bin1738 146.432 57.9871 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J0945.7+5759 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 815.31 sec. Max Memory : 1258 MB Average Memory : 301.91 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 969 sec. Turnaround time : 1005 sec. The output (if any) is above this job summary.