10.1.24-MariaDB crash report

[root@centos2 mysql]# mysqld --print-defaults or SHOW VARIABLES

mysqld would have been started with the following arguments:

--port=3306 --socket=/var/lib/mysql/mysql.sock --skip-external-locking --key_buffer_size=8192M --max_allowed_packet=500M --table_open_cache=256 --sort_buffer_size=2M --read_buffer_size=1M --read_rnd_buffer_size=4M --myisam_sort_buffer_size=64M --thread_cache_size=8 --query_cache_size=16M --thread_concurrency=0 --symbolic-links=0 --max_connections=1024 --lower_case_table_names=1 --innodb_data_home_dir=/var/lib/mysql --innodb_data_file_path=ibdata1:10M:autoextend --innodb_log_group_home_dir=/var/lib/mysql --innodb_buffer_pool_size=16G --innodb_log_file_size=5242880 --innodb_log_buffer_size=256M --innodb_flush_log_at_trx_commit=2 --innodb_lock_wait_timeout=50

Jun 23 14:40:11 centos2 mysqld: 170623 14:40:11 [ERROR] mysqld got signal 11 ;

Jun 23 14:40:11 centos2 mysqld: This could be because you hit a bug. It is also possible that this binary

Jun 23 14:40:11 centos2 mysqld: or one of the libraries it was linked against is corrupt, improperly built,

Jun 23 14:40:11 centos2 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.

Jun 23 14:40:11 centos2 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs

Jun 23 14:40:11 centos2 mysqld: We will try our best to scrape up some info that will hopefully help

Jun 23 14:40:11 centos2 mysqld: diagnose the problem, but since we have already crashed,

Jun 23 14:40:11 centos2 mysqld: something is definitely wrong and this may fail.

Jun 23 14:40:11 centos2 mysqld: Server version: 10.1.24-MariaDB

Jun 23 14:40:11 centos2 mysqld: key_buffer_size=8589934592

Jun 23 14:40:11 centos2 mysqld: read_buffer_size=1048576

Jun 23 14:40:11 centos2 mysqld: max_used_connections=234

Jun 23 14:40:11 centos2 mysqld: max_threads=1026

Jun 23 14:40:11 centos2 mysqld: thread_count=67

Jun 23 14:40:11 centos2 mysqld: It is possible that mysqld could use up to

Jun 23 14:40:11 centos2 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 11561556 K  bytes of memory

Jun 23 14:40:11 centos2 mysqld: Hope that's ok; if not, decrease some variables in the equation.

Jun 23 14:40:11 centos2 mysqld: Thread pointer: 0x7ef8d9580008

Jun 23 14:40:11 centos2 mysqld: Attempting backtrace. You can use the following information to find out

Jun 23 14:40:11 centos2 mysqld: where mysqld died. If you see no messages after this, something went

Jun 23 14:40:11 centos2 mysqld: terribly wrong...

Jun 23 14:40:11 centos2 mysqld: stack_bottom = 0x7ef8c48af0b0 thread_stack 0x48400

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7f03b895433e]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x305)[0x7f03b847a0a5]

Jun 23 14:40:11 centos2 mysqld: /lib64/libpthread.so.0(+0xf370)[0x7f03b7a92370]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(_ZN17Query_cache_block11headers_lenEv+0x0)[0x7f03b82b9b10]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(_ZN17Query_cache_block4dataEv+0x11)[0x7f03b82b9b31]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(_ZN11Query_cache6insertEP3THDP15Query_cache_tlsPKcmj+0x5c)[0x7f03b82bd52c]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(net_real_write+0x45)[0x7f03b8267cf5]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(net_flush+0x23)[0x7f03b8268033]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(net_write_command+0x3fb)[0x7f03b826879b]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(cli_advanced_command+0xe2)[0x7f03b8459d32]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(mysql_close_slow_part+0x54)[0x7f03b84572f4]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(mysql_close+0x1a)[0x7f03b845732a]

Jun 23 14:40:11 centos2 mysqld: /usr/lib64/mysql/plugin/ha_federatedx.so(_ZN19federatedx_io_mysqlD1Ev+0x24)[0x7f03b11f8ee4]

Jun 23 14:40:11 centos2 mysqld: /usr/lib64/mysql/plugin/ha_federatedx.so(_ZN14federatedx_txn5closeEP18st_fedrated_server+0x69)[0x7f03b11f8289]

Jun 23 14:40:11 centos2 mysqld: /usr/lib64/mysql/plugin/ha_federatedx.so(+0xa62f)[0x7f03b11f162f]

Jun 23 14:40:11 centos2 mysqld: /usr/lib64/mysql/plugin/ha_federatedx.so(+0xa7e5)[0x7f03b11f17e5]

Jun 23 14:40:11 centos2 mysqld: mysys/stacktrace.c:268(my_print_stacktrace)[0x7f03b11f52b8]

