-
Type: Task
-
Status: Done (View Workflow)
-
Priority: Normal
-
Resolution: Done
-
Component/s: spt_operational_database
During chyan's test, there happened the following error:
2023-07-07T08:53:17.944 mcs f text="command failed: IntegrityError('(psycopg2.errors.ForeignKeyViolation) insert or update on table \"cobra_match\" violates foreign key constraint \"cobra_match_pfs_visit_id_fkey\"\nDETAIL: Key (pfs_visit_id, iteration, cobra_id)=(96418, 0, 1) is not present in table \"cobra_move\".\n') in execute_values() at /software/conda/envs/rubin3_ics/lib/python3.8/site-packages/psycopg2/extras.py:1270"
This is because the insertion sequence is `cobra_target` --> `cobra_match` --> `cobra_move`. Please change the order of foreign key constraints of `cobra_move` and `cobra_match`.
- relates to
-
INSTRM-1687 Separating some columns from cobra_target table into cobra_move
- Done