Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22646

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

    XMLWordPrintable

    Details

      Description

      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=...
      ...
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: