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

Assertion `thd->killed != 0' failed in ha_maria::enable_indexes

    XMLWordPrintable

Details

    Description

      Note: the test is for reproducing purposes only! Don't put it into the regression suite, create a better one instead.

      --let $run= 1000
      --let $datadir= `SELECT @@datadir`
       
      while ($run)
      {
        --echo #########################
        --echo # $run run(s) left
       
        CREATE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=Aria;
        INSERT INTO t1 VALUES 
          (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),
          (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),
          (NULL),(NULL),(NULL),(NULL),(NULL);
       
        --connect (con1,localhost,root,,test)
        --send
          CREATE OR REPLACE TABLE t1 (c VARCHAR(1024) NOT NULL) ENGINE=Aria ROW_FORMAT FIXED;
       
        --connection default
        SELECT * FROM t1 INTO OUTFILE 'load_t1';
        LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1;
        LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1;
        LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1;
        LOAD DATA INFILE 'load_t1' REPLACE INTO TABLE t1;
        --error 0,ER_DUP_ENTRY
        ALTER TABLE t1 ADD PRIMARY KEY(c(67));
        --connection con1
        --reap
        --disconnect con1
       
        --connection default
        DROP TABLE t1;
       
        --remove_file $datadir/test/load_t1
        --dec $run
      }
      

      10.0 b7944343dd3

      mysqld: /data/src/10.0/storage/maria/ha_maria.cc:2025: virtual int ha_maria::enable_indexes(uint): Assertion `thd->killed != 0' failed.
      180918  3:30:58 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f7c66263ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00000000009ef1af in ha_maria::enable_indexes (this=0x7f7c5e883888, mode=2) at /data/src/10.0/storage/maria/ha_maria.cc:2025
      #9  0x00000000009ef82f in ha_maria::end_bulk_insert (this=0x7f7c5e883888) at /data/src/10.0/storage/maria/ha_maria.cc:2219
      #10 0x000000000063943e in handler::ha_end_bulk_insert (this=0x7f7c5e883888) at /data/src/10.0/sql/handler.h:2716
      #11 0x0000000000709588 in copy_data_between_tables (thd=0x7f7c602a2070, from=0x7f7c5e8a2070, to=0x7f7c5ebbb070, create=..., ignore=false, order_num=0, order=0x0, copied=0x7f7c68332310, deleted=0x7f7c68332308, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7f7c68331800) at /data/src/10.0/sql/sql_table.cc:9740
      #12 0x0000000000707961 in mysql_alter_table (thd=0x7f7c602a2070, new_db=0x7f7c5e8fa760 "test", new_name=0x0, create_info=0x7f7c683324e0, table_list=0x7f7c5e8fa180, alter_info=0x7f7c68332450, order_num=0, order=0x0, ignore=false) at /data/src/10.0/sql/sql_table.cc:9150
      #13 0x0000000000770139 in Sql_cmd_alter_table::execute (this=0x7f7c5e8fa830, thd=0x7f7c602a2070) at /data/src/10.0/sql/sql_alter.cc:312
      #14 0x0000000000654f0e in mysql_execute_command (thd=0x7f7c602a2070) at /data/src/10.0/sql/sql_parse.cc:5118
      #15 0x0000000000658564 in mysql_parse (thd=0x7f7c602a2070, rawbuf=0x7f7c5e8fa088 "ALTER TABLE t1 ADD PRIMARY KEY(c(67))", length=37, parser_state=0x7f7c68333640) at /data/src/10.0/sql/sql_parse.cc:6637
      #16 0x000000000064ae84 in dispatch_command (command=COM_QUERY, thd=0x7f7c602a2070, packet=0x7f7c617e5071 "ALTER TABLE t1 ADD PRIMARY KEY(c(67))", packet_length=37) at /data/src/10.0/sql/sql_parse.cc:1300
      #17 0x000000000064a184 in do_command (thd=0x7f7c602a2070) at /data/src/10.0/sql/sql_parse.cc:1003
      #18 0x000000000076b88c in do_handle_one_connection (thd_arg=0x7f7c602a2070) at /data/src/10.0/sql/sql_connect.cc:1377
      #19 0x000000000076b5fe in handle_one_connection (arg=0x7f7c602a2070) at /data/src/10.0/sql/sql_connect.cc:1292
      #20 0x0000000000acdbd4 in pfs_spawn_thread (arg=0x7f7c601a2370) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #21 0x00007f7c67f67494 in start_thread (arg=0x7f7c68334700) at pthread_create.c:333
      #22 0x00007f7c6632093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.