| From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
|---|---|
| To: | Noah Misch <noah(at)leadboat(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE |
| Date: | 2024-10-27 05:00:00 |
| Message-ID: | ec25f651-58ca-9266-e485-c561907d18e6@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello Noah,
27.10.2024 07:09, Noah Misch wrote:
> On Sat, Oct 26, 2024 at 11:49:36AM -0700, Noah Misch wrote:
>> intra-grant-inplace-db.spec got a novel failure today:
>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sarus&dt=2024-10-26%2014%3A08%3A58
>>
>> The isolationtester_waiting query is supposed to detect that step vac2 is
>> blocked. vac2 didn't finish within the timeout, but isolationtester_waiting
>> never considered it blocked.
>> ... work on reproducing this.
FWIW, there was a similar failure in August: [1], and I also could not
reproduce that locally, yet wrote a preliminary analysis at [2] in the
Unsorted section, in the hope to see it again and continue investigation.
[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=iguana&dt=2024-08-29%2013%3A57%3A57
[2] https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures
Best regards,
Alexander
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2024-10-27 06:54:22 | Re: Assertion failure when autovacuum drops orphan temp indexes. |
| Previous Message | Noah Misch | 2024-10-27 04:09:28 | Re: heap_inplace_lock vs. autovacuum w/ LOCKTAG_TUPLE |