RE: Test failures of 100_bugs.pl

From: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
To: "Yu Shi (Fujitsu)" <shiy(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Test failures of 100_bugs.pl
Date: 2024-03-11 12:34:08
Message-ID: OS0PR01MB571682565C4D62C766A55C9E94242@OS0PR01MB5716.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Monday, April 24, 2023 5:50 PM Yu Shi (Fujitsu) <shiy(dot)fnst(at)fujitsu(dot)com> wrote:
>
> On Fri, Apr 21, 2023 1:48 PM Yu Shi (Fujitsu) <shiy(dot)fnst(at)fujitsu(dot)com> wrote:
> >
> > I wrote a patch to dump rel state in wait_for_subscription_sync() as
> suggested.
> > Please see the attached patch.
> > I will try to add some debug logs in code later.
> >
>
> Please see the attached v2 patch.
>
> I added some debug logs when invalidating syncing table states and updating
> table_states_not_ready list. I also adjusted the message level in the tests which
> failed before.

Just a reference.

I think similar issue has been analyzed in other thread[1] and the reason seems
clear that the table state cache invalidation got lost due to a race condition.
The fix is also being discussed there.

[1] https://www.postgresql.org/message-id/flat/711a6afe-edb7-1211-cc27-1bef8239eec7%40gmail.com

Best Regards,
Hou zj

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2024-03-11 12:43:39 Re: POC, WIP: OR-clause support for indexes
Previous Message Bharath Rupireddy 2024-03-11 12:30:00 Re: Add new error_action COPY ON_ERROR "log"