--source include/have_partition.inc

--source include/have_sequence.inc

SET max_statement_time= 5;

CREATE TABLE t1 (a DATETIME) ENGINE=MyISAM PARTITION BY HASH(YEAR(a));

CREATE TABLE t2 (b INT) ENGINE=MyISAM;

CREATE TABLE t3 (c INT) ENGINE=MyISAM;

INSERT INTO t3 SELECT seq FROM seq_1_to_1000000;

--connect (con1,localhost,root,,test)

--let $run= 5

SET lock_wait_timeout= 1;

while ($run)

{

    --echo #

    --echo # $run runs left

    --echo #

    --connection con1

    LOCK TABLES t1 WRITE, t2 WRITE;

    --connection default

    --send

        INSERT INTO t3 SELECT * FROM t3;

    --connection con1

    --send

        FLUSH TABLES;

    --connection default

    --error 0,ER_STATEMENT_TIMEOUT

    --reap

    --connection con1

    --error 0,ER_LOCK_WAIT_TIMEOUT

    --reap

    UNLOCK TABLES;

    --dec $run

}

# Cleanup

--disconnect con1

--connection default

DROP TABLE t1, t2, t3;

mysqld: /data/src/10.1/sql/table_cache.cc:331: bool tc_release_table(TABLE*): Assertion `!table->pos_in_locked_tables' failed.

200207  2:56:09 [ERROR] mysqld got signal 6 ;

#7  0x00007f5cb30f8f12 in __GI___assert_fail (assertion=0x55a9f0b479f9 "!table->pos_in_locked_tables", file=0x55a9f0b479a8 "/data/src/10.1/sql/table_cache.cc", line=331, function=0x55a9f0b47e80 <tc_release_table(TABLE*)::__PRETTY_FUNCTION__> "bool tc_release_table(TABLE*)") at assert.c:101

#8  0x000055a9f032ab23 in tc_release_table (table=0x7f5caa8afe70) at /data/src/10.1/sql/table_cache.cc:331

#9  0x000055a9f00f40d5 in close_thread_table (thd=0x7f5cac3d1070, table_ptr=0x7f5cac3d1130) at /data/src/10.1/sql/sql_base.cc:1091

#10 0x000055a9f00f7c1f in Locked_tables_list::unlink_all_closed_tables (this=0x7f5cac3d4a28, thd=0x7f5cac3d1070, lock=0x0, reopen_count=0) at /data/src/10.1/sql/sql_base.cc:3030

#11 0x000055a9f00f7e61 in Locked_tables_list::reopen_tables (this=0x7f5cac3d4a28, thd=0x7f5cac3d1070, need_reopen=false) at /data/src/10.1/sql/sql_base.cc:3097

#12 0x000055a9f00f31fe in close_cached_tables (thd=0x7f5cac3d1070, tables=0x0, wait_for_refresh=true, timeout=1) at /data/src/10.1/sql/sql_base.cc:596

#13 0x000055a9f02cae5a in reload_acl_and_cache (thd=0x7f5cac3d1070, options=4, tables=0x0, write_to_binlog=0x7f5cb4cd9970) at /data/src/10.1/sql/sql_reload.cc:343

#14 0x000055a9f0164ecb in mysql_execute_command (thd=0x7f5cac3d1070) at /data/src/10.1/sql/sql_parse.cc:4628

#15 0x000055a9f016c761 in mysql_parse (thd=0x7f5cac3d1070, rawbuf=0x7f5caa821088 "FLUSH TABLES", length=12, parser_state=0x7f5cb4cda1e0) at /data/src/10.1/sql/sql_parse.cc:7209

#16 0x000055a9f015b93b in dispatch_command (command=COM_QUERY, thd=0x7f5cac3d1070, packet=0x7f5cac3d7071 "FLUSH TABLES", packet_length=12) at /data/src/10.1/sql/sql_parse.cc:1499

#17 0x000055a9f015a6f9 in do_command (thd=0x7f5cac3d1070) at /data/src/10.1/sql/sql_parse.cc:1131

#18 0x000055a9f0297ae3 in do_handle_one_connection (thd_arg=0x7f5cac3d1070) at /data/src/10.1/sql/sql_connect.cc:1331

#19 0x000055a9f0297814 in handle_one_connection (arg=0x7f5cac3d1070) at /data/src/10.1/sql/sql_connect.cc:1242

#20 0x000055a9f06bd76e in pfs_spawn_thread (arg=0x7f5cb283a670) at /data/src/10.1/storage/perfschema/pfs.cc:1868

#21 0x00007f5cb49a74a4 in start_thread (arg=0x7f5cb4cdb700) at pthread_create.c:456

#22 0x00007f5cb31b5d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97