From: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
---|---|
To: | 'Amit Kapila' <amit(dot)kapila16(at)gmail(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com> |
Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Fix 035_standby_logical_decoding.pl race conditions |
Date: | 2025-04-03 05:34:10 |
Message-ID: | OSCPR01MB14966608F78B5BFC907CF8E82F5AE2@OSCPR01MB14966.jpnprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear Bertrand, Amit,
> > I do prefer v5-PG17-2 as it is "closer" to HEAD. That said, I think that we should
> > keep the slots active and only avoid doing the checks for them (they are
> invalidated
> > that's fine, they are not that's fine too).
> >
>
> I don't mind doing that, but there is no benefit in making slots
> active unless we can validate them. And we will end up adding some
> more checks, as in function check_slots_conflict_reason without any
> advantage. I feel Kuroda-San's second patch is simple, and we have
> fewer chances to make mistakes and easy to maintain in the future as
> well.
I have concerns for Bertrand's patch that it could introduce another timing
issue. E.g., if the activated slots are not invalidated, dropping slots is keep
being activated so the dropping might be fail. I did not reproduce this but
something like this can happen if we activate slots.
Attached patch has a conclusion of these discussions, slots are created but
it seldomly be activated.
Naming of patches are bit different, but please ignore...
Best regards,
Hayato Kuroda
FUJITSU LIMITED
Attachment | Content-Type | Size |
---|---|---|
v5-PG16-0001-Stabilize-035_standby_logical_decoding.pl.patch | application/octet-stream | 5.8 KB |
v5-PG17-0001-Stabilize-035_standby_logical_decoding.pl.patch | application/octet-stream | 6.9 KB |
0001-Fix-invalid-referring-of-hash-ref-for-replication-sl.patch | application/octet-stream | 2.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | torikoshia | 2025-04-03 05:34:27 | Re: RFC: Logging plan of the running query |
Previous Message | torikoshia | 2025-04-03 05:32:16 | Re: RFC: Logging plan of the running query |