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

Assertion `index->type == 32' failed in dict_index_build_internal_fts

    XMLWordPrintable

Details

    Description

      The assertion only fails on 10.3, while 10.4+ produce the warnings which are probably expected. If they indeed are, then the JIRA entry is for the record only, I don't expect it to be fixed.

      --source include/have_innodb.inc
      		 
       
      		 
      --let $datadir= `select @@datadir`
      		 
       
      		 
      CREATE TABLE t (f CHAR(8), FULLTEXT KEY (f)) ENGINE=InnoDB;
      		 
      FLUSH TABLES t FOR EXPORT;
      		 
      --copy_file $datadir/test/t.ibd $datadir/test/t.ibd.save
      		 
      --copy_file $datadir/test/t.cfg $datadir/test/t.cfg.save
      		 
      UNLOCK TABLES;
      		 
       
      		 
      ALTER TABLE t DISCARD TABLESPACE;
      		 
      --move_file $datadir/test/t.ibd.save $datadir/test/t.ibd
      		 
      --move_file $datadir/test/t.cfg.save $datadir/test/t.cfg
      		 
      ALTER TABLE t IMPORT TABLESPACE;
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;

      10.3 d6e80c21

      		 
      2022-07-07 21:59:14 9 [ERROR] InnoDB: Index `f` of table `test`.`t` is corrupted
      		 
      2022-07-07 21:59:14 9 [Note] InnoDB: Load corrupted index `f` of table `test`.`t`
      		 
      mysqld: /data/src/10.3/storage/innobase/dict/dict0dict.cc:2723: dict_index_t* dict_index_build_internal_fts(dict_index_t*): Assertion `index->type == 32' failed.
      		 
      220707 21:59:14 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007f4e28d1e662 in __GI___assert_fail (assertion=0x55e29bbea851 "index->type == 32", file=0x55e29bbe9620 "/data/src/10.3/storage/innobase/dict/dict0dict.cc", line=2723, function=0x55e29bbea868 "dict_index_t* dict_index_build_internal_fts(dict_index_t*)") at assert.c:101
      		 
      No locals.
      		 
      #8  0x000055e29b58f59e in dict_index_build_internal_fts (index=0x7f4dcc168c20) at /data/src/10.3/storage/innobase/dict/dict0dict.cc:2723
      		 
              new_index = 0x7f4e1dea42b0
      		 
              __PRETTY_FUNCTION__ = "dict_index_t* dict_index_build_internal_fts(dict_index_t*)"
      		 
              table = 0x11d6b0f09c577500
      		 
      #9  0x000055e29b58d297 in dict_index_add_to_cache (index=@0x7f4e1dea4340: 0x7f4dcc168c20, page_no=4294967295, add_v=0x0) at /data/src/10.3/storage/innobase/dict/dict0dict.cc:2014
      		 
              new_index = 0x0
      		 
              n_ord = 139972113234896
      		 
              i = 1285409291122472192
      		 
              __PRETTY_FUNCTION__ = "dberr_t dict_index_add_to_cache(dict_index_t*&, ulint, const dict_add_v_col_t*)"
      		 
      #10 0x000055e29b5aa8d5 in dict_load_indexes (table=0x7f4dcc167bc0, heap=0x7f4dcc03c780, ignore_err=DICT_ERR_IGNORE_FK_NOKEY) at /data/src/10.3/storage/innobase/dict/dict0load.cc:2580
      		 
              index = 0x7f4dcc168c20
      		 
              err_msg = 0x0
      		 
              sys_indexes = 0x55e29d840850
      		 
              sys_index = 0x55e29d842820
      		 
              pcur = {btr_cur = {index = 0x55e29d842820, page_cur = {index = 0x0, rec = 0x7f4e1e1a898c "", offsets = 0x0, block = 0x7f4e1e13eb00}, purge_node = 0x0, left_block = 0x0, thr = 0x0, flag = BTR_CUR_BINARY, tree_height = 1, up_match = 1, up_bytes = 0, low_match = 0, low_bytes = 7, n_fields = 0, n_bytes = 0, fold = 0, path_arr = 0x0, rtr_info = 0x0}, latch_mode = 1, old_stored = false, old_rec = 0x0, old_n_core_fields = 10288, old_n_fields = 0, rel_pos = 0, block_when_stored = {m_block = 0x0, m_page_id = {m_space = 0, m_page_no = 0}}, modify_clock = 0, pos_state = BTR_PCUR_IS_POSITIONED, search_mode = PAGE_CUR_GE, trx_if_known = 0x0, old_rec_buf = 0x0, buf_size = 0}
      		 
              tuple = 0x7f4dcc03c800
      		 
              dfield = 0x7f4dcc03c838
      		 
              rec = 0x7f4e1e1a898c ""
      		 
              buf = 0x7f4dcc03c850 ""
      		 
              mtr = {m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea4628, prev = 0x7f4e1dea4628}}, size_ = 1}, m_size = 32, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea4608, prev = 0x7f4e1dea4608}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\000\353\023\036N\177\000\000\001\000\000\000\000\000\000\000\360\022T\372\023\226.\000`\003\000\000\000\000\000\000\020G\352\035N\177\000\000@B\033(N\177\000\000\000\a\002'N\177\000\000\240\235\332&N\177\000\000\003\021\062\233\342U\000\000\000w\352\035N\177\000\000\000w\352\035N\177\000\000\340F\352\035N\177\000\000\377\377\377\377\377\377\377\377\340F\352\035N\177\000\000\221\021F\233\342U\000\000\263\215%\233\342U\000\000(\347\023\234\342U\000\000\000G\352\035N\177\000\000\320v%\233\000\000\000\000\001\000\000\234\000\000\000\000\000\000\000\000\342U", '\000' <repeats 18 times>..., m_used = 32}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea4868, prev = 0x7f4e1dea4868}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea4848, prev = 0x7f4e1dea4848}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000uW\234\360\260\326\021\260H\352\035N\177\000\000\020N\352\035N\177\000\000\340H\352\035N\177", '\000' <repeats 18 times>, "\300o\352\035N\177\000\000\000\300\004\000\000\000\000\000\002\230E\233\342U\000\000\340H\352\035N\177\000\000\200>\v\314M\177\000\000 I\352\035N\177\000\000@\260E\233\342U\000\000\020I\352\035N\177\000\000\000uW\234\360\260\326\021\000\000\000\000\000\000\000\000\060\360\026\314\000\000\000\000\361\370\310\233\342U\000\000\000\000\000\000\000\000\000\000@I\352\035N\177\000\000\223\331\206\233\000\000\001\000`I\352\035N\177\000\000g\330\206\233\342U\000\000`I\352\035N\177\000\000\223\331\206\233\342U\000\000"..., m_used = 0}}, m_made_dirty = false, m_inside_ibuf = false, m_modifications = false, m_n_log_recs = 0, m_log_mode = MTR_LOG_ALL, m_user_space_id = 0, m_user_space = 0x0, m_state = MTR_STATE_ACTIVE, m_flush_observer = 0x0, m_commit_lsn = 0}
      		 
              error = DB_SUCCESS
      		 
              __PRETTY_FUNCTION__ = "dberr_t dict_load_indexes(dict_table_t*, mem_heap_t*, dict_err_ignore_t)"
      		 
      #11 0x000055e29b5ac2ee in dict_load_table_one (name=@0x7f4e1dea5300: {m_name = 0x7f4dcc011340 "test/t"}, ignore_err=DICT_ERR_IGNORE_FK_NOKEY, fk_tables=std::deque with 0 elements) at /data/src/10.3/storage/innobase/dict/dict0load.cc:2968
      		 
              err = 501894960
      		 
              sys_tables = 0x55e29d843b00
      		 
              pcur = {btr_cur = {index = 0x55e29d845270, page_cur = {index = 0x0, rec = 0x0, offsets = 0x0, block = 0x0}, purge_node = 0x0, left_block = 0x0, thr = 0x0, flag = BTR_CUR_BINARY, tree_height = 1, up_match = 1, up_bytes = 0, low_match = 0, low_bytes = 0, n_fields = 0, n_bytes = 0, fold = 0, path_arr = 0x0, rtr_info = 0x0}, latch_mode = 8, old_stored = false, old_rec = 0x0, old_n_core_fields = 4, old_n_fields = 0, rel_pos = 0, block_when_stored = {m_block = 0x0, m_page_id = {m_space = 0, m_page_no = 0}}, modify_clock = 0, pos_state = BTR_PCUR_NOT_POSITIONED, search_mode = PAGE_CUR_GE, trx_if_known = 0x0, old_rec_buf = 0x0, buf_size = 0}
      		 
              sys_index = 0x55e29d845270
      		 
              tuple = 0x7f4dcc03c800
      		 
              heap = 0x7f4dcc03c780
      		 
              dfield = 0x7f4dcc03c838
      		 
              rec = 0x7f4e1e3f4352 "test/t"
      		 
              field = 0x7f4e1e3f4352 "test/t"
      		 
              len = 6
      		 
              mtr = {m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea4e38, prev = 0x7f4e1dea4e38}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea4e18, prev = 0x7f4e1dea4e18}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\000\000\000\000 ", '\000' <repeats 15 times>, "\001\000\000\000\000\000\000\000\003\021\062\233\342U\000\000\000w\352\035N\177\000\000\000w\352\035N\177\000\000\300N\352\035N\177\000\000\377\377\377\377\377\377\377\377\300N\352\035N\177\000\000\221\021F\233\342U\000\000I\351\061\233\342U\000\000\"\264$\233\342U\000\000\340N\352\035N\177\000\000H\360\067\234\342U\000\000@\360\067\234\342U\000\000\000uW\234\360\260\326\021\000O\352\035N\177\000\000\310p\231\036N\177\000\000\060O\352\035N\177\000\000\001", '\000' <repeats 15 times>, "\300o\352\035N\177\000\000\000\300\004\000\000\000\000\000\002\230E\233\342U\000\000"..., m_used = 0}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea5078, prev = 0x7f4e1dea5078}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea5058, prev = 0x7f4e1dea5058}, m_buf_end = 0, m_magic_n = 375767, m_data = "`\340r)N\177\000\000\000\000\000\000\000\000\000\000pQ\352\035N\177\000\000\200\361r)N\177\000\000\241\022\342(N\177\000\000 R\352\035N\177\000\000\001\000\000\000N\177\000\000\024\000\000\000\000\000\000\000\000T\352\035N\177\000\000\020Q\352\035N\177\000\000 \367r)N\177\000\000PR\352\035N\177\000\000\360\241\356(N\177\000\000\024", '\000' <repeats 23 times>, "\060\360\026\314M\177\000\000@S\352\035N\177\000\000\206\220P\233\342U\000\000\000\000\000\000\000\000\000\000\300\371\276\233\342U\000\000S\f\000\000\000\000\000\000 U\352\035N\177\000\000\000\000\000\000\000\000\000\000\300\217P\233\342U\000\000"..., m_used = 0}}, m_made_dirty = false, m_inside_ibuf = false, m_modifications = false, m_n_log_recs = 0, m_log_mode = MTR_LOG_ALL, m_user_space_id = 0, m_user_space = 0x0, m_state = MTR_STATE_COMMITTED, m_flush_observer = 0x0, m_commit_lsn = 0}
      		 
              _db_stack_frame_ = {func = 0x55e29bbf149d "dict_load_table", file = 0x55e29bbef9c0 "/data/src/10.3/storage/innobase/dict/dict0load.cc", level = 2147483656, line = -1, prev = 0x7f4e1dea5330}
      		 
              __PRETTY_FUNCTION__ = "dict_table_t* dict_load_table_one(const table_name_t&, dict_err_ignore_t, dict_names_t&)"
      		 
              table = 0x7f4dcc167bc0
      		 
              index_load_err = DICT_ERR_IGNORE_FK_NOKEY
      		 
      #12 0x000055e29b5ab313 in dict_load_table (name=0x7f4dcc011340 "test/t", ignore_err=DICT_ERR_IGNORE_FK_NOKEY) at /data/src/10.3/storage/innobase/dict/dict0load.cc:2751
      		 
              fk_list = std::deque with 0 elements
      		 
              result = 0x0
      		 
              i = non-dereferenceable iterator for std::deque
      		 
              _db_stack_frame_ = {func = 0x55e29baede40 "ha_innobase::discard_or_import_tablespace", file = 0x55e29bae71e8 "/data/src/10.3/storage/innobase/handler/ha_innodb.cc", level = 2147483655, line = -1, prev = 0x7f4e1dea5ab0}
      		 
              __PRETTY_FUNCTION__ = "dict_table_t* dict_load_table(const char*, dict_err_ignore_t)"
      		 
      #13 0x000055e29b5ad002 in dict_load_table_on_id (table_id=32, ignore_err=DICT_ERR_IGNORE_FK_NOKEY) at /data/src/10.3/storage/innobase/dict/dict0load.cc:3190
      		 
              table_name = 0x7f4dcc011340 "test/t"
      		 
              id_buf = "\000\000\000\000\000\000\000 "
      		 
              pcur = {btr_cur = {index = 0x55e29d845ea0, page_cur = {index = 0x0, rec = 0x7f4e1e628191 "", offsets = 0x0, block = 0x7f4e1e170300}, purge_node = 0x0, left_block = 0x0, thr = 0x0, flag = BTR_CUR_BINARY, tree_height = 1, up_match = 1, up_bytes = 0, low_match = 0, low_bytes = 7, n_fields = 0, n_bytes = 0, fold = 0, path_arr = 0x0, rtr_info = 0x0}, latch_mode = 1, old_stored = false, old_rec = 0x0, old_n_core_fields = 59121, old_n_fields = 0, rel_pos = 0, block_when_stored = {m_block = 0x0, m_page_id = {m_space = 0, m_page_no = 0}}, modify_clock = 0, pos_state = BTR_PCUR_IS_POSITIONED, search_mode = PAGE_CUR_GE, trx_if_known = 0x0, old_rec_buf = 0x0, buf_size = 0}
      		 
              heap = 0x7f4dcc011270
      		 
              tuple = 0x7f4dcc0112f0
      		 
              dfield = 0x7f4dcc011328
      		 
              sys_table_ids = 0x55e29d845ea0
      		 
              sys_tables = 0x55e29d843b00
      		 
              rec = 0x7f4e1e628191 ""
      		 
              field = 0x7f4e1e628199 "test/tgtid_slave_pos\016\b "
      		 
              len = 6
      		 
              table = 0x0
      		 
              mtr = {m_memo = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea5548, prev = 0x7f4e1dea5548}}, size_ = 1}, m_size = 32, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea5528, prev = 0x7f4e1dea5528}, m_buf_end = 0, m_magic_n = 375767, m_data = "\000\000\000\000\000\000\000\000 \000\000\000\000\000\000\000\000\003\027\036N\177\000\000\001\000\000\000\000\000\000\000\223\331\206\233\000\000\001\000\300U\352\035N\177\000\000\227A\211\233\342U\000\000\300U\352\035N\177\000\000\320\f\000\314M\177\000\000\320\f\000\314M\177\000\000\260\f\000\314\001\000\000\000\000X\352\035N\177\000\000\t4\211\233\000\000\000\000\n\t\311\233\342U", '\000' <repeats 11 times>, "V\352\035N\177\000\000\223\331\206\233\000\000\001\000 V\352\035N\177\000\000\227A\211\233\342U\000\000 V\352\035N\177\000\000\320\f\000\314M\177\000\000\320\f\000\314M\177\000\000\260\f\000\314\001\000\000\000`X\352\035N\177\000\000\t4\211\233\000\000\000\000"..., m_used = 32}}, m_log = {m_heap = 0x0, m_list = {<ilist<mtr_buf_t::block_t, void>> = {sentinel_ = {next = 0x7f4e1dea5788, prev = 0x7f4e1dea5788}}, size_ = 1}, m_size = 0, m_first_block = {<ilist_node<void>> = {next = 0x7f4e1dea5768, prev = 0x7f4e1dea5768}, m_buf_end = 0, m_magic_n = 375767, m_data = "9\376\310\233\342U\000\000`\v\000\314M\177\000\000\340\377\377\377\377\377\377\377\n\t\311\233\342U\000\000\000\000\000\000\000\000\000\000\360W\352\035N\177\000\000g\330\206\233\342U\000\000\000X\352\035N\177\000\000\223\331\206\233\342U\000\000\020X\352\035N\177\000\000`\v\000\314M\177\000\000 X\352\035N\177\000\000\245\r\211\233\342U\000\000\320\f\000\314M\177\000\000\260\f\000\314M\177\000\000PX\352\035N\177\000\000\000uW\234\360\260\326\021\363\241\215\233\342U\000\000\200\065\204\235\342U\000\000pX\352\035N\177\000\000^\215[\233\342U\000\000\000\000\000\000\000\000\000\000\070=\026\314M\177\000\000\000\300\004\000\000\000\000\000\200\065\204\235\342U\000\000"..., m_used = 0}}, m_made_dirty = false, m_inside_ibuf = false, m_modifications = false, m_n_log_recs = 0, m_log_mode = MTR_LOG_ALL, m_user_space_id = 0, m_user_space = 0x0, m_state = MTR_STATE_ACTIVE, m_flush_observer = 0x0, m_commit_lsn = 0}
      		 
              __PRETTY_FUNCTION__ = "dict_table_t* dict_load_table_on_id(table_id_t, dict_err_ignore_t)"
      		 
      #14 0x000055e29b585743 in dict_table_open_on_id_low (table_id=32, ignore_err=DICT_ERR_IGNORE_FK_NOKEY, open_only_if_in_cache=0) at /data/src/10.3/storage/innobase/include/dict0priv.inl:90
      		 
              table = 0x0
      		 
              fold = 424183904935
      		 
              __PRETTY_FUNCTION__ = "dict_table_t* dict_table_open_on_id_low(table_id_t, dict_err_ignore_t, ulint)"
      		 
      #15 0x000055e29b587d43 in dict_table_open_on_id (table_id=32, dict_locked=1, table_op=DICT_TABLE_OP_NORMAL) at /data/src/10.3/storage/innobase/dict/dict0dict.cc:824
      		 
              table = 0x7f4dcc163be0
      		 
              __PRETTY_FUNCTION__ = "dict_table_t* dict_table_open_on_id(table_id_t, ulint, dict_table_op_t)"
      		 
      #16 0x000055e29b23a5b0 in ha_innobase::discard_or_import_tablespace (this=0x7f4dcc16e888, discard=0 '\000') at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:13165
      		 
              _db_stack_frame_ = {func = 0x55e29b92b9e0 "mysql_discard_or_import_tablespace", file = 0x55e29b929b90 "/data/src/10.3/sql/sql_table.cc", level = 2147483654, line = -1, prev = 0x7f4e1dea5cc0}
      		 
              err = DB_SUCCESS
      		 
              id = 32
      		 
              __PRETTY_FUNCTION__ = "virtual int ha_innobase::discard_or_import_tablespace(my_bool)"
      		 
      #17 0x000055e29b006b39 in handler::ha_discard_or_import_tablespace (this=0x7f4dcc16e888, discard=0 '\000') at /data/src/10.3/sql/handler.cc:4587
      		 
              __PRETTY_FUNCTION__ = "int handler::ha_discard_or_import_tablespace(my_bool)"
      		 
      #18 0x000055e29adb9187 in mysql_discard_or_import_tablespace (thd=0x7f4dcc000d90, table_list=0x7f4dcc012bb8, discard=false) at /data/src/10.3/sql/sql_table.cc:6070
      		 
              alter_prelocking_strategy = {<Prelocking_strategy> = {_vptr.Prelocking_strategy = 0x55e29c007788 <vtable for Alter_table_prelocking_strategy+16>}, <No data fields>}
      		 
              error = 6625
      		 
              _db_stack_frame_ = {func = 0x55e29b9112c8 "mysql_execute_command", file = 0x55e29b9106a8 "/data/src/10.3/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f4e1dea5ed0}
      		 
      #19 0x000055e29ae54a62 in Sql_cmd_discard_import_tablespace::execute (this=0x7f4dcc013220, thd=0x7f4dcc000d90) at /data/src/10.3/sql/sql_alter.cc:553
      		 
              select_lex = 0x7f4dcc0053d8
      		 
              table_list = 0x7f4dcc012bb8
      		 
      #20 0x000055e29ace0aae in mysql_execute_command (thd=0x7f4dcc000d90) at /data/src/10.3/sql/sql_parse.cc:6075
      		 
              res = 0
      		 
              up_result = 0
      		 
              lex = 0x7f4dcc004b80
      		 
              select_lex = 0x7f4dcc0053d8
      		 
              first_table = 0x7f4dcc012bb8
      		 
              all_tables = 0x7f4dcc012bb8
      		 
              unit = 0x7f4dcc004c40
      		 
              have_table_map_for_update = false
      		 
              rpl_filter = 0x3889b8931dc
      		 
              _db_stack_frame_ = {func = 0x55e29b9125a0 "mysql_parse", file = 0x55e29b9106a8 "/data/src/10.3/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f4e1dea6400}
      		 
              __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
      		 
              orig_binlog_format = BINLOG_FORMAT_MIXED
      		 
              orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
      		 
      #21 0x000055e29ace6090 in mysql_parse (thd=0x7f4dcc000d90, rawbuf=0x7f4dcc012ad8 "ALTER TABLE t IMPORT TABLESPACE", length=31, parser_state=0x7f4e1dea65b0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7870
      		 
              found_semicolon = 0x0
      		 
              error = 32589
      		 
              lex = 0x7f4dcc004b80
      		 
              err = false
      		 
              _db_stack_frame_ = {func = 0x55e29b910b32 "dispatch_command", file = 0x55e29b9106a8 "/data/src/10.3/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f4e1dea6590}
      		 
              __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
      		 
      #22 0x000055e29acd28c5 in dispatch_command (command=COM_QUERY, thd=0x7f4dcc000d90, packet=0x7f4dcc008f31 "ALTER TABLE t IMPORT TABLESPACE", packet_length=31, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
      		 
              packet_end = 0x7f4dcc012af7 ""
      		 
              parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f4dcc000d90, m_ptr = 0x7f4dcc012af8 "\004", m_tok_start = 0x7f4dcc012af8 "\004", m_tok_end = 0x7f4dcc012af8 "\004", m_end_of_query = 0x7f4dcc012af7 "", m_tok_start_prev = 0x7f4dcc012af7 "", m_buf = 0x7f4dcc012ad8 "ALTER TABLE t IMPORT TABLESPACE", m_buf_length = 31, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7f4dcc012b50 "ALTER TABLE t IMPORT TABLESPACE", m_cpp_ptr = 0x7f4dcc012b6f "", m_cpp_tok_start = 0x7f4dcc012b6f "", m_cpp_tok_start_prev = 0x7f4dcc012b6f "", m_cpp_tok_end = 0x7f4dcc012b6f "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x100009b86d993 <error: Cannot access memory at address 0x100009b86d993>, m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = PRESERVE_COMMENT, m_cpp_text_start = 0x7f4dcc012b5c "t IMPORT TABLESPACE", m_cpp_text_end = 0x7f4dcc012b5d " IMPORT TABLESPACE", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f4dcc004658}
      		 
              net = 0x7f4dcc001098
      		 
              error = false
      		 
              do_end_of_statement = true
      		 
              _db_stack_frame_ = {func = 0x55e29b9108bd "do_command", file = 0x55e29b9106a8 "/data/src/10.3/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f4e1dea6df0}
      		 
              drop_more_results = false
      		 
              __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
      		 
              res = <optimized out>
      		 
      #23 0x000055e29acd1283 in do_command (thd=0x7f4dcc000d90) at /data/src/10.3/sql/sql_parse.cc:1398
      		 
              return_value = false
      		 
              packet = 0x7f4dcc008f30 "\003ALTER TABLE t IMPORT TABLESPACE"
      		 
              packet_length = 32
      		 
              net = 0x7f4dcc001098
      		 
              command = COM_QUERY
      		 
              _db_stack_frame_ = {func = 0x55e29bc927d0 "?func", file = 0x55e29bc927d6 "?file", level = 2147483649, line = -1, prev = 0x0}
      		 
              __PRETTY_FUNCTION__ = "bool do_command(THD*)"
      		 
      #24 0x000055e29ae4e878 in do_handle_one_connection (connect=0x55e29d86cb30) at /data/src/10.3/sql/sql_connect.cc:1403
      		 
              create_user = true
      		 
              thr_create_utime = 3642466182701
      		 
              thd = 0x7f4dcc000d90
      		 
      #25 0x000055e29ae4e5e3 in handle_one_connection (arg=0x55e29d86cb30) at /data/src/10.3/sql/sql_connect.cc:1308
      		 
              connect = 0x55e29d86cb30
      		 
      #26 0x000055e29b7fdb62 in pfs_spawn_thread (arg=0x55e29d8a9060) at /data/src/10.3/storage/perfschema/pfs.cc:1869
      		 
              typed_arg = 0x55e29d8a9060
      		 
              user_arg = 0x55e29d86cb30
      		 
              user_start_routine = 0x55e29ae4e5b3 <handle_one_connection(void*)>
      		 
              pfs = 0x7f4e2701fb40
      		 
              klass = 0x55e29d3ae280
      		 
      #27 0x00007f4e28eb7ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      		 
              ret = <optimized out>
      		 
              pd = <optimized out>
      		 
              unwind_buf = {cancel_jmp_buf = {{jmp_buf = {139973486081792, -2149187085446212743, 140732485058366, 140732485058367, 139973486079936, 311296, 2067352818131342201, 2067394591493264249}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
      		 
              not_first_call = 0
      		 
      #28 0x00007f4e28de7def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

      10.4 9a0cbd31

      		 
      FLUSH TABLES t FOR EXPORT;
      		 
      Warnings:
      		 
      Warning	1235	This version of MariaDB doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.'
      		 
      Warning	1235	This version of MariaDB doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.'
      		 
      UNLOCK TABLES;
      		 
      Warnings:
      		 
      Warning	1235	This version of MariaDB doesn't yet support 'FLUSH TABLES on tables that have an FTS index. FTS auxiliary tables will not be flushed.'
      		 
      ALTER TABLE t DISCARD TABLESPACE;
      		 
      ALTER TABLE t IMPORT TABLESPACE;
      		 
      Warnings:
      		 
      Warning	1817	Index corrupt: Index f not found or corrupt, you should recreate this index.
      		 
      DROP TABLE t;
      		 
      bug.import8a 'innodb'                    [ fail ]  Found warnings/errors in server log file!
      		 
              Test ended at 2022-07-07 22:05:00
      		 
      line
      		 
      2022-07-07 22:04:59 9 [Warning] InnoDB: Skip adjustment of root pages for index `f`.
      		 
      ^ Found warnings in /mnt8t/bld/10.4-debug-nightly/mysql-test/var/log/mysqld.1.err

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.