Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?) - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)
Date
Msg-id Z7-ohctRCTPxCon7@paquier.xyz
Whole thread Raw
In response to Re: suspicious lockup on widowbird in AdvanceXLInsertBuffer (could it be due to 6a2275b8953?)  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On Wed, Feb 26, 2025 at 05:23:51PM -0500, Peter Geoghegan wrote:
> According to the revert commit's commit message there was also
> problems on batta at the time. Might have been the same issue that you
> saw on widowbird. Alexander?

This problem has already been discussed, and I saw the same backtrace
as you do on my hosts:
https://www.postgresql.org/message-id/Z7PSeT7AbrjmiCCV@paquier.xyz

It is not the first time where we have a problematic patch causing
some animals to freeze, so I would recommend using a wait_timeout =>
43200 or similar in the configuration of your buildfarm animals so as
they would unfreeze themselves without the need for a manual
intervention.  This setting has saved me quite a few maintenance
cycles.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: ahmedashour
Date:
Subject: [PATCH] [52] Review of patch 5381 - Documentation for pgstatindex fragmentation
Next
From: Jeff Davis
Date:
Subject: Re: Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators