| 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
| 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 |