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 DEFERRED

creates 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