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

[Jesús Campoy]

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
> >>> >> >>
> >>> >>
> >>>
> >>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230410/f6a21e70/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logs_pgpool.zip
Type: application/zip
Size: 20572 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230410/f6a21e70/attachment-0001.zip>