BUG #18108: server process was terminated by signal 11: Segmentation fault
От | PG Bug reporting form |
---|---|
Тема | BUG #18108: server process was terminated by signal 11: Segmentation fault |
Дата | |
Msg-id | 18108-974fbad9f3c11e1c@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18108: server process was terminated by signal 11: Segmentation fault
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: