[pgpool-general-jp: 1386] オンラインリカバリがセカンドステージで止まってしまう

[石本 優貴]

$B$*@$OC$K$J$C$F$*$j$^$9!#@PK\$H?=$7$^$9!#(B
pgpool$B$N%l%W%j%1!<%7%g%s%b!<%I$K$D$$$F$465<x$$$?$@$1$^$;$s$G$7$g$&$+!#(B
$B%^%9%?!"%9%l!<%V$N(B2$BBf9=@.$G(Bpgpool$B$O%l%W%j%1!<%7%g%s%b!<%I$G(B
$B1?MQ$7$F$$$^$9!#(B
$B%9%l!<%V$X$NF14|$,Jx$l$?$?$a%*%s%i%$%s%j%+%P%j$G$NI|5l$r;n$_$?$N$G$9$,!"(B
$B%;%+%s%I%9%F!<%8$G;_$^$C$F$7$^$$$^$9!#(B


$B4D6-(B
$B!&(BCentOS6.3 x86_64
$B!&(BPostgreSQL 8.1.23
$B!&(Bpgpool-$B-6(B 2.3.3


$B%^%9%?$N(Bpgpool$B%m%0(B
$B$3$3$+$i(B--------------------------------
2015-10-08 14:42:22 LOG:   pid 3298: pgpool-II successfully started.
version 2.3.3 (tomiteboshi)
2015-10-08 14:42:39 LOG:   pid 3332: send_failback_request: fail back 1
th node request from pid 3332
2015-10-08 14:42:39 LOG:   pid 3298: starting fail back. reconnect host
192.168.56.102(5432)
2015-10-08 14:42:39 LOG:   pid 3298: failover_handler: set new master
node: 0
2015-10-08 14:42:39 LOG:   pid 3298: failback done. reconnect host
192.168.56.102(5432)
2015-10-08 14:42:55 LOG:   pid 3332: notice_backend_error: 1 fail over
request from pid 3332
2015-10-08 14:42:55 LOG:   pid 3298: starting degeneration. shutdown
host 192.168.56.102(5432)
2015-10-08 14:42:55 LOG:   pid 3298: failover_handler: set new master
node: 0
2015-10-08 14:42:55 LOG:   pid 3298: failover done. shutdown host
192.168.56.102(5432)
2015-10-08 14:43:10 LOG:   pid 3332: starting recovering node 1
2015-10-08 14:43:10 LOG:   pid 3332: CHECKPOINT in the 1st stage done
2015-10-08 14:43:10 LOG:   pid 3332: starting recovery command: "SELECT
pgpool_recovery('recovery_1st_stage.sh', '192.168.56.102',
'/usr/local/pgsql/data')"
2015-10-08 14:45:54 LOG:   pid 3332: 1st stage is done
2015-10-08 14:45:54 LOG:   pid 3332: starting 2nd stage
2015-10-08 14:45:54 LOG:   pid 3332: all connections from clients have
been closed
2015-10-08 14:45:54 LOG:   pid 3332: CHECKPOINT in the 2nd stage done
2015-10-08 14:45:54 LOG:   pid 3332: starting recovery command: "SELECT
pgpool_recovery('recovery_2nd_stage.sh', '192.168.56.102',
'/usr/local/pgsql/data')"
$B$3$3$^$G(B--------------------------------
$B$3$N8e%j%+%P%j%3%^%s%I$rCfCG$7!"%5!<%P$r:F5/F0$7$^$7$?!#(B

$B%;%+%s%I%9%F!<%8$N<B9T%9%/%j%W%H$O2<5-$NDL$j$G$9!#(B

$B$3$3$+$i(B--------------------------------
#! /bin/bash

PSQL=/usr/local/pgsql/bin/psql

MASTER_BASEDIR=$1
RECOVERY_HOST=$2
RECOVERY_BASEDIR=$3

# $B:G?7$N%"!<%+%$%V%m%0$rJ]B8(B
#$PSQL -c 'SELECT pg_switch_xlog()' postgres
$PSQL -c "SELECT pg_start_backup('bkup01')" postgres

# $B:G?7$N%"!<%+%$%V%m%0$r%j%+%P%j ＠ h$KE>Aw(B
rsync -az -e ssh $MASTER_BASEDIR/archive_log/
$RECOVERY_HOST:$RECOVERY_BASEDIR/archive_log/

$PSQL -c "SELECT pg_stop_backup()" postgres
$B$3$3$^$G(B--------------------------------

$B$3$A$i$N%1!<%9$K;w$F$$$k$H;W$C$?$N$G$9$,!"<B9T%9%/%j%W%H$N5-=R$,0[$C$F$$(B
$B$k$h$&$G;29M$K$7$FNI$$$+H=CG$G$-$^$;$s$G$7$?!#(B
http://www.sraoss.jp/pipermail/pgpool-general-jp/2008-March/000405.html

$B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B