We're updating the issue view to help you get more done.Â
Deadlock in 2Pack after creating a foreign key constraint with AD_Sequence
Description
The LCO Magnetic Media is creating a foreign key with ad_sequence table - this creates a lock (probably changes in the latest postgresql database) because the statement
1
ALTER TABLE LCO_DIAN_Format ADD CONSTRAINT adsequence_lcodianformat FOREIGN KEY (AD_Sequence_ID) REFERENCES ad_sequence(ad_sequence_id) DEFERRABLE INITIALLY DEFERREDcreates a lock on the whole AD_Sequence table - and then when trying to get a next id sequence is locked.
Environment
None
Status
Assignee
Carlos Ruiz
Reporter
Carlos Ruiz
Labels
None
Tested By
None
Priority
Major