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

[Yuki Hayashi]

$B ＠ P0fMM(B

$B$*@$OC$K$J$C$F$*$j$^$9!#<ALd<T$NNS$G$9!#(B

$B$4JV;v$"$j$,$H$&$4$6$$$^$9!#(B

PostgreSQL$B$N%m%0$rAwIU$5$;$F$$$?$@$-$^$9!#(B
rsync$B$,#52sO"B3<:GT$7$F$$$k$h$&$G$9!#(B

$B$A$J$_$K!"%7%9%F%`E*$K$OIi2Y$,$[$H$s$I$J$$!"?<Lk(B0:00$B$+$i%*%s%i%$%s%j%+%P%j$7$?>l9g$b<:GT$7$^$7$?!#(B

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

2012/10/03 22:12, Tatsuo Ishii wrote:
> $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
>> ====================================================
> 

-------------- next part --------------
$B%Y!<%9%P%C%/%"%C%W$NF14|(B START
-------------- next part --------------
$B%Y!<%9%P%C%/%"%C%W$NF14|(B START
$B%Y!<%9%P%C%/%"%C%W$NF14|(B END
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(1$B2sL\(B) START
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(1$B2sL\(B) END   $B=hM};~4V(B=152$BIC(B
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(2$B2sL\(B) START
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(2$B2sL\(B) END   $B=hM};~4V(B=48$BIC(B
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(3$B2sL\(B) START
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(3$B2sL\(B) END   $B=hM};~4V(B=141$BIC(B
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(4$B2sL\(B) START
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(4$B2sL\(B) END   $B=hM};~4V(B=69$BIC(B
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(5$B2sL\(B) START
rsync$B$K$h$kF14|$r7+$jJV$7:9J,$r8:>/$9$k(B(5$B2sL\(B) END   $B=hM};~4V(B=44$BIC(B
rsync$B$K$h$kF14|$N7+$jJV$7!'=hM};~4V5vMFHO0O30(B NG