[Pgpool-general] psql commands cause fail over
Gary Fu
gfu at sigmaspace.com
Mon Jan 17 18:49:01 UTC 2011
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)
More information about the Pgpool-general
mailing list