[Draft] Assorted crashes and assertion failures in and around tdc_remove_table

mysqld: /home/travis/src/sql/table_cache.cc:1125: bool tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, const char*, bool): Assertion `table->in_use == thd' failed.

180308  8:33:07 [ERROR] mysqld got signal 6 ;

Query (0x7fb8700192f8): ALTER TABLE G ADD INDEX `test_idx` USING HASH (`col_varchar_10_utf8`( 7 ), `col_varchar_1024_utf8`( 200 ) )  /* QNO 704 CON_ID 19 */

Connection ID (thread ID): 19

Status: NOT_KILLED

#6  0x00007fb8b5aebbf6 in __assert_fail_base (fmt=0x7fb8b5c40058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5572dc67fd46 "table->in_use == thd", file=file@entry=0x5572dc67fb60 "/home/travis/src/sql/table_cache.cc", line=line@entry=1125, function=function@entry=0x5572dc680660 <tdc_remove_table(THD*, enum_tdc_remove_table_type, char const*, char const*, bool)::__PRETTY_FUNCTION__> "bool tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, const char*, bool)") at assert.c:92

#7  0x00007fb8b5aebca2 in __GI___assert_fail (assertion=0x5572dc67fd46 "table->in_use == thd", file=0x5572dc67fb60 "/home/travis/src/sql/table_cache.cc", line=1125, function=0x5572dc680660 <tdc_remove_table(THD*, enum_tdc_remove_table_type, char const*, char const*, bool)::__PRETTY_FUNCTION__> "bool tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, const char*, bool)") at assert.c:101

#8  0x00005572dbd8af3c in tdc_remove_table (thd=0x7fb870008d60, remove_type=TDC_RT_REMOVE_NOT_OWN, db=0x7fb87407ae08 "test", table_name=0x7fb87407ae0d "G", kill_delayed_threads=false) at /home/travis/src/sql/table_cache.cc:1125

#9  0x00005572dbb234f3 in wait_while_table_is_used (thd=0x7fb870008d60, table=0x7fb8700b1a00, function=HA_EXTRA_PREPARE_FOR_RENAME) at /home/travis/src/sql/sql_base.cc:1206

#10 0x00005572dbc6594b in mysql_inplace_alter_table (thd=0x7fb870008d60, table_list=0x7fb8700194b0, table=0x7fb8700b1a00, altered_table=0x7fb8700b7040, ha_alter_info=0x7fb8b48ec5b0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fb8b48ec620, alter_ctx=0x7fb8b48ed1e0) at /home/travis/src/sql/sql_table.cc:7338

#11 0x00005572dbc6af28 in mysql_alter_table (thd=0x7fb870008d60, new_db=0x7fb870019ac0 "test", new_name=0x0, create_info=0x7fb8b48eddf0, table_list=0x7fb8700194b0, alter_info=0x7fb8b48edd40, order_num=0, order=0x0, ignore=false) at /home/travis/src/sql/sql_table.cc:9353

#12 0x00005572dbce5bc3 in Sql_cmd_alter_table::execute (this=0x7fb870019c98, thd=0x7fb870008d60) at /home/travis/src/sql/sql_alter.cc:324

#13 0x00005572dbba01d6 in mysql_execute_command (thd=0x7fb870008d60) at /home/travis/src/sql/sql_parse.cc:6208

#14 0x00005572dbba4b2f in mysql_parse (thd=0x7fb870008d60, rawbuf=0x7fb8700192f8 "ALTER TABLE G ADD INDEX `test_idx` USING HASH (`col_varchar_10_utf8`( 7 ), `col_varchar_1024_utf8`( 200 ) )  /* QNO 704 CON_ID 19 */", length=132, parser_state=0x7fb8b48ef210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7902

#15 0x00005572dbb92a65 in dispatch_command (command=COM_QUERY, thd=0x7fb870008d60, packet=0x7fb870010a81 " ALTER TABLE G ADD INDEX `test_idx` USING HASH (`col_varchar_10_utf8`( 7 ), `col_varchar_1024_utf8`( 200 ) )  /* QNO 704 CON_ID 19 */ ", packet_length=134, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1806

#16 0x00005572dbb913c8 in do_command (thd=0x7fb870008d60) at /home/travis/src/sql/sql_parse.cc:1360

#17 0x00005572dbce090a in do_handle_one_connection (connect=0x5572decf7e70) at /home/travis/src/sql/sql_connect.cc:1335

#18 0x00005572dbce0697 in handle_one_connection (arg=0x5572decf7e70) at /home/travis/src/sql/sql_connect.cc:1241

#19 0x00007fb8b66ad184 in start_thread (arg=0x7fb8b48f0700) at pthread_create.c:312

#20 0x00007fb8b5bba03d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

perl /home/travis/rqg//run-scenario.pl --duration=350 --threads=6 --seed=1520497971 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--table-open-cache=8 --rpl_mode=row-nosync --mysqld=--slave-skip-errors=all --grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz --scenario=Restart --engine=InnoDB --vardir=/home/travis/logs/vardir1_4

#3  <signal handler called>

#4  0x00005577152bb27e in my_hash_iterate (hash=0x2, action=0x5577152e903d <remove_from_locked_mutex>, argument=0x7f827812e578) at /data/src/10.2/mysys/hash.c:791

#5  0x00005577152e8e2d in safe_mutex_free_deadlock_data (mp=0x7f827812e578) at /data/src/10.2/mysys/thr_mutex.c:656

#6  0x00005577152e8d49 in safe_mutex_destroy (mp=0x7f827812e578, file=0x5577153c09e8 "/data/src/10.2/sql/table.cc", line=444) at /data/src/10.2/mysys/thr_mutex.c:603

#7  0x0000557714a05ba7 in inline_mysql_mutex_destroy (that=0x7f827812e578, src_file=0x5577153c09e8 "/data/src/10.2/sql/table.cc", src_line=444) at /data/src/10.2/include/mysql/psi/mysql_thread.h:640

#8  0x0000557714a0751e in TABLE_SHARE::destroy (this=0x7f827812e488) at /data/src/10.2/sql/table.cc:444

#9  0x0000557714a0771b in free_table_share (share=0x7f827812e488) at /data/src/10.2/sql/table.cc:489

#10 0x0000557714af9d9e in tdc_delete_share_from_hash (element=0x7f828802f7d0) at /data/src/10.2/sql/table_cache.cc:534

#11 0x0000557714afa5ad in tdc_purge (all=true) at /data/src/10.2/sql/table_cache.cc:707

#12 0x00005577148984a0 in close_cached_tables (thd=0x7f8274000b00, tables=0x0, wait_for_refresh=true, timeout=86400) at /data/src/10.2/sql/sql_base.cc:376

#13 0x0000557714a8c4a9 in reload_acl_and_cache (thd=0x7f8274000b00, options=4, tables=0x0, write_to_binlog=0x7f82f0910910) at /data/src/10.2/sql/sql_reload.cc:334

#14 0x0000557714913fae in mysql_execute_command (thd=0x7f8274000b00) at /data/src/10.2/sql/sql_parse.cc:5384

#15 0x000055771491b5d1 in mysql_parse (thd=0x7f8274000b00, rawbuf=0x7f82740110c8 "FLUSH TABLES /* QNO 1535 CON_ID 16 */", length=37, parser_state=0x7f82f0911200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902

#16 0x00005577149094f1 in dispatch_command (command=COM_QUERY, thd=0x7f8274000b00, packet=0x7f8274008851 "FLUSH TABLES /* QNO 1535 CON_ID 16 */ ", packet_length=38, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806

#17 0x0000557714907e54 in do_command (thd=0x7f8274000b00) at /data/src/10.2/sql/sql_parse.cc:1360

#18 0x0000557714a56646 in do_handle_one_connection (connect=0x55771858d860) at /data/src/10.2/sql/sql_connect.cc:1335

#19 0x0000557714a563d3 in handle_one_connection (arg=0x55771858d860) at /data/src/10.2/sql/sql_connect.cc:1241

#20 0x0000557714e761f8 in pfs_spawn_thread (arg=0x557718592440) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#21 0x00007f82fb859494 in start_thread (arg=0x7f82f0912700) at pthread_create.c:333

#22 0x00007f82f9c3f93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

perl ./runall-new.pl --duration=60 --threads=6 --seed=1520488291 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsPreparedTwice,ExecuteAsSPTwice  --mysqld=--log_output=FILE --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/data/bld/10.2   --mysqld=--max-statement-time=30  --mysqld=--table-open-cache=8   --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema  --vardir=/dev/shm/vardir

mysqld: /data/src/10.2/mysys/thr_mutex.c:747: add_to_locked_mutex: Assertion `0' failed.

