Postgres Pro
Downloads
Home   >   mailing lists

Re: finding the other statement causing a sharelock - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: finding the other statement causing a sharelock
Date
Msg-id 20101108221842.339c0b39@dawn.webthatworks.it
Whole thread Raw
In response to Re: finding the other statement causing a sharelock  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: finding the other statement causing a sharelock  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
On Mon, 08 Nov 2010 15:45:12 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> > I get
> > DETAIL:  Process 24749 waits for ShareLock on transaction
> > 113443492; blocked by process 25199. Process 25199 waits for
> > ShareLock on transaction 113442820; blocked by process 24749.
>
> > I would like to know both statements that caused the sharelock
> > problem.

> Recent versions of PG record both (or all) statements involved in a
> deadlock in the postmaster log.

What about not so recent 8.3.9?
thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Removing pgsql_tmp files
Next
From: Scott Marlowe
Date:
Subject: Re: finding the other statement causing a sharelock