[pgpool-general-jp: 1176] ヘルスチェックの失敗について

[笠原 裕樹]

$B3^86$H?=$7$^$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B

PostgreSQL 9.2.4$B$H(Bpgpool-$B-6(B 3.2.5$B$r;H$C$F(B
$B%Y%s%A%^!<%/B,Dj$r9T$$$^$7$?$,!"(B
$BB,DjESCf$G%U%'%$%k%*!<%P$,H/@8$7$^$7$?!#(B

[$BB,Dj4D6-(B]
$B!!(Bpgpool-$B-6%5!<%P#1Bf(B(master-slave$B%b!<%I$G;HMQ(B)
$B!!(BPostgreSQL$B$O(BSynchronous Replication$B$N#2Bf9=@.(B
$B!!%/%i%$%"%s%H#3Bf$+$iIi2Y$r$+$1$kB,Dj(B

$BB,Dj;~$N(Bpgpool-$B-6%m%0$K$O!"0J2<$N%a%C%;!<%8$,$"$j$^$7$?!#(B

--

$B!!(B2013-07-11 13:17:09 ERROR: pid 15380: connect_inet_domain_socket: select() timed out
$B!!(B2013-07-11 13:17:09 ERROR: pid 15380: make_persistent_db_connection: connection to 192.168.4.21(5432) failed
$B!!(B2013-07-11 13:30:50 LOG:   pid 13911: connect_inet_domain_socket: select() timed out. retrying...
$B!!(B2013-07-11 13:30:51 LOG:   pid 13911: connect_inet_domain_socket: select() timed out. retrying...
$B!!(B2013-07-11 13:36:21 ERROR: pid 15380: connect_inet_domain_socket: select() timed out
$B!!(B2013-07-11 13:36:21 ERROR: pid 15380: make_persistent_db_connection: connection to 192.168.4.21(5432) failed
$B!!(B2013-07-11 13:36:21 ERROR: pid 15380: health check failed. 1 th host 192.168.4.21 at port 5432 is down
$B!!!D(B
$B!!(B2013-07-11 13:36:21 LOG:   pid 15380: failover: set new primary node: 0
$B!!(B2013-07-11 13:36:21 LOG:   pid 15380: failover: set new master node: 0
$B!!(B2013-07-11 13:36:21 LOG:   pid 15380: failover done. shutdown host 192.168.4.21(5432)

--

$B%X%k%9%A%'%C%/%W%m%;%9$,<B9T$7$?(Bselect$B$G(B
timeout$B$,5/$3$C$?$3$H$,860x$G$O$J$$$+$H9M$($F$*$j$^$9!#(B

$BB,Dj;~$N%X%k%9%A%'%C%/4X78 ＠ _DjCM$O0J2<$G$7$?!#(B

--

$B!!(Bhealth_check_period = 10
$B!!(Bhealth_check_timeout = 60
$B!!(Bhealth_check_user = 'postgres'
$B!!(Bhealth_check_password = ''
$B!!(Bhealth_check_max_retries = 0
$B!!(Bhealth_check_retry_delay = 1

--

$B$=$N8e!"%f!<%6%^%K%e%"%k$N(Bhealth_check_max_retries$B$N5-=R$r;29M$K!"(B
health_check_max_retries = 3$B$K ＠ _Dj$7$F:FB,Dj$7$?$H$3$m(B
$B%U%'%$%k%*!<%P$r2sHr$G$-$^$7$?!#(B

$B<ALd;v9`(B
--
$B!&%f!<%6%^%K%e%"%k$N(Bhealth_check_max_retries$B$N5-=R$O0J2<$K$J$C$F$*$j$^$9$,!"(B

$B!!!V$3$N ＠ _Dj$OF0:n$K$`$i$N$"$k%M%C%H%o!<%/4D6-$K$*$$$F!"%^%9%?$, ＠ 5>o$G$"$k$K$b4X$o$i$:(B
$B!!!!$?$^$K%X%k%9%A%'%C%/$,<:GT$9$k$3$H$,M=A[$5$l$k>l9g$KM-MQ$G$9!#!W(B

$B!!K\7o$GH/@8$7$?%X%k%9%A%'%C%/$N<:GT(B($B5Z$S%U%'%$%k%*!<%P(B)$B$O!"(B
$B!!(B"$B$?$^$K%X%k%9%A%'%C%/$,<:GT$9$k(B"$B%1!<%9$KEv$F$O$^$k$N$G$7$g$&$+!)(B
$B!!$^$?!"<:GT$9$k%1!<%9$H$7$FB>$K$I$N$h$&$J%1!<%9$,A[Dj$5$l$k$N$+!"65$($FD:$1$J$$$G$7$g$&$+!)(B
--

$B$h$m$7$/$*4j$$CW$7$^$9!#(B

$BE:IU%U%!%$%k!'(B
$B!!(Bpgpool.log$B!'B,Dj;~$N(Bpgpool-$B-6%m%0(B
$B!!(Bpgpool.conf$B!'B,Dj;~$N(Bpgpool.conf

-- 
--------------------------------------------
NTT$B%=%U%H%&%'%"3t<02q<R(B
$B5;=Q3+H/%;%s%?!<(B
OSS$B5;=QItLg(B
$B%S%C%0%G!<%??d?J<<(B(BDO)
$B3^86!!M5<y(B (Yuki Kasahara)
$B")(B231-8551
$B?@F`@n8)!!2#IM;TCf6h;32<D.(B209$B!!Dk;=4XFb%S%k(B11F
TEL$B!'(B045-212-7665

E-Mail: kasahara.yuki ＠ po.ntts.co.jp
--------------------------------------------

-------------- next part --------------
$B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
$B%U%!%$%kL>(B: pgpool.zip
$B7?(B:         application/x-zip-compressed
$B%5%$%:(B:     5833 $B%P%$%H(B
$B ＠ bL@(B:       $BL5$7(B
URL:        <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20130711/eb6692b5/attachment-0001.bin>