Hi,
I found that archive recovery and SR promote command is failed by contrecord is
requested by 0/4000020" in ReadRecord().
I investigate about "contrecord", it means that record crosses page boundary.
I think it is not irregular page, and should be try to read next page in this
case.
But in archive recovery mode, PG misjudged archive recovery is end. And PITR
ends on the way...
In standby mode, PG cannot finish standby loops ...
What do you think ?
My investigation about this point in source code (PG9.2.4) is here.
xlog_internal.h
> 105 /* When record crosses page boundary, set this flag in new page's header
> */
> 106 #define XLP_FIRST_IS_CONTRECORD 0x0001
xlog.c @ ReadRecord()
> 4045 if ((((XLogPageHeader) readBuf)->xlp_info &
> XLP_FIRST_IS_CONTRECORD) &&
> 4046 targetRecOff == pageHeaderSize)
> 4047 {
> 4048 ereport(emode_for_corrupt_record(emode, *RecPtr),
> 4049 (errmsg("contrecord is requested by
> %X/%X",
> 4050 RecPtr->xlogid,
> RecPtr->xrecoff)));
> 4051 goto next_record_is_invalid;
xlog.c @ XLogInsert()
I think that "> 1116 Insert->currpage->xlp_info |=
XLP_FIRST_IS_CONTRECORD;" is normal path, not irregular.
> 1085 * Append the data, including backup blocks if any
> 1086 */
> 1087 while (write_len)
> 1088 {
> 1089 while (rdata->data == NULL)
> 1090 rdata = rdata->next;
> 1091
> 1092 if (freespace > 0)
> 1093 {
> 1094 if (rdata->len > freespace)
> 1095 {
> 1096 memcpy(Insert->currpos, rdata->data,
> freespace);
> 1097 rdata->data += freespace;
> 1098 rdata->len -= freespace;
> 1099 write_len -= freespace;
> 1100 }
> 1101 else
> 1102 {
> 1103 memcpy(Insert->currpos, rdata->data,
> rdata->len);
> 1104 freespace -= rdata->len;
> 1105 write_len -= rdata->len;
> 1106 Insert->currpos += rdata->len;
> 1107 rdata = rdata->next;
> 1108 continue;
> 1109 }
> 1110 }
> 1111
> 1112 /* Use next buffer */
> 1113 updrqst = AdvanceXLInsertBuffer(false);
> 1114 curridx = Insert->curridx;
> 1115 /* Insert cont-record header */
> 1116 Insert->currpage->xlp_info |= XLP_FIRST_IS_CONTRECORD;
> 1117 contrecord = (XLogContRecord *) Insert->currpos;
> 1118 contrecord->xl_rem_len = write_len;
> 1119 Insert->currpos += SizeOfXLogContRecord;
> 1120 freespace = INSERT_FREESPACE(Insert);
> 1121 }
Best regards,
--
NTT Open Sorce Software Center
Mitsumasa KONDO
[mitsu-ko@localhost postgresql-9.2.3]$
[Master] 2013-04-30 23:23:38 EDT LOG: 00000: database system was shut down in
recovery at 2013-04-30 22:38:11 EDT
[Master] 2013-04-30 23:23:38 EDT LOCATION: StartupXLOG, xlog.c:6207
000000010000000000000002 archive_status
[Master] 2013-04-30 23:23:41 EDT LOG: 00000: restored log file
"00000002.history" from archive
[Master] 2013-04-30 23:23:41 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 archive_status
[Master] 2013-04-30 23:23:44 EDT LOG: 00000: restored log file
"00000003.history" from archive
[Master] 2013-04-30 23:23:44 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 archive_status
[Master] 2013-04-30 23:23:47 EDT LOG: 00000: restored log file
"00000004.history" from archive
[Master] 2013-04-30 23:23:47 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 archive_status
[Master] 2013-04-30 23:23:50 EDT LOG: 00000: restored log file
"00000005.history" from archive
[Master] 2013-04-30 23:23:50 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 archive_status
cp: cannot stat `../arc/00000006.history': File is missing
000000010000000000000002 archive_status
[Master] 2013-04-30 23:23:56 EDT LOG: 00000: restored log file
"00000005.history" from archive
[Master] 2013-04-30 23:23:56 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
[Master] 2013-04-30 23:23:56 EDT LOG: 00000: starting archive recovery
[Master] 2013-04-30 23:23:56 EDT LOCATION: StartupXLOG, xlog.c:6308
000000010000000000000002 00000005.history archive_status
cp: cannot stat `../arc/000000050000000000000002': File is missing
000000010000000000000002 00000005.history archive_status
cp: cannot stat `../arc/000000040000000000000002': File is missing
000000010000000000000002 00000005.history archive_status
cp: cannot stat `../arc/000000030000000000000002': File is missing
000000010000000000000002 00000005.history archive_status
[Master] 2013-04-30 23:24:08 EDT LOG: 00000: restored log file
"000000020000000000000002" from archive
[Master] 2013-04-30 23:24:08 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
[Master] 2013-04-30 23:24:08 EDT LOG: 00000: redo starts at 0/2000020
[Master] 2013-04-30 23:24:08 EDT LOCATION: StartupXLOG, xlog.c:6715
[Master] 2013-04-30 23:24:08 EDT LOG: 00000: consistent recovery state reached
at 0/3000000
[Master] 2013-04-30 23:24:08 EDT LOCATION: CheckRecoveryConsistency,
xlog.c:7252
[Master] 2013-04-30 23:24:08 EDT LOG: 00000: database system is ready to
accept read only connections
[Master] 2013-04-30 23:24:08 EDT LOCATION: sigusr1_handler, postmaster.c:4272
000000010000000000000002 000000020000000000000002 00000005.history
archive_status
cp: cannot stat `../arc/000000050000000000000003': File is missing
000000010000000000000002 000000020000000000000002 00000005.history
archive_status
cp: cannot stat `../arc/000000040000000000000003': File is missing
000000010000000000000002 000000020000000000000002 00000005.history
archive_status
cp: cannot stat `../arc/000000030000000000000003': File is missing
000000010000000000000002 000000020000000000000002 00000005.history
archive_status
[Master] 2013-04-30 23:24:21 EDT LOG: 00000: restored log file
"000000020000000000000003" from archive
[Master] 2013-04-30 23:24:21 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 000000020000000000000002 000000020000000000000003
00000005.history archive_status
cp: cannot stat `../arc/000000050000000000000004': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
00000005.history archive_status
cp: cannot stat `../arc/000000040000000000000004': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
00000005.history archive_status
cp: cannot stat `../arc/000000030000000000000004': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
00000005.history archive_status
[Master] 2013-04-30 23:24:33 EDT LOG: 00000: restored log file
"000000020000000000000004" from archive
[Master] 2013-04-30 23:24:33 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
[Master] 2013-04-30 23:24:33 EDT LOG: 00000: contrecord is requested by
0/4000020
[Master] 2013-04-30 23:24:33 EDT LOCATION: ReadRecord, xlog.c:4027
[Master] 2013-04-30 23:24:33 EDT LOG: 00000: redo done at 0/3000080
[Master] 2013-04-30 23:24:33 EDT LOCATION: StartupXLOG, xlog.c:6852
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status
cp: cannot stat `../arc/000000050000000000000003': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status
cp: cannot stat `../arc/000000040000000000000003': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status
cp: cannot stat `../arc/000000030000000000000003': File is missing
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status
[Master] 2013-04-30 23:24:45 EDT LOG: 00000: restored log file
"000000020000000000000003" from archive
[Master] 2013-04-30 23:24:45 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status
cp: cannot stat `../arc/00000006.history': File is missing
[Master] 2013-04-30 23:24:48 EDT LOG: 00000: selected new timeline ID: 6
[Master] 2013-04-30 23:24:48 EDT LOCATION: StartupXLOG, xlog.c:6958
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history archive_status xlogtemp.24906
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: restored log file
"00000005.history" from archive
[Master] 2013-04-30 23:24:51 EDT LOCATION: RestoreArchivedFile, xlog.c:3259
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: archive recovery complete
[Master] 2013-04-30 23:24:51 EDT LOCATION: exitArchiveRecovery, xlog.c:5796
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: checkpoint starting:
end-of-recovery immediate wait
[Master] 2013-04-30 23:24:51 EDT LOCATION: LogCheckpointStart, xlog.c:7717
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: checkpoint complete: wrote 0
buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.000 s, sync=0.000 s, total=0.175 s; sync files=0, longest=0.000 s,
average=0.000 s
[Master] 2013-04-30 23:24:51 EDT LOCATION: LogCheckpointEnd, xlog.c:7805
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: database system is ready to
accept connections
[Master] 2013-04-30 23:24:51 EDT LOCATION: reaper, postmaster.c:2408
[Master] 2013-04-30 23:24:51 EDT LOG: 00000: autovacuum launcher started
[Master] 2013-04-30 23:24:51 EDT LOCATION: AutoVacLauncherMain,
autovacuum.c:407
[mitsu-ko@localhost postgresql-9.2.3]$ ls Master/pg_xlog/
000000010000000000000002 000000020000000000000002 000000020000000000000003
000000020000000000000004 00000005.history 00000006.history
000000060000000000000003 000000060000000000000004 archive_status
[mitsu-ko@localhost postgresql-9.2.3]$ vim Master/pg_xlog/00000005.history
[mitsu-ko@localhost postgresql-9.2.3]$ ls arc/
000000010000000000000001 000000020000000000000005
00000002000000000000000C 000000020000000000000013 00000002000000000000001A
000000020000000000000021 000000020000000000000028 00000004000000000000002B
000000010000000000000002 000000020000000000000006
00000002000000000000000D 000000020000000000000014 00000002000000000000001B
000000020000000000000022 000000020000000000000029 00000005.history
000000010000000000000002.00000020.backup 000000020000000000000007
00000002000000000000000E 000000020000000000000015 00000002000000000000001C
000000020000000000000023 00000002000000000000002A 00000005000000000000002B
00000002.history 000000020000000000000008
00000002000000000000000F 000000020000000000000016 00000002000000000000001D
000000020000000000000024 00000003.history 00000005000000000000002C
000000020000000000000002 000000020000000000000009
000000020000000000000010 000000020000000000000017 00000002000000000000001E
000000020000000000000025 00000003000000000000002A 00000006.history
000000020000000000000003 00000002000000000000000A
000000020000000000000011 000000020000000000000018 00000002000000000000001F
000000020000000000000026 00000004.history
000000020000000000000004 00000002000000000000000B
000000020000000000000012 000000020000000000000019 000000020000000000000020
000000020000000000000027 00000004000000000000002A
__TEST_START(LOG_INIT)__
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-1 0 LOG: 00000: database system
was interrupted; last known up at 2013-04-17 19:39:12 JST
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-2 0 LOCATION: StartupXLOG,
xlog.c:6293
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-3 0 LOG: 00000: creating missing
WAL directory "pg_xlog/archive_status"
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-4 0 LOCATION:
ValidateXLOGDirectoryStructure, xlog.c:3711
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-5 0 LOG: 00000: restored log file
"00000010.history" from archive
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-6 0 LOCATION: RestoreArchivedFile,
xlog.c:3273
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-7 0 LOG: 00000: entering standby
mode
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-8 0 LOCATION: StartupXLOG,
xlog.c:6359
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-9 0 LOG: 00000: restored log file
"000000100000003B000000B0" from archive
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-10 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-11 0 LOG: 00000: redo starts at
3B/B0000020
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-12 0 LOCATION: StartupXLOG,
xlog.c:6817
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-13 0 LOG: 00000: consistent
recovery state reached at 3B/B0000210
2013-04-17 19:45:55 JST 27272 516e7d63.6a88-14 0 LOCATION:
CheckRecoveryConsistency, xlog.c:7356
2013-04-17 19:45:55 JST 27250 516e7d63.6a72-3 0 LOG: 00000: database system is
ready to accept read only connections
2013-04-17 19:45:55 JST 27250 516e7d63.6a72-4 0 LOCATION: sigusr1_handler,
postmaster.c:4267
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-15 0 LOG: 00000: restored log file
"000000100000003B000000B1" from archive
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-16 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-17 0 LOG: 00000: contrecord is
requested by 3B/B1000020
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-18 0 LOCATION: ReadRecord,
xlog.c:4050
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-19 0 LOG: 00000: contrecord is
requested by 3B/B1000020
2013-04-17 19:45:56 JST 27272 516e7d63.6a88-20 0 LOCATION: ReadRecord,
xlog.c:4050
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 19:45:56 JST 27281 516e7d64.6a91-1 0 LOG: 00000: streaming
replication successfully connected to primary
2013-04-17 19:45:56 JST 27281 516e7d64.6a91-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:171
2013-04-17 20:00:55 JST 27276 516e7d63.6a8c-1 0 LOG: 00000: restartpoint
starting: time
2013-04-17 20:00:55 JST 27276 516e7d63.6a8c-2 0 LOCATION: LogCheckpointStart,
xlog.c:7821
2013-04-17 20:02:37 JST 27276 516e7d63.6a8c-3 0 LOG: 00000: restartpoint
complete: wrote 997 buffers (0.3%); 1 transaction log file(s) added, 0 removed,
0 recycled; write=100.167 s, sync=0.972 s, total=101.416 s; sync files=81,
longest=0.050 s, average=0.012 s
2013-04-17 20:02:37 JST 27276 516e7d63.6a8c-4 0 LOCATION: LogCheckpointEnd,
xlog.c:7893
2013-04-17 20:02:37 JST 27276 516e7d63.6a8c-5 0 LOG: 00000: recovery restart
point at 3B/B1000020
2013-04-17 20:02:37 JST 27276 516e7d63.6a8c-6 0 DETAIL: last completed
transaction was at log time 2013-04-17 20:02:37.133057+09
2013-04-17 20:02:37 JST 27276 516e7d63.6a8c-7 0 LOCATION: CreateRestartPoint,
xlog.c:8601
2013-04-17 20:06:47 JST 27281 516e7d64.6a91-3 0 FATAL: XX000: could not
receive data from WAL stream:
2013-04-17 20:06:47 JST 27281 516e7d64.6a91-4 0 LOCATION: libpqrcv_receive,
libpqwalreceiver.c:368
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-21 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-22 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-23 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-24 0 LOCATION: ReadRecord,
xlog.c:4082
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-25 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:06:52 JST 27272 516e7d63.6a88-26 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-27 0 LOG: 00000: received promote
request
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-28 0 LOCATION:
CheckForStandbyTrigger, xlog.c:10777
2013-04-17 20:06:59 JST 8217 516e824c.2019-1 0 FATAL: 57P01: terminating
walreceiver process due to administrator command
2013-04-17 20:06:59 JST 8217 516e824c.2019-2 0 LOCATION:
ProcessWalRcvInterrupts, walreceiver.c:150
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-29 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-30 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-31 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:06:59 JST 27272 516e7d63.6a88-32 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:17 JST 8507 516e8253.213b-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:17 JST 8507 516e8253.213b-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:17 JST 27272 516e7d63.6a88-33 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:17 JST 27272 516e7d63.6a88-34 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:17 JST 27272 516e7d63.6a88-35 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:17 JST 27272 516e7d63.6a88-36 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:20 JST 8791 516e8265.2257-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:20 JST 8791 516e8265.2257-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:20 JST 27272 516e7d63.6a88-37 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:20 JST 27272 516e7d63.6a88-38 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:20 JST 27272 516e7d63.6a88-39 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:20 JST 27272 516e7d63.6a88-40 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:23 JST 8894 516e826a.22be-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:23 JST 8894 516e826a.22be-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:23 JST 27272 516e7d63.6a88-41 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:23 JST 27272 516e7d63.6a88-42 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:23 JST 27272 516e7d63.6a88-43 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:23 JST 27272 516e7d63.6a88-44 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:30 JST 8970 516e826f.230a-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:30 JST 8970 516e826f.230a-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:30 JST 27272 516e7d63.6a88-45 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:30 JST 27272 516e7d63.6a88-46 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:30 JST 27272 516e7d63.6a88-47 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:30 JST 27272 516e7d63.6a88-48 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:33 JST 9072 516e8274.2370-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:33 JST 9072 516e8274.2370-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:33 JST 27272 516e7d63.6a88-49 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:33 JST 27272 516e7d63.6a88-50 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:33 JST 27272 516e7d63.6a88-51 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:33 JST 27272 516e7d63.6a88-52 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:40 JST 9149 516e8279.23bd-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:40 JST 9149 516e8279.23bd-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:40 JST 27272 516e7d63.6a88-53 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:40 JST 27272 516e7d63.6a88-54 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:40 JST 27272 516e7d63.6a88-55 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:40 JST 27272 516e7d63.6a88-56 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:43 JST 9250 516e827e.2422-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:43 JST 9250 516e827e.2422-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:43 JST 27272 516e7d63.6a88-57 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:43 JST 27272 516e7d63.6a88-58 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:43 JST 27272 516e7d63.6a88-59 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:43 JST 27272 516e7d63.6a88-60 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:50 JST 9327 516e8283.246f-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:50 JST 9327 516e8283.246f-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:50 JST 27272 516e7d63.6a88-61 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:50 JST 27272 516e7d63.6a88-62 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:50 JST 27272 516e7d63.6a88-63 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:50 JST 27272 516e7d63.6a88-64 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:07:53 JST 9428 516e8288.24d4-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:07:53 JST 9428 516e8288.24d4-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:07:53 JST 27272 516e7d63.6a88-65 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:07:53 JST 27272 516e7d63.6a88-66 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:07:53 JST 27272 516e7d63.6a88-67 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:07:53 JST 27272 516e7d63.6a88-68 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:08:00 JST 9505 516e828d.2521-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:08:00 JST 9505 516e828d.2521-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:08:00 JST 27272 516e7d63.6a88-69 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:08:00 JST 27272 516e7d63.6a88-70 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:08:00 JST 27272 516e7d63.6a88-71 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:08:00 JST 27272 516e7d63.6a88-72 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:08:03 JST 9588 516e8292.2574-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:08:03 JST 9588 516e8292.2574-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:08:03 JST 27272 516e7d63.6a88-73 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:08:03 JST 27272 516e7d63.6a88-74 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:08:03 JST 27272 516e7d63.6a88-75 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:08:03 JST 27272 516e7d63.6a88-76 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:08:10 JST 9687 516e8297.25d7-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
2013-04-17 20:08:10 JST 9687 516e8297.25d7-2 0 LOCATION: libpqrcv_connect,
libpqwalreceiver.c:102
2013-04-17 20:08:10 JST 27272 516e7d63.6a88-77 0 LOG: 00000: restored log file
"000000100000003B000000BE" from archive
2013-04-17 20:08:10 JST 27272 516e7d63.6a88-78 0 LOCATION:
RestoreArchivedFile, xlog.c:3273
2013-04-17 20:08:10 JST 27272 516e7d63.6a88-79 0 LOG: 00000: invalid record
length at 3B/BECDEC68
2013-04-17 20:08:10 JST 27272 516e7d63.6a88-80 0 LOCATION: ReadRecord,
xlog.c:4082
/bin/cp: cannot stat `/dbfp/pgarch/arc1/00000011.history': No such file or
directory
2013-04-17 20:08:13 JST 9767 516e829c.2627-1 0 FATAL: XX000: could not connect
to the primary server: could not connect to server: No route to host
Is the server running on host "192.168.107.8" and accepting
TCP/IP connections on port 5432?
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
