[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