Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
-
None
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
- relates to
-
MDEV-22500 Assertion `thd->killed != 0' failed in ha_maria::enable_indexes
- Closed