Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-31890

Attempt to re-register the LATISS instrument with butler register-instrument fails for /repo/main

    XMLWordPrintable

    Details

    • Team:
      Data Facility
    • Urgent?:
      No

      Description

      Newer versions of the LSST Stack introduced new filters for LATISS instrument. As a result, ingest attempts for Auxtel images to the /repo/main at NCSA fail due to the Butler not recognizing them. For example:

      psycopg2.errors.ForeignKeyViolation: insert or update on table "exposure" violates foreign key constraint "fkey_exposure_physical_filter_instrument_name_instrume_ee4bb371"
      		 
      DETAIL:  Key (instrument, physical_filter)=(LATISS, FELH0600~empty) is not present in table "physical_filter".

      According to the discussion in this thread, the new version of the instrument (introducing the new filters) can be re-registered with butler register-instrument. However, my attempt to do that failed with the following error:

      lsst.daf.butler.registry.interfaces._database.DatabaseConflictError: Conflict in sync for table instrument on column(s) visit_max: 3050123199999 != 6050123199999, exposure_max: 3050123199999 != 6050123199999.

      The full traceback can be found here.

        Attachments

          Issue Links

          is blocked by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-31903 Add update kwargs/option to instrument registration

          • Done
          is triggered by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-30142 Support P and Q for simulated images

          • Done

            Activity

            Ascending order - Click to sort in descending order
            mkowalik Mikolaj Kowalik created issue -
            mkowalik Mikolaj Kowalik made changes -
            Field Original Value New Value
            Summary Attempt to re-register the LATISS instrumet with butler register-instrument fails for /repo/main Attempt to re-register the LATISS instrument with butler register-instrument fails for /repo/main
            tjenness Tim Jenness made changes -
            Component/s daf_butler [ 11300 ]
            Component/s obs_lsst [ 16504 ]
            tjenness Tim Jenness made changes -
            Labels gen3-middleware
            tjenness Tim Jenness made changes -
            Link This issue is triggered by DM-16297 [ DM-16297 ]
            tjenness Tim Jenness made changes -
            Watchers Mikolaj Kowalik, Tim Jenness [ Mikolaj Kowalik, Tim Jenness ] Jim Bosch, Mikolaj Kowalik, Tim Jenness [ Jim Bosch, Mikolaj Kowalik, Tim Jenness ]
            jbosch Jim Bosch made changes -
            Link This issue is blocked by DM-31903 [ DM-31903 ]
            tjenness Tim Jenness made changes -
            Link This issue is triggered by DM-16297 [ DM-16297 ]
            tjenness Tim Jenness made changes -
            Link This issue is triggered by DM-30142 [ DM-30142 ]
            tjenness Tim Jenness made changes -
            Team Data Facility [ 12219 ]

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              mkowalik Mikolaj Kowalik
              Watchers:
              Jim Bosch, Mikolaj Kowalik, Tim Jenness
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.