Re: postgres_fdw test timeouts

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgres_fdw test timeouts
Date: 2023-12-02 23:48:49
Message-ID: CA+hUKGLoy9sqNcYH+oOPOq+vUb47JJKYA=859Vr1c9ABbqhjcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Dec 1, 2023 at 9:38 AM Nathan Bossart <nathandbossart(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2023-12-03 01:17:08 Re: Patch: Improve Boolean Predicate JSON Path Docs
Previous Message Tom Lane 2023-12-02 22:46:39 Re: Is WAL_DEBUG related code still relevant today?