[pgpool-general-jp: 1448] Re: マスタスレーブモードとコマンドクエリキャッシュ有効時にpgpool2から応答がこなくなる

Nobuyuki Nagai nagai.nb @ ncos.nec.co.jp
2017年 1月 19日 (木) 09:23:04 JST


$B$43NG'$*$h$S!"<!$N%^%$%J!<%P!<%8%g%s$KH?1G$5$l$k$H$N$4O"Mm!"$"$j$,$H$&$4$6$$$^$9!#(B

$B4JC1$G$9$,!"0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B


> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii @ sraoss.co.jp]
> Sent: Thursday, January 19, 2017 8:00 AM
> To: Nagai Nobuyuki($B1J0f(B $B?.9T(B) <nagai.nb @ ncos.nec.co.jp>
> Cc: pgpool-general-jp @ sraoss.jp
> Subject: Re: [pgpool-general-jp: 1441] $B%^%9%?%9%l!<%V%b!<%I$H%3%^%s%I%/(B
> $B%(%j%-%c%C%7%eM-8z;~$K(Bpgpool2$B$+$i1~Ez$,$3$J$/$J$k(B
> 
> $B @ P0f$G$9!#(B
> 
> $B:F8=%F%9%H$H%Q%C%A$N$4Ds0F$"$j$,$H$&$4$6$$$^$9!#(B
> 
> > $B:F8=$G$-$k%=!<%9$H!"G0$N0Y!"$3$A$i$N(Bpgpool.conf$B$rAw$j$^$9!#(B
> > pgpool 3.5.5$B$G$b:F8=$9$k$3$H$O3NG'$7$F$$$^$9!#(B
> >
> >
> > $BF0$-$H$7$F$O!"(B
> > $B-!(Bselect 1$B$r<B9T$7$F%-%c%C%7%e$KEPO?(B
> > $B-"(BAuto Commit $B$r(Boff
> > $B-#(Bselect 1$B$r<B9T$7$F%-%c%C%7%e$,%R%C%H(B
> > $B-$(Bselect * from test$B$r<B9T$9$k$H(Bpgpool$B$+$i1~Ez$,$J$$!#(B
> > $B$G$9!#(B
> 
> Auto commit$B$N(Bon/off$B$OL54X78$N$h$&$G!"%-%c%C%7%e$,%R%C%H$7$?8e<B%F!<%V(B
> $B%k(B
> $B$r%"%/%;%9$9$k%/%(%j$rEj$2$k$H$3$m$,%]%$%s%H$N$h$&$G$9!#(B
> ($B$G$J$$$H!"(Bdo_query()$B$,8F$P$l$J$$(B)
> 
> > $B$3$N;~$N(Bdebug5$B$N(Bpgpool.log$B$rE:IU$7$^$9!#(B
> > 643$B9TL\$G(B
> > $B!!(B2017-01-18 22:31:14: pid 750: DETAIL:  received kind 'P'(50) from
> > frontend
> > $B$G$9$,!"(B
> > $B!!(B2017-01-18 22:31:14: pid 750: DEBUG:  do_query: send flush message to
> > 0
> > $B$H$J$C$F$$$^$9!#(B
> >
> >
> >
> >
> > $B$=$7$F!"(Bpgpool3.5.4$B$K$O$J$j$^$9$,!"(B
> > pool_proto_modules.c$B$N(B Execute$B4X?t$G!"(B
> >   698         if (foundp)
> >   699         {
> >   700             pool_ps_idle_display(backend);
> >   701             pool_set_skip_reading_from_backends();
> >   702             pool_stats_count_up_num_cache_hits();
> >   703             pool_unset_query_in_progress();
> >   704
> >   705             /* */$B!z0J2<DI2C(B
> >   706             pool_unset_pending_response();
> >   707
> >   708             return POOL_CONTINUE;
> > $B$H!"=$@5$9$k$H-$$O2~A1$5$l$^$9!#(B
> 
> $B$O$$!"$3$N=$@5$GLdBj$,2r7h$9$k$3$H$r$3$A$i$G$b3NG'$7$^$7$?!#$3$N=$@5$O(B
> $B<!$N%^%$%J!<%P!<%8%g%s$KH?1G$5$l$^$9(B($BG0$N0Y$K(B3.5-stable$B$KBP$9$k(Bdiff$B$r(B
> $BE:(B
> $BIU$7$F$*$-$^$9(B)$B!#(B
> 
> $B$"$j$,$H$&$4$6$$$^$7$?!#(B
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
> > $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> >
> >> -----Original Message-----
> >> From: Nagai Nobuyuki($B1J0f(B $B?.9T(B)
> >> Sent: Wednesday, January 18, 2017 8:13 PM
> >> To: 'Tatsuo Ishii' <ishii @ sraoss.co.jp>
> >> Cc: pgpool-general-jp @ sraoss.jp
> >> Subject: RE: [pgpool-general-jp: 1441] $B%^%9%?%9%l!<%V%b!<%I$H%3%^%s(B
> $B%I%/(B
> >> $B%(%j%-%c%C%7%eM-8z;~$K(Bpgpool2$B$+$i1~Ez$,$3$J$/$J$k(B
> >>
> >> > $B$G$b%O%s%0$9$k$H$$$&$3$H$G$7$g$&$+!)(B
> >>
> >> $B<B:]$K$O(Bibatis$B$r;HMQ$7$?%"%W%j%1!<%7%g%s$G!"(B
> >> Auto Commit off$B$K$h$k(Bbegin$B$d!"(B
> >> $B%3%M%/%7%g%s%W!<%k$K$h$k@\B33NG'$G(Bselect 1$B$,N.$F$*$j!"(B
> >> $BC1=c$J(BSQL$BJ8$G$N:F8=%Q%?!<%s$H8@$&$N$O3NN)$G$-$F$$$^$;$s!#(B
> >>
> >> $B"(=t;v>p$K$h$j @ 8$J$^$J(BSQL$BJ8$rDs<($9$k$3$H$b$G$G$-$:(B
> >> $B!!$9$_$^$;$s!#(B
> >> $B!!C"$7!"%"%W%j$+$i(BDB$B$X$N=hM}$N @ hF,(B(ibatis$B$N%a%=%C%IC10L$G(B2$BH/L\$"$?(B
> $B$j(B)
> >> $B$G(B
> >> $B!!$[$\(B100%$BH/@8$7$F$$$k>u67$G$9!#(B
> >>
> >>
> >> $B$=$7$FD:$$$?(BSample.java$B$G<B9T$9$k$H!"$3$A$i$N4D6-$G$b @ 5>o=*N;$7$^$9!#(B
> >>
> >> $B"((Btcpdump$B$r$_$k$H2<5-%7!<%1%s%9$K$*$$$F!z$r<u?.$7$?(Bpgpool$B$+$i(B
> >> $B!!(BFlush$B$,Ht$P$:!"@5>o$K(BParse$B$r(BPostgreSQL$B$KAw?.$7$F$$$^$7$?!#(B
> >>
> >>
> >> $B$h$C$F!"$3$A$i$G$b4JC1$J:F8=%W%m%0%i%`$r:n @ .$7$F$_$^$9!#(B
> >> $B$=$l$G>e<j$/:F8=$G$-$?$i!":FEY!"%a!<%k$5$;$F2<$5$$!#(B
> >>
> >>
> >>
> >> > -----Original Message-----
> >> > From: Tatsuo Ishii [mailto:ishii @ sraoss.co.jp]
> >> > Sent: Wednesday, January 18, 2017 6:07 PM
> >> > To: Nagai Nobuyuki($B1J0f(B $B?.9T(B) <nagai.nb @ ncos.nec.co.jp>
> >> > Cc: ishii @ sraoss.co.jp; pgpool-general-jp @ sraoss.jp
> >> > Subject: Re: [pgpool-general-jp: 1441] $B%^%9%?%9%l!<%V%b!<%I$H%3%^(B
> $B%s%I(B
> >> $B%/(B
> >> > $B%(%j%-%c%C%7%eM-8z;~$K(Bpgpool2$B$+$i1~Ez$,$3$J$/$J$k(B
> >> >
> >> > > $B1J0f$G$9!#$*JV;v$"$j$,$H$&$4$6$$$^$9!#(B
> >> > >
> >> > > SQL$B$H$7$F$O(B
> >> > >
> >> > >> SELECT 1;	/* cache$B$J$7!#(Bcache$B$r:n$k(B */
> >> > >> SELECT 1;	/* cache$B$,$"$k$N$G(Bcache$B$rJV$9(B */
> >> > >> SELECT 2;	/* cache$B$J$7!#$3$3$G%O%s%0(B */
> >> > >
> >> > > $B$G!"F1$8G'<1$G$9$,!"(B3$B$DL\$N(Bcache$BM-L5$O4X78$J$$$+$H;W$$$^$9!#(B
> >> >
> >> > $B3NG'$G$9$,!"(B
> >> >
> >> > SELECT 1;	/* cache$B$J$7!#(Bcache$B$r:n$k(B */
> >> > SELECT 1;	/* cache$B$,$"$k$N$G(Bcache$B$rJV$9(B */
> >> > SELECT ;	/* cache$B$,$"$k$N$G(Bcache$B$rJV$9!#$3$3$G%O%s%0(B */
> >> >
> >> > $B$G$b%O%s%0$9$k$H$$$&$3$H$G$7$g$&$+!)(B
> >> >
> >> > > $B$G!"D:$$$?(Bpgpool.conf$B$G$9$,(B
> >> > > $B!!(Bmemory_cache_enabled = off
> >> > > $B$H$J$C$F$$$^$9!#(B
> >> >
> >> > pgpool.conf$B$N0lHV:G8e$N9T$K(B
> >> > memory_cache_enabled = on
> >> > $B$,$"$j$^$9!#(B
> >> >
> >> > >> > $B!!(Bmemory_cache_enabled = on
> >> > > $B$G;n$7$FD:$1$J$$$G$7$g$&$+!)(B
> >> > >
> >> > > $B"($3$A$i$G$O:F8=$7$J$$$h$&$G$7$?$i!"F1$8$h$&$J%_%K%W%m%0%i%`$r:n(B
> $B @ .(B
> >> $B$7(B
> >> > $B$F$_$^$9!#(B
> >> > >
> >> > >
> >> > >
> >> > > $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
> >> > >
> >> > >
> >> > >> -----Original Message-----
> >> > >> From: Tatsuo Ishii [mailto:ishii @ sraoss.co.jp]
> >> > >> Sent: Wednesday, January 18, 2017 5:40 PM
> >> > >> To: pgpool-general-jp @ sraoss.jp; Nagai Nobuyuki($B1J0f(B $B?.9T(B)
> >> > >> <nagai.nb @ ncos.nec.co.jp>
> >> > >> Subject: Re: [pgpool-general-jp: 1441] $B%^%9%?%9%l!<%V%b!<%I$H%3(B
> $B%^(B
> >> $B%s(B
> >> > $B%I%/(B
> >> > >> $B%(%j%-%c%C%7%eM-8z;~$K(Bpgpool2$B$+$i1~Ez$,$3$J$/$J$k(B
> >> > >>
> >> > >> $B @ P0f$G$9!#(B
> >> > >>
> >> > >> $B$9$_$^$;$s!#$h$/J,$+$i$J$+$C$?$N$G$9$,!"8=>]$N:F8=>r7o$H$7$F$O!"(B
> >> > >>
> >> > >> SELECT 1;	/* cache$B$J$7!#(Bcache$B$r:n$k(B */
> >> > >> SELECT 1;	/* cache$B$,$"$k$N$G(Bcache$B$rJV$9(B */
> >> > >> SELECT 2;	/* cache$B$J$7!#$3$3$G%O%s%0(B */
> >> > >>
> >> > >> $B$H$$$&$3$H$G$h$$$G$7$g$&$+!)E:IU$N$h$&$J8!>Z%W%m%0%i%`$r<B9T$7(B
> $B$F$_(B
> >> > $B$?$N(B
> >> > >> $B$G$9$,!"@5>o=*N;$7$^$7$?!#(BPgpool-II$B$N%P!<%8%g%s$O(B3.5 stable$B$N(B
> head
> >> > $B$G$9(B
> >> > >> (3.5.5$B$H$[$H$s$IF1$8(B)
> >> > >>
> >> > >> $B;29M$^$G$K(Bpgpool.conf$B$bIU$1$F$*$-$^$9!#4D6-$O!"(Bpgpool_setup$B$G(B
> $B:n$C(B
> >> $B$?(B
> >> > $B$b(B
> >> > >> $B$N(B
> >> > >> $B$G$9!#(B
> >> > >> --
> >> > >> Tatsuo Ishii
> >> > >> SRA OSS, Inc. Japan
> >> > >> English: http://www.sraoss.co.jp/index_en.php
> >> > >> Japanese:http://www.sraoss.co.jp
> >> > >>
> >> > >> > $B$O$8$a$^$7$F!"1J0f$H?=$7$^$9!#(B
> >> > >> >
> >> > >> > Java$B%"%W%j%1!<%7%g%s$+$i(Bpgpool-II$B$r2p$7$F!"(B
> >> > >> > PostgreSQL$B$K@\B3$7$F$$$^$9!#(B
> >> > >> >
> >> > >> > $BEv=i$O%G%U%)%k%H$N(Bpgpool.conf$B$G @ 5>o$KDL?.$,$G$-$F$$$?$N$G$9(B
> $B$,!"(B
> >> > >> >
> >> > >> > $B!!(Bmaster_slave_mode = on
> >> > >> > $B!!(Bmaster_slave_sub_mode = 'stream'
> >> > >> > $B!!(Bmemory_cache_enabled = on
> >> > >> > $B!!(Bmemqcache_method = 'shmem'
> >> > >> >
> >> > >> > $B$N @ _Dj$KJQ99$7$F$+$i!"(Bpgpool-II$B$+$i%"%W%j$KL51~Ez$K$J$k(B
> >> > >> > $B;v>]$,H/@8$7$^$7$?!#(B
> >> > >> >
> >> > >> > $B!!(BJava : 6
> >> > >> > $B!!(BJDBC$B%I%i%$%P(B : postgresql-9.4.1212.jre6.jar
> >> > >> > $B!!(Bpgpool-II : 3.5.4 (3.5.5$B$bF1MM(B)
> >> > >> > $B!!(BPostgreSQL : 9.5.5
> >> > >> > $B!!(BCentOS : 6.6
> >> > >> >
> >> > >> > $B$=$3$G!"(Btcpdump$B$H(Bpgpool-II 3.5.4$B$N%=!<%9%3!<%I$NIU$19g$o$;$r(B
> $B9T(B
> >> $B$C(B
> >> > $B$?$H(B
> >> > >> $B$3$m(B
> >> > >> > $B0J2<$N%3!<%I$KLdBj$,$"$k$h$&$K;W$$$^$7$?!#(B
> >> > >> > $B$=$3$G!"$3$A$i$ND4::$G:,K\E*$J4*0c$$$r$7$F$$$J$+$H;W$$!"$I$J(B
> $B$?$+(B
> >> $B$4(B
> >> > $B3N(B
> >> > >> $BG'D:$1$l$P9,$$$G$9!#(B
> >> > >> >
> >> > >> >
> >> > >> > $B!{DL?.(B
> >> > >> > $B!!(BAP$B!!!!!!!!!!!!!!!!!!!!!!(Bpgpool                 PostgreSQL
> >> > >> > $B!!"*(B P(select 1)/B/D/E/S$B"*(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"*(B P(select 1) $B"*(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"*(B B           $B"*(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"*(B D           $B"*(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"*(B H           $B"*(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"+(B 1/2/T       $B"+(B
> >> > >> > $B!!"+(B 1/2/T              $B"+(B
> >> > >> > $B!!"+(B D/C                $B"+(B
> >> > >> > $B!!"+(B Z                  $B"+(B
> >> > >> > $B!!"*(B P(delete $B!A(B)/B/D/E/S$B"*!z(B
> >> > >> > $B!!(B  $B!!!!!!!!!!!!!!!!!!!!!!(B     $B"*(B H           $B"*(B
> >> > >> > $B!!"((BB$B!D(BBind
> >> > >> > $B!!!!(BD$B!D(BDescribe
> >> > >> > $B!!!!(BE$B!D(BEexecute
> >> > >> > $B!!!!(BH$B!D(BFlush
> >> > >> > $B!!!!(BP$B!D(BParse
> >> > >> > $B!!!!(BS$B!D(BSync
> >> > >> >
> >> > >> > $B!{%3!<%I(B
> >> > >> > $B!!(Bpool_proto_modules.c:574 Execute$B4X?t$G!"%-%c%C%7%e$K%R%C%H(B
> $B$9$k(B
> >> $B$H(B
> >> > >> > $B!!(Bpool_unset_query_in_progress()$BEy$r8F$S=P$7$F(B
> >> > >> > $B!!(B704$B9TL\$G%j%?!<%s$7$F$$$^$9!#(B
> >> > >> >
> >> > >> > $B!!%-%c%C%7%e$K%R%C%H$7$J$$$H!"(Bmaster_slave_mode = on$B$J$i(B
> >> > >> > $B!!(B786$B9TL\$G(B pool_unset_pending_response() $B$r8F$S=P$7$F$+$i(B
> >> > >> > $B!!%j%?!<%s$7$F$$$^$9!#(B
> >> > >> >
> >> > >> > $B!!$D$^$j%-%c%C%7%e$,$"$k$H(Bpending_response$B$,(Btrue$B$K$J$C$?$^(B
> $B$^$G!"(B
> >> > >> > $B!!<!$N%/%(%j$,Mh$k$H(B($B!z(B)
> >> > >> > $B!!(Bpool_process_query.c:1980 do_query$B4X?t$G(BFlush$B$rH/9T$7!"(B
> >> > >> > $B!!$7$+$7(BPostgreSQL$B$+$i$O1~Ez$,$J$$$?$a!"(B2009$B9TL\$G%?%$%`%"%&(B
> $B%H(B
> >> $B$9(B
> >> > $B$k(B
> >> > >> > $B!!$^$G%k!<%W$7B3$1$k$N$G$O$J$$$+!)(B
> >> > >> >
> >> > >> > $B!!"((Bpool_is_pending_response$B4X?t$O(B
> >> > >> > $B!!(B    master_slave_mode = on
> >> > >> >   $B!!(B  master_slave_sub_mode = 'stream'
> >> > >> >     $B0J30$G$O8GDj(Bfalse$B$G!"(BFlush$B$rH/9T$9$k%k!<%H$K$J$i$J$$!#(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 メーリングリストの案内