| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: streaming replication question |
| Date: | 2010-10-05 09:08:00 |
| Message-ID: | 1286269680.2025.962.camel@ebony |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Sat, 2010-10-02 at 12:02 -0400, Rajesh Kumar Mallah wrote:
> FATAL: too many KnownAssignedXids
That's a bug.
I've a few guesses about that, but I'll put some better instrumentation
in to see if we can prove what's causing it.
Can you reproduce that again, or was that failure isolated to that
particular point in the WAL stream? You can try turning HS off, then
turning it back on again later.
If you suspect a bug in Hot Standby, please set
trace_recovery_messages = DEBUG2
in postgresql.conf and repeat the action
Always useful to know
* max_connections
* current number of sessions
* whether we have two phase commits happening
Thanks
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Uckun | 2010-10-05 09:20:41 | Trying to figure out why these queries are so slow |
| Previous Message | Fujii Masao | 2010-10-05 08:38:47 | Re: streaming replication question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2010-10-05 09:32:03 | Re: leaky views, yet again |
| Previous Message | Itagaki Takahiro | 2010-10-05 09:01:45 | Re: leaky views, yet again |