Assertion `table2->cached' failed in dict_table_t::add_to_cache

MariaDB origin/10.3 294ac1fbab306e97dad3588a00e3527f2056e7e4 2020-05-19T15:27:22+00:00 + Patch for MDEV-22633

...

Version: '10.3.24-MariaDB-debug-log'  socket:...

mysqld: /home/mleich/10.3-MDEV-22633/storage/innobase/dict/dict0dict.cc:1274: void dict_table_t::add_to_cache(): Assertion `table2->cached' failed.

...

Query (0x7f31ec010af0): ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx3` ( col_text ), ALGORITHM = NOCOPY

..

Connection ID (thread ID): 39

Status: NOT_KILLED

(rr) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51

#1  0x00007f3289bf9801 in __GI_abort () at abort.c:79

#2  0x00007f3289be939a in __assert_fail_base (fmt=0x7f3289d707d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5635057c8076 "table2->cached", 

    file=file@entry=0x5635057c7c10 "/home/mleich/10.3-MDEV-22633/storage/innobase/dict/dict0dict.cc", line=line@entry=1274, function=function@entry=0x5635057cbc80 <dict_table_t::add_to_cache()::__PRETTY_FUNCTION__> "void dict_table_t::add_to_cache()")

    at assert.c:92

#3  0x00007f3289be9412 in __GI___assert_fail (assertion=0x5635057c8076 "table2->cached", file=0x5635057c7c10 "/home/mleich/10.3-MDEV-22633/storage/innobase/dict/dict0dict.cc", line=1274, 

    function=0x5635057cbc80 <dict_table_t::add_to_cache()::__PRETTY_FUNCTION__> "void dict_table_t::add_to_cache()") at assert.c:101

#4  0x00005635050d0188 in dict_table_t::add_to_cache (this=0x7f31d804ccf0) at /home/mleich/10.3-MDEV-22633/storage/innobase/dict/dict0dict.cc:1272

#5  0x00005635050c3670 in dict_create_table_step (thr=0x7f31ec023650) at /home/mleich/10.3-MDEV-22633/storage/innobase/dict/dict0crea.cc:1275

#6  0x0000563504ea04ce in que_thr_step (thr=0x7f31ec023650) at /home/mleich/10.3-MDEV-22633/storage/innobase/que/que0que.cc:1047

#7  0x0000563504ea06fd in que_run_threads_low (thr=0x7f31ec023650) at /home/mleich/10.3-MDEV-22633/storage/innobase/que/que0que.cc:1101

#8  0x0000563504ea094b in que_run_threads (thr=0x7f31ec023650) at /home/mleich/10.3-MDEV-22633/storage/innobase/que/que0que.cc:1141

#9  0x0000563504f0c92e in row_create_table_for_mysql (table=0x7f31d804ccf0, trx=0x7f326fc09888, mode=FIL_ENCRYPTION_DEFAULT, key_id=1) at /home/mleich/10.3-MDEV-22633/storage/innobase/row/row0mysql.cc:2427

#10 0x00005635051614ec in fts_create_one_index_table (trx=0x7f326fc09888, index=0x7f31e4093740, fts_table=0x7f32500e52e0, heap=0x7f31ec0684e0) at /home/mleich/10.3-MDEV-22633/storage/innobase/fts/fts0fts.cc:1996

#11 0x000056350516179c in fts_create_index_tables (trx=0x7f326fc09888, index=0x7f31e4093740, id=1192) at /home/mleich/10.3-MDEV-22633/storage/innobase/fts/fts0fts.cc:2068

#12 0x0000563504dbac6b in prepare_inplace_alter_table_dict (ha_alter_info=0x7f32500e61e0, altered_table=0x7f31ef4b2be8, old_table=0x7f31e0080cd8, table_name=0x7f31d77bed35 "t1", flags=33, flags2=84, fts_doc_id_col=8, add_fts_doc_id=false,

    add_fts_doc_id_idx=false) at /home/mleich/10.3-MDEV-22633/storage/innobase/handler/handler0alter.cc:5861

#13 0x0000563504dbee2e in ha_innobase::prepare_inplace_alter_table (this=0x7f31e0083570, altered_table=0x7f31ef4b2be8, ha_alter_info=0x7f32500e61e0) at /home/mleich/10.3-MDEV-22633/storage/innobase/handler/handler0alter.cc:6921

#14 0x0000563504b4da44 in handler::ha_prepare_inplace_alter_table (this=0x7f31e0083570, altered_table=0x7f31ef4b2be8, ha_alter_info=0x7f32500e61e0) at /home/mleich/10.3-MDEV-22633/sql/handler.cc:4563

#15 0x00005635049095f0 in mysql_inplace_alter_table (thd=0x7f31ec000ce8, table_list=0x7f31ec010c98, table=0x7f31e0080cd8, altered_table=0x7f31ef4b2be8, ha_alter_info=0x7f32500e61e0, inplace_supported=HA_ALTER_INPLACE_NOCOPY_LOCK,

    target_mdl_request=0x7f32500e6360, alter_ctx=0x7f32500e6910) at /home/mleich/10.3-MDEV-22633/sql/sql_table.cc:7597

#16 0x0000563504910233 in mysql_alter_table (thd=0x7f31ec000ce8, new_db=0x7f31ec0053d0, new_name=0x7f31ec005790, create_info=0x7f32500e7500, table_list=0x7f31ec010c98, alter_info=0x7f32500e7440, order_num=0, order=0x0, ignore=false)

    at /home/mleich/10.3-MDEV-22633/sql/sql_table.cc:9922

#17 0x000056350499e839 in Sql_cmd_alter_table::execute (this=0x7f31ec0113f0, thd=0x7f31ec000ce8) at /home/mleich/10.3-MDEV-22633/sql/sql_alter.cc:512

#18 0x000056350482fdf7 in mysql_execute_command (thd=0x7f31ec000ce8) at /home/mleich/10.3-MDEV-22633/sql/sql_parse.cc:6030

#19 0x0000563504835586 in mysql_parse (thd=0x7f31ec000ce8, rawbuf=0x7f31ec010af0 "ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx3` ( col_text ), ALGORITHM = NOCOPY  /* E_R Thread8 QNO 558 CON_ID 39 */", length=126, parser_state=0x7f32500e8610,

    is_com_multi=false, is_next_command=false) at /home/mleich/10.3-MDEV-22633/sql/sql_parse.cc:7817

