Uploaded image for project: 'DRP 2-D Pipeline'
  1. DRP 2-D Pipeline
  2. PIPE2D-1083

Postgresql ingest is broken

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done (View Workflow)
    • Priority: Normal
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                price price
                Reporter:
                price price
                Reviewers:
                hassan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: