Re: Backends stuck in LISTEN - Mailing list pgsql-bugs

From Marko Tiikkaja
Subject Re: Backends stuck in LISTEN
Date
Msg-id 52CD6733.60307@joh.to
Whole thread Raw
In response to Re: Backends stuck in LISTEN  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Backends stuck in LISTEN
List pgsql-bugs
On 1/8/14 3:50 PM, Alvaro Herrera wrote:
> Yeah, this makes a lot more sense.  What this is saying is that it's
> waiting for the I/O-lock on the pg_clog page to be released.  In other
> words there is some other process holding that lock, which is supposed
> to be reading the page, but for some reason it's failing to do that
> timely.  I guess you would need to get backtraces from all processes to
> see which one differs (i.e. which one has the lock and is trying to do
> something but not doing it).

I got only two, and they both looked like this, unfortunately.  I'll try
to find the offender should this happen again.

In the meanwhile I'll be happy to provide more information if someone
has any ideas.


Regards,
Marko Tiikkaja

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #8686: Standby could not restart.
Next
From: Tom Lane
Date:
Subject: Re: Backends stuck in LISTEN