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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers