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

From Tom Lane
Subject Re: Backends stuck in LISTEN
Date
Msg-id 6588.1389196547@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backends stuck in LISTEN  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Backends stuck in LISTEN
List pgsql-bugs
Marko Tiikkaja <marko@joh.to> writes:
>> In the meanwhile I'll be happy to provide more information if someone
>> has any ideas.

Oh, after further thought: this trace says the process was trying to look
up the status of XID 1124964531 (see the TransactionIdGetStatus and
TransactionLogFetch calls).  Do all the backtraces show this same XID?

If I did the math right, this corresponds to pg_clog file 010C.  Do you
have such a file?  Does it look to have the right size and permissions?
What file names are present in pg_clog?

It'd also be interesting to see the current XID counter according to
pg_controldata, especially if you have some idea how far it's advanced
since the problem happened.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backends stuck in LISTEN
Next
From: Marko Tiikkaja
Date:
Subject: Re: Backends stuck in LISTEN