| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Marko Tiikkaja <marko(at)joh(dot)to> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Backends stuck in LISTEN |
| Date: | 2014-01-08 15:55:47 |
| Message-ID: | 6588.1389196547@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Marko Tiikkaja <marko(at)joh(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Tiikkaja | 2014-01-08 16:24:55 | Re: Backends stuck in LISTEN |
| Previous Message | Tom Lane | 2014-01-08 15:38:49 | Re: Backends stuck in LISTEN |