#20 0x0000563504821de0 in dispatch_command (command=COM_QUERY, thd=0x7f31ec000ce8, packet=0x7f31ec0087b9 " ALTER TABLE t1 ADD FULLTEXT INDEX IF NOT EXISTS `ftidx3` ( col_text ), ALGORITHM = NOCOPY  /* E_R Thread8 QNO 558 CON_ID 39 */ ",

    packet_length=128, is_com_multi=false, is_next_command=false) at /home/mleich/10.3-MDEV-22633/sql/sql_parse.cc:1855

#21 0x00005635048206fa in do_command (thd=0x7f31ec000ce8) at /home/mleich/10.3-MDEV-22633/sql/sql_parse.cc:1401

#22 0x0000563504998843 in do_handle_one_connection (connect=0x563508c01048) at /home/mleich/10.3-MDEV-22633/sql/sql_connect.cc:1403

#23 0x00005635049985a5 in handle_one_connection (arg=0x563508c01048) at /home/mleich/10.3-MDEV-22633/sql/sql_connect.cc:1308

#24 0x00007f328a8f06db in start_thread (arg=0x7f32500e9700) at pthread_create.c:463

#25 0x00007f3289cda88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

(rr)

RQG:

git clone https://github.com/mleich1/rqg --branch experimental RQG_mleich

origin/experimental b2e97d7d0757fc515591526dcd0c1f3aedd9e0a9 2020-05-19T19:46:01+02:00

perl rqg.pl \

--mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \

--grammar=conf/mariadb/table_stress_innodb.yy \

--gendata=conf/mariadb/table_stress.zz \

--gendata_sql=conf/mariadb/table_stress.sql \

--engine=Innodb \

--reporters=Deadlock1,ErrorLog,Backtrace \

--mysqld=--connect_timeout=60 \

--mysqld=--net_read_timeout=30 \

--mysqld=--net_write_timeout=60 \

--mysqld=--loose-idle_readonly_transaction_timeout=0 \

--mysqld=--loose-idle_transaction_timeout=0 \

--mysqld=--loose-idle_write_transaction_timeout=0 \

--mysqld=--interactive_timeout=28800 \

--mysqld=--lock_wait_timeout=86400 \

--mysqld=--innodb-lock-wait-timeout=50 \

--mysqld=--loose-table_lock_wait_timeout=50 \

--mysqld=--wait_timeout=28800 \

--mysqld=--slave_net_timeout=60 \

--mysqld=--loose-max-statement-time=30 \

--mysqld=--loose-debug_assert_on_not_freed_memory=0 \

--mysqld=--log-output=none \

--duration=300 \

--seed=random \

--sqltrace=MarkErrors \

--threads=9 \

--mysqld=--innodb_adaptive_hash_index=ON \

--mysqld=--innodb_page_size=64K \

--mysqld=--innodb-buffer-pool-size=24M \

--no_mask \

--workdir=...

...