BUG #18108: server process was terminated by signal 11: Segmentation fault

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: liuqi7850(at)126(dot)com
Subject: BUG #18108: server process was terminated by signal 11: Segmentation fault
Date: 2023-09-14 08:19:03
Message-ID: 18108-974fbad9f3c11e1c@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18108
Logged by: xianglinsao1
Email address: liuqi7850(at)126(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-09-14 08:43:23 BUG #18109: enable_partitionwise_aggregate does not apply when inserting or updating
Previous Message David Rowley 2023-09-14 07:29:40 Re: BUG #18103: bugs of concurrent merge into when use different join plan