Yes, do you mean that I have to disable it ? As far as I know, our
application may fail over with it disabled.
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
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
