Open larnoldgithub opened 11 months ago
After post-processing I got 2 errors like this one: As it's a timeout from mysql, I just re-launched the command and it worked.
01:07:42.335- |PROC| 01:07:42.346-@!|PROC|W[40-503-00019]: Error found for ID='113890' 01:07:42.378-@!|PROC| apero_postprocess_spirou.py 20AQ08-May12 2488154o_pp.fits --crunfile=run_CCF_POLAR_POSTALL_only.ini --program=POSTALL[113890] --recipe_kind=post-all --shortname=POSTALL --parallel=True 01:07:42.389- |PROC| 01:07:42.400- |PROC| 06:07:01.677-**|DatabaseError|E[00-002-00032] <class 'mysql.connector.errors.DatabaseError'>: 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Command: INSERT INTO log_offline_db VALUES("apero_postprocess_spirou", "POSTALL", "out", "recipe", "post-all", "POSTALL[113890]", "PID-00016949305908435618-4YMQ", "2023-09-17 06:03:10.844", "1694930590.844", "APEROG-PID-00016945696122097780-86IY_apero_processing_group", 0, 0, NULL, "/data/spirou4/apero-data/offline/tmp", "/data/spirou4/apero-data/offline/out", "20AQ08-May12", "/data/spirou4/apero-data/offline/msg/processing/APEROG-PID-00016945696122097780-86IY_apero_processing_group/20AQ08-May12/APEROL-PID-00016949305908435618-4YMQ_apero_postprocess_spirou.log", "Not Set", "apero_postprocess_spirou.py 20AQ08-May12 2488154o_pp.fits --skip=False --clear=False --no_in_qc=False --program=POSTALL[113890] --recipe_kind=post-all --parallel=True --shortname=POSTALL --crunfile=run_CCF_POLAR_POSTALL_only.ini --nosave=False ", "obs_dir=20AQ08-May12 || files[1]=/data/spirou4/apero-data/offline/tmp/20AQ08-May12/2488154o_pp.fits [DRS_PP]", "--skip=False || --clear=False || --no_in_qc=False", "--xhelp=None || --debug=None || --listing=None || --listingall=None || --version=None || --info=None || --program=POSTALL[113890] || --recipe_kind=post-all || --parallel=True || --shortname=POSTALL || --idebug=None || --ref=None || --crunfile=run_CCF_POLAR_POSTALL_only.ini || --quiet=None || --nosave=False || --force_indir=None || --force_outdir=None", "2023-09-17 06:03:10.844", NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 3, "IN_PARALLEL|RUNNING|ENDED|FORCE_REFWAVE|USER_FIBERS", 1, "15.59246826171875", "-1", "98.2339096069336", "0.0", "-1", "0.0", "51.1", "-1", 28, NULL, NULL) path: /h/spdrs/.apero/apero_at_localhost Function: apero.base.drs_db.py.Database.execute() 01:07:42.603- |PROC| 01:07:42.614- |PROC| 01:07:42.624- |PROC| ***
After post-processing I got 2 errors like this one: As it's a timeout from mysql, I just re-launched the command and it worked.
01:07:42.335- |PROC| 01:07:42.346-@!|PROC|W[40-503-00019]: Error found for ID='113890' 01:07:42.378-@!|PROC| apero_postprocess_spirou.py 20AQ08-May12 2488154o_pp.fits --crunfile=run_CCF_POLAR_POSTALL_only.ini --program=POSTALL[113890] --recipe_kind=post-all --shortname=POSTALL --parallel=True 01:07:42.389- |PROC| 01:07:42.400- |PROC| 06:07:01.677-**|DatabaseError|E[00-002-00032] <class 'mysql.connector.errors.DatabaseError'>: 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Command: INSERT INTO log_offline_db VALUES("apero_postprocess_spirou", "POSTALL", "out", "recipe", "post-all", "POSTALL[113890]", "PID-00016949305908435618-4YMQ", "2023-09-17 06:03:10.844", "1694930590.844", "APEROG-PID-00016945696122097780-86IY_apero_processing_group", 0, 0, NULL, "/data/spirou4/apero-data/offline/tmp", "/data/spirou4/apero-data/offline/out", "20AQ08-May12", "/data/spirou4/apero-data/offline/msg/processing/APEROG-PID-00016945696122097780-86IY_apero_processing_group/20AQ08-May12/APEROL-PID-00016949305908435618-4YMQ_apero_postprocess_spirou.log", "Not Set", "apero_postprocess_spirou.py 20AQ08-May12 2488154o_pp.fits --skip=False --clear=False --no_in_qc=False --program=POSTALL[113890] --recipe_kind=post-all --parallel=True --shortname=POSTALL --crunfile=run_CCF_POLAR_POSTALL_only.ini --nosave=False ", "obs_dir=20AQ08-May12 || files[1]=/data/spirou4/apero-data/offline/tmp/20AQ08-May12/2488154o_pp.fits [DRS_PP]", "--skip=False || --clear=False || --no_in_qc=False", "--xhelp=None || --debug=None || --listing=None || --listingall=None || --version=None || --info=None || --program=POSTALL[113890] || --recipe_kind=post-all || --parallel=True || --shortname=POSTALL || --idebug=None || --ref=None || --crunfile=run_CCF_POLAR_POSTALL_only.ini || --quiet=None || --nosave=False || --force_indir=None || --force_outdir=None", "2023-09-17 06:03:10.844", NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 0, 3, "IN_PARALLEL|RUNNING|ENDED|FORCE_REFWAVE|USER_FIBERS", 1, "15.59246826171875", "-1", "98.2339096069336", "0.0", "-1", "0.0", "51.1", "-1", 28, NULL, NULL) path: /h/spdrs/.apero/apero_at_localhost Function: apero.base.drs_db.py.Database.execute() 01:07:42.603- |PROC| 01:07:42.614- |PROC| 01:07:42.624- |PROC| ***