Jan 30 14:30:21 SQL2 mysqld: 160130 14:30:21 [ERROR] mysqld got signal 11 ; Jan 30 14:30:21 SQL2 mysqld: This could be because you hit a bug. It is also possible that this binary Jan 30 14:30:21 SQL2 mysqld: or one of the libraries it was linked against is corrupt, improperly built, Jan 30 14:30:21 SQL2 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware. Jan 30 14:30:21 SQL2 mysqld: Jan 30 14:30:21 SQL2 mysqld: To report this bug, see http://kb.askmonty.org/en/reporting-bugs Jan 30 14:30:21 SQL2 mysqld: Jan 30 14:30:21 SQL2 mysqld: We will try our best to scrape up some info that will hopefully help Jan 30 14:30:21 SQL2 mysqld: diagnose the problem, but since we have already crashed, Jan 30 14:30:21 SQL2 mysqld: something is definitely wrong and this may fail. Jan 30 14:30:21 SQL2 mysqld: Jan 30 14:30:21 SQL2 mysqld: Server version: 10.1.11-MariaDB-1~jessie-log Jan 30 14:30:21 SQL2 mysqld: key_buffer_size=33554432 Jan 30 14:30:21 SQL2 mysqld: read_buffer_size=1048576 Jan 30 14:30:21 SQL2 mysqld: max_used_connections=24 Jan 30 14:30:21 SQL2 mysqld: max_threads=10002 Jan 30 14:30:21 SQL2 mysqld: thread_count=20 Jan 30 14:30:21 SQL2 mysqld: It is possible that mysqld could use up to Jan 30 14:30:21 SQL2 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 51447637 K bytes of memory Jan 30 14:30:21 SQL2 mysqld: Hope that's ok; if not, decrease some variables in the equation. Jan 30 14:30:21 SQL2 mysqld: Jan 30 14:30:21 SQL2 mysqld: Thread pointer: 0x0x7fabc4e42008 Jan 30 14:30:21 SQL2 mysqld: Attempting backtrace. You can use the following information to find out Jan 30 14:30:21 SQL2 mysqld: where mysqld died. If you see no messages after this, something went Jan 30 14:30:21 SQL2 mysqld: terribly wrong... Jan 30 14:30:21 SQL2 mysqld: stack_bottom = 0x7fb970636df8 thread_stack 0x40000 Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fc1766a732e] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x34d)[0x7fc1761e98fd] Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7fc1758188d0] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG21do_checkpoint_requestEm+0x98)[0x7fc17629ede8] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG20checkpoint_and_purgeEm+0x11)[0x7fc17629ee11] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG23trx_group_commit_leaderEPNS_18group_commit_entryE+0x513)[0x7fc1762a1ce3] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x1bb)[0x7fc1762a216b] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbb+0xcf)[0x7fc1762a239f] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x65951f)[0x7fc1762a251f] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x6598bc)[0x7fc1762a28bc] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x659f8a)[0x7fc1762a2f8a] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z19ha_commit_one_phaseP3THDb+0x92)[0x7fc1761ec262] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z15ha_commit_transP3THDb+0x346)[0x7fc1761eca86] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z17trans_commit_stmtP3THD+0x38)[0x7fc176142f18] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xc3c)[0x7fc1760601fc] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20e)[0x7fc176068a6e] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x420269)[0x7fc176069269] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x181c)[0x7fc17606b0bc] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x16e)[0x7fc17606bd9e] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x182)[0x7fc176134fc2] Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7fc176135180] Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7fc1758110a4] Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fc1739bd9cd] Jan 30 14:30:22 SQL2 mysqld: Jan 30 14:30:22 SQL2 mysqld: Trying to get some variables. Jan 30 14:30:22 SQL2 mysqld: Some pointers may be invalid and cause the dump to abort. Jan 30 14:30:22 SQL2 mysqld: Query (0x7fb968849020): is an invalid pointer Jan 30 14:30:22 SQL2 mysqld: Connection ID (thread ID): 845228 Jan 30 14:30:22 SQL2 mysqld: Status: NOT_KILLED Jan 30 14:30:22 SQL2 mysqld: Jan 30 14:30:22 SQL2 mysqld: 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 Jan 30 14:30:22 SQL2 mysqld: Jan 30 14:30:22 SQL2 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Jan 30 14:30:22 SQL2 mysqld: information that should help you find out what is causing the crash. Jan 30 14:30:33 SQL2 mysqld_safe: Number of processes running now: 0 Jan 30 14:30:33 SQL2 mysqld_safe: WSREP: not restarting wsrep node automatically Jan 30 14:30:33 SQL2 mysqld_safe: mysqld from pid file /data/mysql/sql2.pid ended