=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA4NDVdICBwZ3Bvb2wtGyRC?= =?iso-2022-jp?b?LTYkRyROISEbKEJWQUNVVU0gVkVSQk9TRSBBTkFMWVpFGyRC?= =?iso-2022-jp?b?JEskRhsoQmtpbmQgbWlzbWF0Y2gbJEIkLDUvJDMbKEIbJEIk?= =?iso-2022-jp?b?ayQzJEgkSyREJCQkRiROPEFMZBsoQg==?=

FATK)角谷 m.sumiya @ bsol.biz
2010年 11月 8日 (月) 12:53:46 JST


$B3QC+$H?=$7$^$9!#(B

PostgreSQL$B%5!<%P$r=8Ls$7E}9g(BPostgreSQL$B%5!<%P$r9=C[$7$F$$$^$9!#(B
$B$=$l$KH<$$!"(Bpgpool-$B-6$rF3F~$7%l%W%j%1!<%7%g%s$r<B;\$7$F$$$^$9!#(B

$B!Z(BPostgreSQL$B%5!<%P9=@.![(B
PostgreSQL$B%5!<%PBf?t!'(B2$BBf!J%^%9%?%5!<%P(B,$B%9%l!<%V%5!<%P!K(B
OS$B!'(BRed Hat Enterprise Linux ES release 4
pgpool-$B-6%P!<%8%g%s!'(B2.3.3
PostgreSQL$B%P!<%8%g%s!'(B7.2.2/7.3.1/7.3.4/7.3.6/7.3.8/7.3.9/7.3.14/7.3.15

$B!Z<ALd![(B
$B>e5-9=@.$N%^%9%?%5!<%PB&$N(Bpgpool-$B-6(B2.3.3$B$r;HMQ$7(B
$B$?$H$($P!"(BPostgreSQL7.3.15$B!J%^%9%?!"%9%l!<%V!K$KBP$7$F(B
VACUUM VERBOSE ANALYZE$B!!$r9T$$(Bnodoinfo$B$r3NG'$9$k$H%9%l!<%VB&(BPostgreSQL$B$,%@%&%s$7$?$HG'<1$5$l$k>l9g$H!"@.8y$9$k>l9g$,$"$j$^$9!#(B
$B%P!<%8%g%s$d9=@.$K$h$kLdBj$J$N$+!"@Z$jJ,$1$,$G$-$J$$>uBV$G$9!#(B
$B2<5-E:IU%m%0$h$jLdBj2r>C$9$k$K$O!"$I$N$h$&$K$9$l$P$h$$$G$7$g$&$+!)$*<j?t$r$*3]$1$$$?$7$^$9!#(B

$B!Z$=$NB>D4::4QE@>pJs![(B
$B#1!%(BpostgreSQL$BC1BN$KBP$7$F(BVACUUM VERBOSE ANALYZE$B$r9T$&!!"M7k2L!'%(%i!<H/@8L5(B
$B#2!%%G!<%?NL$r8:$i$7(BVACUUM VERBOSE ANALYZE$B$r9T$&!!"M7k2L!'%(%i!<H/@8M-(B
$B#3!%(Bpgpool-$B-6(B2.3.3$B$KBP$7$F(B VACUUME$B%3%^%s%I$rJQ2=$5$;$k(B
$B"M7k2L!'(B
$B!z(BVACUUM + ANALYZE + VERBOSE $B"*(B $B9b3NN($G%@%&%s$,H/@8$9$k!#(B
$B!z(BVACUUM + ANALYZE $B"*(B $BH/@8$7$J$$!#(B
$B!z(BVACUUM + VERBOSE $B"*(B $BDc3NN($G%@%&%s$,H/@8$9$k!#(B

$B!ZD4::7k2L$K$h$kBP1~?dB,![(B
$B#1!%(Bpgpool-$B-67PM3$G(BVACUUM$B$r9T$&>l9g(BVERBOSE$B!J3F%F!<%V%k$K$D$$$F(Bvacuum$B$N>\:Y$J3hF0Js9p$r=PNO!K$r=PNO$7$J$$$h$&$K$9$k!#(B

$B!Z%m%0![(B
$B!Z(Bpgpool$B$N%m%0$K$O0J2<$N$h$&$K=PNO$5$l$F$$$^$9!#!J%^%9%?B&=PNO!K![(B
2010-11-02 17:34:02 LOG:   pid 14740: connection received: host=127.0.0.1 
port=50718
2010-11-02 17:34:02 LOG:   pid 14740: statement: begin; select 
getdatabaseencoding(); commit
2010-11-02 17:34:02 LOG:   pid 14740: statement: SET autocommit TO 
'on';VACUUM  VERBOSE ANALYZE
2010-11-02 17:34:08 ERROR: pid 14740: read_kind_from_backend: 1 th kind N 
does not match with master or majority connection kind C
2010-11-02 17:34:08 ERROR: pid 14740: kind mismatch among backends. Possible 
last query was: "SET autocommit TO 'on';VACUUM  VERBOSE ANALYZE " kind 
details are: 0[C] 1[N:INFO:  Analyzing public.koushi_mst]
2010-11-02 17:34:08 LOG:   pid 14740: notice_backend_error: 1 fail over 
request from pid 14740
2010-11-02 17:34:08 LOG:   pid 14711: starting degeneration. shutdown host 
10.46.12.82(5439)
2010-11-02 17:34:08 LOG:   pid 14711: failover_handler: set new master node: 
0
2010-11-02 17:34:08 LOG:   pid 14711: failover done. shutdown host 
10.46.12.82(5439)
pool_config: could not open configuration file (pgpool.conf)
pool_config: using default values...
2010-11-02 17:38:48 ERROR: pid 16422: could not read pid file
2010-11-02 17:39:38 LOG:   pid 14711: received fast shutdown request
stop request sent to pgpool. waiting for termination....done.

$B!Z%^%9%?B&(BPostgreSQL7.3.15$B%m%0![(B
Nov  2 17:34:02 rksm11 pgsql5439[15789]: [20] LOG:  query: begin; select 
getdatabaseencoding(); commit
Nov  2 17:34:02 rksm11 pgsql5439[15789]: [21] LOG:  duration: 0.000266 sec
Nov  2 17:34:02 rksm11 pgsql5439[15789]: [22] LOG:  query: SET autocommit TO 
'on';VACUUMVERBOSE ANALYZE
Nov  2 17:34:08 rksm11 pgsql5439[15789]: [23] LOG:  duration: 6.528783 sec
Nov  2 17:34:56 rksm11 pgsql5439[15960]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
Nov  2 17:35:56 rksm11 pgsql5439[16152]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
Nov  2 17:36:56 rksm11 pgsql5439[16232]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
Nov  2 17:37:56 rksm11 pgsql5439[16299]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
Nov  2 17:38:56 rksm11 pgsql5439[16434]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
Nov  2 17:41:43 rksm11 pgsql5439[17163]: [1] FATAL:  Database "postgres" 
does not exist in the system catalog.
$B!Z%9%l!<%VB&(BPostgreSQL7.3.15$B%m%0![(B
Nov  2 17:34:02 rksm12 pgsql5439[8123]: [20] LOG:  query: begin; select 
getdatabaseencoding(); commit
Nov  2 17:34:02 rksm12 pgsql5439[8123]: [21] LOG:  duration: 0.000252 sec
Nov  2 17:34:02 rksm12 pgsql5439[8123]: [22] LOG:  query: SET autocommit TO 
'on';VACUUM  VERBOSE ANALYZE
Nov  2 17:34:08 rksm12 pgsql5439[8123]: [23] LOG:  duration: 6.467867 sec
Nov  2 17:34:08 rksm12 pgsql5439[7995]: [20] LOG:  pq_recvbuf: unexpected 
EOF on client connection
Nov  2 17:34:08 rksm12 pgsql5439[8053]: [58] LOG:  pq_recvbuf: unexpected 
EOF on client connection
Nov  2 17:34:08 rksm12 pgsql5439[8067]: [20] LOG:  pq_recvbuf: unexpected 
EOF on client connection
Nov  2 17:34:08 rksm12 pgsql5439[8083]: [39] LOG:  pq_recvbuf: unexpected 
EOF on client connection
Nov  2 17:34:08 rksm12 pgsql5439[8051]: [20] LOG:  pq_recvbuf: unexpected 
EOF on client connection
Nov  2 17:34:08 rksm12 pgsql5439[8078]: [20] LOG:  pq_recvbuf: unexpected 
EOF on client connection

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

$B0J>e(B 
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20101108/707c6a66/attachment.html 


pgpool-general-jp メーリングリストの案内