Message-ID: <d73d7064-acb6-6424-df5c-bca945ee0315@gmail.com>
Date: Tue, 9 Apr 2024 23:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: BUG #17257: (auto)vacuum hangs within lazy_scan_prune()
Content-Language: en-US
To: Robert Haas <robertmhaas@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
References: <17257-1e46de26bec11433@postgresql.org>
 <d5d5af5d-ba46-aff3-9f91-776c70246cc3@gmail.com>
 <CA+TgmoYPFBgP7UmzVQkgneKSbfeL+g3NEd-worPkzfyKRzPYeA@mail.gmail.com>
 <5cbe0b03-d6f3-501d-3849-534568b0e776@gmail.com>
 <CA+TgmoaNyZcPEd3ZA+5ZbuQnivS_1L=OTtRNv15tK6YDJZeOEA@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <CA+TgmoaNyZcPEd3ZA+5ZbuQnivS_1L=OTtRNv15tK6YDJZeOEA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/d73d7064-acb6-6424-df5c-bca945ee0315%40gmail.com>
Precedence: bulk

09.04.2024 21:59, Robert Haas wrote:
>
>> But on dad1539ae I got no failures for 3 runs (the same is on
>> REL_16_STABLE with a slightly modified lazy_scan_prune patch).
> I'm having trouble understanding what this means exactly -- are you
> talking about REL_16_STABLE, or about dad1539ae, or both, or what? At
> any rate, it's really important here that we understand whether we
> still have a bug here, and if so, in which releases and with what test
> case. I wasn't aware of dad1539ae but that certainly seems like it
> might've made a big difference, if not fixing the problem entirely
> then at least making it a lot less likely. And I think it's possible
> that some of the related freezing+pruning commits on master might have
> removed the problem altogether, but that needs to be tested.

I was talking about both — dad1539ae eliminated the bug (judging from the
repro) on REL_14_STABLE, and I suppose that 18b87b201 did the same for
REL_15_STABLE/REL_16_STABLE...
(On 18b87b201~1 I've got (twice):
TRAP: FailedAssertion("HeapTupleHeaderIsHeapOnly(htup)", File: "pruneheap.c", Line: 964, PID: 1854895)

I can double-check exactly 18b87b201 with the repro, if it makes sense.)

Best regards,
Alexander