[pgpool-general-jp: 527] Re: pg_pool2について
Tatsuo Ishii
ishii ＠ sraoss.co.jp
2009年 1月 9日 (金) 12:40:17 JST
$B ＠ P0f$G$9!%(B
> > $B2?$+$N860x$G=LB`$,H/@8$7!$$=$l$K5$IU$+$:(Bpgpool$B$r$7$P$i$/;H$C$F$$$F!$$=(B
> > $B$N8e(Bpgpool$B$r:F5/F0$7$?!$$H$$$&2DG=@-$b$"$k$H;W$$$^$9$,!$G!2?$G$7$g$&$+!)(B
>
> $B:90[$N$"$C$?%F!<%V%k(B(insert$B$N$_$N%l%3!<%I(B)$B$N3:Ev%l%3!<%I$NA08e(B
> 1$BIC$"$?$j$K$b%l%3!<%I$O(Binsert$B$5$l$F$*$j$^$9$N$G!"=LB`"*:F5/F0"*(B
> $B$=$N$^$^1?MQ$H$$$&E@$OL5$$$+$H;W$$$^$9!#$b$A$m$s:F5/F0$b9T$C$F(B
> $B$*$j$^$;$s!#(B
>
>
> > $B$=$&$G$J$$$H$9$k$H!$$"$H$O!$%l%3!<%I7o?t$,0[$J$k$H$$$&$3$H$O!$(B
> >
> > - $B$I$A$i$+$N%N!<%I$G(BINSERT$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B
> > - $B$I$A$i$+$N%N!<%I$G(BDELETE$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B
> >
> > $B$N$I$A$i$+$K$J$k$H;W$$$^$9!%$?$@!$$3$N>l9g$O(Bpgpool$B$+(BPostgreSQL$B$N%m%0$K(B
> > $B2?$+=q$+$l$F$$$k$O$:$G$9$,!$$=$NE@$O$$$+$,$G$7$g$&$+!)(B
>
> $B%m%0$K=PNO$5$l$F$$$l$F$$$k$+$H;W$$3NG'$7$?$N$G$9$,!"(B
> postgresql.log$B!&(Bpgpool.log$BN>J}$H$b2?$b=PNO$5$l$F$$$^$;$s$G$7$?!#(B
> $B$=$N8e$K!">e5-8=>]$,5/$3$C$?8e$K$=$N%l%3!<%I%"%/%;%9$7$?;~$K(B
> $B%m!<%k%P%C%/MQ$N%/%(%j!<$N%m%0$,=P$F$$$^$7$?!#(B
>
> ERROR: syntax error at or near "send" at character 1
> STATEMENT: send invalid query from pgpool to abort transaction
$B$3$l$O ＠ 5>o$G$9!%(B
>
> $B0J>e$+$i2?$+J,$+$k;v$O$4$6$$$^$9$G$7$g$&$+!)(B
$B0l ＠ Z(BPostgreSQL$B$N%m%0$K$b(BERROR$B$,=P$F$$$J$$$H$9$k$H!$$A$g$C$H$o$+$j$^$;(B
$B$s!%(Bpgpool$B$r7PM3$7$J$$$G(BPostgreSQL$B$K%"%/%;%9$9$k7PO)$,$J$$$+$H$+!$2?$+(B
$BFC<l$J%H%j%,$r;H$C$F$$$k$H$+0L$G$9$M!%(B
$B8eJ,$+$C$F$$$k%P%0$H$7$F$O!$(B
- SERIALIZABLE$B$NJ,N%%l%Y%k$r;H$C$F$$$k>l9g$K!$$"$k%1!<%9$G%G!<%?$NIT(B
$B ＠ 09g$,5/$-$k(B
- $B%/%(%j$N%-%c%s%;%k$r$9$k$H!$%G!<%?$NIT ＠ 09g$,5/$-$k$3$H$,$"$k(B
$B$H$$$&$N$,$"$j$^$9$,!$$3$l$i$N%1!<%9$G$O(BPostgreSQL$B$N%m%0$K%(%i!<$,5-O?(B
$B$5$l$k$N$G!$:#2s$N%1!<%9$K$O3:Ev$7$J$$$h$&$G$9!%(B
> $BDI5-$H$J$j$^$9$,!":#2s$N8=>]$K$D$$$F$O!"=5$K(B1,2$B2sDxEY$GH/@8$7(B
> $B$F$*$j$^$9!#(B
>
> $B$^$?!">e5-$H$O4XO"$7$F!"#2Bf$h$j%N!<%I?t$rB?$/$7$?>l9g$K ＠ _Dj(B
> $B$J$I$K9MN8$OI,MW$G$7$g$&$+!)(B
$BFC$KI,MW$"$j$^$;$s!%(B
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> $B0J>e$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
>
> On Thu, 08 Jan 2009 20:01:04 +0900 (JST)
> Tatsuo Ishii <ishii ＠ sraoss.co.jp> wrote:
>
> > $B ＠ P0f$G$9!%K\G/$b$h$m$7$/$*4j$$$7$^$9!%(B
> >
> > > $B ＠ hF|!"%a!<%k$5$;$F$$$?$@$$$?EgE{$G$9!#(B
> > >
> > > $BK\G/$b$h$m$7$/$*4j$$$7$^$9!#(B
> > >
> > > $B0JA0$K$b<ALd$5$;$F$$$?$@$-$^$7$?$,!"(Bpg_pool2$B$N%P!<%8%g%s$K8m(B
> > > $B$j$,$4$6$$$^$7$?$N$G!":FEY$4<ALd$5$;$F$$$?$@$-$^$9!#(B
> > >
> > > $B3F%5!<%P4V$N%l%3!<%I$K:90[$,H/@8$7$?8=>]$,3NG'$5$l$?$b$N$O!"(B
> > > $B%P!<%8%g%s(B 2.1-beta2$B$r;HMQ$7$F$*$j$^$7$?!#(B
> > >
> > > $B2~$a$F<ALd$5$;$F$$$?$@$-$^$9$,!"(Bpg_pool2$B$, ＠ 5>o$K5/F0$7$F$$$k(B
> > > $B$K$b$+$+$o$i$:!"99?77O%/%(%j$,A4$F$N%5!<%P$KH?1G$5$l$J$$2DG=(B
> > > $B ＠ -$O$4$6$$$^$9$G$7$g$&$+!#(B
> >
> > $B2?$+$N860x$G=LB`$,H/@8$7!$$=$l$K5$IU$+$:(Bpgpool$B$r$7$P$i$/;H$C$F$$$F!$$=(B
> > $B$N8e(Bpgpool$B$r:F5/F0$7$?!$$H$$$&2DG=@-$b$"$k$H;W$$$^$9$,!$G!2?$G$7$g$&$+!)(B
> >
> > $B$=$&$G$J$$$H$9$k$H!$$"$H$O!$%l%3!<%I7o?t$,0[$J$k$H$$$&$3$H$O!$(B
> >
> > - $B$I$A$i$+$N%N!<%I$G(BINSERT$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B
> > - $B$I$A$i$+$N%N!<%I$G(BDELETE$B$,<B9T$5$l$F$$$J$$$3$H$,$"$C$?(B
> >
> > $B$N$I$A$i$+$K$J$k$H;W$$$^$9!%$?$@!$$3$N>l9g$O(Bpgpool$B$+(BPostgreSQL$B$N%m%0$K(B
> > $B2?$+=q$+$l$F$$$k$O$:$G$9$,!$$=$NE@$O$$$+$,$G$7$g$&$+!)(B
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> >
> > > $B0J>e(B
> > >
> > > On Wed, 24 Dec 2008 18:41:32 +0900
> > > $BEgE{(B $B9LJ?(B <k.shimadutsu ＠ 4qualia.co.jp> wrote:
> > >
> > > >
> > > > $B ＠ P0fMM(B
> > > >
> > > > $BEgE{$G$9!#(B
> > > >
> > > > $BAa5^$J$42sEz$"$j$,$H$&$4$6$$$^$9!#(B
> > > > $B4pK\E*$K$"$k%5!<%P$N0l$D$G%(%i!<$,H/@8$7!":90[$,H/@8$9$k$h$&(B
> > > > $B$J>u67$K$J$k$H ＠ Z$jN%$5$l$k$3$H$H$$$&$3$H$GG'<1$$$?$7$^$7$?!#(B
> > > >
> > > > $B ＠ P0fMM$h$j<ALd$$$?$@$$$?E@$K$D$$$F$O!"0J2<$K2sEz$5$;$F$$$?$@(B
> > > > $B$-$^$7$?!#(B
> > > >
> > > > > $B$=$&;W$o$l$?M}M3$r6qBNE*$K65$($FD:$1$^$9$+!)(B
> > > >
> > > > PostgreSQL$B$N%m%0$K%(%i!<$,H/@8$7$F$$$J$$$N$K!"%5!<%P4V$N%l%3(B
> > > > $B!<%I7o?t$K:90[$,$"$C$?$3$H(B
> > > > $B$^$?!"0J2<$N$h$&$J(BSQL$B$r%W%m%0%i%`$+$i<B9T$7$F$$$k$N$G$9$,!"(B
> > > > $B3F%5!<%P$r3NG'$9$k$H%l%3!<%I$,B8:_$7$J$$%5!<%P$,8+$D$+$C$?$3$H(B
> > > >
> > > > CREATE TABLE table_a
> > > > (
> > > > user_id int not null,
> > > > item_id int not null,
> > > > regist_date timestamp without time zone not null,
> > > > PRIMARY KEY (user_id ,item_id)
> > > > )
> > > >
> > > > INSERT INTO table_a ( user_id ,item_id regist_date )
> > > > VALUES ( 1 ,1 ,'2008-12-22 00:05:00' );
> > > >
> > > > $B>e5-$K$D$$$F!"%"%I%P%$%9$dD4::J}K!Ey$4$6$$$^$7$?$i!"$465<x$$$?(B
> > > > $B$@$1$l$P$H;W$$$^$9!#(B
> > > >
> > > >
> > > > $B0J>e(B
> > > >
> > > > On Tue, 23 Dec 2008 21:56:13 +0900 (JST)
> > > > Tatsuo Ishii <ishii ＠ sraoss.co.jp> wrote:
> > > >
> > > > > $B ＠ P0f$G$9!%(B
> > > > >
> > > > > > $B$O$8$a$^$7$F!"EgE{$H?=$7$^$9!#(B
> > > > > >
> > > > > > $B8=:_(Bpgpool2$B$r;HMQ$7$F$*$j!"(BDB$B%5!<%P$r(B4$BBf=`Hw$7$F$$$k$N$G$9$,!"(B
> > > > > > $B5)$K%5!<%P4V$N%l%3!<%I?t$K:90[$, ＠ 8$8$F$7$^$&8=>]$,H/@8$$$?$7(B
> > > > > > $B$^$7$?!#(B
> > > > > > $B7k2L$r8+$k$H!"(BINSERT$B$N=hM}$,ESCf$G3F%5!<%P$K<B9T$5$l$kESCf$G(B
> > > > > > $B;_$^$C$F$$$k$h$&$K;W$o$l$^$9!#(B
> > > > >
> > > > > $B$=$&;W$o$l$?M}M3$r6qBNE*$K65$($FD:$1$^$9$+!)(B
> > > > >
> > > > > > $B0J2<(B3$BE@!"ITL@$JE@$,$"$j!"<ALd$5$;$F$$$?$@$-$^$9!#(B
> > > > > >
> > > > > > $B-!(Bpgpool$B$,=hM}Cf$K(B1$B$D$N%5!<%P$KBP$7%(%i!<$,H/@8$7$?>l9g$K$O!"(B
> > > > > > $B!!(Bpgpool2$B$,<B9T$7$?B>$N=hM}$r%m!<%k%P%C%/$5$l$k!#(B
> > > > > > $B!!$3$A$i$NG'<1$K4V0c$$$O$4$6$$$^$;$s$G$7$g$&$+!#(B
> > > > >
> > > > > SQL$B$N<B9T%(%i!<$K$J$k>l9g$O!$7k2L$H$7$F$=$&$J$j$^$9(B($BF1$8%(%i!<%/%(%j$,(B
> > > > > $BAw?.$5$l$k$?$a(B)$B!%(B
> > > > >
> > > > > $B$=$&$G$O$J$/$F!$$?$^$?$^$"$k%5!<%P$@$1$,%(%i!<$r5/$7!$B>$N%5!<%P$O ＠ 5>o(B
> > > > > $B$K%3%_%C%H$5$l$?>l9g$O!$%m!<%k%P%C%/$9$k$N$G$O$J$/!$%(%i!<$r5/$7$?%5!<(B
> > > > > $B%P$r ＠ Z$jN%$9$3$H$K$h$C$F!$A4BN$H$7$F ＠ 09g@-$rJ]$D$N$,(Bpgpool-II$B$NJ}?K$G(B
> > > > > $B$9!%(B
> > > > >
> > > > > > $B-"(BWEB$B%5!<%PB&$+$i(Bpgpool$B$X$N%3%M%/%7%g%s$,6/@)E*$K ＠ ZCG$5$l$?(B
> > > > > > $B!!>l9g$J$I%m!<%k%P%C%/$5$l$J$$2DG=@-$O$4$6$$$^$9$G$7$g$&$+!#(B
> > > > >
> > > > > $B$J$$$H;W$$$^$9!%(B
> > > > >
> > > > > > $B-#>e5-0J30$K!"(Bpgpool$B$, ＠ 5>o$K5/F0$7$F$$$k$K$b$+$+$o$i$:!"99?7(B
> > > > > > $B!!7O%/%(%j$,A4$F$N%5!<%P$KH?1G$5$l$J$$2DG=@-$O$"$j$^$9$G$7$g(B
> > > > > > $B!!$&$+!#(B
> > > > >
> > > > > $B$*;H$$$N%P!<%8%g%s$O8E$$$N$G!$%P%0$KAx6x$7$F$$$k2DG=@-$O$"$k$H;W$$$^$9!%(B
> > > > >
> > > > > $B$"$H!$:G?7$N%P!<%8%g%s$G$b!$%H%i%s%6%/%7%g%s$NJ,N%%l%Y%k$K(BSERIALIZABLE
> > > > > $B$r;H$C$F$$$k:]$KLdBj$,5/$-$k2DG=@-$,$"$j$^$9(B($B<!$N%P!<%8%g%s$G=$@5M=Dj(B)$B!%(B
> > > > >
> > > > > > $B4D6-$H$7$F$O!"(BWEB(PHP)+DB(pgpool2,postgres)4$BBf$N9=@.$H$J$C$F(B
> > > > > > $B$*$j!"0J2<$N$h$&$J%P!<%8%g%s$r;HMQ$7$F$*$j$^$9!#(B
> > > > > > $B$J$*!"(BNOW()$B4X?t$H(Bserial$B7?$N%+%i%`$O<BAu$7$F$*$j$^$;$s!#(B
> > > > >
> > > > > $B<!$N%P!<%8%g%s$G$O!$(BSERIAL$B7?$b;H$($k$h$&$K$J$kM=Dj$G$9!%(B
> > > > >
> > > > > now()$B$O(B...$B9M$(Cf(B:-)
> > > > > --
> > > > > Tatsuo Ishii
> > > > > SRA OSS, Inc. Japan
> > > > >
> > > > > > $B4D6-(B
> > > > > > WEB
> > > > > > $B!!(BPHP$B%P!<%8%g%s(B $B!!!!(B5.2$B7O(B
> > > > > > $B!!(BApache$B%P!<%8%g%s!!(B2.0$B7O(B
> > > > > > $B!!(BOS$B!!!!!!!!!!!!!!!!(BFedora Core 3
> > > > > >
> > > > > > DB
> > > > > > $B!!(Bpgpool$B%P!<%8%g%s!!(B2.0.1
> > > > > > $B!!%5!<%PBf?t!!!!!!!!(B4$BBf(B
> > > > > > $B!!(BOS$B!!!!!!!!!!!!!!!!(BFedora Core 3
> > > > > > $B!!(BDB$B%P!<%8%g%s!!!!!!(BPostgres 8.2.4
> > > > > >
> > > > > > $B"((BApache$B$N%m%0%m!<%F%$%H$N;~4V$O(B0$B;~$G!"%m!<%F%$%H$N%?%$%_%s%0(B
> > > > > > $B!!$G(BKill Hup$B%3%^%s%I$,<B9T$5$l$F$$$^$9!#(B
> > > > > >
> > > > > > $B2?B4!"$h$m$7$/$*4j$$$7$^$9!#(B
> > > > > >
> > > > > >
> > > > > > $B0J>e(B
> > > > > >
> > > > > > $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> > > > > > $B(#(%!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(&($(B
> > > > > > $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > > > $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > > > $B!C!!")(B141-0031$B!!El5~ETIJ ＠ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> > > > > > $B!C!!(BTEL: 03-5759-0292 FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > > > $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> > > > > > $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> > > > > >
> > > >
> > > > $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> > > > $B(#(%!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(&($(B
> > > > $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B!C!!")(B141-0031$B!!El5~ETIJ ＠ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> > > > $B!C!!(BTEL: 03-5759-0292 FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > > $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> > > > $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> > > >
> > >
> > > $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> > > $B(#(%OB!zI.;&!!%G%3$j?M!!!A<c<T$h!"F|K\$N$?$a$K%a!<%k$r;H$(!*!A!!(&($(B
> > > $B!C!!!!!!(Bhttp://decori.4qualia.co.jp/$B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > $B!C!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > $B!C!!")(B141-0031$B!!El5~ETIJ ＠ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> > > $B!C!!(BTEL: 03-5759-0292 FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> > > $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> > > $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
> > >
>
> $B""(#(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!($"#(B
> $B(#(%OB!zI.;&!!%G%3$j?M!!!A<c<T$h!"F|K\$N$?$a$K%a!<%k$r;H$(!*!A!!(&($(B
> $B!C!!!!!!(Bhttp://decori.4qualia.co.jp/$B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!3t<02q<R%U%)!<!&%/%*%j%"!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!!!!!EgE{!!9LJ?!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B!C!!")(B141-0031$B!!El5~ETIJ ＠ n6h@>8^H?ED(B8-3-16 $B%@%t%#%s%A@>8^H?ED-6(B7F $B!C(B
> $B!C!!(BTEL: 03-5759-0292 FAX: 03-5759-0293$B!!!!!!!!!!!!!!!!!!!!!!!!!!!C(B
> $B(&($(Bhttp://www.4qualia.co.jp/ $B!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(#(%(B
> $B"#(&(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(!(%""(B
>
pgpool-general-jp メーリングリストの案内