180308 21:22:30 [ERROR] mysqld got signal 6 ;

Query (0x7f23ec0110c8): OPTIMIZE TABLE t2 /* QNO 1736 CON_ID 17 */

Connection ID (thread ID): 17

Status: NOT_KILLED

#7  0x00007f24704aaee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x00005619ee9f701c in add_to_locked_mutex (locked_mutex=0x7f23ec05b740, current_mutex=0x5619ef5d4400 <LOCK_unused_shares>) at /data/src/10.2/mysys/thr_mutex.c:747

#9  0x00005619ee9f6f20 in add_used_to_locked_mutex (used_mutex=0x5619ef5d4400 <LOCK_unused_shares>, locked_mutex=0x7f23ec05b740) at /data/src/10.2/mysys/thr_mutex.c:721

#10 0x00005619ee9f62b6 in safe_mutex_lock (mp=0x7f23f003dd50, my_flags=0, file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", line=744) at /data/src/10.2/mysys/thr_mutex.c:386

#11 0x00005619ee206b27 in inline_mysql_mutex_lock (that=0x7f23f003dd50, src_file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", src_line=744) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681

#12 0x00005619ee20870f in tdc_lock_share (thd=0x7f23ec000b00, db=0x7f23ec0117e0 "test", table_name=0x7f23ec011198 "t2") at /data/src/10.2/sql/table_cache.cc:744

