[pgpool-general: 8640] Re: The cluster fails over even when failover_on_backend_error = off
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Mar 15 07:22:41 JST 2023
>>> What else happens is that nodes "b" and "c" will vote to failover from
>>> "a" to "b", even though failover_on_backend_error = off.
>>>
>>> Why does that happen?
>>> https://www.pgpool.net/docs/pgpool-II-4.3.5/en/html/runtime-config-failover.html
>>> says it should just "report an error and disconnect the session in
>>> case of such errors."
>>>
>>> Is it because "if no client is connected, Pgpool-II will not detect
>>> the event even if the parameter is on"? (This is a pre-production
>>> system, so the application servers aren't talking to it.)
>>>
>>> Attached is a log file extract and PGPOOL SHOW command.
>> Turning off failover_on_backend_error prevents pgpool child process
>
> Meaning that "PostgreSQL backend connection" specifically and only
> refers to processes which "do SQL stuff"?
Yes.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list