Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-366

Assertion `share->reopen == 1' failed in maria_extra on DROP TABLE which is locked twice

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 5.5.25
    • 5.5.27
    • None

    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;

      Attachments

        Activity

          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

          monty Michael Widenius added a comment - 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

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.