[pgpool-general-jp: 846] Re: pgpool--6$G$N!!VACUUM VERBOSE ANALYZE$K$Fkind mismatchが起こ_k$3$H$K$D$$$F$N<ALd
Yoshiharu Mori
y-mori ＠ sraoss.co.jp
2010年 11月 8日 (月) 21:39:50 JST
$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
--
Yoshiharu Mori <y-mori ＠ sraoss.co.jp>
SRA OSS, Inc Japan http://www.sraoss.co.jp
pgpool-general-jp メーリングリストの案内