Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.9
-
None
-
None
-
None
-
Linux version 3.18.11-gentoo (root@dbserver15) (gcc version 4.8.4 (Gentoo 4.8.4 p1.4, pie-0.6.1) ) #3 SMP Tue Apr 21 21:05:13 NZST 2015
free -g
total used free shared buff/cache available
Mem: 125 13 0 0 112 112
Description
myisam_use_mmap=1
OUT of memory report and crash at random times.
rebooting with
myisam_use_mmap=0
Does not crash
example, at this time at least 100 Gb free:
2017-11-08 3:38:52 140469833914112 [ERROR] mysqld: Out of memory (Needed 1232 bytes)
|
171108 3:38:52 [ERROR] mysqld got signal 11 ;
|
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.2.9-MariaDB-log
|
key_buffer_size=1073741824
|
read_buffer_size=1048576
|
max_used_connections=155
|
max_threads=8002
|
thread_count=162
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 17602880 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x7fe45dc4c008
|
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 = 0x7fc1ae8d4e78 thread_stack 0x49000
|
*** buffer overflow detected ***: /usr/sbin/mysqld terminated
|
======= Backtrace: =========
|
/lib64/libc.so.6(+0x6fc9b)[0x7fe2fed31c9b]
|
/lib64/libc.so.6(__fortify_fail+0x37)[0x7fe2fedb9ec7]
|
/lib64/libc.so.6(+0xf5fc0)[0x7fe2fedb7fc0]
|
/lib64/libc.so.6(+0xf7e37)[0x7fe2fedb9e37]
|
/usr/sbin/mysqld(my_addr_resolve+0x45)[0x7fe30214c275]
|
/usr/sbin/mysqld(my_print_stacktrace+0x1ba)[0x7fe30213a4ea]
|
/usr/sbin/mysqld(handle_fatal_signal+0x305)[0x7fe301bf0905]
|
/lib64/libpthread.so.0(+0x10f50)[0x7fe300230f50]
|
/usr/sbin/mysqld(+0x5d484a)[0x7fe301b9e84a]
|
/usr/sbin/mysqld(lf_alloc_new+0x7b)[0x7fe3021409db]
|
/usr/sbin/mysqld(lf_hash_insert+0x1f)[0x7fe30214141f]
|
/usr/sbin/mysqld(_Z17tdc_acquire_shareP3THDP10TABLE_LISTjPP5TABLE+0x49c)[0x7fe301ba0b7c]
|
/usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x3c1)[0x7fe301a46a31]
|
/usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xa13)[0x7fe301a49693]
|
/usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x5a)[0x7fe301a49e2a]
|
/usr/sbin/mysqld(+0x512841)[0x7fe301adc841]
|
/usr/sbin/mysqld(_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x7dc)[0x7fe301aecfbc]
|
/usr/sbin/mysqld(_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x266)[0x7fe301aee506]
|
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x6a6)[0x7fe301ad6776]
|
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x30)[0x7fe301ad6e10]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xee)[0x7fe301ad6f5e]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x11e)[0x7fe301ad78ae]
|
/usr/sbin/mysqld(+0x4b72c6)[0x7fe301a812c6]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5ac0)[0x7fe301a8d380]
|
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x23d)[0x7fe301a8ecfd]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xceb)[0x7fe301a8fa4b]
|
/usr/sbin/mysqld(_Z10do_commandP3THD+0xd4)[0x7fe301a91374]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x224)[0x7fe301b4ced4]
|
/usr/sbin/mysqld(handle_one_connection+0x34)[0x7fe301b4cf64]
|
/usr/sbin/mysqld(+0xb39478)[0x7fe302103478]
|
/lib64/libpthread.so.0(+0x7494)[0x7fe300227494]
|
/lib64/libc.so.6(clone+0x6d)[0x7fe2feda9b6d]
|