[MDEV-11266] MariaDB crashes every other day Created: 2016-11-10  Updated: 2016-11-13  Resolved: 2016-11-13

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2.2
Fix Version/s: 10.2.3

Type: Bug Priority: Critical
Reporter: Ranjan Ghosh Assignee: Nirbhay Choubey (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu Xenial


Issue Links:
Duplicate
is duplicated by MDEV-9416 MariaDB galera got signal 11 when alt... Closed

 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.



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2016-11-13 ]

This issue has been fixed in 10.1 and should be part of the next 10.2 release.

Generated at Thu Feb 08 07:48:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.