Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16362

MariaDB crashing after update to version 10.2.15-1

    XMLWordPrintable

Details

    Description

      I have 3 node cluster that started to crash very often (two times in the last 24 hours) after upgrade mariadb version from 10.2.14 to 10.2.15.

      Logs are reporting the following:

      May 29 20:14:03 sqlserver mysqld: 180529 20:14:03 [ERROR] mysqld got signal 11 ;
      May 29 20:14:03 sqlserver mysqld: This could be because you hit a bug. It is also possible that this binary
      May 29 20:14:03 sqlserver mysqld: or one of the libraries it was linked against is corrupt, improperly built,
      May 29 20:14:03 sqlserver mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
      May 29 20:14:03 sqlserver mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      May 29 20:14:03 sqlserver mysqld: We will try our best to scrape up some info that will hopefully help
      May 29 20:14:03 sqlserver mysqld: diagnose the problem, but since we have already crashed,
      May 29 20:14:03 sqlserver mysqld: something is definitely wrong and this may fail.
      May 29 20:14:03 sqlserver mysqld: Server version: 10.2.15-MariaDB
      May 29 20:14:03 sqlserver mysqld: key_buffer_size=134217728
      May 29 20:14:03 sqlserver mysqld: read_buffer_size=131072
      May 29 20:14:03 sqlserver mysqld: max_used_connections=9
      May 29 20:14:03 sqlserver mysqld: max_threads=153
      May 29 20:14:03 sqlserver mysqld: thread_count=17
      May 29 20:14:03 sqlserver mysqld: It is possible that mysqld could use up to
      May 29 20:14:03 sqlserver mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467238 K  bytes of memory
      May 29 20:14:03 sqlserver mysqld: Hope that's ok; if not, decrease some variables in the equation.
      May 29 20:14:03 sqlserver mysqld: Thread pointer: 0x7fc044002bb8
      May 29 20:14:03 sqlserver mysqld: Attempting backtrace. You can use the following information to find out
      May 29 20:14:03 sqlserver mysqld: where mysqld died. If you see no messages after this, something went
      May 29 20:14:03 sqlserver mysqld: terribly wrong...
      May 29 20:14:03 sqlserver mysqld: stack_bottom = 0x7fc058096d30 thread_stack 0x49000
      May 29 20:14:03 sqlserver mysqld: *** buffer overflow detected ***: /usr/sbin/mysqld terminated
      May 29 20:14:03 sqlserver mysqld: ======= Backtrace: =========
      May 29 20:14:03 sqlserver mysqld: /lib64/libc.so.6(__fortify_fail+0x37)[0x7fc05b97c6e7]
      May 29 20:14:03 sqlserver mysqld: /lib64/libc.so.6(+0x116862)[0x7fc05b97a862]
      May 29 20:14:03 sqlserver mysqld: /lib64/libc.so.6(+0x118647)[0x7fc05b97c647]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(my_addr_resolve+0xda)[0x5637c83aca6a]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x1c2)[0x5637c8396132]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x355)[0x5637c7e21a05]
      May 29 20:14:03 sqlserver mysqld: /lib64/libpthread.so.0(+0xf6d0)[0x7fc05d5c66d0]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z11ull_get_keyPKhPmc+0x14)[0x5637c7e881f4]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(my_hash_first_from_hash_value+0x6b)[0x5637c837359b]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(my_hash_search+0x11)[0x5637c8373701]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN22Item_func_release_lock7val_intEv+0x199)[0x5637c7e8a449]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN4Item4sendEP8ProtocolP6String+0x20c)[0x5637c7e323dc]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xdb)[0x5637c7c1012b]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0x53)[0x5637c7c67e33]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0xaa4)[0x5637c7ce7474]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_ZN4JOIN4execEv+0x33)[0x5637c7ce7623]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x11a)[0x5637c7ce777a]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x5637c7ce82d4]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(+0x4197f9)[0x5637c7bcd7f9]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6864)[0x5637c7c99a24]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x2de)[0x5637c7c9c3ae]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(+0x4e8c7f)[0x5637c7c9cc7f]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xf0b)[0x5637c7c9e21b]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x165)[0x5637c7ca0075]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1aa)[0x5637c7d6230a]
      May 29 20:14:03 sqlserver mysqld: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5637c7d6242d]
      May 29 20:14:03 sqlserver mysqld: /lib64/libpthread.so.0(+0x7e25)[0x7fc05d5bee25]
      May 29 20:14:03 sqlserver mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fc05b962bad]
      
      

      Can you guys please let me know if this is a bug with the new version or something else?

      Thanks in advance for your support.

      Attachments

        Activity

          People

            elenst Elena Stepanova
            oswgarcia Oswaldo Garcia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.