Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Haiyang Li <mohen.lhy@alibaba-inc.com>

Cc: Xuneng Zhou <xunengzhou@gmail.com>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>

Date: 2025-11-11T02:12:17Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

For inplace update, send nontransactional invalidations.
- 243e9b40f1b2 18.0 cited

On Tue, Nov 11, 2025 at 09:42:29AM +0800, Haiyang Li wrote:
> The WAL are provided in attachment. Unfortunately, I can not share the script.
> The testing scenario is rather complex, and the executed SQL statements can
> only be tracked via the logs. At this point, I have not been able to obtain a
> reproducible case, which is the challenging part. However, I can provide the
> actions carried out by a specific transaction if you need.

That's unfortunate.  Having a reproducible test case that works with
upstream would speed up the analysis of the problem a lot.
--
Michael