Crash with innodb_lazy_drop_table=ON
Bug #766236 reported by
Vadim Tkachenko
This bug affects 1 person
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
With innodb_
110419 9:20:46 InnoDB: Assertion failure in thread 1342912832 in file fil/fil0fil.c line 834
InnoDB: Failing assertion: UT_LIST_
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.
It is not easy repeatable, I have that innodb_
Related branches
To post a comment you must log in.
I was able to repeat crash second time. 3d298, system=0xe5e1998) at fil/fil0fil.c:834 tablespace (id=13045) at fil/fil0fil.c:2310 table_for_ mysql (name=<value optimized out>, trx=0x2ae00d1e2098, c:3415 :delete_ table (this=<value optimized out>, ha_innodb. cc:7442 f900, table_type= 0xd353220, 674c8 "ts_1000", warning= true) at handler.cc:2005 table_part2 (thd=0x2ae10813 f900, tables= 0x2ae00cc67500, if_exists=false, temporary= false, drop_view=false, dont_log_ query=false) at sql_table.cc:2071 f900, tables= 0x2ae00cc67500, if_exists=0 '\000', temporary= <value optimized out>) at sql_table.cc:1850 command (thd=0x2ae10813 f900) at sql_parse.cc:3549 f900, rawbuf= 0x2ae00cc67430 "DROP TABLE ts_1000", =0x50a41e28) at sql_parse.cc:6219 length= <value optimized out>) at sql_parse.cc:1278 f900) at sql_parse.cc:903 one_connection (arg=0x2ae10813 f900) at sql_connect.cc:1751 libpthread. so.0
bt is
0x0000003c60030265 in raise () from /lib64/libc.so.6
(gdb) bt
#0 0x0000003c60030265 in raise () from /lib64/libc.so.6
#1 0x0000003c60031d10 in abort () from /lib64/libc.so.6
#2 0x00000000007b6c49 in fil_node_close_file (node=0x2ae0077
#3 0x00000000007b7d80 in fil_node_free (id=<value optimized out>, x_latched=1) at fil/fil0fil.c:1050
#4 fil_space_free (id=<value optimized out>, x_latched=1) at fil/fil0fil.c:1376
#5 0x00000000007bd4d2 in fil_delete_
#6 0x0000000000738495 in row_drop_
drop_db=<value optimized out>) at row/row0mysql.
#7 0x00000000006e6fbd in ha_innobase:
name=0x50a3fdc0 "./test1/ts_1000") at handler/
#8 0x000000000065ea56 in ha_delete_table (thd=0x2ae10813
path=<value optimized out>, db=0x2ae00cc67830 "test1", alias=0x2ae00cc
generate_
#9 0x00000000006658ed in mysql_rm_
drop_
#10 0x0000000000665e67 in mysql_rm_table (thd=0x2ae10813
drop_
#11 0x000000000058ddcc in mysql_execute_
#12 0x0000000000590f09 in mysql_parse (thd=0x2ae10813
length=18, found_semicolon
#13 0x0000000000591939 in dispatch_command (command=COM_QUERY, thd=0x2ae10813f900,
packet=<value optimized out>, packet_
#14 0x00000000005925d0 in do_command (thd=0x2ae10813
#15 0x00000000005843b1 in handle_
#16 0x0000003c6080673d in start_thread () from /lib64/
#17 0x0000003c600d3d1d in clone () from /lib64/libc.so.6