[pgpool-general: 8702] Re: Clients disconnection when slave node is off

[Tatsuo Ishii]

Hi Jesús,

Can you try again after setting "auto_failback = off"? I suspect
auto_failback confuses pgpool.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

> Hi Tatsuo,
> 
> When I connect to pgpool with psql this session is not disconnected.
> However, I've performed a test with pgbench inserting data with 30 clients
> in the database and when I shutdown server2 some clients of pgbench are
> disconnected.
> Please find attached a zip file with pgpool logs, pgbench log and
> configurations of pgpool and postgres.
> 
> Thank you for your assistance in this matter.
> 
> Best,
> Jesús
> 
> El mié, 22 mar 2023 a las 2:05, Tatsuo Ishii (<ishii at sraoss.co.jp>)
> escribió:
> 
>> > Please find attached my pgpool config and a log file when the standby
>> > (server2) is powered off.
>> > Thank you for your help.
>>
>> I assume server2 = host B.
>>
>> I have looked into the log file but failed to find log lines related
>> to user sessions which were diconnected. I was looking for such log
>> lines because you said:
>>
>> > Sometimes I have to power off the host B and then, the clients connected
>>
>> If such an event occurs, there should be such log lines.
>> Many log lines like:
>>
>> 2023-03-20 10:59:27.725: [unknown] pid 31499: LOG:  failover or failback
>> event detected
>> 2023-03-20 10:59:27.725: [unknown] pid 31499: DETAIL:  restarting myself
>> 2023-03-20 10:59:27.726: main pid 30237: LOG:  child process with pid:
>> 31499 exits with status 256
>> 2023-03-20 10:59:27.727: main pid 30237: LOG:  fork a new child process
>> with pid: 29017
>>
>> just show that process 31499 is not related to any client session
>> ([unknown] indicates this) and even if the process exited, any client
>> will not be affected.
>>
>> Can you connect to pgpool using psql and shutdown server2 so that log
>> lines I am expecting are recorded?
>>
>> Best reagards,
>> --
>> Tatsuo Ishii
>> SRA OSS LLC
>> English: http://www.sraoss.co.jp/index_en/
>> Japanese:http://www.sraoss.co.jp
>>
>>
>> > Best,
>> > Jesús
>> >
>> > El vie, 17 mar 2023 a las 0:13, Tatsuo Ishii (<ishii at sraoss.co.jp>)
>> > escribió:
>> >
>> >> > Ok, I will send you the log ASAP.
>> >> > I forget to indicate that we are running two instances of pgpool using
>> >> > watchdog and VIP.
>> >> >
>> >> > I mean, in host A is running pgpool (active) and primary database. In
>> >> host
>> >> > B is running the other instance of pgpool and the standby database.
>> >> > Sometimes I have to power off the host B and then, the clients
>> connected
>> >> to
>> >> > pgpool in VIP are disconnected.
>> >> >
>> >> > I have the same pgpool.conf for both pgpool instances. Do you need It?
>> >>
>> >> No, one pgpool.conf is enough.
>> >>
>> >> > Thanks for your help!
>> >>
>> >> You are welcome.
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS LLC
>> >> English: http://www.sraoss.co.jp/index_en/
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>>