[pgpool-general-jp: 1130] Re: CPU LOAD AVERAGE が急に高くなった

2012年 12月 5日 (水) 17:49:50 JST

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

> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> 
> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> vmstat$B$G3NG'$7$?$H$3$m!"2<5-$N7k2L$H$J$j$^$7$?!#(B
> 
> $ vmstat -a 60 20
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu-----
> r b swpd free inact active si so bi bo in cs us sy id wa st
> 0 0 0 2709144 509296 4257028 0 0 0 1 2 1 0 1 99 0 0
> 0 0 0 2719180 509292 4247096 0 0 0 6 7488 45216 2 11 86 0 0
> 744 0 0 2712740 509292 4253820 0 0 0 4 7591 45949 2 12 86 0 0
> 1 0 0 2725264 509296 4240500 0 0 0 5 7233 43023 2 11 87 0 0
> 0 0 0 2722528 509296 4243832 0 0 0 5 8218 50401 2 13 85 0 0
> 0 0 0 2707284 509292 4259328 0 0 0 4 7681 46280 2 12 86 0 0
> 1 0 0 2715328 509292 4251216 0 0 0 5 7580 45324 2 12 86 0 0
> 1 0 0 2705532 509296 4260352 0 0 0 5 8149 48694 2 12 85 0 0
> 1 0 0 2723388 509292 4242424 0 0 0 4 7773 46200 2 12 86 0 0
> 1 0 0 2745840 509292 4220840 0 0 0 4 7888 47009 2 12 86 0 0
> 0 0 0 2742732 509292 4223856 0 0 0 5 8347 51063 2 13 85 0 0
> 872 0 0 2721048 509292 4245500 0 0 0 6 7978 47823 2 12 85 0 0
> 1 0 0 2726248 509292 4240560 0 0 0 5 7473 44433 2 11 87 0 0
> 0 0 0 2723048 509292 4243676 0 0 0 6 7189 43058 2 11 87 0 0
> 0 0 0 2720164 509292 4246212 0 0 0 7 7906 46810 2 12 86 0 0
> 0 0 0 2727024 509288 4239000 0 0 0 5 8075 49246 2 12 86 0 0
> 743 0 0 2723536 509288 4243188 0 0 0 5 8212 50050 2 12 85 0 0
> 0 0 0 2714988 509288 4251804 0 0 0 5 8132 49569 2 12 86 0 0
> 0 0 0 2726860 509808 4238744 0 0 0 5 9099 55722 3 14 83 0 0
> 0 0 0 2721808 509812 4244748 0 0 0 5 8597 52920 2 13 84 0 0
> 
> $B=hM}BT$A$N%W%m%;%9?t$,5^$K(B700$B0J>e$KA}$($?$?$a!"(B
> $B$3$N860x$G%m!<%I%"%Y%l!<%8$,9b$/$J$C$?$G$O$J$$$+$H;W$$$^$9!#(B
> 
> $B0x$_$K!"(Bpgpool$B$N%m%0$K$O!"2<5-$N$h$&$J%(%i!<%m%0$,=PNO$5$l$F$$$^$9!#(B
> $B$3$l$O=hM}BT$A$N%W%m%;%9?t>e$,$C$?M}M3$G$7$g$&$+!)(B

$B$=$l$O$A$g$C$HJ,$+$j$^$;$s$,(B...

> 2012-12-03 08:37:58 ERROR: pid 43600: "MD5" authentication with pgpool
> failed for user "postgres"
> 2012-12-03 10:27:48 ERROR: pid 46814: "MD5" authentication with pgpool
> failed for user "postgres"
> 2012-12-03 11:13:18 ERROR: pid 48096: "MD5" authentication with pgpool
> failed for user "postgres"
> 2012-12-03 11:40:13 ERROR: pid 49149: "MD5" authentication with pgpool
> failed for user "postgres"
> $B!J0lIt$N$_!K(B

$BK\Mh ＠ .8y$9$k$O$:$N(Bmd5$BG'>Z$,<:GT$9$k!"$H$$$&>c32$,(Bpgpool-II 3.2.1$B$r%j%j!<(B
$B%9$7$?8e$K8+$D$+$C$F$*$j!"$=$l$,4X78$7$F$$$k2DG=@-$,$"$j$^$9!#(B

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ee0bac759857599023da9268d82c05604b759a64

$B$9$G$K(Bgit$B$G$O=$@5$5$l$F$$$k$N$G!"$h$m$7$1$l$P(Bgit$B$+$i(B3.2-stable$B%D%j!<$r(B
$B%@%&%s%m!<$7$F$*;n$7$/$@$5$$!#(B

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE

> $B8=:_(Bpool_hba.conf $B$GG'>Z$7$F$$$^$9!#(B
> pool_hba.conf$B$O2<5-$N$h$&$K ＠ _Dj$7$F$$$^$9!#(B
> 
> host all all 111.111.111.112/32 md5
> host all all 111.111.111.113/32 md5
> 
> pool_passwd$B$K(Bpostgres$B$N(BID$B!?(BPWD$B$O5-:\:Q$G!"(B
> Apache$B"*(Bpgpool$B$X$N@\B3$OLdBjL5$5$=$&$G$9!#(B
> $B>e5-$N%(%i!<$O$I$N860x$G$7$g$&$+!)(B
> 
> $B$*<j?t$r$*3]$1$7$^$9$,!"59$7$/$*4j$$CW$7$^$9!#(B
> 
> 
> (2012/12/01 23:35), $BD%!!J!L1(B wrote:
>> $B ＠ P0fMM(B
>>
>> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
>> $BAaB.$N$4JV?.@?$K$"$j$,$H$&$4$6$$$^$9!#(B
>>
>> $B3NG'$7$F$+$i$4Js9p$5$;$FD:$-$^$9!#(B
>>
>>
>> (2012/12/01 23:22), Tatsuo Ishii wrote:
>>> $B ＠ P0f$H?=$7$^$9!#(B
>>>
>>> $BLdBj$r ＠ Z$jJ,$1$k$?$a$K!"(Bwatchdog$B$r(Boff$B$K$7$?$i2~A1$5$l$k$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$*@$OC$K$J$C$F$*$j$^$9!#(B
>>>> $BD%$H?=$7$^$9!#(B
>>>>
>>>> $BA0F|<ALd$5$;$FD:$$LdBj$O!"8=:_$^$@2~A1$7$F$$$^$;$s!#(B
>>>> $B$7$+$b$@$s$@$s$R$I$/$J$C$F$$$^$9!#(B
>>>> CPU LOAD AVERAGE$B$,9b$$;~$O!"(B50$B!A(B70$B$0$i$$$N?t;z$b$"$j$^$7$?!#(B
>>>>
>>>> $B>\$7$$>pJs$rE:IUCW$7$^$7$?!#(B
>>>> $B$<$R$*CN7C$rGR<Z$5$;$FD:$1$l$P$H;W$$$^$9!#(B
>>>> $BE:IU-!%7%9%F%`9=@.?^(B
>>>> $BE:IU-"(Bpgpool.conf
>>>> $BE:IU-#(Bpostgresql.conf$B!J%^%9%?B&!K(B
>>>>
>>>> $B0J>e!"59$7$/$*4j$$CW$7$^$9!#(B
>>>>
>>>>
>>>> (2012/11/27 15:46), $BD%!!J!L1(B wrote:
>>>>> $B$O$8$a$^$7$F!#(B
>>>>> $BD%$H?=$7$^$9!#(B
>>>>>
>>>>> PGPOOL-$B-6(B(3.2.1)$B!\(BPostgreSQL(9.1.6)$B$rMxMQ$7$F$*$j$^$9!#(B
>>>>> PostgreSQL$B$O(B2$BBf9=@.$G!"(BStream Replication$B$GF14|$r<h$C$F$$$^$9!#(B
>>>>>
>>>>> $B8=:_!"(BCPU LOAD AVERAGE $B$,5^$K9b$/$J$C$?8=>]$,H/@8$7$F$$$^$9!#(B
>>>>> $BBgBN#1F|#5!"#62s$0$i$$$G$9!#(B
>>>>>
>>>>> $B%5!<%P$O9=C[$7$?$P$C$+$j$G$9$,!"$^$@K\HV2TF/$7$F$$$J$$$N$G!"(B
>>>>> $B%5!<%P$NIi2Y$,$"$^$j$J$$$O$:$G$9!#(B
>>>>>
>>>>> CPU LOAD AVERAGE$B$,9b$/$J$C$?$H$-$G$b!"(B
>>>>> pgpool $B$H(B PostgreSQL$B$N%m%0$K$O0[>o$J%a%C%;!<%8$,=PNO$5$l$F$$$^$;$s!#(B
>>>>>
>>>>> $BBP=hK!$,J,$+$i$J$$$N$G!":$$C$F$*$j$^$9!#(B
>>>>> $B$4B8CN$JJ}$O$465<x$*4j$$$G$-$^$9$G$7$g$&$+!#(B
>>>>>
>>>>> $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> pgpool-general-jp mailing list
>>>>> pgpool-general-jp ＠ sraoss.jp
>>>>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>>
>>
>>
>> _______________________________________________
>> pgpool-general-jp mailing list
>> pgpool-general-jp ＠ sraoss.jp
>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp