Re: BUG #5443: Undetected deadlock situation

Peter Eisentraut <peter_e@gmx.net> wrote:

> This is not a deadlock.

Agreed.

> It's just two locks on the same table

Not as I read it.

> (and maybe a bit more readable formatting).

Eliminating null columns and mangling column headers for length, I
get this:

>>   locktype    |  tranid  | virtualx |  pid  |      mode     | gr
>> transactionid | 39773877 | 63/15761 | 11157 | ShareLock     | f
>> transactionid | 39773877 | 4/10902  |  6421 | ExclusiveLock | t

So it looks like two locks on the same transaction ID by different
transactions.  How does that happen?

-Kevin