[pgpool-general-jp: 1091] Re: オンラインリカバリ後にゾンビプロセスになる

[s-fukuda ＠ acs21.co.jp]

$B ＠ P0fMM(B

$B$4JV?.$"$j$,$H$&$4$6$$$^$9!#(B
$BJ!ED$G$4$6$$$^$9!#(B

$BEvJ}$G8!F$$7$?7k2L!"1?MQ$G%+%P!<$9$k$3$H$H$J$j$^$7$?!#(B

$BK\7o%/%m!<%:$H$5$;$F$/$@$5$$!#(B

$B$*A{$,$;$7$F?=$7Lu$"$j$^$;$s$G$7$?!#(B

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


>$B ＠ P0f$G$9!#(B
>
>debug$B%b!<%I$G$N(Bpgpool$B$N%m%0(B
>PostgreSQL$B$N%m%0(B($B%^%9%?$H%9%l!<%V(B)
>pgpool.conf
>$B%j%+%P%j%9%/%j%W%H(B($B%U%!!<%9%H%9%F!<%8$H%;%+%s%I%9%F!<%8(B)
>
>$B$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$O$8$a$^$7$F!#(B
>> $BJ!ED$H?=$7$^$9!#(B
>> 
>> $B8=:_!"(BPGPOOL-$B-6(B(3.1.3)$B!\(BPostgreSQL(8.4.12-1)$B$rMxMQ(B
>> $B$7$F$*$j$^$9!#(B
>> 
>> $B%l%W%j%1!<%7%g%s%b!<%I$G1?MQ$7!"%*%s%i%$%s%j%+%P%j$N(B
>> $B ＠ _Dj$r9T$$!"(Bpcp_recovery_node$B$r<B9T$7$?$H$3$m!"%3%^%s%I(B
>> $B$O ＠ 5>o$K=*N;$9$k$N$G$9$,!"%W%m%;%9$N%j%9%?!<%H$,$+$+$C$?(B
>> $B:]$K%W%m%;%9$,%>%s%S%W%m%;%9$H$J$C$F$7$^$$$^$9!#(B
>> 
>> $B!c<B9TA0!d(B
>> postgres 18045 17008 0 10:13 ? 00:00:00 pgpool: PCP: wait for connection request
>> 
>> $B!c<B9T8e!d(B
>> postgres 19114 17008 0 15:52 ? 00:00:00 [pgpool] <defunct>
>> 
>> $B"#<B9T$7$?%3%^%s%I(B
>> 
>> pcp_recovery_node 100 localhost $B%]!<%H(B $B%f!<%6L>(B $B%Q%9%o!<%I(B $B%N!<%I(BID
>> 
>> 
>> $B"#4D6-(B
>>  RHEL 5.6 (64bit)
>>  - pgpool-$B-6(B 3.1.3
>> 
>>  RHEL 5.6 (64bit)
>>  - PostgreSQL 8.4.12-1
>> 
>> 
>> $BBP=hK!$,$o$+$i$::$$C$F$*$j$^$9!#(B
>> 
>> $B$I$J$?$+BP=hK!$r$4B8CN$JJ}!"$465<x4j$($^$;$s$G$7$g$&$+!#(B
>> 
>> $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>> 
>