Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.23
-
Windows Server 2012 R2, Intel Xeon E5-2630 v3, 128GB RAM, Raid 10 SSD
Description
My server is crashing periodically (every other day?) and I'm getting this report: Could possibly be a memory thing, but I'm not sure. I don't believe this was an issue in 10.0.20, which I recently upgraded from.
mysqld got exception 0xe06d7363 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
Server version: 10.1.23-MariaDB
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=86
|
max_threads=1001
|
thread_count=86
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2489266 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x0
|
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...
|
KERNELBASE.dll!RaiseException()
|
mysqld.exe!_CxxThrowException()[throw.cpp:136]
|
mysqld.exe!std::_Xout_of_range()[xthrow.cpp:25]
|
mysqld.exe!dict_stats_analyze_index_for_n_prefix()[dict0stats.cc:1763]
|
mysqld.exe!dict_stats_analyze_index()[dict0stats.cc:2092]
|
mysqld.exe!dict_stats_update_persistent()[dict0stats.cc:2295]
|
mysqld.exe!dict_stats_update()[dict0stats.cc:3298]
|
mysqld.exe!dict_stats_process_entry_from_recalc_pool()[dict0stats_bg.cc:458]
|
mysqld.exe!dict_stats_thread()[dict0stats_bg.cc:551]
|
KERNEL32.DLL!BaseThreadInitThunk()
|
ntdll.dll!RtlUserThreadStart()
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Here's my config file:
[mysqld]
|
|
datadir=C:/Program Files/MariaDB 10.0/data
|
port=3306
|
|
character-set-server=latin1
|
default_storage_engine=innodb
|
|
sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
|
|
innodb_file_per_table
|
innodb_buffer_pool_size=80G
|
innodb_buffer_pool_instances=16
|
innodb_log_file_size=4G
|
innodb_flush_log_at_trx_commit=2
|
innodb_flush_neighbors=0
|
innodb_thread_concurrency=0
|
|
aria_pagecache_buffer_size=2G
|
|
query_cache_type = 1
|
query_cache_limit = 256K
|
query_cache_min_res_unit = 2k
|
query_cache_size = 80M
|
|
max_connections=10000
|
|
skip-name-resolve
|
|
tmp_table_size=256M
|
max_heap_table_size=256M
|
|
max_allowed_packet=16M
|
|
table_open_cache = 2000
|
table-definition-cache = 2000
|
open_files_limit = 14000
|
innodb_open_files = 6000
|
|
thread_pool_max_threads = 1000
|
|
[client]
|
|
port=3306
|
Attachments
Issue Links
- relates to
-
MDEV-12444 [Draft] InnoDB: Failing assertion: total_recs > 0
- Closed
-
MDEV-13733 Server Crash - mysqld got exception 0xe06d7363
- Closed