[Pgpool-general] psql commands cause fail over

[Tatsuo Ishii]

>  Yes, do you mean that I have to disable it ?

Yes, if you want to avoid error when executing \d.

> As far as I know, our
>  application may fail over with it disabled.

If you still have an error in spite of disabling replicate_select,
please let me know details (pgpool.conf, pgpool-II version).

> 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