From: | Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Address the bug in 041_checkpoint_at_promote.pl |
Date: | 2025-02-12 11:20:34 |
Message-ID: | CAMm1aWZKPKzBHkEgD4cS+aq4fbSRE1YiN06z_Fu_XJLa3caTuw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > Removing the wakeup makes the test
> > complete, but it should wait in its lookup loop.
>
> Thank you for confirming. Besides fixing the if condition as done in
> the patch, do you think any other changes are necessary?
I see that it's already been committed and understand that no other
changes are needed. Thank you!
Best Regards,
Nitin Jadhav
Azure Database for PostgreSQL
Microsoft
On Wed, Feb 12, 2025 at 3:29 PM Nitin Jadhav
<nitinjadhavpostgres(at)gmail(dot)com> wrote:
>
> > Removing the wakeup makes the test
> > complete, but it should wait in its lookup loop.
>
> Thank you for confirming. Besides fixing the if condition as done in
> the patch, do you think any other changes are necessary?
>
> Best Regards,
> Nitin Jadhav
> Azure Database for PostgreSQL
> Microsoft
>
> On Wed, Feb 12, 2025 at 1:54 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> >
> > On Wed, Feb 12, 2025 at 01:28:55PM +0530, Nitin Jadhav wrote:
> > > The code is intended to wait for the restart point to complete before
> > > proceeding. However, it doesn't actually wait. Regardless of whether
> > > the restart point completes, the loop exits after the first iteration
> > > because the if condition always evaluates to true. This happens
> > > because $logstart is not passed as an argument to log_contains() by
> > > mistake. If the restart point operation is quick, this issue might not
> > > be noticeable, which is often the case.
> > >
> > > I've attached a patch to fix this issue. Please review and share your feedback.
> >
> > Oops, you're right. I am measuring 2ms or so in average between the wakeup
> > and the restartpoint complete. Removing the wakeup makes the test
> > complete, but it should wait in its lookup loop.
> >
> > Will fix down to v17 where this error has been introduced.
> > --
> > Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Rushabh Lathia | 2025-02-12 11:22:36 | Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints |
Previous Message | Álvaro Herrera | 2025-02-12 11:13:52 | Re: NOT ENFORCED constraint feature |