[pgpool-general-jp: 680] Re: pgpool2-2.3.1/insufficient data left in message

ISHIDA Akio iakio @ mono-space.net
2010年 1月 22日 (金) 01:26:35 JST


$B$3$s$K$A$O!#@PED$G$9!#(B

$B$A$g$C$H$^$@8!F$$,$D$$$F$$$J$$$N$G$9$,!"%m%0$r8+$?46$8$G$O(B
Parse$B$, @ .8y$7$?%N!<%I$H<:GT$7$?%N!<%I$,$$$k$h$&$G$9!#(B

pgpool.conf$B$r$_$;$F$$$?$@$/$3$H$O$G$-$^$9$+!)(B
$B$^$?!"(BPHP$BB&$N%3!<%I$r$_$;$F$$$?$@$1$k$H=u$+$j$^$9!#(B

2010$BG/(B1$B7n(B20$BF|(B20:06 $B;.3$!!B @ FsO/(B <saragai @ mbgx.tis.co.jp>:
> $B;.3$$G$9!#(B
>
> $BD9J8$H$J$j$^$9$,!"$*5v$7$/$@$5$$!#(B
>
> pgpool$B-6(B-2.2.6$B$+$i(B2.3.1$B$X%P!<%8%g%s%"%C%W$7$?$H$3$m!"(B
> $B2<5-(Bpgpool$B$N%m%0$K$"$j$^$9(BSQL$B$K$F%(%i!<$,H/@8$7!"(B
> $B=LB`2TF0$5$l$k$H$$$&;v>]$,H/@8$7$F$*$j$^$9!#(B
>
> $B!Z(Bpgpool$B%m%0![(B
> 2010-01-19 19:36:07 ERROR: pid 19213: read_kind_from_backend:
> 1 th kind E does not match with master or majority connection kind 1
> 2010-01-19 19:36:07 ERROR: pid 19213: kind mismatch among backends.
> Possible last query was: "Parse: INSERT INTO tmp_control_area_table
> SELECT 'fcslck9if50hqa4dv73s3lnad6', p.page_id, pr.revision,
> p.parent_page_id, 1, NOW()
> FROM page p, page_revision pr
> WHERE p.parent_page_id IN
> (SELECT page_id FROM tmp_control_area_table
> WHERE "level" = 0
> AND session_id = 'fcslck9if50hqa4dv73s3lnad6'
> )
> AND p.page_id = pr.page_id
> AND p.link_flag = 1" kind details are: 0[1] 1[E: insufficient data left
> in message]
> 2010-01-19 19:36:07 LOG: pid 19213: notice_backend_error: 1 fail over
> request from pid 19213
> 2010-01-19 19:36:07 LOG: pid 19115: starting degeneration. shutdown host
> 172.16.48.185(5432)
> 2010-01-19 19:36:07 LOG: pid 19115: failover_handler: set new master node: 0
> 2010-01-19 19:36:07 LOG: pid 19115: failover done. shutdown host
> 172.16.48.185(5432)
>
> $B;v>]$NH/@8860x$O(Bpgpool$B$N%P!<%8%g%s%"%C%W$K$h$k$b$N$H9M$($F$*$j!"(B
> $B%P%0$N5?$$$b$"$k$?$a!"860x$rD4::$$$?$@$/$3$H$O2DG=$G$7$g$&$+!#(B
>
> $BB>$N>pJs$K$D$$$F$O0J2<$NDL$j$G$9!#(B
> $B!Z(Bpostgres$B%m%0(B($B @ Z$jN%$5$l$?%5!<%P$N$_=PNO(B)$B![(B
> 2010-01-19 19:36:07 JST:10514 ERROR:  insufficient data left in message
>
> $B!Z(Bphp PDO$B$G<hF@$7$?%(%i!<7k2L![(B
> SQLSTATE[XX000]: Internal error: 7 ERROR: kind mismatch among backends.
> Possible last que
> ry was: "Parse: INSERT INTO tmp_control_area_table
> SELECT 'fcslck9if50hqa4dv73s3lnad6', p.page_id, pr.revision,
> p.parent_page_id, 1,NOW()
> FROM page p, page_revision pr
> WHERE p.parent_page_id IN
> (SEL
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
>
> $B!Z(Bpostgresql$B$N%P!<%8%g%s![(B
> 8.3.7
>
>
> $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
>
>



-- 
ISHIDA Akio <iakio @ mono-space.net/ishida @ cycleof5th.com>


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