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
