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

[Tatsuo Ishii]

Hi,

Can you share pgpool log?

> Hi Tatsuo,
> 
> Should I test anything else to try to solve my problem?
> 
> Thank you.
> 
> Best,
> Jesús
> 
> El vie, 31 mar 2023 12:10, Jesús Campoy <jesuscampoy at gmail.com> escribió:
> 
>> Hi,
>>
>> I just performed the same tests with auto_failback to off but the
>> behaviour is the same (clients are disconnected).
>>
>> Thank you Tatsuo.
>>
>> Best,
>> Jesús
>>
>> El vie, 31 mar 2023 2:31, Tatsuo Ishii <ishii at sraoss.co.jp> escribió:
>>
>>> 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
>>> >> >>
>>> >>
>>>
>>