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

Assertion `0' in row_upd_sec_index_entry during DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME NOW()

    XMLWordPrintable

    Details

      Description

      mariadbd: /home/mleich/Server/10.6/storage/innobase/row/row0upd.cc:2109: dberr_t row_upd_sec_index_entry(upd_node_t*, que_thr_t*): Assertion `0' failed.
       
      --source include/have_innodb.inc
      # No crash with MyISAM
      # CREATE TABLE `t1` ( `c0` varchar(255), pk integer, fulltext key (`c0` ), primary key (pk)) ENGINE=MyISAM ;
      # Crash
      # CREATE TABLE `t1` ( `c0` varchar(255), pk integer, fulltext key (`c0` ), primary key (pk)) ENGINE=innodb ;
      CREATE TABLE `t1` ( `c0` varchar(255), pk integer, fulltext key (`c0` )) ENGINE=innodb ;
      INSERT INTO t1 VALUES  ('banker', 1) ;
      ALTER TABLE t1 ADD SYSTEM VERSIONING ;
      UPDATE t1 SET `c0` = 'criminal' WHERE c0 = 'banker';
      DELETE HISTORY FROM t1 BEFORE SYSTEM_TIME NOW() ;
      # Two DDLs for revealing that the server is gone
      CREATE TABLE t2 (col1 INT) ENGINE = InnoDB;
      DROP TABLE t2;
      

        Attachments

          Activity

            People

            Assignee:
            midenok Aleksey Midenkov
            Reporter:
            mleich Matthias Leich
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration