Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.28
-
None
-
Centos 7.4.1708 64 bit 64GB ram, hardware raid array
Description
- In the middle of the day, when use is actually low (we run massive updates over night and machine is quite a bit more busy then with many threads going), mariadb died. CPU use was around 12% on one core by mariadb at the time. No idea from the log why, so, including here. From reading the info, it would appear there is no dump, right? I see no reference to any fix in 10.1.29.
mysqld would have been started with the following arguments:
--datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mariadb/mariadb.pid --symbolic-links=0 --innodb_file_per_table=1 --datadir=/home/mysql --socket=/var/lib/mysql/mysql.sock --tmpdir=/home/mysqltemp --log-bin=/var/lib/mysqllogs/binlog --expire_logs_days=3 --log_error=/var/log/mariadb/mariadb.log --slow_query_log=1 --slow_query_log_file=/var/log/mariadb/slow-query.log --long_query_time=30 --log_slow_admin_statements=1 --user=mysql --binlog-format=MIXED --collation_server=latin1_general_cs --group_concat_max_len=2M --server_id=9 --slave_compressed_protocol=1 --symbolic-links=0 --max_connections=250 --thread_handling=pool-of-threads --extra_port=3307 --connect_timeout=50 --max_heap_table_size=512M --tmp_table_size=512M --max_allowed_packet=64M --query_cache_size=128M --query_prealloc_size=499712 --net_read_timeout=300 --net_write_timeout=600 --table_open_cache=10000 --innodb_flush_log_at_trx_commit=0 --innodb_log_file_size=1G --innodb_buffer_pool_size=24G --innodb_lock_wait_timeout=500 --innodb_flush_method=O_DIRECT --innodb_file_format=Barracuda --innodb_status_output=0 --innodb_status_output_locks=1 --innodb_stats_sample_pages=12 --innodb_read_io_threads=8 --key_buffer_size=256M --join_buffer_size=512K --bulk_insert_buffer_size=512M --read_rnd_buffer_size=1M --aria_pagecache_buffer_size=512M --aria_sort_buffer_size=256M
Attachments
Issue Links
- duplicates
-
MDEV-16822 mysqld crash restart
-
- Closed
-
- is duplicated by
-
MDEV-15617 [ERROR] mysqld got signal 11 ;
-
- Closed
-
- relates to
-
MDEV-14272 Mariadb crashes with signal 11 when using federatedx engine and galera
-
- Closed
-
-
MDEV-12951 Server crash [mysqld got exception 0xc0000005]
-
- Closed
-
For easy reference:
171115 12:09:44 [ERROR] mysqld got signal 11 ;
...
Thread pointer: 0x7f85d5ae7008
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f8b80233ff8 thread_stack 0x48400
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55ffd482c92e]
/usr/sbin/mysqld(handle_fatal_signal+0x305)[0x55ffd434fce5]
/lib64/libpthread.so.0(+0xf5e0)[0x7f8c8946f5e0]
/usr/sbin/mysqld(_ZN13QUERY_PROFILE10new_statusEPKcS1_S1_j+0x70)[0x55ffd429e000]
/usr/sbin/mysqld(set_thd_stage_info+0xd4)[0x55ffd4191da4]
/usr/sbin/mysqld(_ZN11Query_cache8try_lockEP3THDNS_19Cache_try_lock_modeE+0x91)[0x55ffd4189031]
/usr/sbin/mysqld(_ZN11Query_cache6insertEP3THDP15Query_cache_tlsPKcmj+0x3f)[0x55ffd418d1ff]
/usr/sbin/mysqld(net_real_write+0x45)[0x55ffd4136e05]
/usr/sbin/mysqld(net_flush+0x23)[0x55ffd4137143]
/usr/sbin/mysqld(net_write_command+0x3fb)[0x55ffd41378ab]
/usr/sbin/mysqld(cli_advanced_command+0xe2)[0x55ffd432f782]
/usr/sbin/mysqld(mysql_send_query+0x31)[0x55ffd432ce61]
/usr/sbin/mysqld(mysql_real_query+0x11)[0x55ffd432ce81]
/usr/lib64/mysql/plugin/ha_federated.so(_ZN12ha_federated4infoEj+0x13c)[0x7f8c7b5f85fc]
/usr/sbin/mysqld(+0x484215)[0x55ffd4214215]
/usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x72f)[0x55ffd421cc2f]
/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x2f)[0x55ffd421f51f]
/usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x8f)[0x55ffd421f65f]
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x255)[0x55ffd42201e5]
/usr/sbin/mysqld(+0x376297)[0x55ffd4106297]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x6cb0)[0x55ffd41ca9b0]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x342)[0x55ffd41cd702]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x280a)[0x55ffd41d106a]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x136)[0x55ffd41d19c6]
/usr/sbin/mysqld(_Z26threadpool_process_requestP3THD+0xfb)[0x55ffd42dad2b]
/usr/sbin/mysqld(+0x598735)[0x55ffd4328735]
/lib64/libpthread.so.0(+0x7e25)[0x7f8c89467e25]
/lib64/libc.so.6(clone+0x6d)[0x7f8c8780b34d]