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 9 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_J1220.1+7105_daily_bin1738 RA = 185.044, Dec = 71.092 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='418121', job_status='RUN', time_executed='2022-11-14 01:10:45.890198', time_epoch_executed='1668417045.89' WHERE source_name='4FGL J1220.1+7105' and cadence='daily' and bin_id='1738' Database successfully updated. Done. Creating custom output directory: /scratch/kocevski/418121 Creating custom pfile directory: /scratch/kocevski/418121/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/418121/ft1_4FGL_J1220.1+7105_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/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits Selecting the photons: time -p gtselect infile=/scratch/kocevski/418121/ft1_4FGL_J1220.1+7105_daily_bin1738.fits outfile=/scratch/kocevski/418121/ft1_filteredMKT_4FGL_J1220.1+7105_daily_bin1738.fits ra=185.044 dec=71.092 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.13 user 3.88 sys 0.23 Adding sun position to ft2 file: /nfs/farm/g/glast/g/LCRepository/Repository/bin/sunpos /scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits Selecting the good time intervals: time -p gtmktime scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_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/418121/ft1_filteredMKT_4FGL_J1220.1+7105_daily_bin1738.fits evtable="EVENTS" outfile="/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_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.58 user 0.35 sys 0.17 Number of photons that the gtmktime cut: 675 Generating the livetime cube: time -p gtltcube evfile="/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits" evtable="EVENTS" scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits sctable="SC_DATA" outfile=/scratch/kocevski/418121/ltcube_689817601_690076801_4FGL_J1220.1+7105_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/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits .....................! real 15.41 user 14.88 sys 0.33 Generating the exposure map: time -p gtexpmap evfile=/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits sctable="SC_DATA" expcube=/scratch/kocevski/418121/ltcube_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits outfile=/scratch/kocevski/418121/expmap_689817601_690076801_4FGL_J1220.1+7105_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/418121/ltcube_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits .....................! real 194.43 user 187.29 sys 4.88 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 235 point sources and 0 extended sources Setting source of interest to: 4FGL J1220.1+7105 @ 185.044 71.092 Creating the counts map: time -p gtbin evfile=/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits outfile=/scratch/kocevski/418121/cmap_689817601_690076801_4FGL_J1220.1+7105_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=185.044 yref=71.092 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.57 user 0.41 sys 0.15 Creating the high resolution counts map: time -p gtbin evfile=/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits outfile=/scratch/kocevski/418121/cmap_HighResolution_689817601_690076801_4FGL_J1220.1+7105_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=185.044 yref=71.092 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.39 sys 0.16 Computing the diffuse response: time -p gtdiffrsp evfile=/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits evtable="EVENTS" scfile=/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits sctable="SC_DATA" srcmdl=/scratch/kocevski/418121/Model_4FGL_J1220.1+7105_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/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits.....................! real 80.94 user 78.75 sys 1.24 Creating the likelihood object... obs = UnbinnedObs('/scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits', '/scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits', expMap='/scratch/kocevski/418121/expmap_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits', expCube='/scratch/kocevski/418121/ltcube_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits', irfs='P8R3_SOURCE_V2') like = UnbinnedAnalysis(obs, '/scratch/kocevski/418121/Model_4FGL_J1220.1+7105_daily_bin1738.xml', optimizer='MINUIT') Using source of interest name: '4FGL J1220.1+7105' 4FGL J1220.1+7105 Spectrum: LogParabola 401 norm: 6.062e+00 0.000e+00 0.000e+00 1.000e+06 ( 1.000e-12) 402 alpha: 2.189e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 403 beta: 1.310e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 404 Eb: 7.210e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed Likelihood Fit Parameters: Event file(s): /scratch/kocevski/418121/ft1_filtered_4FGL_J1220.1+7105_daily_bin1738.fits Spacecraft file(s): /scratch/kocevski/418121/ft2_4FGL_J1220.1+7105_daily_bin1738.fits Exposure map: /scratch/kocevski/418121/expmap_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits Exposure cube: /scratch/kocevski/418121/ltcube_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.fits IRFs: P8R3_SOURCE_V2 Source model file: /scratch/kocevski/418121/Model_4FGL_J1220.1+7105_daily_bin1738.xml Optimizer: MINUIT Statistic: UNBINNED Performing an iterative likelihood fit... Fit tolerance = 1 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 7183.88984893 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 7183.82216956 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'Prefactor ' .27984E-03 1.0000 .0000 .10000E+07 2 'Prefactor ' 53.348 1.0000 .0000 .10000E+07 3 'norm ' .15377E-06 1.0000 .0000 .10000E+07 4 'Prefactor ' .36099 1.0000 .0000 .10000E+07 5 'Prefactor ' 5.1677 1.0000 .0000 .10000E+07 6 'norm ' 3.3112 1.0000 .0000 .10000E+07 7 'norm ' .10144E-04 1.0000 .0000 .10000E+07 8 'Prefactor ' .53629E-03 1.0000 .0000 .10000E+07 9 'Prefactor ' .78954E-03 1.0000 .0000 .10000E+07 10 'Prefactor ' .66502E-06 1.0000 .0000 .10000E+07 11 'norm ' .47240E-03 1.0000 .0000 .10000E+07 12 'Prefactor ' 6.7016 1.0000 .0000 .10000E+07 13 'norm ' .68778E-07 1.0000 .0000 .10000E+07 14 'Prefactor ' 34.283 1.0000 .0000 .10000E+07 15 'Prefactor ' .11165E-02 1.0000 .0000 .10000E+07 16 'Prefactor ' 24.040 1.0000 .0000 .10000E+07 17 'Prefactor ' 3.0602 1.0000 .0000 .10000E+07 18 'norm ' .72293E-05 1.0000 .0000 .10000E+07 19 'norm ' .61910 1.0000 .0000 .10000E+07 20 'Prefactor ' .12207E-02 1.0000 .0000 .10000E+07 21 'Prefactor ' .34044E-02 1.0000 .0000 .10000E+07 22 'Prefactor ' .23239E-02 1.0000 .0000 .10000E+07 23 'Prefactor ' 2.9072 1.0000 .0000 .10000E+07 24 'Prefactor ' .45178E-03 1.0000 .0000 .10000E+07 25 'Prefactor ' .23623E-02 1.0000 .0000 .10000E+07 26 'Prefactor ' .14074E-02 1.0000 .0000 .10000E+07 27 'Prefactor ' 30.835 1.0000 .0000 .10000E+07 28 'Prefactor ' .21257E-02 1.0000 .0000 .10000E+07 29 'Normalizat' 1.1256 1.0000 .10000E-01 10.000 30 'Prefactor ' .70422 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7540E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. FCN= 7183.819 FROM MIGRAD STATUS=CONVERGED 197 CALLS 2812 TOTAL EDM= .87E-09 STRATEGY=1 ERROR MATRIX UNCERTAINTY= 1.5% EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 Prefactor .28433E-06 7.1527 -.10416E-06** at limit ** 2 Prefactor 54.163 6.8756 -.22162E-07 -.30869E-01 3 norm .36476E-06 3.1680 -.81751E-07** at limit ** 4 Prefactor .38569E-06 20.181 -.88523E-07** at limit ** 5 Prefactor 5.1508 4.7673 -.84363E-08 -.70534E-03 6 norm 3.3099 .91189 .48588E-09 -.23375E-02 7 norm .33307E-09 1.9578 -.91008E-07** at limit ** 8 Prefactor .48018E-05 9.3534 -.19157E-06** at limit ** 9 Prefactor .55511E-10 8.2727 .26711E-07** at limit ** 10 Prefactor .0000 1.1459 .14956E-07** at limit ** 11 norm .43854E-08 4.9497 -.12196E-06** at limit ** 12 Prefactor 6.5986 10.200 .12623E-07 .67754E-03 13 norm .27756E-09 2.7039 .32727E-07** at limit ** 14 Prefactor 34.258 11.521 .11227E-06 .19629E-01 15 Prefactor .21292E-04 38.948 -.37197E-06** at limit ** 16 Prefactor 23.460 46.668 -.14311E-06 .60349E-01 17 Prefactor 3.0549 4.4417 .57508E-08 -.37710E-02 18 norm .11102E-09 2.0714 .19764E-07** at limit ** 19 norm .62415 3.5307 .10847E-07 .19940E-03 20 Prefactor .20961E-04 36.955 -.11676E-06** at limit ** 21 Prefactor .93703E-07 12.603 -.48157E-07** at limit ** 22 Prefactor .40523E-07 11.995 -.11999E-06** at limit ** 23 Prefactor 2.9383 2.2246 -.16129E-07 .74414E-03 24 Prefactor .28905E-06 2.5533 -.10114E-06** at limit ** 25 Prefactor .15710E-07 6.8645 -.27053E-07** at limit ** 26 Prefactor .57171E-06 30.832 .22141E-06** at limit ** 27 Prefactor 30.195 3.9990 .10410E-07 .24272E-01 28 Prefactor .56632E-06 14.452 -.12954E-06** at limit ** 29 Normalizat 1.1258 .16164 -.77747E-06 -.61246E-04 30 Prefactor .70434 .16122 .56548E-06 -.19749E-04 ERR DEF= .500 Final values: Prefactor = 2.84328e-07 Prefactor = 54.1626 norm = 3.64764e-07 Prefactor = 3.85691e-07 Prefactor = 5.15076 norm = 3.30986 norm = 3.33067e-10 Prefactor = 4.80177e-06 Prefactor = 5.55112e-11 Prefactor = 0 norm = 4.38538e-09 Prefactor = 6.59859 norm = 2.77556e-10 Prefactor = 34.258 Prefactor = 2.12915e-05 Prefactor = 23.4602 Prefactor = 3.05492 norm = 1.11022e-10 norm = 0.624151 Prefactor = 2.09614e-05 Prefactor = 9.37028e-08 Prefactor = 4.05231e-08 Prefactor = 2.93834 Prefactor = 2.89047e-07 Prefactor = 1.57097e-08 Prefactor = 5.71709e-07 Prefactor = 30.1947 Prefactor = 5.66325e-07 Normalizat = 1.12578 Prefactor = 0.704338 ********** ** 18 **HESSE ********** FCN= 7183.819 FROM HESSE STATUS=OK 650 CALLS 3462 TOTAL EDM= .46E-05 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 Prefactor .28433E-06 9.2340 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 Prefactor 54.163 28.746 .13692E-03 -1.5561 3 norm .36476E-06 3.4282 .42118E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 4 Prefactor .38569E-06 101.99 .94153E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 5 Prefactor 5.1508 4.7665 .44199E-03 -1.5663 6 norm 3.3099 .90496 .55608E-03 -1.5672 7 norm .33307E-09 1.9371 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 8 Prefactor .48018E-05 8.3336 .63073E-02 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 9 Prefactor .55511E-10 8.3733 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 10 Prefactor .0000 1.1430 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 11 norm .43854E-08 4.9984 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 12 Prefactor 6.5986 11.087 .38737E-03 -1.5657 13 norm .27756E-09 2.7064 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 14 Prefactor 34.258 11.655 .17081E-03 -1.5591 15 Prefactor .21292E-04 65.277 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 16 Prefactor 23.460 58.589 .20400E-03 -1.5611 17 Prefactor 3.0549 39.733 .57966E-03 -1.5673 18 norm .11102E-09 2.0692 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 19 norm .62415 3.8453 .67534E-03 -1.5692 20 Prefactor .20961E-04 54.723 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 21 Prefactor .93703E-07 15.826 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 22 Prefactor .40523E-07 12.414 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 23 Prefactor 2.9383 30.956 .59566E-03 -1.5674 24 Prefactor .28905E-06 11.312 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 25 Prefactor .15710E-07 7.0418 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 26 Prefactor .57171E-06 33.096 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 27 Prefactor 30.195 29.236 .18011E-03 -1.5598 28 Prefactor .56632E-06 18.057 .42118E-03 -1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 29 Normalizat 1.1258 .14880 .37042E-01 -.88928 30 Prefactor .70434 .14524 .42457E-01 -1.0336 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 4.55678e-06 Minuit parameter uncertainties: 1 0.00324076 2 28.7465 3 0.00223643 4 0.012544 5 4.76652 6 0.904957 7 5.13622e-05 8 0.0126517 9 3.64678e-05 10 3.12428e-08 11 0.000296689 12 11.0868 13 5.53871e-05 14 11.6554 15 0.0745623 16 58.5907 17 22.0349 18 3.31332e-05 19 3.09841 20 0.0677376 21 0.00243577 22 0.00141838 23 19.0748 24 0.00361641 25 0.000664779 26 0.00869974 27 29.2363 28 0.00639569 29 0.14886 30 0.145315 Done. MINUIT Return Code (Fixed Index): 0 logL (Fixed Index) = 7183.81902545 Extracting fit parameters... 4FGL J1220.1+7105 Spectrum: LogParabola 401 norm: 1.110e-10 3.313e-05 0.000e+00 1.000e+06 ( 1.000e-12) 402 alpha: 2.189e+00 0.000e+00 0.000e+00 5.000e+00 ( 1.000e+00) fixed 403 beta: 1.310e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 404 Eb: 7.210e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 751 Prefactor: 7.043e-01 1.453e-01 0.000e+00 1.000e+01 ( 1.000e+00) 752 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 753 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 750 Normalization: 1.126e+00 1.489e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Fixed Index): -0.00 Ra Dec: 185.044 71.092 Photon Flux Upper Limit: 4.07e-08 ph cm-2 s-1 Energy Flux Upper Limit: 1.65e-05 MeV cm-2 s-1 Saving results to: /scratch/kocevski/418121/likelihoodResults_689817601_690076801_4FGL_J1220.1+7105_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) = 7183.72920518 delta logL = 0.0898202754543 Fit tolerance = 0.0001 Performing likelihood fit... Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 7183.68188381 delta logL = 0.137141638528 Fit tolerance = 1e-08 Performing likelihood fit... ********** ** 14 **SET NOWARN ********** PARAMETER DEFINITIONS: NO. NAME VALUE STEP SIZE LIMITS 1 'norm ' .55843E-01 1.0000 .0000 .10000E+07 2 'alpha ' 5.0000 1.0000 .0000 5.0000 3 'Normalizat' 1.1011 1.0000 .10000E-01 10.000 4 'Prefactor ' .71884 1.0000 .0000 10.000 ********** ** 15 **SET ERR .5000 ********** ********** ** 16 **SET GRAD 1.000 ********** ********** ** 17 **MINIMIZE .7540E+05 .2000E-04 ********** MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. MIGRAD MINIMIZATION HAS CONVERGED. MIGRAD WILL VERIFY CONVERGENCE AND ERROR MATRIX. FCN= 7183.682 FROM MIGRAD STATUS=CONVERGED 104 CALLS 346 TOTAL EDM= .11E-07 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER STEP FIRST NO. NAME VALUE ERROR SIZE DERIVATIVE 1 norm .55733E-01 .12405 .35944E-04** at limit ** 2 alpha 5.0000 4.1835 .50000 ** at limit ** 3 Normalizat 1.1009 .16666 .21664E-03 .56203E-04 4 Prefactor .71916 .16011 .25878E-03 .82592E-05 ERR DEF= .500 Final values: norm = 0.0557329 alpha = 5 Normalizat = 1.10086 Prefactor = 0.719155 ********** ** 18 **HESSE ********** FCN= 7183.682 FROM HESSE STATUS=OK 31 CALLS 377 TOTAL EDM= .16E-10 STRATEGY= 1 ERROR MATRIX ACCURATE EXT PARAMETER INTERNAL INTERNAL NO. NAME VALUE ERROR STEP SIZE VALUE 1 norm .55733E-01 .11942 .71888E-05 -1.5703 WARNING - - ABOVE PARAMETER IS AT LIMIT. 2 alpha 5.0000 4.1032 .50000 1.5708 WARNING - - ABOVE PARAMETER IS AT LIMIT. 3 Normalizat 1.1009 .16697 .86656E-05 -.89724 4 Prefactor .71916 .16031 .10351E-04 -1.0278 ERR DEF= .500 Minuit fit quality: 3 estimated distance: 1.6075e-11 Minuit parameter uncertainties: 1 0.119424 2 2.76309e-05 3 0.167046 4 0.160412 shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory rmdir: failed to remove `/scratch/kocevski/418121': No such file or directory shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory Done. MINUIT Return Code (Free Index): 0 logL (Free Index) = 7183.68188003 delta logL = 0.137145421738 Extracting fit parameters... 4FGL J1220.1+7105 Spectrum: LogParabola 401 norm: 5.573e-02 1.194e-01 0.000e+00 1.000e+06 ( 1.000e-12) 402 alpha: 5.000e+00 2.763e-05 0.000e+00 5.000e+00 ( 1.000e+00) 403 beta: 1.310e-01 0.000e+00 -5.000e+00 1.000e+01 ( 1.000e+00) fixed 404 Eb: 7.210e+02 0.000e+00 3.000e+01 5.000e+05 ( 1.000e+00) fixed GAL_V02 Spectrum: PowerLaw 751 Prefactor: 7.192e-01 1.604e-01 0.000e+00 1.000e+01 ( 1.000e+00) 752 Index: 0.000e+00 0.000e+00 -1.000e+00 1.000e+00 ( 1.000e+00) fixed 753 Scale: 1.000e+02 0.000e+00 5.000e+01 2.000e+02 ( 1.000e+00) fixed EG_v02 Spectrum: FileFunction 750 Normalization: 1.101e+00 1.670e-01 1.000e-02 1.000e+01 ( 1.000e+00) TS (Free Index): -0.00 Ra Dec: 185.044 71.092 Creating a high resolution counts map... INFO: Auto-setting vmin to -1.000e-01 [aplpy.core] INFO: Auto-setting vmax to 1.110e+00 [aplpy.core] Saving /scratch/kocevski/418121/cmap_HighResolution_689817601_690076801_4FGL_J1220.1+7105_daily_bin1738.png Cleaning up... ** Nuclear option initiated! ** rmdir /scratch/kocevski/418121 Updating database... UPDATE lightcurve_data_v2 SET energy_flux_upper_limit='1.65e-05', job_status='DONE', photon_flux_upper_limit='4.07e-08', time_completed='2022-11-14 01:27:40.734076', job_id='418121', GAL2='0.72', fit_tolerance='1e-08', EG2='1.10', EG='1.13', time_epoch_completed='1668418060.73', return_code2='0', ts='-0.00', comment='SUCCESS', return_code='0', GAL='0.70', dlogl='1.37e-01', ts2='0.30', photon_index_error='0.00', photon_index='2.19' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; Database successfully updated. Analysis Complete. Mon Nov 14 01:27:40 PST 2022 syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2'' at line 1 Command execution failed. Waiting 12.3721775768 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 10.0728843146 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 9.55808224179 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 3.41802883498 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 8.48579744075 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 29.9362275587 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 24.339900852 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 12.1299271141 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 3.62768697049 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 2.24010041583 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 23.7486579399 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 13.3330784842 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 14.2088250924 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 25.168126021 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 20.1886046915 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 22.3713382518 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 4.03623456129 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 26.8760055054 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 27.6897562497 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 17.683373812 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 13.9609700476 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 29.0618573157 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 12.8951111759 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 3.9364792411 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 16.3962247123 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 24.7920684622 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 7.61001566582 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 22.334024839 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 10.3570494666 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 0.592163806714 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 29.9688076606 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 0.521450776342 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 15.845248967 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 0.382482270041 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 17.1924761398 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 23.3483500785 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 20.0218682863 seconds and trying again... UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' AND cadence='daily'; UPDATE lightcurve_data_v2 SET job_status='FAIL', comment='local variable 'ts_freeIndex' referenced before assignment', time_epoch_completed='1668416837.2', time_completed='2022-11-14 01:07:17.196773', job_id='411901' WHERE bin_id='1738' AND source_name='4FGL J1220.1+7105' 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='1668416837.2'' 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='1668416837.2'' at line 1 Command execution failed. Waiting 26.1095096472 seconds and trying again... Maximum wait time exceeded. Proceeding. Analysis Complete. Mon Nov 14 01:17:30 PST 2022 ------------------------------------------------------------ Sender: LSF System Subject: Job 411901: <4FGL_J1220.1+7105_daily_bin1738> in cluster Done Job <4FGL_J1220.1+7105_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 00:50:11 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 00:50:15 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 00:50:15 2022 Terminated at Mon Nov 14 01:17:31 2022 Results reported at Mon Nov 14 01:17:31 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1220.1+7105_daily_bin1738 185.044 71.092 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1220.1+7105 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 966.00 sec. Max Memory : 1257 MB Average Memory : 320.76 MB Total Requested Memory : - Delta Memory : - Max Swap : - Max Processes : 5 Max Threads : 21 Run time : 1635 sec. Turnaround time : 1640 sec. The output (if any) is above this job summary. ------------------------------------------------------------ Sender: LSF System Subject: Job 418121: <4FGL_J1220.1+7105_daily_bin1738> in cluster Done Job <4FGL_J1220.1+7105_daily_bin1738> was submitted from host by user in cluster at Mon Nov 14 01:10:12 2022 Job was executed on host(s) , in queue , as user in cluster at Mon Nov 14 01:10:27 2022 was used as the home directory. was used as the working directory. Started at Mon Nov 14 01:10:27 2022 Terminated at Mon Nov 14 01:27:41 2022 Results reported at Mon Nov 14 01:27:41 2022 Your job looked like: ------------------------------------------------------------ # LSBATCH: User input /nfs/farm/g/glast/g/LCRepository/Likelihood/Scripts/LikelihoodAnalysis.py 4FGL_J1220.1+7105_daily_bin1738 185.044 71.092 689817601 690076801 irfs=P8R3_SOURCE_V2 zmax=90 ROI=12 association=4FGL_J1220.1+7105 fixedModel=True performFreeIndexFit=True freeVariableSources=True nuke=True repositoryJob=True verbose=False ------------------------------------------------------------ Successfully completed. Resource usage summary: CPU time : 1003.50 sec. Max Memory : 641 MB Average Memory : 335.17 MB Total Requested Memory : - Delta Memory : - Max Swap : 2930 MB Max Processes : 6 Max Threads : 21 Run time : 1034 sec. Turnaround time : 1049 sec. The output (if any) is above this job summary.