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

[Tatsuo Ishii]

Hi,

Thanks. I will looking into this.

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

> Hi,
> 
> Please find attached logs.
> 
> Thank you.
> 
> Best,
> Jesús
> 
> El lun, 3 abr 2023 11:06, Tatsuo Ishii <ishii at sraoss.co.jp> escribió:
> 
>> 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
>> >>> >> >>
>> >>> >>
>> >>>
>> >>
>>