Re: Proposal: recent access based routing for primary-replica setups

From: Nadav Shatz <nadav(at)tailorbrands(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: pgpool-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Proposal: recent access based routing for primary-replica setups
Date: 2025-11-18 11:37:10
Message-ID: CACeKOO3kSTnAsjQMmuYFAFDG513W4KeAX=vZ7NVaFafMy9KFXQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-hackers

Hi Tatsuo,

Please see attached an updated version.

thank you

On Fri, Nov 7, 2025 at 2:07 AM Tatsuo Ishii <ishii(at)postgresql(dot)org> wrote:

> > Sorry for that - thanks for the patch.
> >
> > Please find attached a new version
>
> Thanks for the new version. Unfortunately this time regression test
> fails at:
>
> > Waiting for command timeout...
> > fail: command timeout not detected
>
> Attached is the pgpool.log.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS K.K.
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>
> > On Mon, Nov 3, 2025 at 9:05 AM Tatsuo Ishii <ishii(at)postgresql(dot)org>
> wrote:
> >
> >> > thanks and sorry for the issues, please find attached updated version.
> >>
> >> No problem.
> >>
> >> This time the patch applies fine, no compiler warnings. However,
> >> regression test did not passed here (on Ubuntu 24 LTS if this
> >> matters). So I looked into
> >> src/test/regression/tests/041.external_replication_delay/test.sh a
> >> little bit and apply attached patch (test.sh.patch). It moved forward
> >> partially but failed at:
> >>
> >> fail: command execution failure not detected
> >>
> >> Please find attached
> >>
> src/test/regression/tests/041.external_replication_delay/testdir/pgpool.log
> >> and src/test/regression/log/041.external_replication_delay.
> >>
> >> Best regards,
> >> --
> >> Tatsuo Ishii
> >> SRA OSS K.K.
> >> English: http://www.sraoss.co.jp/index_en/
> >> Japanese:http://www.sraoss.co.jp
> >>
> >
> >
> > --
> > Nadav Shatz
> > Tailor Brands | CTO
>

--
Nadav Shatz
Tailor Brands | CTO

Attachment Content-Type Size
0001-Fix-multiple-issues-in-external-replication-delay-fe.patch application/octet-stream 8.1 KB

In response to

Responses

Browse pgpool-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-11-19 23:09:30 Re: Proposal: recent access based routing for primary-replica setups
Previous Message VASUKI M 2025-11-07 11:25:28 Re: Autofail back inconsistent