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

From: "Haiyang Li" <mohen(dot)lhy(at)alibaba-inc(dot)com>
To: "Xuneng Zhou" <xunengzhou(at)gmail(dot)com>, "pgsql-bugs" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump
Date: 2025-11-11 01:42:29
Message-ID: 13b5ed51-0a02-4b3a-b8b3-b33505f1fe6c.mohen.lhy@alibaba-inc.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Xuneng,
Xuneng Zhou <xunengzhou(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2025-11-11 02:12:17 Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump
Previous Message Xuneng Zhou 2025-11-11 01:11:53 Re: BUG #19109: catalog lookup with the wrong snapshot during logical decoding causes coredump