Menu

#48 There is one fatal error occurs when recovery from master by Streaming Replication.The error log is below:

9.2rc
open
nobody
1
None
nobody
2015-01-24
2015-01-24
xxc
No

[postgres@postgresql_s1 ~]$ <,,2015-01-24 10:28:03 CST>LOG: 00000: database system was interrupted while in recovery at log time 2015-01-23 16:07:50 CST
<,,2015-01-24 10:28:03 CST>HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
<,,2015-01-24 10:28:03 CST>LOCATION: StartupXLOG, xlog.c:6347
<,,2015-01-24 10:28:03 CST>LOG: 00000: restored log file "00000002.history" from archive
<,,2015-01-24 10:28:03 CST>LOCATION: RestoreArchivedFile, xlog.c:3277
<,,2015-01-24 10:28:03 CST>LOG: 00000: entering standby mode
<,,2015-01-24 10:28:03 CST>LOCATION: StartupXLOG, xlog.c:6417
<,,2015-01-24 10:28:03 CST>LOG: 00000: restored log file "00000002000000000000000E" from archive
<,,2015-01-24 10:28:03 CST>LOCATION: RestoreArchivedFile, xlog.c:3277
<,,2015-01-24 10:28:03 CST>LOG: 00000: redo starts at 0/E43D9B8
<,,2015-01-24 10:28:03 CST>LOCATION: StartupXLOG, xlog.c:6881
<,,2015-01-24 10:28:03 CST>LOG: 00000: consistent recovery state reached at 0/E43E070
<,,2015-01-24 10:28:03 CST>LOCATION: CheckRecoveryConsistency, xlog.c:7420
<,,2015-01-24 10:28:03 CST>LOG: 00000: database system is ready to accept read only connections
<,,2015-01-24 10:28:03 CST>LOCATION: sigusr1_handler, postmaster.c:4533
<,,2015-01-24 10:28:03 CST>LOG: 00000: restored log file "00000002000000000000000F" from archive
<,,2015-01-24 10:28:03 CST>LOCATION: RestoreArchivedFile, xlog.c:3277
<,,2015-01-24 10:28:03 CST>FATAL: XX000: too many KnownAssignedXids
<,,2015-01-24 10:28:03 CST>CONTEXT: xlog redo insert: rel 24584/24587/24589; tid 707/30
<,,2015-01-24 10:28:03 CST>LOCATION: KnownAssignedXidsAdd, procarray.c:3543
<,,2015-01-24 10:28:03 CST>LOG: 00000: startup process (PID 95824) exited with exit code 1
<,,2015-01-24 10:28:03 CST>LOCATION: LogChildExit, postmaster.c:3133
<,,2015-01-24 10:28:03 CST>LOG: 00000: terminating any other active server processes
<,,2015-01-24 10:28:03 CST>LOCATION: HandleChildCrash, postmaster.c:2912

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.