[pgcluster: 877] Re: リカバリモードにてオンライン復旧について

[柳田]

　柳田です。

>早速、1.0.9aから1.0.10にバージョンアップしてみます。
やってみました。
結果は同様の事象が発生しました。
設定ファイルは1.0.9aの時のものをコピーしました。

復旧に使うマスタクラスタサーバにアクセスできないことは
わかるのですが、どうしてなのかがわかりません。
何度も申し訳ないですが、よろしくお願いします。

【レプリケーションデバッグ】---------------------------------------------------------
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():recovery accept port 8101
2006-04-14 18:46:20 [17097] DEBUG:read_packet():receive packet
2006-04-14 18:46:20 [17097] DEBUG:no = 1
2006-04-14 18:46:20 [17097] DEBUG:max_connect = 100
2006-04-14 18:46:20 [17097] DEBUG:port = 5431
2006-04-14 18:46:20 [17097] DEBUG:recoveryPort = 7001
2006-04-14 18:46:20 [17097] DEBUG:hostName = fire119
2006-04-14 18:46:20 [17097] DEBUG:pg_data = /service/pgc1.0.10_pgsql7.3.9/data
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():receive packet no:1
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():1st master fire114 - 5431
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():1st target fire119 - 5431
2006-04-14 18:46:20 [17097] DEBUG:first_setup_recovery():1st setup target fire119
2006-04-14 18:46:20 [17097] DEBUG:first_setup_recovery():1st setup port 5431
2006-04-14 18:46:20 [17097] DEBUG:first_setup_recovery():add recovery target to host table
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_load_balance_packet():host[fire119] port[7780]
2006-04-14 18:46:20 [17097] ERROR:send_packet():host[fire119] port[7780]PGR_Create_Socket_Connect failed
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_load_balance_packet():host[fire114] port[7780]
2006-04-14 18:46:20 [17097] ERROR:send_packet():host[fire114] port[7780]PGR_Create_Socket_Connect failed
2006-04-14 18:46:20 [17097] DEBUG:first_setup_recovery():set RECOVERY_PGDATA_REQ packet data
2006-04-14 18:46:20 [17097] ERROR:first_setup_recovery():get master info error , master may be down
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():first_setup_recovery end:1 
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():recovery accept port 8101
2006-04-14 18:46:20 [17097] DEBUG:read_packet():receive packet
2006-04-14 18:46:20 [17097] DEBUG:no = 200
2006-04-14 18:46:20 [17097] DEBUG:max_connect = 100
2006-04-14 18:46:20 [17097] DEBUG:port = 5431
2006-04-14 18:46:20 [17097] DEBUG:recoveryPort = 7001
2006-04-14 18:46:20 [17097] DEBUG:hostName = fire119
2006-04-14 18:46:20 [17097] DEBUG:pg_data = /service/pgc1.0.10_pgsql7.3.9/data
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():receive packet no:200
2006-04-14 18:46:20 [17097] DEBUG:pgrecovery_loop():recovery error accept. top queueing and initiarse recovery status
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_queue():master fire114 - 5431
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_queue():send_queue return status 0
2006-04-14 18:46:20 [17097] ERROR:send_packet():host[fire114] port[7779]PGR_Create_Socket_Connect failed
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_load_balance_packet():host[fire119] port[7780]
2006-04-14 18:46:20 [17159] DEBUG:replicate_loop():session closed
2006-04-14 18:46:20 [17159] DEBUG:replicate_loop():replicate loop exit
2006-04-14 18:46:20 [17097] ERROR:send_packet():host[fire119] port[7780]PGR_Create_Socket_Connect failed
2006-04-14 18:46:20 [17097] DEBUG:PGRsend_load_balance_packet():host[fire114] port[7780]
2006-04-14 18:46:20 [17097] ERROR:send_packet():host[fire114] port[7780]PGR_Create_Socket_Connect failed