Horton

Re: Hot Standby: too many KnownAssignedXids

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Joachim Wieland <joe@mcknight.de>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2010-11-23T07:45:25Z
Lists: 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