[pgpool-general-jp: 1446] Re: マスタスレーブモードとコマンドクエリキャッシュ有効時にpgpool2から応答がこなくなる
Nobuyuki Nagai
nagai.nb ＠ ncos.nec.co.jp
2017年 1月 18日 (水) 22:52:43 JST
$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
$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
$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: pgpool.conf
$B7?(B: application/octet-stream
$B%5%$%:(B: 34691 $B%P%$%H(B
$B ＠ bL@(B: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20170118/d0b4def3/attachment-0003.obj>
-------------- next part --------------
$B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
$B%U%!%$%kL>(B: Sample.java
$B7?(B: application/octet-stream
$B%5%$%:(B: 1353 $B%P%$%H(B
$B ＠ bL@(B: Sample.java
URL: <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20170118/d0b4def3/attachment-0004.obj>
-------------- next part --------------
$B%F%-%9%H7A<00J30$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
$B%U%!%$%kL>(B: pgpool.log
$B7?(B: application/octet-stream
$B%5%$%:(B: 54091 $B%P%$%H(B
$B ＠ bL@(B: pgpool.log
URL: <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20170118/d0b4def3/attachment-0005.obj>
pgpool-general-jp メーリングリストの案内