[pgpool-general-jp: 1094] オンラインリカバリーのBackEndError

[Yuki Hayashi]

$B$*@$OC$K$J$C$F$*$j$^$9!#(B

$B%*%s%i%$%s%j%+%P%j!]$r2?EY<B;\$7$F$b!"(B20$BJ,DxEY7P2a$7$?$"$H$K!"(B"BackEndError"$B$H$J$j=*N;$7$F$7$^$$$^$9!#(B
pgpool$B!&(BPostgreSQL$B$K$D$$$F!"L5CN$G?=$7Lu$"$j$^$;$s$,!"(B"BackEndError"$B$H$J$C$F$7$^$&860x$K$D$$$F!"$465<x$*4j$$$$$?$7$^$9!#(B

===============================================================================
$B!ZI8=`=PNO$NFbMF![(B
$ online_recovery_node00-9833

BackendError
-------------------------------------------------------------------------------
$B!Z(Bpgpool$B-6$N%m%0FbMF![(B
2012-09-12 20:21:20 LOG:   pid 30286: starting recovering node 0
2012-09-12 20:21:20 LOG:   pid 30286: CHECKPOINT in the 1st stage done
2012-09-12 20:21:20 LOG:   pid 30286: starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage.sh', 'rpen1.nn.kawai-juku.ac.jp', '/usr/local/pgsql/8.0.4/data-5433')"
2012-09-12 20:21:21 LOG:   pid 24896: authentication is timeout
2012-09-12 20:21:21 LOG:   pid 21787: connection received: host=10.1.6.231 port=4305
2012-09-12 20:21:21 ERROR: pid 21787: pool_read: read failed (Connection reset by peer)
2012-09-12 20:21:24 LOG:   pid 21702: connection received: host=10.1.6.232 port=4334
2012-09-12 20:21:24 ERROR: pid 21702: pool_read: read failed (Connection reset by peer)
2012-09-12 20:21:24 LOG:   pid 24546: connection received: host=10.1.6.232 port=48653
$B!!!'(B
2012-09-12 20:39:01 ERROR: pid 30286: exec_recovery: recovery_1st_stage.sh command failed at 1st stage
===============================================================================


===============================================================================
$B!Z4D6-![(B
-------------------------------------------------------------------------------
<<host1>>
$B#O#S!!!'!!(BRHEL 4.7
pgpool$B-6!!!'!!#2!%#3!%#3(B
PostgreSQL$B!!!'!!#8!%#0!%#4(B

<<host2>>
$B#O#S!!!'!!(BRHEL 4.7
pgpool$B-6!!!'!!#2!%#3!%#3(B
PostgreSQL$B!!!'!!#8!%#0!%#4(B
-------------------------------------------------------------------------------

$B!Z(Bconf$B$NFbMF!JH4?h!K![(B
-------------------------------------------------------------------------------
$B!'(B
pcp_timeout = 30
child_life_time = 300
connection_life_time = 0
authentication_timeout = 60

replication_mode = true
load_balance_mode = false

health_check_timeout = 60

fail_over_on_backend_error = true

backend_hostname0 = 'host1.$B%I%a%$%sL>(B'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/usr/local/pgsql/8.0.4/data-5432'
backend_hostname1 = 'host2.$B%I%a%$%sL>(B'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/usr/local/pgsql/8.0.4/data-5432'

recovery_1st_stage_command = 'recovery_1st_stage.sh'
recovery_2nd_stage_command = 'recovery_2nd_stage.sh'
recovery_timeout = 90
client_idle_limit_in_recovery = 0
--------------------------------------------------------------------------------
================================================================================

$BF1$8%5!<%P!&%P!<%8%g%s$G!"(BPort=5433$B$N(BPostgreSQL$B$r2TF/$7$F$$$k$N$G$9$,!"$3$N%G!<%?%Y!<%9$O%*%s%i%$%s%j%+%P%j$, ＠ .8y$7$?(B
$B<B ＠ S$,$"$j$^$9!#!J$=$N;~$O!"(B20$BJ,0JFb$K=*N;!K(B
pgpool$B-6$N ＠ _Dj$b(BPort$BHV9f0J30$OF1$8 ＠ _Dj$K$7$F$*$j$^$9!#(B

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

-- 
====================================================
$BNS!!M45.(B
 MAIL$B!'(B yuuki.hayashi ＠ kawaijuku.jp
====================================================