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

[Tatsuo Ishii]

$B ＠ P0f$G$9!#(B

$B%*%s%i%$%s%j%+%P%j$N>c32D4::$G$O!"(Bpgpool$B$G$O$J$/$F(BPostgreSQL$B$N%m%0$rD4(B
$B$Y$k$N$,AaF;$G$9!#(Bhost1$B$H(Bhost2$B$N%m%0$r8+$;$F$$$?$@$1$^$9$+!)(B
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> $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
> ====================================================