Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE

On Mon, Mar 16, 2026 at 04:23:40PM +0900, Michael Paquier wrote:
> Aye, we have a timing issue here, and at first it seemed to me that
> this was a bug in the backend logic.  But actually I suspect that it
> is simpler than that: we don't disable autovacuum so couldn't an
> autovacuum worker connect to the database "testdb" that we are trying
> to rename in this query?  I cannot be 100% sure because we have
> reduced the log activity for the sake of the tests, but that feels
> possible to me.  We could try to disable autovacuum entirely, then see
> if the situation gets better in the buildfarm.
>
> The failure rate is so low that it is likely going to take a few weeks
> to check the stability of the situation.  We could also lot more
> things, of course, as a temporary solution.

After sleeping on it, I do not have a better idea than the attached,
so we could always get that into the tree and see if the situation
improves, even if it would take time.  Iwata-san and others, what do
you think?  Perhaps you could think of a different reason causing this
failure?
--
Michael