MariaDB server crash status=11/SEGV on version 10.6.19
Hi, First, I apologize if my English isn't perfect. After upgrading my MariaDB server from version 10.6.18 to 10.6.19. I encountered an issue. When I execute a "SELECT ... FROM ( SELECT ... ) x WHERE x.colume1 .." statement, the server returns the error: "ERROR 2013 (HY000): Lost connection to server during query." I checked the `/var/log/messages` and found this message: "mariadb.service: Main process exited, code=killed, status=11/SEGV.". I used core dumping to investigate further and found that the stack frame count reaches #12171. The error at #0 is "... Item::build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item.h:1928". The previous stack frames keep repeating two frames: #1 Item_func_case_simple::do_build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item_cmpfunc.h:2448 #2 ... Item::build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item.h:1928 My OS is Rocky Linux 8.10. The MariaDB server versions where I encountered this issue are 10.6.19 and 10.11.9. The MariaDB server version without issues is 10.6.18. Has anyone else encountered this problem? Thanks in advance for any help.
On Tue, 20 Aug 2024 05:09:00 -0000 zxc072211--- via discuss <discuss@lists.mariadb.org> wrote:
The error at #0 is "... Item::build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item.h:1928". The previous stack frames keep repeating two frames: #1 Item_func_case_simple::do_build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item_cmpfunc.h:2448 #2 ... Item::build_clone ... at /usr/src/debug/MariaDB-/src_0/sql/item.h:1928
My OS is Rocky Linux 8.10. The MariaDB server versions where I encountered this issue are 10.6.19 and 10.11.9. The MariaDB server version without issues is 10.6.18.
Thank you for providing information about the stack trace and showing the version information! Interesting that Item_func_case_simple::do_build_clone (was build_clone in the previous version) is the only such method that calls build_clone from a parent class: https://github.com/MariaDB/server/compare/mariadb-10.6.18...mariadb-10.6.19#... Perhaps it should have been changed like Item_func_in::do_build_clone and also call do_build_clone from a parent class? https://github.com/MariaDB/server/compare/mariadb-10.6.18...mariadb-10.6.19#... That would resolve to Item_func_or_sum::do_build_clone. Otherwise, indeed, Item_func_case::build_clone is inherited straight from class Item and calls do_build_clone once again. At least that's what Doxygen tells me. -- Best regards, Ivan
Thank you for your reply. I found that this issue has already been reported in Jira MDEV-34783.
Teilnehmer (2)
-
Ivan Krylov -
zxc072211＠gmail.com