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

[皿海 太二朗]

$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