Horton

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

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

View thread
From: "Haiyang Li" <mohen.lhy@alibaba-inc.com>
To: "Xuneng Zhou" <xunengzhou@gmail.com>, "pgsql-bugs" <pgsql-bugs@lists.postgresql.org>
Date: 2025-11-11T01:42:29Z
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 →

  1. For inplace update, send nontransactional invalidations.

Hi Xuneng,
Xuneng Zhou <xunengzhou@gmail.com> 2025-11-11 09:12 write:
>> I have not yet figured out the root cause and will continue analyzing.
>> If you need the complete WAL log from 8/3C425D18 to 8/8A01FE30, please let
>> me know — I can provide it.
> 
> That would be helpful. Could you also share the test or script that
> reproduces the core dump?
>
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.


    超大附件列表            000000010000000800000000.log  [5.6MB]
        进入下载页面  https://webmail.alibaba-inc.com/alimail/openLinks/downloadMimeMetaDiskBigAttach?id=netdiskid%3Av001%3Afile%3ADzzzzzzNqZw%3B%2BKGz%2F3J5NSJCivtPFH7iKC6L9xNA7nCG6ZMEvfm2C9VVNDTn%2F9EhmSwdsFLDK%2Fd%2FZm3kcn5KaOnaPJGa2gxAPLpDrtHGPBQKjwwhc1WpBMgi8MI23BF5pXl9UVzmPXslD8SNpGL9Ev4%3D            000000010000000800000001.log  [44.1MB]
        进入下载页面  https://webmail.alibaba-inc.com/alimail/openLinks/downloadMimeMetaDiskBigAttach?id=netdiskid%3Av001%3Afile%3ADzzzzzzNqZv%3B%2BKGz%2F3J5NSJCivtPFH7iKC6L9xNA7nCG6ZMEvfm2C9VVNDTn%2F9EhmSwdsFLDK%2Fd%2FZm3kcn5KaOnaPJGa2gxAPLpDrtHGPBQKjwwhc1WpBMgi8MI23BF5pXl9UVzmPXslSF34nkWy7Vo%3D            000000010000000800000002.log  [7.3MB]
        进入下载页面  https://webmail.alibaba-inc.com/alimail/openLinks/downloadMimeMetaDiskBigAttach?id=netdiskid%3Av001%3Afile%3ADzzzzzzNqZu%3B%2BKGz%2F3J5NSJCivtPFH7iKC6L9xNA7nCG6ZMEvfm2C9VVNDTn%2F9EhmSwdsFLDK%2Fd%2FZm3kcn5KaOnaPJGa2gxAPLpDrtHGPBQKjwwhc1WpBMgi8MI23BF5pXl9UVzmPXslYayLKf%2B6X%2BM%3D