ログ[exec_recovery: recovery_2nd_stage.sh command failed at 2nd stage]


・pgpoolログ

2011-04-15 18:40:27 LOG: pid 13183: starting recovering node 1
2011-04-15 18:40:27 LOG: pid 13183: CHECKPOINT in the 1st stage done
2011-04-15 18:40:27 LOG: pid 13183: starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage.sh', '172.18.21.32', '/db/pgsql/data')"
2011-04-15 18:40:28 LOG: pid 13183: 1st stage is done
2011-04-15 18:40:28 LOG: pid 13183: starting 2nd stage
2011-04-15 18:40:28 LOG: pid 13183: all connections from clients have been closed
2011-04-15 18:40:28 LOG: pid 13183: CHECKPOINT in the 2nd stage done
2011-04-15 18:40:28 LOG: pid 13183: starting recovery command: "SELECT pgpool_recovery('recovery_2nd_stage.sh', '172.18.21.32', '/db/pgsql/data')"
2011-04-15 18:40:28 ERROR: pid 13183: exec_recovery: recovery_2nd_stage.sh command failed at 2nd stage



・postgreSQLログ

pg_start_backup
-----------------
87/64000020
(1 row)

Host key verification failed.
Host key verification failed.
Host key verification failed.
rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: unexplained error (code 255) at io.c(463) [sender=2.6.8]
Host key verification failed.
2011-04-15 18:58:09 JST dbp postgres[27275]: [1-1] LOG: duration: 1001.417 ms statement: SELECT pg_stop_backup()
pg_stop_backup
----------------
87/64000088
(1 row)

2011-04-15 18:58:09 JST dbp postgres[27261]: [1-1] LOG: duration: 1229.680 ms statement: SELECT pgpool_recovery('recovery_1st_stage.sh', '172.18.21.32', '/db/pgsql/data')
pg_switch_xlog
----------------
87/65000088
(1 row)

Host key verification failed.
rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: unexplained error (code 255) at io.c(463) [sender=2.6.8]
2011-04-15 18:58:09 JST dbp postgres[27261]: [2-1] ERROR: pgpool_recovery failed
2011-04-15 18:58:09 JST dbp postgres[27261]: [3-1] STATEMENT: SELECT pgpool_recovery('recovery_2nd_stage.sh', '172.18.21.32', '/db/pgsql/data')




pgpoolの2stステージオンライリカバリ失敗の原因・対応


postgresユーザで片系にアクセスし、known_hostsに登録する。

$ ssh -i .ssh/id_dsa.batch 172.18.21.32 hostname
The authenticity of host '172.18.21.32 (172.18.21.32)' can't be established.
RSA key fingerprint is 08:62:d1:e8:6e:60:a6:a7:ac:5a:66:f5:c1:20:e1:51.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.18.21.32' (RSA) to the list of known hosts.
dbp02


※【-i .ssh/id_dsa.batch】は、サーバ鍵の指定です。省いた場合は、パスワード問い合わせがあります。



DB関連書籍


Mysqlのおすすめ書籍
PostgreSQLのおすすめ書籍
DBエンジニアとして読んでおきたい書籍


Google+