#13 0x00005619ee20972a in tdc_remove_table (thd=0x7f23ec000b00, remove_type=TDC_RT_REMOVE_UNUSED, db=0x7f23ec0117e0 "test", table_name=0x7f23ec011198 "t2", kill_delayed_threads=false) at /data/src/10.2/sql/table_cache.cc:1086

#14 0x00005619ee17828c in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f23ec000b00, tables=0x7f23ec0111d0, check_opt=0x7f23ec0055a8, operator_name=0x5619eeae4308 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5619ee296de8 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:1152

#15 0x00005619ee178d86 in Sql_cmd_optimize_table::execute (this=0x7f23ec0117e8, thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_admin.cc:1363

#16 0x00005619ee024c57 in mysql_execute_command (thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_parse.cc:6208

#17 0x00005619ee0295d1 in mysql_parse (thd=0x7f23ec000b00, rawbuf=0x7f23ec0110c8 "OPTIMIZE TABLE t2 /* QNO 1736 CON_ID 17 */", length=42, parser_state=0x7f2454e9d200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902

#18 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23ec000b00, packet=0x7f23ec008851 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806

#19 0x00005619ee015e54 in do_command (thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_parse.cc:1360

#20 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335

#21 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241

#22 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f1185a60) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#23 0x00007f2472181494 in start_thread (arg=0x7f2454e9e700) at pthread_create.c:333

#24 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6

perl ./runall-new.pl --duration=60 --threads=6 --seed=1520488291 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsPreparedTwice,ExecuteAsSPTwice  --mysqld=--log_output=FILE --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/data/bld/10.2   --mysqld=--max-statement-time=30  --mysqld=--table-open-cache=8   --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema  --vardir=/dev/shm/vardir2

