RE: Fix publisher-side sequence permission reporting

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: 'vignesh C' <vignesh21(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Tristan Partin <tristan(at)partin(dot)io>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: Fix publisher-side sequence permission reporting
Date: 2026-07-15 11:40:08
Message-ID: OS9PR01MB12149D8AFCC23CE88858F8D9FF5F82@OS9PR01MB12149.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dear Vignesh,

> There was an issue reported by Noah at [1], the finding-7 reported
> fails with an assert. The assertion can be triggered if a sequence is
> dropped concurrently while the sequence synchronization worker is
> processing it:

Also, there is a BF failure due to the same reason [1]. At line 269 in the test
we dropped the sequence. If the sequencesync worker has already read the sequence
info at that time, the crash can happen. The point here was that sequencesync
worker could be re-started to try synchronizing sequences which had
insufficient privileges.

BTW, I agree the fix.

[1]: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2026-07-15%2007%3A54%3A30

Best regards,
Hayato Kuroda
FUJITSU LIMITED

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rafia Sabih 2026-07-15 11:50:32 Re: Bypassing cursors in postgres_fdw to enable parallel plans
Previous Message Andrew Dunstan 2026-07-15 11:37:02 Re: Proposal: new file format for hba/ident/hosts configuration?