[Pgpool-general] pcp_recovery_node and errors in postgres log

[Tomasz Chmielewski]

I followed the http://linuxsilo.net/articles/postgresql-pgpool.html to set up pgpool-ii replication.


When I detach and recover a node with these commands:

# pcp_detach_node -d 240 127.0.0.1 9898 user pass 1
# pcp_recovery_node -d 240 127.0.0.1 9898 user pass 1


I can observer the following on node 1 in postgres logs - :

2009-12-23 06:03:15 SGT LOG:  database system was interrupted; last known up at 2009-12-23 06:03:12 SGT
2009-12-23 06:03:15 SGT LOG:  starting archive recovery
2009-12-23 06:03:15 SGT LOG:  restore_command = '/usr/bin/scp db10:/var/lib/postgresql/8.3/main/pg_xlog_archive/%f %p'
scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002.history: No such file or directory
2009-12-23 06:03:16 SGT LOG:  incomplete startup packet
2009-12-23 06:03:16 SGT FATAL:  the database system is starting up
2009-12-23 06:03:17 SGT FATAL:  the database system is starting up
2009-12-23 06:03:17 SGT LOG:  restored log file "00000002000000000000005D" from archive
2009-12-23 06:03:17 SGT LOG:  automatic recovery in progress
2009-12-23 06:03:17 SGT LOG:  redo starts at 0/5D000068
2009-12-23 06:03:17 SGT FATAL:  the database system is starting up
2009-12-23 06:03:18 SGT FATAL:  the database system is starting up
2009-12-23 06:03:18 SGT FATAL:  the database system is starting up
2009-12-23 06:03:19 SGT LOG:  restored log file "00000002000000000000005E" from archive
scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002000000000000005F: No such file or directory
2009-12-23 06:03:19 SGT LOG:  could not open file "pg_xlog/00000002000000000000005F" (log file 0, segment 95): No such file or directory
2009-12-23 06:03:19 SGT LOG:  redo done at 0/5E000068
2009-12-23 06:03:19 SGT FATAL:  the database system is starting up
2009-12-23 06:03:19 SGT FATAL:  the database system is starting up
2009-12-23 06:03:20 SGT FATAL:  the database system is starting up
2009-12-23 06:03:20 SGT LOG:  restored log file "00000002000000000000005E" from archive
2009-12-23 06:03:20 SGT FATAL:  the database system is starting up
scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000003.history: No such file or directory
2009-12-23 06:03:20 SGT LOG:  selected new timeline ID: 3
scp: /var/lib/postgresql/8.3/main/pg_xlog_archive/00000002.history: No such file or directory
2009-12-23 06:03:20 SGT LOG:  archive recovery complete
2009-12-23 06:03:20 SGT LOG:  autovacuum launcher started
2009-12-23 06:03:20 SGT LOG:  database system is ready to accept connections


Because of these errors, recovery sometimes fails.

How does postgres on the node which is recovered determines the %f files it needs to copy?


-- 
Tomasz Chmielewski
http://wpkg.org