Description:
Same assertion : https://bugs.mysql.com/bug.php?id=80669
GDB Info
********
#0 0x00007fe56adb79b1 in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000183f729 in my_write_core (sig=6) at /sda/qa/mysql57_dbg/mysys/stacktrace.c:249
#2 0x0000000000e80e82 in handle_fatal_signal (sig=6) at /sda/qa/mysql57_dbg/sql/signal_handler.cc:220
#3 <signal handler called>
#4 0x00007fe5690d91f7 in raise () from /lib64/libc.so.6
#5 0x00007fe5690da8e8 in abort () from /lib64/libc.so.6
#6 0x0000000001ac0372 in ut_dbg_assertion_failed (expr=0x20e00d0 "fil_space_get(table->space) != __null", file=0x20dfb48 "/sda/qa/mysql57_dbg/storage/innobase/row/row0quiesce.cc", line=724) at /sda/qa/mysql57_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001a478f4 in row_quiesce_table_start (table=0x7fe53d8aa320, trx=0x7fe5598008b0) at /sda/qa/mysql57_dbg/storage/innobase/row/row0quiesce.cc:724
#8 0x00000000018c1556 in ha_innopart::external_lock (this=0x7fe53d837b30, thd=0x7fe53d819000, lock_type=0) at /sda/qa/mysql57_dbg/storage/innobase/handler/ha_innopart.cc:4202
#9 0x0000000000f094c0 in handler::ha_external_lock (this=0x7fe53d837b30, thd=0x7fe53d819000, lock_type=0) at /sda/qa/mysql57_dbg/sql/handler.cc:7908
#10 0x00000000016be43b in lock_external (thd=0x7fe53d819000, tables=0x7fe53d8334b8, count=1) at /sda/qa/mysql57_dbg/sql/lock.cc:389
#11 0x00000000016be13d in mysql_lock_tables (thd=0x7fe53d819000, tables=0x7fe53d82cf60, count=1, flags=4096) at /sda/qa/mysql57_dbg/sql/lock.cc:326
#12 0x0000000001487e1b in lock_tables (thd=0x7fe53d819000, tables=0x7fe53d82c9d0, count=1, flags=4096) at /sda/qa/mysql57_dbg/sql/sql_base.cc:6632
#13 0x00000000014878b1 in open_and_lock_tables (thd=0x7fe53d819000, tables=0x7fe53d82c9d0, flags=4096, prelocking_strategy=0x7fe56b3ae3a0) at /sda/qa/mysql57_dbg/sql/sql_base.cc:6449
#14 0x0000000001549ecf in flush_tables_with_read_lock (thd=0x7fe53d819000, all_tables=0x7fe53d82c9d0) at /sda/qa/mysql57_dbg/sql/sql_reload.cc:476
#15 0x000000000150a261 in mysql_execute_command (thd=0x7fe53d819000, first_level=true) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:4149
#16 0x000000000150dd05 in mysql_parse (thd=0x7fe53d819000, parser_state=0x7fe56b3af550) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:5582
#17 0x0000000001503590 in dispatch_command (thd=0x7fe53d819000, com_data=0x7fe56b3afcb0, command=COM_QUERY) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:1458
#18 0x00000000015024c4 in do_command (thd=0x7fe53d819000) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:999
#19 0x0000000001633442 in handle_connection (arg=0x7fe54e3f0a00) at /sda/qa/mysql57_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#20 0x0000000001cb6b15 in pfs_spawn_thread (arg=0x7fe550fc9c20) at /sda/qa/mysql57_dbg/storage/perfschema/pfs.cc:2190
#21 0x00007fe56adb2e25 in start_thread () from /lib64/libpthread.so.0
#22 0x00007fe56919c34d in clone () from /lib64/libc.so.6
How to repeat:
Testcase
CREATE DATABASE test;
USE test;
CREATE TABLE t1(c1 INT,c2 CHAR)PARTITION BY HASH(c1);
ALTER TABLE t1 DISCARD TABLESPACE;
FLUSH TABLES t1 WITH READ LOCK;
