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

mariadb crash observed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.6.8
    • N/A
    • Server
    • None
    • Ubuntu 18.04 mariadb package 1:10.6.8+maria~bionic

    Description

      We found a spontaneous crash in our mariadb server. It was configured as a part of galera cluster. The configuration file and error log is attached. If there is not enough information you may raise the concern to me, however the customer is likely unwilling to provide further information, at least they are unwilling to disclose their DB schema.

      Dec  2 08:00:03 mariadb-server mariadbd[14288]: 221202  8:00:03 [ERROR] mysqld got signal 11 ;
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: This could be because you hit a bug. It is also possible that this binary
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: or one of the libraries it was linked against is corrupt, improperly built,
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: We will try our best to scrape up some info that will hopefully help
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: diagnose the problem, but since we have already crashed,
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: something is definitely wrong and this may fail.
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Server version: 10.6.8-MariaDB-1:10.6.8+maria~bionic
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: key_buffer_size=134217728
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: read_buffer_size=131072
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: max_used_connections=10
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: max_threads=153
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: thread_count=12
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: It is possible that mysqld could use up to
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467959 K  bytes of memory
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Hope that's ok; if not, decrease some variables in the equation.
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Thread pointer: 0x7f5198001268
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Attempting backtrace. You can use the following information to find out
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: where mysqld died. If you see no messages after this, something went
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: terribly wrong...
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: stack_bottom = 0x7f519de6bd98 thread_stack 0x49000
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x5626ecd424ee]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(handle_fatal_signal+0x545)[0x5626ec78aa25]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x12980)[0x7f51a1eb8980]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN13st_join_table17save_explain_dataEP20Explain_table_accessybPS_+0x30f)[0x5626ec5bbbdf]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN24save_explain_data_internEP13Explain_querybbbPKc+0xbb5)[0x5626ec5bd7f5]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN17save_explain_dataEP13Explain_querybbbb+0x1e6)[0x5626ec5bdb56]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN13build_explainEv+0x7f)[0x5626ec5bdc2f]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Printing to addr2line failed
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0x62)[0x5626ec5c74b2]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(+0x6f5ee1)[0x5626ec527ee1]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0xb7)[0x5626ec5276d7]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN13st_select_lex14handle_derivedEP3LEXj+0x47)[0x5626ec545b27]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x17f)[0x5626ec5c10cf]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x1636)[0x5626ec5c4c86]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xc3)[0x5626ec5c7513]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xb3)[0x5626ec5c75e3]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x5626ec5c7d11]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(+0x738061)[0x5626ec56a061]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x1298)[0x5626ec566178]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1d6)[0x5626ec56d136]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(+0x73a802)[0x5626ec56c802]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1baf)[0x5626ec56309f]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z10do_commandP3THDb+0x127)[0x5626ec560f47]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3e7)[0x5626ec6658c7]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(handle_one_connection+0x34)[0x5626ec665c54]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /usr/sbin/mariadbd(+0xb9883d)[0x5626ec9ca83d]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f51a1ead6db]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f51a12ab61f]
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Trying to get some variables.
      Dec  2 08:00:03 mariadb-server mariadbd[14288]: Some pointers may be invalid and cause the dump to abort.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            leeyc0 Yiu-Chung Lee
            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.