Skip site navigation (1) Skip section navigation (2)

Re: BUG #5443: Undetected deadlock situation

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Claudio <claudio(at)livra(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5443: Undetected deadlock situation
Date: 2010-04-30 13:16:52
Message-ID: 1272633412.24187.10.camel@fsopti579.F-Secure.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On fre, 2010-04-30 at 03:51 +0000, Claudio wrote:
> The following bug has been logged online:
> 
> Bug reference:      5443
> Logged by:          Claudio
> Email address:      claudio(at)livra(dot)com
> PostgreSQL version: 8.3.7
> Operating system:   CentOS
> Description:        Undetected deadlock situation
> Details: 
> 
> During a massive update of a table A, a single-row update of table A in
> another session created an undetected deadlock situation, as evidenced by
> the following locks (taken from pg_locks):
> 
>    locktype    | database | relation | page  | tuple | virtualxid |
> transactionid | classid | objid | objsubid | virtualtransaction |  pid  |   
>    mode       | granted 
>  transactionid |          |          |       |       |            |     
> 39773877 |         |       |          | 63/15761           | 11157 |
> ShareLock        | f       
>  transactionid |          |          |       |       |            |     
> 39773877 |         |       |          | 4/10902            |  6421 |
> ExclusiveLock    | t       
> 

This is not a deadlock.  It's just two locks on the same table, one is
granted, and the other one is waiting.  There needs to be more
information to make sense of this (and maybe a bit more readable
formatting).



In response to

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2010-04-30 13:47:50
Subject: Re: BUG #5443: Undetected deadlock situation
Previous:From: Peter EisentrautDate: 2010-04-30 13:14:21
Subject: Re: [9.0beta5/cvs head] build failure due to unchecked results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group