InnoDB: Assertion failure in thread 140616411674384 in file dict/dict0dict.c line 1821
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned | ||
5.1 |
Fix Released
|
High
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Unassigned |
Bug Description
I think this issue may have to with the innodb_
InnoDB: Error: Waited for 5 secs for hash index ref_count (12) to drop to 0.
index: "PRIMARY" table: "webchart_
InnoDB: Error: Waited for 10 secs for hash index ref_count (12) to drop to 0.
index: "PRIMARY" table: "webchart_
[...]
InnoDB: Error: Waited for 595 secs for hash index ref_count (12) to drop to 0.
index: "PRIMARY" table: "webchart_
InnoDB: Error: Waited for 600 secs for hash index ref_count (12) to drop to 0.
index: "PRIMARY" table: "webchart_
110615 18:54:11 InnoDB: Assertion failure in thread 140616411674384 in file dict/dict0dict.c line 1821
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
110615 18:54:11 - mysqld got signal 6 ;
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.
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.
key_buffer_
read_buffer_
max_used_
max_threads=100
threads_
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xbbe22d0
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 = 0x7fe3cf446e98 thread_stack 0x40000
/usr/local/
/usr/local/
/lib64/
/lib64/
/lib64/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fe108007aa0): drop table variable_tree
Connection ID (thread ID): 65842
Status: NOT_KILLED
The manual page at http://
information that should help you find out what is causing the crash.
110615 18:54:11 mysqld_safe Number of processes running now: 0
110615 18:54:11 mysqld_safe mysqld restarted
Config:
[client]port = 3306
socket = /tmp/mysql.sock
[mysqld]
myisam_recover
server-id = 1
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
tmpdir = /usr/local/
datadir = /usr/local/
pid-file = /usr/local/
log-bin = /usr/local/
slow_query_log = 1
slow_query_log_file = /usr/local/
log-error = /usr/local/
default-table-type = InnoDB
concurrent_insert = 2
loose_handlerso
loose_handlerso
loose_handlerso
loose_handlerso
open_files_limit = 65535
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_open_files = 1000
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
innodb_
max_connections = 100
table_cache = 10000
open-files-limit = 20000
thread_cache_size = 20
key_buffer_size = 4G
max_heap_table_size = 50M
tmp_table_size = 50M
expire_logs_days = 30
max_binlog_size = 200M
max_allowed_packet = 1G
query_cache_size = 0
query_cache_type = 0
long_query_time = 1
[mysql]
no-auto-rehash
Related branches
- Stewart Smith: Pending requested
-
Diff: 301 lines (+207/-8)1 file modifiedinnodb_fix_misc.patch (+207/-8)
- Stewart Smith: Pending requested
-
Diff: 1151 lines (+949/-32)3 files modifiedinnodb_adaptive_hash_index_partitions.patch (+36/-7)
innodb_buffer_pool_pages_i_s.patch (+2/-2)
innodb_fix_misc.patch (+911/-23)
description: | updated |
Changed in percona-server: | |
assignee: | nobody → Valentine Gostev (longbow) |
tags: | added: i17014 |
Changed in percona-server: | |
assignee: | Valentine Gostev (longbow) → Yasufumi Kinoshita (yasufumi-kinoshita) |
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → High |
As request in i17014, here is the stack strace:
See attached symbol and stack file.
MySQL Version:
Ver 5.1.56-rel12.7-log for unknown-linux-gnu on x86_64 (Percona Server with XtraDB (GPL), Release 12.7, Revision 224)
[xxx]# resolve_stack_dump -s mysqld.sym -n mysql.stack remove_ from_cache + 252 remove_ from_cache + 106 table_for_ mysql + 2009 :delete_ table(char const*) + 205 table(THD* , handlerton*, char const*, char const*, char const*, bool) + 212 table_part2( THD*, TABLE_LIST*, bool, bool, bool, bool) + 1302 table(THD* , TABLE_LIST*, char, char) + 119 command( THD*) + 10942 command( enum_server_ command, THD*, char*, unsigned int) + 2545 one_connection + 1969
0x87a309 my_print_stacktrace + 57
0x5ae1ee handle_segfault + 846
0x7fe3d181d0f0 _end + -794604856
0x7fe3d09e76c5 _end + -809504611
0x7fe3d09e8ea5 _end + -809498499
0x7e7d6c dict_index_
0x7ed00a dict_table_
0x774c29 row_drop_
0x71af3d ha_innobase:
0x691994 ha_delete_
0x698826 mysql_rm_
0x698d57 mysql_rm_
0x5bcb6e mysql_execute_
0x5c067b mysql_parse(THD*, char*, unsigned int, char const**) + 1307
0x5c1071 dispatch_
0x5c1cb8 do_command(THD*) + 296
0x5b3ca1 handle_
0x7fe3d1814a3a _end + -794639342
0x7fe3d0a9367d _end + -808800171