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

creates a lock on the whole AD_Sequence table - and then when trying to get a next id sequence is locked.

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Priority

Created November 11, 2018 at 1:10 AM
Updated January 1, 2019 at 1:17 PM
Resolved November 11, 2018 at 1:23 AM