[MDEV-14894] [Draft] Assorted crashes and assertion failures in and around tdc_remove_table Created: 2018-01-08  Updated: 2023-11-28  Resolved: 2023-11-28

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: HTML File threads     HTML File threads1     HTML File threads2     HTML File threads3     HTML File threads4    
Issue Links:
Relates
relates to MDEV-11129 CREATE OR REPLACE TABLE t1 AS SELECT ... Closed
relates to MDEV-16773 Assertion `element->all_tables.is_emp... Closed
relates to MDEV-16407 [Draft] Error: Freeing overrun buffer... Closed

 Description   
Assertion `table->in_use == thd'

https://api.travis-ci.org/v3/job/350612237/log.txt
vardir: var-mdev14894-1.tar.gz at ftp://ftp.askmonty.org/public/jira
threads1

10.2 a050189773c911e0b9689aa212c44aaa0cea7b66

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

experimental f6acdbc55e206cf67a3922536e65839f45bc7d7b

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

Not easily reproducible

Crash in in my_hash_iterate

vardir: var-mdev14894-2.tar.gz at ftp://ftp.askmonty.org/public/jira
threads2

10.2 8f98835bb8655

#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

experimental f6acdbc55e2 with alt_drop_foreign_key disabled in conf/mariadb/alter_table.yy

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

Not easily reproducible

Assertion `0' at add_to_locked_mutex

vardir: var-mdev14894-3.tar.gz at ftp://ftp.askmonty.org/public/jira
threads3

10.2 8f98835bb8655

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

experimental f6acdbc55e2 with alt_drop_foreign_key disabled in conf/mariadb/alter_table.yy

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

Assertion `remove_type == TDC_RT_REMOVE_UNUSED

This part is reproduced and extracted into MDEV-20471

10.3 b4c377f21510849a67bcb0c72e8715903883ce4d

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


Assertion `element->all_tables.is_empty()

This part is reproduced and extracted into MDEV-16773

vardir: var-mdev14894-4.tar.gz at ftp://ftp.askmonty.org/public/jira
threads4

10.2 8f98835bb8655

#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

experimental f6acdbc55e2 with alt_drop_foreign_key disabled in conf/mariadb/alter_table.yy

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



 Comments   
Comment by Sergey Vojtovich [ 2018-09-07 ]

First assertion failure mentioned in description "table->in_use == thd" is similar to MDEV-16773. That is this assert is not valid anymore.

Comment by Sergey Vojtovich [ 2018-09-10 ]

First assertion failure was fixed along with MDEV-16773.

Comment by Elena Stepanova [ 2018-11-25 ]

New occurrence of

10.4 27f3329ff6cb755b600d536347669bef1a7d98b5

Assertion `remove_type == TDC_RT_REMOVE_UNUSED || thd->mdl_context.is_lock_owner(MDL_key::TABLE, db, table_name, MDL_EXCLUSIVE)' failed.

on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/459286086

elenst-jira-refs 33ad7f04959f76e6a6553f34ba131dd19884c4f4

perl ./runall-new.pl --basedir=/home/travis/server --vardir=/home/travis/logs/vardir --duration=350 --threads=6 --seed=1543169608 --reporters=Backtrace,ErrorLog,Deadlock --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/instant_add.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/redefine_temporary_tables.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=5 --mysqld=--loose-innodb-lock-wait-timeout=3 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/connect_kill_sql.yy --gendata=conf/runtime/connect_kill_data.zz --mysqld=--loose-file-key-management-filename=/home/travis/rqg/conf/mariadb/encryption_keys.txt

Comment by Elena Stepanova [ 2019-01-13 ]

New occurrence of

mysqld: /home/travis/src/sql/table_cache.cc:1103: 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.

on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/478904037

Comment by Sergey Vojtovich [ 2019-01-14 ]

I guess the above comes from sequence creation failure, which is triggered by CREATE TABLE r LIKE `t002` /* QNO 1913 CON_ID 13 */.
I vaguely remember there was jira task for this issue, but couldn't find it quickly.

Comment by Elena Stepanova [ 2019-02-08 ]

On 10.4 again:
https://travis-ci.org/elenst/travis-tests/jobs/490549924 [2704 4 1]

mysqld: /home/travis/src/sql/table_cache.cc:1103: 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.

https://travis-ci.org/elenst/travis-tests/jobs/490549939 [2704 19 1]
https://travis-ci.org/elenst/travis-tests/jobs/490052191 [2700 29 1]

Comment by Elena Stepanova [ 2019-02-16 ]

https://travis-ci.org/elenst/travis-tests/jobs/491240718 [2718 12 1]

Comment by Elena Stepanova [ 2019-04-05 ]

Keeps happening
on 10.4: https://travis-ci.org/elenst/travis-tests/jobs/512527064 [3093 28 1]

Generated at Thu Feb 08 08:17:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.