Re: postgres_fdw test timeouts - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: postgres_fdw test timeouts
Date
Msg-id CA+hUKGLoy9sqNcYH+oOPOq+vUb47JJKYA=859Vr1c9ABbqhjcw@mail.gmail.com
Whole thread Raw
In response to postgres_fdw test timeouts  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: postgres_fdw test timeouts
List pgsql-hackers
On Fri, Dec 1, 2023 at 9:38 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
> AFAICT the failures began around September 10th, which leads me to wonder
> if this is related to commit 04a09ee.  That is little more than a wild
> guess, though.  I haven't been able to deduce much else from the logs I can
> find, and I didn't find any previous reports about this in the archives
> after lots of searching, so I thought I'd at least park these notes here in
> case anyone else has ideas.

Thanks for finding this correlation.  Yeah, poking around in the cfbot
history database I see about 1 failure like that per day since that
date, and there doesn't seem to be anything else as obviously likely
to be related to wakeups and timeouts.  I don't understand what's
wrong with the logic, and I think it would take someone willing to
debug it locally to figure that out.  Unless someone has an idea, I'm
leaning towards reverting that commit and leaving the relatively minor
problem that it was intended to fix as a TODO.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is WAL_DEBUG related code still relevant today?
Next
From: shihao zhong
Date:
Subject: Re: Patch: Improve Boolean Predicate JSON Path Docs