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

Tatsuo Ishii ishii @ sraoss.co.jp
2017年 1月 19日 (木) 08:00:23 JST


$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%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$rE:(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%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\$"$?$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%^%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$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%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$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(Bhead
>> > $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: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!!(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$;$r9T(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$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$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$?$^$^$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%?%$%`%"%&%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
-------------- next part --------------
$B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
$B%U%!%$%kL>(B: query_cache.diff
$B7?(B:         text/x-patch
$B%5%$%:(B:     482 $B%P%$%H(B
$B @ bL@(B:       $BL5$7(B
URL:        <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20170119/0405db7c/attachment.bin>


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