is there a possibility that there is no index on the FKY column bravo.alpha_id.
On Wed, Mar 16, 2016 at 11:09 AM, Albe Laurenz <laurenz.a...@wien.gv.at> wrote: > Thomas Kellerer wrote: > >> Can you determine what statements were executed in these transactions > before the deadlock? > >> It was probably one of these that took the conflicting lock. > > > > Unfortunately not. Statement logging is not enabled on that server > (space-constrained). > > > > And while we know the statements that can possibly be executed by these > parts of the application, > > several on them depend on the actual data, so it's hard to tell which > path the two transactions > > actually used. > > But that's where the solution to your problem must be... > > Look at all statements that modify "alpha" and could be in the same > transaction > with the INSERT to "bravo". > > Yours, > Laurenz Albe > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
