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

LP:990187 - Assertion `share->reopen == 1' failed at maria_extra on ADD PARTITION

    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/990187

      mysqld: storage/maria/ma_extra.c:288: maria_extra: Assertion `share->reopen == 1' failed.
       
      #6 0x00007f544d7c0d4d in __GI___assert_fail (assertion=0xdf6f72 "share->reopen == 1", file=<optimized out>, line=288, function=<optimized out>) at assert.c:81
      #7 0x0000000000997387 in maria_extra (info=0x34a0a90, function=HA_EXTRA_FORCE_REOPEN, extra_arg=0x0) at storage/maria/ma_extra.c:288
      #8 0x0000000000952038 in ha_maria::extra (this=0x34cf618, operation=HA_EXTRA_FORCE_REOPEN) at storage/maria/ha_maria.cc:2510
      #9 0x0000000000c7bf3a in ha_partition::loop_extra (this=0x34ceb28, operation=HA_EXTRA_FORCE_REOPEN) at sql/ha_partition.cc:6261
      #10 0x0000000000c7b963 in ha_partition::extra (this=0x34ceb28, operation=HA_EXTRA_FORCE_REOPEN) at sql/ha_partition.cc:6025
      #11 0x00000000005ad69f in wait_while_table_is_used (thd=0x3383fe0, table=0x34ce160, function=HA_EXTRA_FORCE_REOPEN) at sql/sql_base.cc:2341
      #12 0x000000000091b73e in fast_alter_partition_table (thd=0x3383fe0, table=0x34ce160, alter_info=0x7f5442ea4660, create_info=0x7f5442ea4560, table_list=0x34867e8, db=0x3486db0 "test", table_name=0x34867b0 "t", fast_alter_table=0x3512590) at sql/sql_partition.cc:6823
      #13 0x00000000006a9877 in mysql_alter_table (thd=0x3383fe0, new_db=0x3486db0 "test", new_name=0x34867b0 "t", create_info=0x7f5442ea4560, table_list=0x34867e8, alter_info=0x7f5442ea4660, order_num=0, order=0x0, ignore=false, require_online=false) at sql/sql_table.cc:6517
      #14 0x000000000092ec66 in Alter_table_statement::execute (this=0x3486fd0, thd=0x3383fe0) at sql/sql_alter.cc:106
      #15 0x00000000006119d9 in mysql_execute_command (thd=0x3383fe0) at sql/sql_parse.cc:4454
      #16 0x0000000000614b7b in mysql_parse (thd=0x3383fe0, rawbuf=0x34866e8 "ALTER TABLE t ADD PARTITION PARTITIONS 2", length=40, parser_state=0x7f5442ea5500) at sql/sql_parse.cc:5731
      #17 0x000000000060841f in dispatch_command (command=COM_QUERY, thd=0x3383fe0, packet=0x347eed1 "ALTER TABLE t ADD PARTITION PARTITIONS 2", packet_length=40) at sql/sql_parse.cc:1055
      #18 0x00000000006076d6 in do_command (thd=0x3383fe0) at sql/sql_parse.cc:794
      #19 0x0000000000707cef in do_handle_one_connection (thd_arg=0x3383fe0) at sql/sql_connect.cc:1253
      #20 0x00000000007076da in handle_one_connection (arg=0x3383fe0) at sql/sql_connect.cc:1168
      #21 0x0000000000bf6a1b in pfs_spawn_thread (arg=0x35077b0) at storage/perfschema/pfs.cc:1015
      #22 0x00007f544e502efc in start_thread (arg=0x7f5442ea6700) at pthread_create.c:304
       
      Query (0x34866e8): ALTER TABLE t ADD PARTITION PARTITIONS 2
      Connection ID (thread ID): 2
      Status: NOT_KILLED

      bzr version-info

      revision-id: sergii@pisem.net-20120421005728-b75h9qm83czzi89k
      date: 2012-04-21 02:57:28 +0200
      build-date: 2012-04-28 03:31:08 +0400
      revno: 3388

      Not reproducible on MariaDB 5.1, 5.2, 5.3.

      1. Test case:

      CREATE TABLE t ( i INT ) ENGINE=Aria
        PARTITION BY HASH(i) PARTITIONS 2;
      ALTER TABLE t ADD PARTITION PARTITIONS 2;

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: