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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
