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.albe@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
