Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.2.2
-
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
- is duplicated by
-
MDEV-9416 MariaDB galera got signal 11 when altering table add unique index
- Closed