Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
5.5.37, 5.5.38
-
None
-
Ubuntu 12.04.4 LTS
Linux debrecen 3.2.0-60-generic #91-Ubuntu SMP Wed Feb 19 03:54:44 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
Description
From mariaddb 5.5.33a mariadb crash after one day uptime
(with 5.5.33a dosnt crash).
I uploaded to ftp.askmonty.org crash report and core files name: mariadb-bug-crash-5.5.38-2014060161434_02.tgz
Error log :
Server version: 5.5.38-MariaDB-1~precise-log
|
key_buffer_size=3221225470
|
read_buffer_size=8388608
|
max_used_connections=77
|
max_threads=122
|
thread_count=73
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 7270511 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0x7f31e15f1000
|
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 = 0x7f30f63fee20 thread_stack 0xc8000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xa7499b]
|
/usr/sbin/mysqld(handle_fatal_signal+0x398)[0x6ccf88]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f399f14fcb0]
|
/lib/x86_64-linux-gnu/libc.so.6(_IO_vfprintf+0x29f1)[0x7f399d93a3b1]
|
/lib/x86_64-linux-gnu/libc.so.6(__fprintf_chk+0xeb)[0x7f399d9f880b]
|
/usr/sbin/mysqld[0x846dcc]
|
/usr/sbin/mysqld[0x847fda]
|
/usr/sbin/mysqld[0x849778]
|
/usr/sbin/mysqld[0x83ec6f]
|
/usr/sbin/mysqld[0x8095bc]
|
/usr/sbin/mysqld(_Z14ha_show_statusP3THDP10handlerton12ha_stat_type+0x217)[0x6d4017]
|
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x3f13)[0x59fcc3]
|
/usr/sbin/mysqld[0x5a1934]
|
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x159f)[0x5a301f]
|
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x1fb)[0x65323b]
|
/usr/sbin/mysqld(handle_one_connection+0x4c)[0x6532bc]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7f399f147e9a]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f399d9e33fd]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f3171026018): SHOW /*!50000 ENGINE*/ INNODB STATUS
|
Connection ID (thread ID): 141550
|
Status: NOT_KILLED
|
|
|
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=off
|
|
|
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.
|
Writing a core file
|