InnoDB: Assertion failure in thread <nr> in file dict0dict.c line 1883 | in dict_index_remove_from_cache | on ALTER TABLE (related to Bug 897258)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.6 |
Invalid
|
Undecided
|
Laurynas Biveinis |
Bug Description
============= Core file
Program terminated with signal 6, Aborted.
#0 0x00000038e260af59 in pthread_
(gdb) t 4
[Switching to thread 4 (Thread 32221)]#0 __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/
75 return (INTERNAL_
(gdb) bt
#0 __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/
#1 0x0000000000695e23 in handle_fatal_signal (sig=6)
at /home/jenkins/
#2 <signal handler called>
#3 0x00000038e1630285 in raise (sig=<value optimized out>) at ../nptl/
#4 0x00000038e1631d30 in abort () at abort.c:88
#5 0x000000000088f9b4 in dict_index_
at /home/jenkins/
#6 0x00000000008958ad in dict_table_
at /home/jenkins/
#7 0x000000000080c471 in row_drop_
at /home/jenkins/
#8 0x00000000007edd11 in ha_innobase:
at /home/jenkins/
#9 0x000000000069c021 in ha_delete_table (thd=0x163a9e20, table_type=
generate_
#10 0x00000000005e167d in quick_rm_table (base=0x4dbb450, db=0x5f1b048 "test", table_name=
at /home/jenkins/
#11 0x00000000005e3e70 in mysql_alter_table (thd=0x163a9e20, new_db=0x5f1b048 "test", new_name=0x5f1aa98 "table100_
alter_
at /home/jenkins/
#12 0x00000000007bc960 in Alter_table_
at /home/jenkins/
#13 0x000000000057f831 in mysql_execute_
at /home/jenkins/
#14 0x0000000000583113 in mysql_parse (thd=0x163a9e20, rawbuf=<value optimized out>, length=<value optimized out>, parser_
at /home/jenkins/
#15 0x00000000005845da in dispatch_command (command=COM_QUERY, thd=0x163a9e20, packet=<value optimized out>, packet_length=72)
at /home/jenkins/
#16 0x0000000000584966 in do_command (thd=0x163a9e20)
at /home/jenkins/
#17 0x00000000006224c1 in do_handle_
at /home/jenkins/
#18 0x00000000006225b4 in handle_
at /home/jenkins/
#19 0x00000038e260677d in start_thread (arg=<value optimized out>) at pthread_
#20 0x00000038e16d3c1d in clone () from /lib64/libc.so.6
(gdb) f 16
#16 0x0000000000584966 in do_command (thd=0x163a9e20)
at /home/jenkins/
(gdb) p thd->query_
$1 = 0x5f1a970 "ALTER TABLE `table100_
============= Error log
InnoDB: Error: Waited for 600 secs for hash index ref_count (1) to drop to 0.
index: "c32" table: "test/#sql2-4b20-a"
121203 3:48:15 InnoDB: Assertion failure in thread 352803136 in file dict0dict.c line 1883
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.
00:48:15 UTC - mysqld got signal 6 ;
============= Info
The error log shows the same stack trace as seen in bug 897258. The testcase there apparently did not generate the same issue anymore. However, this crash above was seen using RQG testing in release Percona-
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 406 lines (+14/-185) (has conflicts)10 files modifiedPercona-Server/storage/innobase/buf/buf0buf.c (+0/-74)
Percona-Server/storage/innobase/buf/buf0flu.c (+1/-8)
Percona-Server/storage/innobase/buf/buf0lru.c (+0/-40)
Percona-Server/storage/innobase/fil/fil0fil.c (+0/-49)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+8/-2)
Percona-Server/storage/innobase/include/buf0buf.h (+5/-0)
Percona-Server/storage/innobase/include/buf0buf.ic (+0/-1)
Percona-Server/storage/innobase/include/buf0lru.h (+0/-7)
Percona-Server/storage/innobase/include/srv0srv.h (+0/-2)
Percona-Server/storage/innobase/srv/srv0srv.c (+0/-2)
fusion1: /data/ssd/ qa/102/ trial12