MariaDB 10.4.10 is crashing after upgrade from 10.3

You are viewing an old version of this question. View the current version here.

PLease find below part of the error which randomly appears during the day. Is it possible that you connect to our system to check?

Mobile: +38641690562

191122 14:32:36 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.

Server version: 10.4.10-MariaDB-log key_buffer_size=6442450944 read_buffer_size=1048576 max_used_connections=107 max_threads=502 thread_count=114 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 7845921 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7ff754f33628 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7ff7a0d58cf0 thread_stack 0x80000 * buffer overflow detected *: /usr/sbin/mysqld terminated

= Backtrace:

/lib64/libc.so.6(fortify_fail+0x37)[0x7ffbac8e7527] /lib64/libc.so.6(+0x1166a2)[0x7ffbac8e56a2] /lib64/libc.so.6(+0x118487)[0x7ffbac8e7487] /usr/sbin/mysqld(my_addr_resolve+0xda)[0x561e8bd3494a] /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x561e8bd1d0c2] /usr/sbin/mysqld(handle_fatal_signal+0x30f)[0x561e8b7b33af] /lib64/libpthread.so.0(+0xf5f0)[0x7ffbae5345f0] /usr/sbin/mysqld(_Z29cleanup_empty_jtbm_semi_joinsP4JOINP4ListI10TABLE_LISTE+0x26)[0x561e8b6cb586] /usr/sbin/mysqld(_ZN4JOIN7cleanupEb+0x1c9)[0x561e8b5e7e29] /usr/sbin/mysqld(_ZN4JOIN7destroyEv+0x46)[0x561e8b5e8446] /usr/sbin/mysqld(_ZN13st_select_lex7cleanupEv+0x68)[0x561e8b648ae8] /usr/sbin/mysqld(_ZN30subselect_single_select_engine7prepareEP3THD+0x44)[0x561e8b868f84] /usr/sbin/mysqld(_ZN14Item_subselect10fix_fieldsEP3THDPP4Item+0x135)[0x561e8b868975] /usr/sbin/mysqld(_ZN17Item_in_subselect10fix_fieldsEP3THDPP4Item+0x8c)[0x561e8b868cbc] /usr/sbin/mysqld(_ZN17Item_in_optimizer10fix_fieldsEP3THDPP4Item+0x1a1)[0x561e8b7f3cf1] /usr/sbin/mysqld(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0x15c)[0x561e8b82047c] /usr/sbin/mysqld(_ZN13Item_func_not10fix_fieldsEP3THDPP4Item+0x1be)[0x561e8b7f130e] /usr/sbin/mysqld(_ZN9Item_cond10fix_fieldsEP3THDPP4Item+0x2c0)[0x561e8b7efbb0] /usr/sbin/mysqld(_ZN3THD16sp_fix_func_itemEPP4Item+0x90)[0x561e8b50c2f0] /usr/sbin/mysqld(_ZN3THD20sp_prepare_func_itemEPP4Itemj+0xf)[0x561e8b50c30f] /usr/sbin/mysqld(_ZN20sp_instr_jump_if_not9exec_coreEP3THDPj+0x1e)[0x561e8b50c35e] /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x155)[0x561e8b512715] /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0xa64)[0x561e8b50df14] /usr/sbin/mysqld(_ZN7sp_head15execute_triggerEP3THDPK25st_mysql_const_lex_stringS4_P13st_grant_info+0x1d7)[0x561e8b50ecb7] /usr/sbin/mysqld(_ZN19Table_triggers_list16process_triggersEP3THD14trg_event_type20trg_action_time_typeb+0x105)[0x561e8b640ad5] /usr/sbin/mysqld(_Z12mysql_updateP3THDP10TABLE_LISTR4ListI4ItemES6_PS4_jP8st_orderybPySA_+0x199a)[0x561e8b64fb8a] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x42cd)[0x561e8b5a899d] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x24b)[0x561e8b5adaeb] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1b5e)[0x561e8b5b08ee] /usr/sbin/mysqld(_Z10do_commandP3THD+0x11c)[0x561e8b5b207c] /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1fa)[0x561e8b68dafa] /usr/sbin/mysqld(handle_one_connection+0x3d)[0x561e8b68dbdd] /lib64/libpthread.so.0(+0x7e65)[0x7ffbae52ce65] /lib64/libc.so.6(clone+0x6d)[0x7ffbac8cd88d]

Answer Answered by Ian Gilfillan in this comment.

As the error message says, I suggest reporting as a bug where someone can gather enough information to try recreate it. There are a quite a few 10.4 bugs that may be related, so your report may help to track this down. If you are looking for someone to log in to your system, I suggest looking into a support contract with one of the MariaDB service providers.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.