Are you enabling replicate_select? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Hi, > > I noticed that sometimes the psql command '\d' (or other commands) > will cause the pgpool (with replication mode) fail over due to the > specific 'oid' is used in the join. Is there any solution/suggestion > how to avoid this ? > > Thanks, > Gary > > 2011-01-17 17:15:44 ERROR: pid 13320: read_kind_from_backend: 1 th > kind C does not match with master or majority connection kind D > 2011-01-17 17:15:44 ERROR: pid 13320: kind mismatch among > backends. Possible last query was: "SELECT c.relchecks, c.relkind, > c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoids, '', > c.reltablespace > FROM pg_catalog.pg_class c > LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid) > WHERE c.oid = '8779873' > " kind details are: 0[D] 1[C] > 2011-01-17 17:15:44 LOG: pid 13320: notice_backend_error: 1 fail over > request from pid 13320 > 2011-01-17 17:15:44 LOG: pid 20686: starting degeneration. shutdown > host sd3db2(5432) > 2011-01-17 17:15:44 LOG: pid 20686: failover_handler: set new master > node: 0 > 2011-01-17 17:15:44 LOG: pid 14446: connection received: > host=172.28.20.139 port=48277 > 2011-01-17 17:15:44 LOG: pid 20686: failover done. shutdown host > sd3db2(5432) > > _______________________________________________ > 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
