[pgpool-general-jp: 1294] Re: =?ISO-2022-JP?B?cGdwb29sLRskQnxyGyhC?= =?ISO-2022-JP?B?GyRCJWwlVyVqJTEhPCU3JWclcyViITwlSSROJUchPCU/MGxDVyVVGyhC?= =?ISO-2022-JP?B?GyRCJSklbSE8SE8wTyRLJEQkJCRGGyhC?=

2014年 6月 27日 (金) 09:12:27 JST

TO : $B ＠ P0fMM(B

$B$*@$OC$K$J$C$F$*$j$^$9!#A0ED$G$9!#(B

$B$42sEz$"$j$,$H$&$4$6$$$^$9!#(B

>> $B$A$J$_$K!"%3%_%C%H<:GT;~$N5sF0$O!"0J2<$N$h$&$K$J$j$^$9$G$7$g$&$+!)(B
>> $B!t(Bbackend0$B$G<:GT$7$?>l9g$O!"(Bbackend1$B$X$N(Bcommit$B<+BN$,9T$o$l$J$$G'<1$G$9!#(B
>> $B$=$N$?$a!"(Bbackend0$B$N(Bcommit$B<:GT!\(Bbackend1$B$N(Bcommit$B ＠ .8y$OL5$$$H;W$C$F$$(B
$B$^$9!#(B
>
> $B5U$G$9$M!#%3%_%C%H$O!"(Bbackend0($B$H$$$&$+ ＠ 53N$K$O%^%9%?!<(B)$B0J30$+$i9T$$$^(B
> $B$9!#$=$l$i$, ＠ .8y$7$?$i(Bbackend0$B$r%3%_%C%H$7$^$9!#$J$N$G!"(Bbackend0$B$H(B
> backend1$B$7$+$J$$>l9g$K$O!"(B
>
>> $B-!(Bbackend0$B$G(Bcommit$B<:GT(B
>> $B"M(Bbackend1$B$X$N(Bcommit$B$O9T$o$:!"%H%i%s%6%/%7%g%s%"%\!<%H(B
>
> $B-!(Bbackend1$B$G(Bcommit$B<:GT(B
> $B"M(Bbackend0$B$X$N(Bcommit$B$O9T$o$:!"%H%i%s%6%/%7%g%s%"%\!<%H(B
>
>> $B-"(Bbackend0$B$G(Bcommit$B ＠ .8y"M(Bbackend1$B$G(Bcommit$B<:GT(B
>> $B"M(Bbackend0$B$KH?1G!\%H%i%s%6%/%7%g%s%"%\!<%H(B
>
> $B-"(Bbackend1$B$G(Bcommit$B ＠ .8y"M(Bbackend10commit$B<:GT(B
> $B"M(Bbackend1$B$KH?1G!\%H%i%s%6%/%7%g%s%"%\!<%H(B

$B$J$k$[$I!"$=$l$G$O!"%/%i%$%"%s%HB&$,G'<1=PMh$k%G!<%?$N>uBV$H(B
backend0$B$N%G!<%?>uBV$O0lCW$9$k$h$&$K$J$C$F$$$k$H$$$&$3$H$G$9$M!#(B
$B!t%3%_%C%H$N ＠ .H]$K$h$C$F!"(Bbackend1$BB&$,??$H$J$k%1!<%9$,L5$$$+$r(B
  $B7|G0$7$F$$$?$N$G$9$,!"LdBjL5$5$=$&$G$9$M!#(B

>
>> $B$^$?!"%3%_%C%H<:GT$N%G!<%?:9J,H/@8;~$K;v>]$r8!CN$9$k$3$H$O2DG=$G$7$g(B
$B$&$+!)(B
>> $B!t(Bpgpool$B$N%m%0%U%!%$%k$"$?$j$K=PNO$5$l$^$9$G$7$g$&$+!)(B
>
> $B0l1~%(%i!<$,5/$3$k$?$S$K%m%0$,=PNO$5$l$k$N$G!"%/%(%j%m%0$rM-8z$K$7$F$*(B
> $B$1$P!"%3%_%C%H$G>e5-$N;v>]$,5/$3$C$?$3$H$OCm0U?<$/%m%0$rDI$($PJ,$+$j$^(B
> $B$9!#(B

$BN;2r$G$9!#$42sEz$"$j$,$H$&$4$6$$$^$9!#(B
$B$3$l$G!"Dj4|E*$J%*%s%i%$%s%j%+%P%j0J30$NJ}K!$b8!F$=PMh$=$&$G$9!#(B

$B=h!9$465<(D:$-$"$j$,$H$&$4$6$$$^$7$?!#(B

$B0J>e$G$9!#$h$m$7$/$*4j$$$$$?$7$^$9!#(B

(2014/06/26 23:30), Tatsuo Ishii wrote:
> $BA0EDMM(B
> 
> $B$3$A$i$3$=$*@$OC$K$J$C$F$$$^$9!#(BSRA OSS$B$N ＠ P0f$G$9!#(B
> 
>> $B$*@$OC$K$J$C$F$*$j$^$9!#A0ED$G$9!#(B
>>
>>> $B$A$g$C$H8m2r$,$"$k$h$&$J5$$,$7$^$9!#(B
>>>
>>> $B%l%W%j%1!<%7%g%s%b!<%I$K$*$$$F$O!"99?7%/%(%j$OI,$:L@<(E*$J%H%i%s%6%/%7%g(B
>>> $B%sFb$G<B9T$5$l$^$9!#(B($B$b$7%f!<%6$,L@<(E*$J%H%i%s%6%/%7%g%s$r$9$G$K3+;O$7(B
>>> $B$F$$$k>l9g$O!"$b$A$m$s99$K%H%i%s%6%/%7%g%s$r3+;O$7$?$j$O$7$^$;$s(B)$B!#(B
>>>
>>> $B$=$NCf$G<B9T$5$l$?(Bwrite$B%/%(%j$N7k2L$,0lCW$7$J$+$C$?$j!"%(%i!<$K$J$C$?>l(B
>>> $B9g$O!"$=$N%H%i%s%6%/%7%g%s$,%"%\!<%H$5$l$F%G!<%?$,85$KLa$k$N$G!"$=$NCJ(B
>>> $B3,$G(BDB$B$K:9J,$,=P$k$3$H$O$J$$$O$:$G$9!#(B
>>>
>>> $B$?$@$7!":G8e$N%3%_%C%H$N$H$3$m$GIT9,$K$b$I$3$+$N%N!<%I$G%3%_%C%H$,<:GT(B
>>> $B$7$?>l9g$K$O!"(BDB$B$K:9J,$,=P$^$9(B($B;d$O%3%_%C%H$,<:GT$7$?;vNc$O8+$?$3$H$,$"(B
>>> $B$j$^$;$s$,(B)$B!#(B
>>>
>>
>> $B%3%_%C%H$N<:GT<+BN$O!"(Bpostgres$B$N%@%&%s!"%O!<%I%&%'%"8N>cEy$N!"(B
>> $B$I$N$_$A<jF0I|5l$,I,MW$J%1!<%9$G$J$$8B$j5/$3$i$J$$$H;W$C$F$$$k$N$G$9$,!"(B
>> $B%M%C%H%o!<%/=VCG$d%M%C%H%o!<%/CY1dEy$N=V4VE*$J>c32$K$h$k%3%_%C%H<:GT$N(B
>> $B%1!<%9$r7|G0$7$F$$$^$7$?!#(B
> 
> $B%M%C%H%o!<%/%(%i!<$K$h$k%3%_%C%H$N<:GT$OHs>o$K$d$C$+$$$G$9!#$J$<$J$i!"(B
> $B%M%C%H%o!<%/E*$K%(%i!<$K$J$C$?$+$i$H8@$C$F!"I,$:$7$b(BPostgreSQL$BB&$G%3%_%C(B
> $B%H$,<:GT$7$F$$$k$H$O8B$i$J$$$3$H$G$9!#(B
> 
> # $B$3$NLdBj$KBP=h$9$k$?$a$K$O!"!V%H%i%s%6%/%7%g%J%k$J!WDL?.%W%m%H%3%k$,(B
> # $BI,MW$G$9$,!";DG0$J$,$i(BPostgreSQL$B$NDL?.%W%m%H%3%k$K$O$=$&$$$&5!G=$O$"(B
> # $B$j$^$;$s!#$?$V$sB>$N(BDBMS$B$K$b$=$&$$$&5!G=$O$J$$$H;W$$$^$9!#$b$7$+$7$?(B
> # $B$i!"%a%$%s%U%l!<%`$N(BDB(RDBMS$B$G$O$J$$$+$b(B)$B$K$O<BAuNc$,$"$k$+$b$7$l$^$;(B
> # $B$s$,(B...
> 
>> $B$=$N$?$a!"BP=hJ}?K$H$7$F(B
>>
>> $B!&1?MQBP=h(B
>> $B!&%7%9%F%`BP=h(B
>> $B!&%7%9%F%`@)8B(B
>>
>> $B$N$I$l$rA*Br$9$k$+$r7h$a$?$$$H;W$$!"(B
>>
>> $B!&%*%s%i%$%s%j%+%P%j$NDj4|<B9T$K$h$k%7%9%F%`BP=h(B
>> $B!\(B
>> $B!&IT9,$,=E$J$k$H(BF/O$BH/@8;~$K%G!<%?$,4,$-La$k2DG=@-$,$"$k$H$$$&%7%9%F%`@)8B(B
>>
>> $B$G8!F$$7$F$*$j$^$7$?!#(B
>> $B!t%R!<%H%i%s;n83$N7k2L<!Bh$G$O%7%9%F%`BP=h$OL5$/$9$+$b$7$l$J$$$G$9!#(B
>>
>> $B$A$J$_$K!"%3%_%C%H<:GT;~$N5sF0$O!"0J2<$N$h$&$K$J$j$^$9$G$7$g$&$+!)(B
>> $B!t(Bbackend0$B$G<:GT$7$?>l9g$O!"(Bbackend1$B$X$N(Bcommit$B<+BN$,9T$o$l$J$$G'<1$G$9!#(B
>> $B$=$N$?$a!"(Bbackend0$B$N(Bcommit$B<:GT!\(Bbackend1$B$N(Bcommit$B ＠ .8y$OL5$$$H;W$C$F$$$^$9!#(B
> 
> $B5U$G$9$M!#%3%_%C%H$O!"(Bbackend0($B$H$$$&$+ ＠ 53N$K$O%^%9%?!<(B)$B0J30$+$i9T$$$^(B
> $B$9!#$=$l$i$, ＠ .8y$7$?$i(Bbackend0$B$r%3%_%C%H$7$^$9!#$J$N$G!"(Bbackend0$B$H(B
> backend1$B$7$+$J$$>l9g$K$O!"(B
> 
>> $B-!(Bbackend0$B$G(Bcommit$B<:GT(B
>> $B"M(Bbackend1$B$X$N(Bcommit$B$O9T$o$:!"%H%i%s%6%/%7%g%s%"%\!<%H(B
> 
> $B-!(Bbackend1$B$G(Bcommit$B<:GT(B
> $B"M(Bbackend0$B$X$N(Bcommit$B$O9T$o$:!"%H%i%s%6%/%7%g%s%"%\!<%H(B
> 
>> $B-"(Bbackend0$B$G(Bcommit$B ＠ .8y"M(Bbackend1$B$G(Bcommit$B<:GT(B
>> $B"M(Bbackend0$B$KH?1G!\%H%i%s%6%/%7%g%s%"%\!<%H(B
> 
> $B-"(Bbackend1$B$G(Bcommit$B ＠ .8y"M(Bbackend10commit$B<:GT(B
> $B"M(Bbackend1$B$KH?1G!\%H%i%s%6%/%7%g%s%"%\!<%H(B
> 
>> $B$^$?!"%3%_%C%H<:GT$N%G!<%?:9J,H/@8;~$K;v>]$r8!CN$9$k$3$H$O2DG=$G$7$g$&$+!)(B
>> $B!t(Bpgpool$B$N%m%0%U%!%$%k$"$?$j$K=PNO$5$l$^$9$G$7$g$&$+!)(B
> 
> $B0l1~%(%i!<$,5/$3$k$?$S$K%m%0$,=PNO$5$l$k$N$G!"%/%(%j%m%0$rM-8z$K$7$F$*(B
> $B$1$P!"%3%_%C%H$G>e5-$N;v>]$,5/$3$C$?$3$H$OCm0U?<$/%m%0$rDI$($PJ,$+$j$^(B
> $B$9!#(B
> 
>> $BEY!9!"<ALd$H$J$C$F$7$^$$!"?=$7Lu$4$6$$$^$;$s!#!#!#(B
>>
>>> $B$A$J$_$K$3$NLdBj$O!"FsAX%3%_%C%H$r;H$C$F$b2sHr$G$-$^$;$s!#(B
>                        ~~~$BFsAj(B
>>> pre-commit(prepare transaction)$B$NCJ3,$G$N%(%i!<$O8e$G(Brollback-prepared
>>> $B$G85$KLa$;$^$9$,!"0lC6$I$3$+$N%N!<%I$G(Bcommit-prepared$B$7$F$7$^$C$?$b$N$O(B
>>> $BLa$;$J$$$+$i$G$9!#(B
>>
>> $B$O$$!"%l%W%j%1!<%7%g%sJ}<0$rA*Br$7$F$$$k0J>e!"%l%W%j%1!<%7%g%s$N(B
>> $BH?1G4IM}$G$b9T$o$J$$8B$j!"(BDB$B:9J,$rDY$7$-$k;v$,IT2DG=$G$"$k$3$H$O(B
>> $BM}2r$7$F$$$^$9!#(B
>> $B$?$@!":9J,$,H/@8$7$?;~$K$I$&$$$&BP=h$r9T$&$+!)$H$$$&$H$3$m$r7h$a$k(B
>> $B$?$a$K<ALd$5$;$FD:$-$^$7$?!#(B
>>
>> $B0J>e$G$9!#$h$m$7$/$*4j$$$7$^$9!#(B
>>
>> (2014/06/26 18:34), Tatsuo Ishii wrote:
>>> $B ＠ P0f$G$9!#(B
>>>
>>>> TO : $BD9EDMM(B
>>>>
>>>> $B$*@$OC$K$J$C$F$*$j$^$9!#A0ED$G$9!#(B
>>>>
>>>> $BAa5^$K$42sEzD:$-!"$"$j$,$H$&$4$6$$$^$9!#(B
>>>> $B?'!9$H%9%C%-%j$7$^$7$?!#(B
>>>>
>>>> $B4JC1$G$O$"$j$^$9$,!"0J>e$H$J$j$^$9!#(B
>>>>
>>>> (2014/06/26 17:42), Yugo Nagata wrote:
>>>>> To: $BA0ED$5$s(B
>>>>>
>>>>> $BD9ED$G$9!#(B
>>>>>
>>>>> On Thu, 26 Jun 2014 17:12:29 +0900
>>>>> $BA0ED(B $B9'2p(B <k.maeda ＠ micros.co.jp> wrote:
>>>>>
>>>>>> TO : $BD9EDMM(B
>>>>>>
>>>>>> $B$*@$OC$K$J$C$F$*$j$^$9!#A0ED$G$9!#(B
>>>>>>
>>>>>> $B$465<(D:$-$"$j$,$H$&$4$6$$$^$9!#(B
>>>>>>
>>>>>>> replicate_select = on $B$G!"%N!<%I4V$G(B SELECT $B7k2L%Q%1%C%H$K0c$$$,$G$?>l(B
>>>>>> $B9g$K$O!"(B
>>>>>>> "kind mismatch among backend" $B$H$$$&(B ERROR $B%m%0$r=PNO$7$F!"@\B3Cf$N(B
>>>>>>> $B;R%W%m%;%9$r:F5/F0$5$;$^$9!#(B
>>>>>>>
>>>>>>> $B$3$N$H$-$K!"%(%i!<$H$J$C$?%/%(%j$N%j%H%i%$$J$I$O9T$$$^$;$s!#(B
>>>>>>
>>>>>> select$B$H%l%W%j%1!<%7%g%s$N$9$l0c$$$K$h$j!"(B
>>>>>> DB1$B%3%_%C%H"M(Bselect$B"M(BDB2$B%3%_%C%H$H$$$&%7!<%1%s%9$,(B
>>>>>> $BH/@8$7$?>l9g$K$O(B"kind mismatch among backend"$B$,H/@8$9$k$H(B
>>>>>> $BM}2r$7$^$7$?!#(B
>>>>>>
>>>>>> select$B!"(Binsert$B!"(Bupdate$B$r%^%k%A%9%l%C%I=hM}$9$k$h$&$J%1!<%9$G$O!"(B
>>>>>> $B!V(Breplicate_select = off$B!W$H$9$k$+!"%"%W%j%1!<%7%g%sB&$G(Bselect$B$N(B
>>>>>> $B%j%H%i%$@)8f$r<BAu$9$kI,MW$,$"$k$H$$$&$3$H$G$9$M!#(B
>>>>>>
>>>>>> $B!V(Breplicate_select = off$B!W$G;n$7Av9T$N7k2L!"(B"kind mismatch"$B$O(B
>>>>>> $BH/@8$7$J$$$3$H$r3NG'$7$^$7$?!#$"$j$,$H$&$4$6$$$^$7$?!#(B
>>>>>
>>>>> $B%l%W%j%1!<%7%g%s%b!<%I$G99?7%/%(%j$H(BSELECT$B%/%(%j$,F1;~$KH/9T$5$l$?>l9g$K$O!"(B
>>>>> $B3F%N!<%I$G8!:w7o?t$,0[$J$k>l9g$,$"$j$^$9$N$G!"(Breplicate_select = off
>>>>> $B$,?d>)$5$l$^$9!#(B
>>>>>
>>>>>>
>>>>>> $B$^$?!"(Bupdate$B7O$N%H%i%s%6%/%7%g%s$,B8:_$9$k%7%9%F%`$N$?$a!"(B
>>>>>> $B%G!<%?$N0l4S ＠ -$rJ]>Z$9$k$?$a$K!V(Bload_balance_mode = off$B!W$K(B
>>>>>> $B$7$h$&$H9M$($F$$$k$N$G$9$,!"$=$N:]$N(Bselect$B;2>H$O!"0J2<$N%7!<%1%s%9$H(B
>>>>>> $B$J$kG'<1$G$9$,!"9g$C$F$$$^$9$G$7$g$&$+!)(B
>>>>>> $B!tDI2C$N<ALd$H$J$C$F$7$^$$?=$7Lu$4$6$$$^$;$s!#(B
>>>>>>
>>>>>> $B-!(Bbackend_XXXX0$B$G;XDj$7$?(BDB$B$K(Bselect
>>>>>> $B-"$b$7!"(Bbackend_XXXX0$B$,%@%&%s$7$F$$$?>l9g!"(Bbackend_XXXX1$B$G(B
>>>>>>      $B;XDj$7$?(BDB$B$K(Bselect
>>>>>
>>>>> $B$O$$!#%l%W%j%1!<%7%g%s%b!<%I$G!"(Bload_balance_mode = off, replicate_select = off
>>>>> $B$N>l9g$O!"%^%9%?!<%N!<%I!J ＠ 8$-$F$$$k%N!<%I$N$&$A!"%N!<%IHV9f$,$b$C$H$b<c$$$b$N!K$K(B
>>>>> SELECT $B%/%(%j$,H/9T$5$l$^$9!#$G$9$N$G!"$4G'<1$NDL$j$H$J$j$^$9!#(B
>>>>>
>>>>>>
>>>>>>> $B0lEY%3%_%C%H$5$l$?%/%(%j$O<h$j>C$9$3$H$O$G$-$^$;$s$,!"99?7%/%(%j$r(B
>>>>>>> $B%l%W%j%1!<%H$7$?$H$-$K!"%N!<%I4V$G99?7$N7k2L$,0[$J$k>l9g(B
>>>>>>> $B!JJRJ}$G ＠ .8y!&JRJ}$G<:GT!"$^$?$O!"7o?t$,0c$&!"$J$I!K!"(B
>>>>>>> $B%H%i%s%6%/%7%g%s$O%"%\!<%H$5$l!"$3$N99?7$O%3%_%C%H$5$l$^$;$s!#(B
>>>>>>
>>>>>> $B$d$O$j!"%3%_%C%H$7$F$+$i$NLa$7$O$7$J$$$s$G$9$M!#(B
>>>>>> $B%l%"%1!<%9$G$O$"$j$^$9$,!"(BDB$B$K:9J,$N=P$k2DG=@-$OM-$j$=$&$J$N$G!"(B
>>>>>> $BDj4|E*$K%*%s%i%$%s%j%+%P%j$r9T$&J}<0$HCW$7$^$9!#(B
>>>
>>> $B$A$g$C$H8m2r$,$"$k$h$&$J5$$,$7$^$9!#(B
>>>
>>> $B%l%W%j%1!<%7%g%s%b!<%I$K$*$$$F$O!"99?7%/%(%j$OI,$:L@<(E*$J%H%i%s%6%/%7%g(B
>>> $B%sFb$G<B9T$5$l$^$9!#(B($B$b$7%f!<%6$,L@<(E*$J%H%i%s%6%/%7%g%s$r$9$G$K3+;O$7(B
>>> $B$F$$$k>l9g$O!"$b$A$m$s99$K%H%i%s%6%/%7%g%s$r3+;O$7$?$j$O$7$^$;$s(B)$B!#(B
>>>
>>> $B$=$NCf$G<B9T$5$l$?(Bwrite$B%/%(%j$N7k2L$,0lCW$7$J$+$C$?$j!"%(%i!<$K$J$C$?>l(B
>>> $B9g$O!"$=$N%H%i%s%6%/%7%g%s$,%"%\!<%H$5$l$F%G!<%?$,85$KLa$k$N$G!"$=$NCJ(B
>>> $B3,$G(BDB$B$K:9J,$,=P$k$3$H$O$J$$$O$:$G$9!#(B
>>>
>>> $B$?$@$7!":G8e$N%3%_%C%H$N$H$3$m$GIT9,$K$b$I$3$+$N%N!<%I$G%3%_%C%H$,<:GT(B
>>> $B$7$?>l9g$K$O!"(BDB$B$K:9J,$,=P$^$9(B($B;d$O%3%_%C%H$,<:GT$7$?;vNc$O8+$?$3$H$,$"(B
>>> $B$j$^$;$s$,(B)$B!#(B
>>>
>>> $B$A$J$_$K$3$NLdBj$O!"FsAX%3%_%C%H$r;H$C$F$b2sHr$G$-$^$;$s!#(B
>>> pre-commit(prepare transaction)$B$NCJ3,$G$N%(%i!<$O8e$G(Brollback-prepared
>>> $B$G85$KLa$;$^$9$,!"0lC6$I$3$+$N%N!<%I$G(Bcommit-prepared$B$7$F$7$^$C$?$b$N$O(B
>>> $BLa$;$J$$$+$i$G$9!#(B
>>>
>>>>>> $B0J>e$G$9!#$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>>>>>>
>>>>>> (2014/06/25 19:23), Yugo Nagata wrote:
>>>>>>> $BD9ED$G$9!#(B
>>>>>>>
>>>>>>> On Wed, 25 Jun 2014 15:39:02 +0900
>>>>>>> $BA0ED(B $B9'2p(B <k.maeda ＠ micros.co.jp> wrote:
>>>>>>>
>>>>>>>> $B=i$a$^$7$F!"A0ED$H?=$7$^$9!#(B
>>>>>>>>
>>>>>>>> pgpool-$B|r$N%l%W%j%1!<%7%g%s%b!<%I$N%G!<%?0lCW%U%)%m!<HO0O$K$D$$$F!"(B
>>>>>>>> $B$b$7!"$4B8$8$G$7$?$i$465<(D:$-$?$$$G$9!#(B
>>>>>>>>
>>>>>>>> $B%l%W%j%1!<%7%g%s%b!<%I!\(Breplicate_select$B!'(Bon$B$N9=@.$G!"(B
>>>>>>>> $B%7%9%F%`$r1?MQ$7$?$H$3$m!"0J2<$N%(%i!<$,IQH/(B(1$BJ,4V$K(B1$B2sDxEY(B)$BCW$7$^$7$?!#(B
>>>>>>>> $B!t%7%9%F%`$N(BDB$B;2>H!&99?7IQEY$O!"$=$l$>$l(B40tps$B$:$DDxEY$G$9!#(B
>>>>>>>> -----------------------------------------------
>>>>>>>> ERROR: pid XXXX: kind mismatch among backends. Possible last query
>>>>>>>> was:"select XXXXXXX" kind details are: 0[C] 1[D]
>>>>>>>> -----------------------------------------------
>>>>>>>>
>>>>>>>> $B%5!<%P9=@.$O0J2<$H$J$j$^$9!#(B
>>>>>>>>
>>>>>>>> ---------------------------
>>>>>>>> $B"#%5!<%P9=@.(B
>>>>>>>> $B!&(BDB$B%5!<%P(B1
>>>>>>>>       - pgpool-$B|r(B 3.3.2
>>>>>>>>       - postgres$B%5!<%P(B 9.2.2
>>>>>>>> $B!&(BDB$B%5!<%P(B2
>>>>>>>>       - pgpool-$B|r(B 3.3.2
>>>>>>>>       - postgres$B%5!<%P(B 9.2.2
>>>>>>>> ---------------------------
>>>>>>>>
>>>>>>>> $B6&M-%G%#%9%/$r;HMQ$7$F$$$J$$0J>e!">e5-9=@.$G$O!"(B
>>>>>>>> DB$B%5!<%P(B1$B$N%G!<%?$H(BDB$B%5!<%P(B2$B$N%G!<%?$,>o$K40A40lCW$9$k$3$H$r(B
>>>>>>>> $BJ]>c=PMh$J$$$N$OM}2r$7$F$$$k$N$G$9$,!"(Bmismatch$B$NIQEY$,B?$$$?$a!"(B
>>>>>>>> $B$I$3$^$G(Bpgpool$B$,%l%W%j%1!<%7%g%s%b!<%I$G$N%G!<%?0lCW$r%U%)%m!<(B
>>>>>>>> $B$7$F$$$k$N$+!"0J2<$"$?$j$rCN$j$?$$$G$9!#(B
>>>>>>>>
>>>>>>>> $B-!(B select$B$H%l%W%j%1!<%7%g%s$N$9$l0c$$$r(Bpgpool$BB&$G%U%)%m!<$7$F$$$k$+!)(B
>>>>>>>> $B!tNc$($P!"(Bselect$B;~$K(Bmismatch$B$,H/@8$7$?>l9g!"%l%W%j%1!<%7%g%s$9$l0c$$$r(B
>>>>>>>>       $B9MN8$7!"%j%H%i%$@)8f$r$+$1$kEy!#(B
>>>>>>>
>>>>>>> replicate_select = on $B$G!"%N!<%I4V$G(B SELECT $B7k2L%Q%1%C%H$K0c$$$,$G$?>l9g$K$O!"(B
>>>>>>> "kind mismatch among backend" $B$H$$$&(B ERROR $B%m%0$r=PNO$7$F!"@\B3Cf$N(B
>>>>>>> $B;R%W%m%;%9$r:F5/F0$5$;$^$9!#(B
>>>>>>>
>>>>>>> $B$3$N$H$-$K!"%(%i!<$H$J$C$?%/%(%j$N%j%H%i%$$J$I$O9T$$$^$;$s!#(B
>>>>>>>
>>>>>>> $B$J$*!"(Breplication_stop_on_mismatch =$B!!(Bon $B$N>l9g$K$O!"(BDB$B%N!<%I$r ＠ Z$jJ|$7$F(B
>>>>>>> $B=LB`1?E>$KF~$k$3$H$O$G$-$^$9!#=LB`BP>]$N(BDB$B%N!<%I$O!VB??t7h!W$G7h$a$i$l$^$9!#(B
>>>>>>> http://www.pgpool.net/docs/latest/pgpool-ja.html#REPLICATION_STOP_ON_MISMATCH
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>> $B-"(B $B%l%W%j%1!<%7%g%s0[>o$,H/@8$7$?:]$NLa$jHO0O$O$I$3$^$G$+!)(B
>>>>>>>> $B!tNc$($P!"(BDB$B%5!<%P(B1$B$G$O%3%_%C%H$K ＠ .8y$7!"(BDB$B%5!<%P(B2$B$G$O(B
>>>>>>>>       $B%3%_%C%H$K<:GT$7$?>l9g!"(BDB$B%5!<%P(B1$B<+BN$N%3%_%C%H$r<h$j>C$9$h$&$J(B
>>>>>>>>       $B%H%i%s%6%/%7%g%s@)8f$r9T$C$F$$$k$+!)(B
>>>>>>>>       $B$=$l$H$b!"La$jHO0O$O!"$"$/$^$G%H%i%s%6%/%7%g%s$N(Brollback$B$^$G$H(B
>>>>>>>>       $B$7$F$$$k$+!)(B
>>>>>>>
>>>>>>> $B0lEY%3%_%C%H$5$l$?%/%(%j$O<h$j>C$9$3$H$O$G$-$^$;$s$,!"99?7%/%(%j$r(B
>>>>>>> $B%l%W%j%1!<%H$7$?$H$-$K!"%N!<%I4V$G99?7$N7k2L$,0[$J$k>l9g(B
>>>>>>> $B!JJRJ}$G ＠ .8y!&JRJ}$G<:GT!"$^$?$O!"7o?t$,0c$&!"$J$I!K!"(B
>>>>>>> $B%H%i%s%6%/%7%g%s$O%"%\!<%H$5$l!"$3$N99?7$O%3%_%C%H$5$l$^$;$s!#(B
>>>>>>>
>>>>>>>>
>>>>>>>> $B0J>e$G$9!#$h$m$7$/$*4j$$$7$^$9!#(B
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>