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

[Jesús Campoy]

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/20230330/1ce4b463/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: log_pgpool.zip
Type: application/zip
Size: 25551 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230330/1ce4b463/attachment-0001.zip>