mysqld: /home/travis/src/sql/table_cache.cc:1101: bool tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, const char*, bool): Assertion `remove_type == TDC_RT_REMOVE_UNUSED || thd->mdl_context.is_lock_owner(MDL_key::TABLE, db, table_name, MDL_EXCLUSIVE)' failed.

180706  8:16:27 [ERROR] mysqld got signal 6 ;

Query (0x7f986c01e108): /* Sequence start */ CREATE TABLE testdb_S.t1_base2_S LIKE test.table1_int_autoinc  /* QNO 1292 CON_ID 18 */

Connection ID (thread ID): 18

Status: KILL_CONNECTION

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on

#7  0x00007f98c304fca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x0000556b96d0e209 in tdc_remove_table (thd=0x7f986c00b460, remove_type=TDC_RT_REMOVE_ALL, db=0x7f986c01e8f8 "test", table_name=0x7f986c01e900 "table1_int_autoinc", kill_delayed_threads=false) at /home/travis/src/sql/table_cache.cc:1099

#9  0x0000556b96bad790 in mysql_rm_table_no_locks (thd=0x7f986c00b460, tables=0x7f986c01e2b0, if_exists=true, drop_temporary=false, drop_view=false, drop_sequence=true, dont_log_query=true, dont_free_locks=true) at /home/travis/src/sql/sql_table.cc:2503

#10 0x0000556b96bb5331 in mysql_create_table_no_lock (thd=0x7f986c00b460, db=0x7f986c01e2c8, table_name=0x7f986c01e2d8, create_info=0x7f98ad551fe0, alter_info=0x7f98ad551f20, is_trans=0x7f98ad551e71, create_table_mode=0, table_list=0x7f986c01e2b0) at /home/travis/src/sql/sql_table.cc:5112

#11 0x0000556b96bb6ad2 in mysql_create_like_table (thd=0x7f986c00b460, table=0x7f986c01e2b0, src_table=0x7f986c01e958, create_info=0x7f98ad553790) at /home/travis/src/sql/sql_table.cc:5644

#12 0x0000556b96ae4e90 in mysql_execute_command (thd=0x7f986c00b460) at /home/travis/src/sql/sql_parse.cc:4253

#13 0x0000556b96af1264 in mysql_parse (thd=0x7f986c00b460, rawbuf=0x7f986c01e108 "/* Sequence start */ CREATE TABLE testdb_S.t1_base2_S LIKE test.table1_int_autoinc  /* QNO 1292 CON_ID 18 */", length=108, parser_state=0x7f98ad554600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8073

#14 0x0000556b96ade607 in dispatch_command (command=COM_QUERY, thd=0x7f986c00b460, packet=0x7f986c015941 "/* Sequence start */ CREATE TABLE testdb_S.t1_base2_S LIKE test.table1_int_autoinc  /* QNO 1292 CON_ID 18 */ ", packet_length=109, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1847

#15 0x0000556b96add038 in do_command (thd=0x7f986c00b460) at /home/travis/src/sql/sql_parse.cc:1392

#16 0x0000556b96c4413d in do_handle_one_connection (connect=0x556b9b0289b0) at /home/travis/src/sql/sql_connect.cc:1402

#17 0x0000556b96c43ec1 in handle_one_connection (arg=0x556b9b0289b0) at /home/travis/src/sql/sql_connect.cc:1308

#18 0x00007f98c3c11184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#19 0x00007f98c311dffd in clone () from /lib/x86_64-linux-gnu/libc.so.6

#7  0x00007fb6c6923ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x000055cc521b5948 in tdc_remove_table (thd=0x7fb644000b00, remove_type=TDC_RT_REMOVE_ALL, db=0x7fb6440111c0 "transforms", table_name=0x7fb6440111d0 "insert_select_10048", kill_delayed_threads=false) at /data/src/10.2/sql/table_cache.cc:1128

#9  0x000055cc52089375 in mysql_rm_table_no_locks (thd=0x7fb644000b00, tables=0x7fb644011228, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false, dont_free_locks=false) at /data/src/10.2/sql/sql_table.cc:2457

#10 0x000055cc52088666 in mysql_rm_table (thd=0x7fb644000b00, tables=0x7fb644011228, if_exists=0 '\000', drop_temporary=0 '\000') at /data/src/10.2/sql/sql_table.cc:2088

#11 0x000055cc51fcba06 in mysql_execute_command (thd=0x7fb644000b00) at /data/src/10.2/sql/sql_parse.cc:4742

#12 0x000055cc51fd55d1 in mysql_parse (thd=0x7fb644000b00, rawbuf=0x7fb6440110c8 "DROP TABLE transforms.insert_select_10048 /* QNO 269 CON_ID 17 */", length=65, parser_state=0x7fb6a931b200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902

#13 0x000055cc51fc34f1 in dispatch_command (command=COM_QUERY, thd=0x7fb644000b00, packet=0x7fb644008851 "DROP TABLE transforms.insert_select_10048 /* QNO 269 CON_ID 17 */ ", packet_length=66, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806

#14 0x000055cc51fc1e54 in do_command (thd=0x7fb644000b00) at /data/src/10.2/sql/sql_parse.cc:1360

#15 0x000055cc52110646 in do_handle_one_connection (connect=0x55cc554fa6a0) at /data/src/10.2/sql/sql_connect.cc:1335

#16 0x000055cc521103d3 in handle_one_connection (arg=0x55cc554fa6a0) at /data/src/10.2/sql/sql_connect.cc:1241

#17 0x000055cc525301f8 in pfs_spawn_thread (arg=0x55cc55f1ba60) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#18 0x00007fb6c85fa494 in start_thread (arg=0x7fb6a931c700) at pthread_create.c:333

#19 0x00007fb6c69e093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

perl ./runall-new.pl --duration=60 --threads=6 --seed=1520488291 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsPreparedTwice,ExecuteAsSPTwice  --mysqld=--log_output=FILE --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/data/bld/10.2   --mysqld=--max-statement-time=30  --mysqld=--table-open-cache=8   --grammar=conf/runtime/performance_schema.yy --mysqld=--performance-schema  --vardir=/dev/shm/vardir3