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

2012年 10月 10日 (水) 15:54:10 JST

$B ＠ P0fMM(B

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

rsync$B$,#52sO"B3<:GT$7$F$$$?$N$O!"%5!<%P$NIi2Y$N1F6A$@$C$?$h$&$G$9!#(B

$B$^$?!"(Brsync$B!J(B1st_stage$B!K$, ＠ 5>o=*N;$7$?>l9g$G$b%*%s%i%$%s%j%+%P%j$N(B2nd_stage$B$G0[>o=*N;$7$F$*$j$^$7$?$,!"(B
$B%*%s%i%$%s%j%+%P%j<B;\A0$K!"%9%l!<%VB&$N(Bpgpool-$B-6$rDd;_$7$F$+$i<B;\$9$k<j=g$K$7$?$H$3$m!"(B
$B ＠ 5>o$K=*N;$7$^$7$?!#(B
$B!JK\%7%9%F%`$G$O!"(Bpgpool-$B-6$K$D$$$F$b>iD92=$7!">c32;~$OIi2YJ,;6AuCV$K$F ＠ Z$jBX$($k9=@.$K$7$F$*$j$^$9!K(B

$BL5;v!"%*%s%i%$%s%j%+%P%j$9$k$3$H$,$G$-$^$7$?!#(B
$B$I$&$b!"$46(NO$"$j$,$H$&$4$6$$$^$7$?!#(B


2012/10/05 9:33, Tatsuo Ishii wrote:
> $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
>>>> ====================================================
>>>
>>
>