Re: Hot Standby: too many KnownAssignedXids - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Hot Standby: too many KnownAssignedXids
Date
Msg-id 4CEB7115.3030409@enterprisedb.com
Whole thread Raw
In response to Hot Standby: too many KnownAssignedXids  (Joachim Wieland <joe@mcknight.de>)
Responses Re: Hot Standby: too many KnownAssignedXids
List pgsql-hackers
On 19.11.2010 23:46, Joachim Wieland wrote:
> FATAL:  too many KnownAssignedXids. head: 0, tail: 0, nxids: 9978,
> pArray->maxKnownAssignedXids: 6890

Hmm, that's a lot of entries in KnownAssignedXids.

Can you recompile with WAL_DEBUG, and run the recovery again with 
wal_debug=on ? That will print all the replayed WAL records, which is a 
lot of data, but it might give a hint what's going on.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Kris Jurka
Date:
Subject: Re: [JDBC] Support for JDBC setQueryTimeout, et al.
Next
From: 高增琦
Date:
Subject: Re: visibility map