-
Type: Bug
-
Status: Done (View Workflow)
-
Priority: Normal
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Following PIPE2D-1058, postgresql ingest failed at Hilo:
$ ingestPfsImagesPgsql.py /work/drp --ignore-ingested --pfsConfigDir /work/drp/pfsDesign --mode=copy --doraise /data/raw/2022-09-22/sps/PFSA0794131* [...] lsst.CameraMapper INFO: Loading exposure registry from /work/drp/registry.pgsql lsst.CameraMapper INFO: Loading calib registry from /work/drp/CALIB/calibRegistry.sqlite3 lsst.ingestPfs INFO: /data/raw/2022-09-22/sps/PFSA07941311.fits --<copy>--> /work/drp/2022-09-22/PFSA079413b1.fits lsst.ingestPfs WARN: Failed to ingest file /data/raw/2022-09-22/sps/PFSA07941311.fits: Failed to register file /data/raw/2022-09-22/sps/PFSA07941311.fits Traceback (most recent call last): File "/work/stack_INFRA-312/stack/miniconda3-py38_4.9.2-3.0.0/Linux64/obs_pfs/commissioning-2022919/python/lsst/obs/pfs/ingest.py", line 675, in runFile self.register.addRow(registry, info, dryrun=args.dryrun, create=args.create) File "/work/stack_INFRA-312/stack/miniconda3-py38_4.9.2-3.0.0/Linux64/pipe_tasks/gb1d6de0934+6a8639994f/python/lsst/pipe/tasks/ingest.py", line 388, in addRow conn.cursor().execute(sql, values) psycopg2.errors.SyntaxError: syntax error at or near "OR" LINE 1: INSERT OR IGNORE INTO raw_visit VALUES (79413,'IQ_TEST','202...
There have been changes in pipe_tasks that I wasn't aware of, and I must have screwed up the testing of PIPE2D-1058.
- relates to
-
PIPE2D-1058 Avoid/fix registry sqlite deadlocks
- Done