Uploaded image for project: 'Instrument control development'
  1. Instrument control development
  2. INSTRM-1952

insert pfs_config_sps failed

    XMLWordPrintable

    Details

      Description

      Just happened last night.

      2023-04-26 14:41:31.144Z cmds             20 CommandLink.py:121 > 2 176 i sequence=24057,None,darks,"cplTest_afterDF","","iic dark exptime=60 cam=n1",failed,"OpdbInsertFailed(pfs_config_sps) with insert 
      or update on table 'pfs_config_sps' violates foreign key constraint 'pfs_config_sps_visit0_fkey'
      DETAIL:  Key (visit0)=(92009) is not present in table 'pfs_config'.)"
      2023-04-26 14:41:31.153Z cmds             20 CommandLink.py:121 > 2 176 f text="OpdbInsertFailed(pfs_config_sps) with insert or update on table 'pfs_config_sps' violates foreign key constraint 'pfs_confi
      g_sps_visit0_fkey'
      DETAIL:  Key (visit0)=(92009) is not present in table 'pfs_config'.)"
      

      visit0 were pointing to fpsVisit but in this context the convergence was on going, so the fps.pfsConfig wasn't created yet.

      Always point visit0 to the current PfsConfig0.

        Attachments

          Activity

            People

            • Assignee:
              arnaud.lefur arnaud.lefur
              Reporter:
              arnaud.lefur arnaud.lefur
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: