[Pgpool-general] Kind mismatch among backends.

[Tatsuo Ishii]

DB node 0 returned less rows than node 1. Are you sure that the number
of rows of the table in each DB node are identical? Is there anything
special to t_accesscontrolcachebuffer? (i.e. view including volatile
data such as current_timestamp). Is it heavily concurrently updated?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Nov 30 11:24:25 psql-1 pgpool: 2010-11-30 11:24:25 ERROR: pid 7958: read_kind_from_backend: 1 th kind D does not match with master or majority connection kind C
> Nov 30 11:24:25 psql-1 pgpool: 2010-11-30 11:24:25 ERROR: pid 7958: kind mismatch among backends. Possible last query was: "/* named HQL query AccessControlCacheBuffer.findAll */ select accesscont0_.id as id235_, accesscont0_.c_action as c2_235_, accesscont0_.c_currentversion as c3_235_, accesscont0_.c_entityid as c4_235_, accesscont0_.c_type as c5_235_ from t_accesscontrolcachebuffer accesscont0_ order by accesscont0_.id limit $1" kind details are: 0[C] 1[D]
> Nov 30 11:24:25 psql-1 pgpool: 2010-11-30 11:24:25 LOG:   pid 7958: do_child: exits with status 1 due to error
> 
> Is there anything that needs to be done to ensure that this doesn't happen?
> 
> Running, pgpool-II version 2.3.2.1 on Ubuntu 10.04 LTS.
> 
> 
> 
> Tim.
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general