Deadlock around remove_table_from_cache with HANDLER + DDL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Philip Stoev |
Bug Description
maria-5.3-handler and mysql-5.1 have a tendency to deadlock if concurrent HANDLER is issued along with ALTER TABLE and logging to CSV table. mysql-5.5 is not affected.
RQG command line:
perl runall.pl --grammar=
This thread appears to be holding everyone else:
# 2011-01-14T10:56:34 #2 0x0876c07e in safe_cond_timedwait (cond=0x8a96f40, mp=0x8a965c0, abstime=0x915db738, file=0x88a8f70 "sql_base.cc", line=8881) at thr_mutex.c:550
# 2011-01-14T10:56:34 #3 0x082f2dc8 in remove_
# 2011-01-14T10:56:34 deleting=0 '\000') at sql_base.cc:8881
# 2011-01-14T10:56:34 #4 0x083ed0ae in wait_while_
# 2011-01-14T10:56:34 #5 0x083f5837 in mysql_alter_table (thd=0xbd89d20, new_db=0xa75cee48 "test", new_name=0xa75cebb8 "table100_
# 2011-01-14T10:56:34 table_list=
# 2011-01-14T10:56:34 #6 0x08299197 in mysql_execute_
# 2011-01-14T10:56:34 #7 0x082a2a8b in mysql_parse (thd=0xbd89d20, rawbuf=0xa75cead8 "ALTER TABLE `table100_
# 2011-01-14T10:56:34 found_semicolon
# 2011-01-14T10:56:34 #8 0x08295107 in dispatch_command (command=COM_QUERY, thd=0xbd89d20, packet=0xbd904b9 "ALTER TABLE `table100_
# 2011-01-14T10:56:34 packet_length=57) at sql_parse.cc:1211
# 2011-01-14T10:56:34 #9 0x082945b4 in do_command (thd=0xbd89d20) at sql_parse.cc:904
# 2011-01-14T10:56:34 #10 0x08291692 in handle_
# 2011-01-14T10:56:34 #11 0x00821919 in start_thread () from /lib/libpthread
# 2011-01-14T10:56:34 #12 0x0076acce in clone () from /lib/libc.so.6
no timeout option applies in this case and the deadlock is permanent and unkillable.
RQG command line:
perl runall.pl --grammar=
Changed in maria: | |
assignee: | nobody → Philip Stoev (philip-stoev) |