[pgpool-general-jp: 1289] Re: =?ISO-2022-JP?B?cGdwb29sLQ==?= =?ISO-2022-JP?B?GyRCfHIlbCVXJWolMSE8JTclZyVzJWIhPCVJJE4lRyE8JT8wbENXGyhC?= =?ISO-2022-JP?B?GyRCJVUlKSVtITxITzBPJEskRCQkJEYbKEI=?=

Yugo Nagata nagata @ sraoss.co.jp
2014年 6月 26日 (木) 17:42:01 JST


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
> 
> $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
> > 
> > 


-- 
Yugo Nagata <nagata @ sraoss.co.jp>


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