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

Missing row in FTS_DOC_ID_INDEX during DELETE HISTORY

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
      		 
      create table t1 (a integer, c0 varchar(255), fulltext key (c0))
      		 
      with system versioning engine innodb;
      		 
      insert into t1 values (1, 'politician');
      		 
      update t1 set c0= 'criminal';
      		 
      delete history from t1;
      		 
      drop table t1;

      Result

      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:49
      		 
      #5  0x00007fc4e905f864 in __GI_abort () at abort.c:79
      		 
      #6  0x00007fc4e905f749 in __assert_fail_base (fmt=0x7fc4e91eb458 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x1752672 "0", file=0x17c2a10 "../src/storage/innobase/row/row0upd.cc", line=2439, function=<optimized out>) at assert.c:92
      		 
      #7  0x00007fc4e9071a96 in __GI___assert_fail (assertion=0x1752672 "0", file=0x17c2a10 "../src/storage/innobase/row/row0upd.cc", line=2439, function=0x17c3feb "dberr_t row_upd_sec_index_entry(upd_node_t *, que_thr_t *)") at assert.c:101
      		 
      #8  0x000000000105a12b in row_upd_sec_index_entry (node=0x7fc48c0fa8a0, thr=0x7fc48c0fbe98) at ../src/storage/innobase/row/row0upd.cc:2439
      		 
      #9  0x000000000105464d in row_upd_sec_step (node=0x7fc48c0fa8a0, thr=0x7fc48c0fbe98) at ../src/storage/innobase/row/row0upd.cc:2582
      		 
      #10 0x0000000001050797 in row_upd (node=0x7fc48c0fa8a0, thr=0x7fc48c0fbe98) at ../src/storage/innobase/row/row0upd.cc:3331
      		 
      #11 0x0000000001050045 in row_upd_step (thr=0x7fc48c0fbe98) at ../src/storage/innobase/row/row0upd.cc:3446
      		 
      #12 0x0000000000fd1fe0 in row_update_for_mysql (prebuilt=0x7fc48c0f9ba8) at ../src/storage/innobase/row/row0mysql.cc:1844
      		 
      #13 0x0000000000df00bc in ha_innobase::delete_row (this=0x7fc48c0ec840, record=0x7fc48c0eb290 "\374\001") at ../src/storage/innobase/handler/ha_innodb.cc:9040
      		 
      #14 0x0000000000b57ece in handler::ha_delete_row (this=0x7fc48c0ec840, buf=0x7fc48c0eb290 "\374\001") at ../src/sql/handler.cc:6566
      		 
      #15 0x0000000000d57a7e in TABLE::delete_row (this=0x7fc48c0f8f68) at ../src/sql/sql_delete.cc:245
      		 
      #16 0x0000000000d540cc in mysql_delete (thd=0x7fc48c000d28, table_list=0x7fc48c0613e0, conds=0x7fc48c01e5c0, order_list=0x7fc48c005670, limit=18446744073709551615, options=0, result=0x0) at ../src/sql/sql_delete.cc:730
      		 
      #17 0x00000000007ce0a3 in mysql_execute_command (thd=0x7fc48c000d28) at ../src/sql/sql_parse.cc:4707
      		 
      #18 0x00000000007c5516 in mysql_parse (thd=0x7fc48c000d28, rawbuf=0x7fc48c0e3120 "delete history from t1", length=22, parser_state=0x7fc4e2237548, is_com_multi=false, is_next_command=false) at ../src/sql/sql_parse.cc:7870

      Attachments

        1. TBR-1468.zz
          1 kB
        2. TBR-1468.cfg
          43 kB
        3. TBR-1468_mic.yy
          0.9 kB
        4. RR_REPLAY_SIMP.sh
          11 kB
        5. breaks.txt
          5 kB
        6. breaks.gdb
          2 kB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30528 Assertion `!mbmaxlen || !(prefix_len % mbmaxlen)' failed in dtype_get_at_most_n_mbchars

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30235 InnoDB crash on table-rebuilding DDL when the statistics tables are corrupted

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24508 Assertion `!strcmp(index->name, "FTS_DOC_ID_INDEX")' failed in row_ins

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30028 InnoDB: Failing assertion: result != FTS_INVALID with versioned table

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21138 Assertion `col->ord_part' or `f.col->ord_part' failed in row_build_index_entry_low, assertion: buf != field_ref_zero in row_merge_buf_add

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28916 Assertion `"unexpected error" == 0' failed in dberr_t row_update_for_mysql(row_prebuilt_t*)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30338 FTS test crash on ALTER TABLE when InnoDB statistics tables are corrupted

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23644 Assertion on evaluating foreign referential action for self-reference in system versioned table

          • Major - Major loss of function.
          • Closed

          Activity

            People

              midenok Aleksey Midenkov
              mleich Matthias Leich
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.