[MDEV-366] Assertion `share->reopen == 1' failed in maria_extra on DROP TABLE which is locked twice Created: 2012-06-25  Updated: 2012-08-15  Resolved: 2012-08-15

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.25
Fix Version/s: 5.5.27

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Aria


 Description   

mysqld: storage/maria/ma_extra.c:288: maria_extra: Assertion `share->reopen == 1' failed.

#6  0x00007f245bf72d4d in __GI___assert_fail (assertion=0xe00f12 "share->reopen == 1", file=<optimized out>, line=288, function=<optimized out>) at assert.c:81
#7  0x000000000099ba13 in maria_extra (info=0x3c93c00, function=HA_EXTRA_FORCE_REOPEN, extra_arg=0x0) at storage/maria/ma_extra.c:288
#8  0x00000000009565d0 in ha_maria::extra (this=0x3c93078, operation=HA_EXTRA_FORCE_REOPEN) at storage/maria/ha_maria.cc:2510
#9  0x00000000005ae69d in wait_while_table_is_used (thd=0x3b74110, table=0x3c926b0, function=HA_EXTRA_FORCE_REOPEN) at sql/sql_base.cc:2348
#10 0x000000000069feef in mysql_rm_table_no_locks (thd=0x3b74110, tables=0x3c76a20, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false) at sql/sql_table.cc:2131
#11 0x000000000069f8d4 in mysql_rm_table (thd=0x3b74110, tables=0x3c76a20, if_exists=0 '\000', drop_temporary=0 '\000') at sql/sql_table.cc:1936
#12 0x000000000060f22a in mysql_execute_command (thd=0x3b74110) at sql/sql_parse.cc:3122
#13 0x000000000061674d in mysql_parse (thd=0x3b74110, rawbuf=0x3c76958 "DROP TABLE t1", length=13, parser_state=0x7f2451657500) at sql/sql_parse.cc:5736
#14 0x0000000000609fc3 in dispatch_command (command=COM_QUERY, thd=0x3b74110, packet=0x3c6f141 "DROP TABLE t1", packet_length=13) at sql/sql_parse.cc:1055
#15 0x000000000060927a in do_command (thd=0x3b74110) at sql/sql_parse.cc:794
#16 0x000000000070a69f in do_handle_one_connection (thd_arg=0x3b74110) at sql/sql_connect.cc:1253
#17 0x000000000070a08a in handle_one_connection (arg=0x3b74110) at sql/sql_connect.cc:1168
#18 0x0000000000bffcbf in pfs_spawn_thread (arg=0x3cf7ae0) at storage/perfschema/pfs.cc:1015
#19 0x00007f245ccb4efc in start_thread (arg=0x7f2451658700) at pthread_create.c:304
#20 0x00007f245c02759d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

bzr version-info

revision-id: igor@askmonty.org-20120624161011-v9cilsq09qv4a2li
date: 2012-06-24 09:10:11 -0700
build-date: 2012-06-25 03:03:28 +0400
revno: 3458

Not reproducible on maria/5.3 and maria/5.2.

Test case:

CREATE TABLE t1 (i INT) ENGINE=Aria;
LOCK TABLES t1 WRITE, t1 AS t1a WRITE;
DROP TABLE t1;



 Comments   
Comment by Michael Widenius [ 2012-08-15 ]

Bug in that sql level called ha_extra(HA_EXTRA_FORCE_REOPEN) on a table that was open multiple times.
Fixed and pushed into 5.5
Fix not needed for earlier versions as it only affects DBUG builds

Generated at Thu Feb 08 06:28:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.