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
