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