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

[Jesús Campoy]

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
>> >> >>
>> >>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230403/0b94022a/attachment.htm>