From: weijie JL <weijie1006jl@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Subject: Fwd: BUG #18805: A specific query on a hash partitioned table always causes a "signal 11: Segmentation fault" error.
Date: Wed, 12 Feb 2025 16:55:49 +0800
Message-ID: <6E52A7B3-BE1C-4EE2-8AB2-FBF230C1F185@gmail.com> (raw)
References: <e977ec0fc2f9b2409f56e002e6350d2cda17f841.camel@cybertec.at>
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.albe@cybertec.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@gmail.com, pgsql-bugs@lists.postgresql.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.
Attachments:elephant.png (image/png, 59.2K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: weijie1006jl@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Fwd: BUG #18805: A specific query on a hash partitioned table always causes a "signal 11: Segmentation fault" error.
In-Reply-To: <6E52A7B3-BE1C-4EE2-8AB2-FBF230C1F185@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox