Fwd: BUG #18805: A specific query on a hash partitioned table always causes a "signal 11: Segmentation fault" error.

It is the same project scenario as the issue below ( BUG 18806）.

https://www.postgresql.org/message-id/18806-d70b0c9fdf63dcbf%40postgresql.org
BUG #18806: When enable_rartitionwise_join is set to ON, the database shuts down abnormally
postgresql.org

> 下面是被转发的邮件：
>
> 发件人: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
> 主题: 回复：BUG #18805: A specific query on a hash partitioned table always causes a "signal 11: Segmentation fault" error.
> 日期: 2025年2月12日 GMT+8 15:40:01
> 收件人: weijie1006jl(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
>
> On Wed, 2025-02-12 at 03:53 +0000, PG Bug reporting form wrote:
>> Executing a specific SQL query in the database consistently results in a
>> "signal 11: Segmentation fault" error, and other connections report the
>> error: FATAL: 57P03: the database system is in recovery mode.
>>
>> When the error occurs, the system log shows: kernel: XFS (dm-2): Corruption
>> of in-memory data (0x8) detected at xfs_trans_cancel+0xc6/0x130 [xfs]
>> (fs/xfs/xfs_trans.c:958). Shutting down filesystem. This indicates in-memory
>> data corruption in the XFS system, and the issue appears after this error.
>
> That sounds like a hardware problem that leads to data corruption.
>
> Check your memory.
>
> Restore your last good backup.
>
> Yours,
> Laurenz Albe
>
> --
>
> *E-Mail Disclaimer*
> Der Inhalt dieser E-Mail ist ausschliesslich fuer den
> bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat
> dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,
> dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder
> Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich
> in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.
>
> *CONFIDENTIALITY NOTICE & DISCLAIMER
> *This message and any attachment are
> confidential and may be privileged or otherwise protected from disclosure
> and solely for the use of the person(s) or entity to whom it is intended.
> If you have received this message in error and are not the intended
> recipient, please notify the sender immediately and delete this message and
> any attachment from your system. If you are not the intended recipient, be
> advised that any use of this message is prohibited and may be unlawful, and
> you must not copy this message or attachment or disclose the contents to
> any other person.