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