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

[Tatsuo Ishii]

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

$B%m%0$rGR8+$7$^$7$?$,!"%j%+%P%j%9%/%j%W$KAH$_9~$^$l$?%7%9%F%`8GM-$N%m%8%C(B
$B%/$NLdBj$N$h$&$K8+<u$1$i$l$^$9!#%9%/%j%W%H$N>\:YFbMF$,$o$+$i$J$$$H?dB,(B
$B$K$J$C$F$7$^$&$N$G!"%9%/%j%W%H$r:n ＠ .$5$l$?J}$K;v>p$rJ9$$$F$_$F$O$$$+$,(B
$B$G$7$g$&!)(B
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

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