Jun 23 14:40:11 centos2 mysqld: sql/sql_cache.cc:844(Query_cache_block::headers_len())[0x7f03b839b6c8]

Jun 23 14:40:11 centos2 mysqld: sql-common/client.c:701(cli_advanced_command)[0x7f03b82ace26]

Jun 23 14:40:11 centos2 mysqld: /usr/sbin/mysqld(_Z12tc_add_tableP3THDP5TABLE+0x42c)[0x7f03b842e13c]

Jun 23 14:40:11 centos2 mysqld: sql/sql_string.h:312(String::free())[0x7f03b82af87d]

Jun 23 14:40:11 centos2 mysqld: sql/sql_base.cc:4067(open_tables(THD*, DDL_options_st const&, TABLE_LIST**, unsigned int*, unsigned int, Prelocking_strategy*))[0x7f03b82b37a0]

Jun 23 14:40:11 centos2 mysqld: sql/sql_base.cc:5258(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x7f03b82b3b34]

Jun 23 14:40:11 centos2 mysqld: sql/sql_parse.cc:5843(execute_sqlcom_select(THD*, TABLE_LIST*))[0x7f03b82ec91d]

Jun 23 14:40:11 centos2 mysqld: sql/sql_parse.cc:2979(mysql_execute_command(THD*))[0x7f03b82f8fbb]

Jun 23 14:40:11 centos2 mysqld: sql/sql_parse.cc:7340(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x7f03b82fc592]

Jun 23 14:40:11 centos2 mysqld: sql/sql_parse.cc:1490(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x7f03b82ffa6a]

Jun 23 14:40:11 centos2 mysqld: sql/sql_parse.cc:1111(do_command(THD*))[0x7f03b83002ca]

Jun 23 14:40:11 centos2 mysqld: sql/sql_connect.cc:1349(do_handle_one_connection(THD*))[0x7f03b83c839a]

Jun 23 14:40:11 centos2 mysqld: sql/sql_connect.cc:1263(handle_one_connection)[0x7f03b83c8540]

Jun 23 14:40:11 centos2 mysqld: /lib64/libpthread.so.0(+0x7dc5)[0x7f03b7a8adc5]

Jun 23 14:40:11 centos2 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7f03b5ea976d]

Jun 23 14:40:11 centos2 mysqld: Trying to get some variables.

Jun 23 14:40:11 centos2 mysqld: Some pointers may be invalid and cause the dump to abort.

Jun 23 14:40:11 centos2 mysqld: Query (0x7f01b0a29020): SELECT u.id AS u__id, u.created_at AS u__created_at, u.created_by AS u__created_by, u.modified_at AS u__modified_at, u.modi\

fied_by AS u__modified_by, u.record_status AS u__record_status, u.user_name AS u__user_name, u.first_name AS u__first_name, u.last_name AS u__last_name, u.email AS u__email, u.pas\

sword AS u__password, u.md5_password AS u__md5_password, u.group_id AS u__group_id, u.referred_by AS u__referred_by FROM user u WHERE (MD5(u.id) = '8f14e45fceea167a5a36dedd4bea254\

3' AND u.password = '4bf199124c5570a7595614c3fa361b6c') LIMIT 1

Jun 23 14:40:11 centos2 mysqld: Connection ID (thread ID): 1260

Jun 23 14:40:11 centos2 mysqld: Status: NOT_KILLED

Jun 23 14:40:11 centos2 mysqld: Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engin\

e_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=off

Jun 23 14:40:11 centos2 mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

Jun 23 14:40:11 centos2 mysqld: information that should help you find out what is causing the crash.

Jun 23 14:40:11 centos2 abrt-hook-ccpp: Process 20150 (mysqld) of user 27 killed by SIGSEGV - dumping core

Jun 23 14:43:30 centos2 abrt-hook-ccpp: Failed to create core_backtrace: waitpid failed: No child processes

Jun 23 14:43:30 centos2 systemd: mariadb.service: main process exited, code=killed, status=11/SEGV

Jun 23 14:43:30 centos2 systemd: Unit mariadb.service entered failed state.

Jun 23 14:43:30 centos2 systemd: mariadb.service failed.

Jun 23 14:43:33 centos2 abrt-server: Package 'MariaDB-server' isn't signed with proper key

Jun 23 14:43:33 centos2 abrt-server: 'post-create' on '/var/spool/abrt/ccpp-2017-06-23-14:40:11-20150' exited with 1

Jun 23 14:43:33 centos2 abrt-server: Deleting problem directory '/var/spool/abrt/ccpp-2017-06-23-14:40:11-20150'

Jun 23 14:43:36 centos2 systemd: mariadb.service holdoff time over, scheduling restart.

Jun 23 14:43:36 centos2 systemd: Starting MariaDB database server...