=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA4NDddIFJlOiBwZ3Bvb2wt?= =?iso-2022-jp?b?GyRCLTYkRyROGyhCVkFDVVVNIFZFUkJPU0UgQU5BTFlaRRsk?= =?iso-2022-jp?b?QiRLJEYbKEJraW5kIG1pc21hdGNoGyRCJCw1LyQzJGsbKEIb?= =?iso-2022-jp?b?JEIkMyRIJEskRCQkJEYkTjxBTGQbKEI=?=

[FATK)角谷]

$B ＠ 9MM(B

$BAaB.$N$4JV?.$"$j$,$H$&$4$6$$$^$9!#3QC+$G$9!#(B
http://ml.postgresql.jp/pipermail/pgsql-jp/2005-June/010777.html
$B$K$O!"2DG=$G$"$k$H5-=R$,$"$j$^$7$?$N$G;n9T:x8m$9$Y$-$+$H9M$($F$$$^$7$?!#(B

verbose$B$NM-L5$K$H$i$o$l$:$K(B
VACUUM$B$O(Bpgpool-II$B7PM3$GH/9T$9$k$N$G$O$J$/!"(B
$B3F(BDB$B$KD>@\H/9T$9$k$h$&$K$$$?$7$^$9!#(B

$B$"$j$,$H$&$4$6$$$^$7$?!#(B

$B0J>e(B

> $B ＠ 9$G$9!#(B
>
> VERBOSE$B$r$D$1$F(BVACUUM$B$r<B9T$9$k$H%^%9%?$H%9%l!<%V$G7k2L$,0[$J$C$?(B
> $B$?$a%9%l!<%VB&$, ＠ Z$jN%$5$l$?$H$$$&$3$H$G$9$M!#(B
> pgpool-II$B$rMxMQ$7$F$b(BVACUUM$B<B9T;~$N%?%W%k$NJ*M}E*$JG[CV$O!"3F%N!<%I$G(B
> $B0l=o$G$O$J$$$N$G!"(BVACUUM$B$N1~Ez7k2L$,0[$J$k%1!<%9$O$h$/$"$j$^$9!#(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
>
> (verbose$B$NM-L5$K$H$i$o$l$:$K(B)VACUUM$B$O(Bpgpool-II$B7PM3$GH/9T$9$k$N$G$O$J$/!"(B
> $B3F(BDB$B$KD>@\H/9T$9$k$h$&$K$7$F$/$@$5$$!#(B
>
>> $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
>
>