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

LP:973039 - Assertion `share->in_trans == 0' failed in maria_close on DROP TABLE under LOCK

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.5.24
    • Component/s: None
    • Labels:

      Description

      https://bugs.launchpad.net/maria/+bug/973039

      Version: '5.5.22-MariaDB-debug-log'

      mysqld: maria-5.5/storage/maria/ma_close.c:88: maria_close: Assertion `share->in_trans == 0' failed
       
      #8 0xb7422014 in __assert_fail () from /lib/libc.so.6
      #9 0x085de4cc in maria_close (info=0x971c778)
          at maria-5.5/storage/maria/ma_close.c:88
      #10 0x0855e645 in ha_maria::close (this=0x9701e50)
          at maria-5.5/storage/maria/ha_maria.cc:1223
      #11 0x083ce4b4 in handler::ha_close (this=0x9701e50)
          at maria-5.5/sql/handler.cc:2284
      #12 0x082ed97e in closefrm (table=0x97016f0, free_share=true)
          at maria-5.5/sql/table.cc:2692
      #13 0x081defc3 in intern_close_table (table=0x97016f0)
          at maria-5.5/sql/sql_base.cc:927
      #14 0x081df03c in free_cache_entry (table=0x97016f0)
          at maria-5.5/sql/sql_base.cc:950
      #15 0x081e0677 in close_thread_table (thd=0x965bbb8, table_ptr=0x9721c10)
          at maria-5.5/sql/sql_base.cc:1633
      #16 0x081dffd0 in close_all_tables_for_name (thd=0x965bbb8, share=0x9704530,
          remove_from_locked_tables=true) at maria-5.5/sql/sql_base.cc:1428
      #17 0x082c0dd8 in mysql_rm_table_no_locks (thd=0x965bbb8, tables=0x970b820,
          if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false)
          at maria-5.5/sql/sql_table.cc:2129
      #18 0x082c0820 in mysql_rm_table (thd=0x965bbb8, tables=0x970b820,
          if_exists=0 '\000', drop_temporary=0 '\000')
          at maria-5.5/sql/sql_table.cc:1929
      #19 0x0823ba68 in mysql_execute_command (thd=0x965bbb8)
          at maria-5.5/sql/sql_parse.cc:3117
      #20 0x08242a67 in mysql_parse (thd=0x965bbb8,
          rawbuf=0x970b780 "DROP TABLE t1, t2", length=17, parser_state=0xad091db8)
          at maria-5.5/sql/sql_parse.cc:5731
      #21 0x08236edc in dispatch_command (command=COM_QUERY, thd=0x965bbb8,
          packet=0x9743ba1 "DROP TABLE t1, t2", packet_length=17)
          at maria-5.5/sql/sql_parse.cc:1055
      #22 0x082363a1 in do_command (thd=0x965bbb8)
          at maria-5.5/sql/sql_parse.cc:794
      #23 0x08320b75 in do_handle_one_connection (thd_arg=0x965bbb8)
          at maria-5.5/sql/sql_connect.cc:1253
      #24 0x083206c0 in handle_one_connection (arg=0x965bbb8)
          at maria-5.5/sql/sql_connect.cc:1168
      #25 0x08548c7b in pfs_spawn_thread (arg=0x974c9e8)
          at maria-5.5/storage/perfschema/pfs.cc:1015
      #26 0xb7701b25 in start_thread () from /lib/libpthread.so.0

      bzr version-info

      revision-id: knielsen@knielsen-hq.org-20120403060057-y2ak3v6lz99m8w5y
      date: 2012-04-03 08:00:57 +0200
      build-date: 2012-04-04 06:45:20 +0400
      revno: 3363

      Could not reproduce on MariaDB 5.3.
      Could not reproduce with MyISAM.

      Test case:

      CREATE TABLE t1 (i INT) ENGINE=Aria;
      CREATE TABLE t2 (i INT) ENGINE=Aria;
      LOCK TABLE t1 WRITE, t2 WRITE;
      # Also fails with FLUSH TABLE t1 and with REPAIR TABLE t1 USE_FRM
      DROP TABLE t1;

      End of test case

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: