Hot Standby: too many KnownAssignedXids

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Hot Standby: too many KnownAssignedXids
Date: 2010-11-19 21:46:04
Message-ID: AANLkTi=Z0DS9zDk=8ooOYUOwMCcXm5FwpkHffMX6fFcN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am seeing the following here on 9.0.1 on Linux x86-64:

LOG: redo starts at 1F8/FC00E978
FATAL: too many KnownAssignedXids
CONTEXT: xlog redo insert: rel 1663/16384/18373; tid 3829898/23

and this is the complete history:

postgres was running as HS in foreground, Ctrl-C'ed it for a restart.

LOG: received fast shutdown request
LOG: aborting any active transactions
FATAL: terminating walreceiver process due to administrator command
FATAL: terminating connection due to administrator command
LOG: shutting down
LOG: database system is shut down

Started it up again:

$ postgres -D /db/
LOG: database system was shut down in recovery at 2010-11-19 14:36:30 EST
LOG: entering standby mode
cp: cannot stat `/archive/00000001000001F900000001': No such file or directory
cp: cannot stat `/archive/00000001000001F8000000FC': No such file or directory
LOG: redo starts at 1F8/FC00E978
FATAL: too many KnownAssignedXids
CONTEXT: xlog redo insert: rel 1663/16384/18373; tid 3829898/23
LOG: startup process (PID 30052) exited with exit code 1
LOG: terminating any other active server processes

(copied the log files over...)

./postgres -D /db/

LOG: database system was interrupted while in recovery at log time
2010-11-19 14:36:12 EST
HINT: If this has occurred more than once some data might be
corrupted and you might need to choose an earlier recovery target.
LOG: entering standby mode
LOG: restored log file "00000001000001F900000001" from archive
LOG: restored log file "00000001000001F8000000FC" from archive
LOG: redo starts at 1F8/FC00E978
FATAL: too many KnownAssignedXids
CONTEXT: xlog redo insert: rel 1663/16384/18373; tid 3829898/23
LOG: startup process (PID 31581) exited with exit code 1
LOG: terminating any other active server processes

Changing the line in the source code to give some more output gives me:

FATAL: too many KnownAssignedXids. head: 0, tail: 0, nxids: 9978,
pArray->maxKnownAssignedXids: 6890

I still have the server, if you want me to debug anything or send a
patch against 9.0.1 that gives more output, just let me know.

Joachim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2010-11-19 21:56:23 Re: directory archive format for pg_dump
Previous Message Greg Smith 2010-11-19 21:28:05 Re: Changes to Linux OOM killer in 2.6.36