<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:$B%a%$%j%*(B
}
</style>
</head>
<body class='hmmessage'>
$B@P0fMM(B<BR>
<BR>
$B$*@$OC$K$J$j$^$9!#(B<BR>
$B2<5-$4JV?.@?$K$"$j$,$H$&$4$6$$$^$9!#(B<BR> <BR>
> > $B"M(Bupdate$B$N5sF0$H$7$F$O!J$*$=$i$/(Bdelete$B$b!)!K99?77k2L$N7o?t$,0[$J$k(B<BR>> > $B!!>l9g$G$b=LB`$7$J$$$b$N$J$N$G$7$g$&$+!)(B<BR>> <BR>> INSERT$B$b$=$&$G$9(B($B$a$C$?$K5/$-$^$;$s$,(B)$B!#(B<BR>> <BR>> $B$?$@!"$3$N%1!<%9$G=LB`$7$J$$$N$,2L$?$7$FNI$$$N$+$I$&$+$K4X$7$F$O5DO@$N(B<BR>> $BM>CO$,$"$k$H$3$m$@$H;W$$$^$9!#(B<BR>> <BR>> $B$b$7(Breplication_stop_on_mismatch$B$,(Btrue$B$N>l9g$K$O!"$3$N%1!<%9$G=LB`$5$;$k$h(B<BR>> $B$&$K$9$k$H$7$F!";?@.!"H?BP$NJ}$N$40U8+$r9-$/;G$$$?$$$H;W$$$^$9!#(B<BR><BR>
$B3N$+$K0B0W$K=LB`$O:$$kJ}$b$*$*$$$+$H;W$$$^$9!#(B<BR>
<BR>
$B$"$j$,$H$&$4$6$$$^$7$?!#(B<BR>
<BR>
$B0J>e$G$9!#(B<BR>
<BR>> Date: Wed, 8 Jul 2009 09:21:55 +0900<BR>> To: pgpool-general-jp@sraoss.jp; kei_wings@hotmail.com<BR>> Subject: Re: [pgpool-general-jp: 571] replication_stop_on_mismatch<BR>> From: ishii@sraoss.co.jp<BR>> <BR>> > $B8=:_(Bpgpool-II-2.2.2$B$G(B<BR>> > $B%P%C%/%(%s%I#2Bf$G%l%W%j%1!<%7%g%s%b!<%I$G;HMQ$7$F$*$j$^$9!#(B<BR>> > <BR>> > pgpool.conf$B$G4X78$9$k$H;W$o$l$k@_Dj2U=j$rH4?h$7$^$9!#(B<BR>> > <BR>> > replication_mode : true<BR>> > load_balance_mode : false<BR>> > replicate_select : false<BR>> > replication_stop_on_mismatch : true<BR>> > <BR>> > $B%^%K%e%"%k>e(Breplication_stop_on_mismatch$B$N@bL@$H$7$F(B<BR>> > true$B$r;XDj$9$k$HIT0lCW$,$"$C$?>l9g(B<BR>> > $B$K6/@)E*$K=LB`1?E>$KF~$k$H$$$&5-=R$,$"$j$^$7$?$N$G(B<BR>> > $B;n$7$K0[$J$k7o?t$N%F!<%V%k$rMQ0U$7$F!"(Bselect $B$H(B update$B$r<B9T$7$F$_$^$7$?!#(B<BR>> > <BR>> > $B!|7o?t$,0[$J$k$h$&$K(Bselect$BJ8$rH/9T$9$k$H<g7O$N7k2L$,JV$C$F$-$^$7$?!#(B<BR>> > replicate_select : false$B$G$"$k$?$a!";EMMDL$j$NF0$-$HM}2r$7$F$*$j$^$9!#(B<BR>> > <BR>> > $B"M$3$3$G%(%i!<$rH/@8$5$;$k$?$a$K$O!V(Breplicate_select : true$B!W$H$9$kB>$J$$$N$G$7$g$&$+!)(B<BR>> <BR>> $B$O$$!"$=$&$G$9!#(B<BR>> <BR>> > $B!|99?77o?t$,0[$J$k$h$&$K(Bupdate$B$rH/9T$9$k$H!"%(%i!<$,H/@8$7$^$7$?$,(B<BR>> > $B=LB`$7$^$;$s$G$7$?!#(B<BR>> > <BR>> > $B%m%0$K$O2<5-$@$1=PNO$5$l$F$$$^$7$?!#(B<BR>> > $B!!!!(Bpgpool detected difference of the number of inserted, updated or delete<BR>> > d tuples. Possible last query was: "update tellers set bid=1 where tid=8;<BR>> > $B!!!!(B<BR>> > replicate_select : true$B$H$7$FF1MM$K(Bupdate$B$r;n$7$^$7$?$,!"$d$O$j7k2L$O(B<BR>> > $BF1$8$G$7$?!#!J(Breplicate_select$B$J$N$G4X78$J$$$G$9$h$M!K(B<BR>> > <BR>> > $B"M(Bupdate$B$N5sF0$H$7$F$O!J$*$=$i$/(Bdelete$B$b!)!K99?77k2L$N7o?t$,0[$J$k(B<BR>> > $B!!>l9g$G$b=LB`$7$J$$$b$N$J$N$G$7$g$&$+!)(B<BR>> <BR>> INSERT$B$b$=$&$G$9(B($B$a$C$?$K5/$-$^$;$s$,(B)$B!#(B<BR>> <BR>> $B$?$@!"$3$N%1!<%9$G=LB`$7$J$$$N$,2L$?$7$FNI$$$N$+$I$&$+$K4X$7$F$O5DO@$N(B<BR>> $BM>CO$,$"$k$H$3$m$@$H;W$$$^$9!#(B<BR>> <BR>> $B$b$7(Breplication_stop_on_mismatch$B$,(Btrue$B$N>l9g$K$O!"$3$N%1!<%9$G=LB`$5$;$k$h(B<BR>> $B$&$K$9$k$H$7$F!";?@.!"H?BP$NJ}$N$40U8+$r9-$/;G$$$?$$$H;W$$$^$9!#(B<BR>> <BR>> > $B$^$?%^%K%e%"%k>e(Breplication_stop_on_mismatch$B$N@bL@$K$"$k(B<BR>> > $B!V%^%9%?!<(BDB$B$HB>$N(BDB$B%N!<%I$N4V$G%G!<%?$NIT0lCW$,$"$C$?>l9g(B<BR>> > $B!W(B<BR>> > $B$H$O2?$r$b$C$FIT0lCW$H$7$F$$$k$N$G$7$g$&$+!)(B<BR>> <BR>> $B!V(BPostgreSQL$B$+$iN.$l$F$/$k1~Ez%Q%1%C%H$N?t$d<oN`$,0[$J$C$?$H$-!W$H$$$&(B<BR>> $B$N$,0lHV@53N$J@bL@$G$9!#E57?E*$JNc$H$7$F$O!"(BSELECT$B$,JV$97o?t$,0[$J$C$?(B<BR>> $B$H$-!"(BPostgreSQL$B$N%/%(%j<B9T7k2L$G!"JRJ}$,@5>o=*N;!"$b$&0lJ}$,0[>o=*N;!"(B<BR>> $B$J$I$N>l9g$G$9!#(B<BR>> --<BR>> Tatsuo Ishii<BR>> SRA OSS, Inc. Japan<BR><br /><hr />$B!Z(BMSN$BAjCLH"![%a!<%k$GJ9$$$FJ,$+$i$J$$$3$H(BMSN$BAjCLH"$GD4$Y$F8+$h$&(B <a href='http://clk.atdmt.com/GBL/go/130818982/direct/01/' target='_new'>$B"%"%"%(B130$BK|?M0J>e$,;H$C$F$$$k(BMSN$BAjCLH"$J$i8+$D$+$j$^$9!*"%"%"%(B</a></body>
</html>