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

Tatsuo Ishii ishii at sraoss.co.jp
Wed Mar 22 11:05:30 JST 2023


> 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
>>



More information about the pgpool-general mailing list