[Pgpool-general] psql commands cause fail over

[Gary Fu]

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