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

Assertion `trx->rsegs.m_redo.rseg' failed in innodb_prepare_commit_versioned

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (id INT PRIMARY KEY, f TEXT UNIQUE, s BIGINT UNSIGNED AS ROW START, e BIGINT UNSIGNED AS ROW END, PERIOD FOR SYSTEM_TIME(s,e)) ENGINE=InnoDB WITH SYSTEM VERSIONING;
      CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
      ALTER TABLE t1 FORCE;
      TRUNCATE TABLE t2;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      10.6 a1542f8a

      mariadbd: /data/src/10.6/storage/innobase/handler/ha_innodb.cc:3168: ulonglong innodb_prepare_commit_versioned(THD*, ulonglong*): Assertion `trx->rsegs.m_redo.rseg' failed.
      210214  0:28:49 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f1de8676f36 in __GI___assert_fail (assertion=0x555c8421bbc4 "trx->rsegs.m_redo.rseg", file=0x555c84219b98 "/data/src/10.6/storage/innobase/handler/ha_innodb.cc", line=3168, function=0x555c8421bb88 "ulonglong innodb_prepare_commit_versioned(THD*, ulonglong*)") at assert.c:101
      #8  0x0000555c8395c33c in innodb_prepare_commit_versioned (thd=0x7f1db4000db8, trx_id=0x7f1ddda11400) at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:3168
      #9  0x0000555c834e88f7 in ha_commit_trans (thd=0x7f1db4000db8, all=false) at /data/src/10.6/sql/handler.cc:1674
      #10 0x0000555c8333f172 in trans_commit_stmt (thd=0x7f1db4000db8) at /data/src/10.6/sql/transaction.cc:472
      #11 0x0000555c83184cfe in mysql_execute_command (thd=0x7f1db4000db8) at /data/src/10.6/sql/sql_parse.cc:5940
      #12 0x0000555c8318a9ee in mysql_parse (thd=0x7f1db4000db8, rawbuf=0x7f1db4013cd0 "TRUNCATE TABLE t2", length=17, parser_state=0x7f1ddda12510) at /data/src/10.6/sql/sql_parse.cc:7906
      #13 0x0000555c83176f31 in dispatch_command (command=COM_QUERY, thd=0x7f1db4000db8, packet=0x7f1db4008e49 "TRUNCATE TABLE t2", packet_length=17) at /data/src/10.6/sql/sql_parse.cc:1833
      #14 0x0000555c83175948 in do_command (thd=0x7f1db4000db8) at /data/src/10.6/sql/sql_parse.cc:1365
      #15 0x0000555c83323117 in do_handle_one_connection (connect=0x555c85e43418, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1410
      #16 0x0000555c83322e7a in handle_one_connection (arg=0x555c85e55b78) at /data/src/10.6/sql/sql_connect.cc:1312
      #17 0x0000555c83880e97 in pfs_spawn_thread (arg=0x555c85ed1a58) at /data/src/10.6/storage/perfschema/pfs.cc:2201
      #18 0x00007f1de8b8e609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x00007f1de8762293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      The failure started happening on 10.6 after this commit:

      commit b08448de64f2af9c849154647bdd61d1725f8928
      Author: Marko Mäkelä
      Date:   Fri Feb 12 17:35:42 2021 +0200
       
          MDEV-20612: Partition lock_sys.latch
      

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.