[Pgpool-general] psql commands cause fail over

[Tatsuo Ishii]

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 at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general