From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: liuqi7850@126.com
Subject: BUG #18108: server process was terminated by signal 11: Segmentation fault
Date: Thu, 14 Sep 2023 08:19:03 +0000
Message-ID: <18108-974fbad9f3c11e1c@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18108
Logged by: xianglinsao1
Email address: liuqi7850@126.com
PostgreSQL version: 15.2
Operating system: redhat 7.9
Description:
Recently I executed a merge SQL with over 1.5W rows inside PG15.2, which
caused the database to report a crash error and then terminated all database
sessions，but changing the merge to insert syntax worked fine, I'm trying to
understand where this is and if I need to change the settings.
Below are the DB and OS logs(ID or address data was changed to unreal):
OS LOG：
Sep 14 09:35:29 localhost kernel: postgres[155588]: segfault at
1857ffc ip 00008afe187b4716 sp 0000fdh87ab9818 error 4 in
libc-2.17.so[7efe1dsf65e000+1c4000]
Sep 14 09:35:29 localhost abrt-hook-ccpp: Process 155588 (postgres)
of user 1000 killed by SIGSEGV - dumping core
Sep 14 09:35:37 localhost abrt-server: Package 'postgresql15-server'
isn't signed with proper key
Sep 14 09:35:37 localhost abrt-server: 'post-create' on
'/xxxxxx/ccpp-2023-09-14-09:35:29-145588' exited with 1
Sep 14 09:35:37 localhost abrt-server: Deleting problem directory
'/var/spool/abrt/ccpp-2023-09-14-09:35:29-144588'
DB LOG：
2023-09-14 09:35:37.490 CST [155588] LOG: server process (PID
155588) was terminated by signal 11: Segmentation fault
2023-09-14 09:35:37.490 CST [155588] DETAIL: Failed process was
running: merge into XXXX d using( ******* ) s
WHEN NOT MATCHED THEN INSERT （********） VALUES (*******)
WHEN MATCHED AND (******) THEN UPDATE SET *******
2023-09-14 09:35:37.490 CST [155588] LOG: terminating any other
active server processes
2023-09-14 09:35:37.540 CST [155588] LOG: connection received:
host=xxxxxxxx port=xxxx
2023-09-14 09:35:37.541 CST [155588] FATAL: the database system is
in recovery mode
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, liuqi7850@126.com
Subject: Re: BUG #18108: server process was terminated by signal 11: Segmentation fault
In-Reply-To: <18108-974fbad9f3c11e1c@postgresql.org>
* 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