> Yes, do you mean that I have to disable it ? Yes, if you want to avoid error when executing \d.
> As far as I know, our > application may fail over with it disabled. If you still have an error in spite of disabling replicate_select, please let me know details (pgpool.conf, pgpool-II version). > Thanks, > Gary >> 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
