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

MariaDB crashes every other day

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.2.2
    • 10.2.3
    • Galera
    • None
    • Ubuntu Xenial

    Description

      Our MariaDB version (in a Galera 2-node cluster) is currently crashing every few days. It seems the crash is always happening during a TRUNCATE. When I search for this I find various anecdotal bugs reports that are similar but all with an unclear state on wthether they are still relevant... We are using MariaDB from the MariaDB repo (not the one bundled with Ubuntu) and 10.2.2 seems to be the most recent version...

      Nov 10 16:16:27 uhu1 mysqld[28271]: 161110 16:16:27 [ERROR] mysqld got signal 11 ;
      Nov 10 16:16:27 uhu1 mysqld[28271]: This could be because you hit a bug. It is also possible that this binary
      Nov 10 16:16:27 uhu1 mysqld[28271]: or one of the libraries it was linked against is corrupt, improperly built,
      Nov 10 16:16:27 uhu1 mysqld[28271]: or misconfigured. This error can also be caused by malfunctioning hardware.
      Nov 10 16:16:27 uhu1 mysqld[28271]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      Nov 10 16:16:27 uhu1 mysqld[28271]: We will try our best to scrape up some info that will hopefully help
      Nov 10 16:16:27 uhu1 mysqld[28271]: diagnose the problem, but since we have already crashed,
      Nov 10 16:16:27 uhu1 mysqld[28271]: something is definitely wrong and this may fail.
      Nov 10 16:16:27 uhu1 mysqld[28271]: Server version: 10.2.2-MariaDB-1~xenial-log
      Nov 10 16:16:27 uhu1 mysqld[28271]: key_buffer_size=134217728
      Nov 10 16:16:27 uhu1 mysqld[28271]: read_buffer_size=2097152
      Nov 10 16:16:27 uhu1 mysqld[28271]: max_used_connections=31
      Nov 10 16:16:27 uhu1 mysqld[28271]: max_threads=302
      Nov 10 16:16:27 uhu1 mysqld[28271]: thread_count=35
      Nov 10 16:16:27 uhu1 mysqld[28271]: It is possible that mysqld could use up to
      Nov 10 16:16:27 uhu1 mysqld[28271]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1992885 K  bytes of memory
      Nov 10 16:16:27 uhu1 mysqld[28271]: Hope that's ok; if not, decrease some variables in the equation.
      Nov 10 16:16:27 uhu1 mysqld[28271]: Thread pointer: 0x0x7f7303c58008
      Nov 10 16:16:27 uhu1 mysqld[28271]: Attempting backtrace. You can use the following information to find out
      Nov 10 16:16:27 uhu1 mysqld[28271]: where mysqld died. If you see no messages after this, something went
      Nov 10 16:16:27 uhu1 mysqld[28271]: terribly wrong...
      Nov 10 16:16:27 uhu1 mysqld[28271]: stack_bottom = 0x7f73431d58f8 thread_stack 0x48c00
      Nov 10 16:16:27 uhu1 mysqld[28271]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x56365fe2c77e]
      Nov 10 16:16:27 uhu1 mysqld[28271]: /usr/sbin/mysqld(handle_fatal_signal+0x2dd)[0x56365f88372d]
      Nov 10 16:16:27 uhu1 mysqld[28271]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x113e0)[0x7f734f6a43e0]
      Nov 10 16:16:27 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z20ha_abort_transactionP3THDS0_c+0xa3)[0x56365f88db03]
      Nov 10 16:16:27 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z15wsrep_abort_thdPvS_c+0x13c)[0x56365f82d66c]
      Nov 10 16:16:27 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z25wsrep_grant_mdl_exceptionP11MDL_contextP10MDL_ticketPK7MDL_key+0x460)[0x56365f81da90]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZNK8MDL_lock14can_grant_lockE13enum_mdl_typeP11MDL_contextb+0x296)[0x56365f7c4ed6]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN11MDL_context21try_acquire_lock_implEP11MDL_requestPP10MDL_ticket+0xe1)[0x56365f7c5aa1]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN11MDL_context12acquire_lockEP11MDL_requestd+0x2e)[0x56365f7c615e]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN11MDL_context13acquire_locksEP8I_P_ListI11MDL_request16I_P_List_adapterIS1_XadL_ZNS1_12next_in_listEEEXadL_ZNS1_12prev_in_listEEEE16I_P_List_counter21I_P_List_no_push_backIS1_EEd+0xdd)[0x56365f7c6cdd]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z16lock_table_namesP3THDRK14DDL_options_stP10TABLE_LISTS5_mj+0x258)[0x56365f6aaeb8]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN22Sql_cmd_truncate_table10lock_tableEP3THDP10TABLE_LISTPb+0x13a)[0x56365f9cd15a]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN22Sql_cmd_truncate_table14truncate_tableEP3THDP10TABLE_LIST+0x73)[0x56365f9cd273]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_ZN22Sql_cmd_truncate_table7executeEP3THD+0x50)[0x56365f9cd480]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1316)[0x56365f6ef746]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x28a)[0x56365f6f72ea]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(+0x47eac7)[0x56365f6f7ac7]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x11d1)[0x56365f6f92b1]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x17c)[0x56365f6fa89c]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x24a)[0x56365f7bc30a]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x56365f7bc49d]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x770a)[0x7f734f69a70a]
      Nov 10 16:16:28 uhu1 mysqld[28271]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f734ed4582d]
      Nov 10 16:16:28 uhu1 mysqld[28271]: Trying to get some variables.
      Nov 10 16:16:28 uhu1 mysqld[28271]: Some pointers may be invalid and cause the dump to abort.
      Nov 10 16:16:28 uhu1 mysqld[28271]: Query (0x7f7303e19020): TRUNCATE cache_render
      Nov 10 16:16:28 uhu1 mysqld[28271]: Connection ID (thread ID): 136386
      Nov 10 16:16:28 uhu1 mysqld[28271]: Status: NOT_KILLED
      Nov 10 16:16:28 uhu1 mysqld[28271]: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
      Nov 10 16:16:28 uhu1 mysqld[28271]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      Nov 10 16:16:28 uhu1 mysqld[28271]: information that should help you find out what is causing the crash.
      

      Attachments

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              rgpublic Ranjan Ghosh
              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.