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

Assertion `table->vers_start != table->vers_end' or other ones failed in row_insert_for_mysql

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
          pk INT AUTO_INCREMENT,
          a INT,
          b BINARY(100),
          c INT AS (a) VIRTUAL,
          d BINARY(100) AS (b) VIRTUAL,
          e INT,
          f INT,
          row_start BIGINT UNSIGNED AS ROW START,
          row_end BIGINT UNSIGNED AS ROW END,
          PRIMARY KEY(pk),
          KEY(b(64)),
          PERIOD FOR SYSTEM_TIME(row_start,row_end)
      ) ENGINE=InnoDB WITH SYSTEM VERSIONING;
       
      INSERT INTO t1 () VALUES (),();
       
      SET STATEMENT system_versioning_alter_history=KEEP FOR ALTER TABLE t1 DROP f;
      INSERT INTO t1 () VALUES ();
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 8a931e4d

      mysqld: /data/src/10.4/storage/innobase/row/row0mysql.cc:1423: dberr_t row_insert_for_mysql(const byte*, row_prebuilt_t*, ins_mode_t): Assertion `table->vers_start != table->vers_end' failed.
      200127 14:06:44 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8d3ec9bf12 in __GI___assert_fail (assertion=0x559e904d0ae0 "table->vers_start != table->vers_end", file=0x559e904cfef8 "/data/src/10.4/storage/innobase/row/row0mysql.cc", line=1423, function=0x559e904d4120 <row_insert_for_mysql(unsigned char const*, row_prebuilt_t*, ins_mode_t)::__PRETTY_FUNCTION__> "dberr_t row_insert_for_mysql(const byte*, row_prebuilt_t*, ins_mode_t)") at assert.c:101
      #8  0x0000559e8fc9301f in row_insert_for_mysql (mysql_rec=0x7f8cf01a15b0 "\377\003", prebuilt=0x7f8cf0189e18, ins_mode=ROW_INS_VERSIONED) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1423
      #9  0x0000559e8faed768 in ha_innobase::write_row (this=0x7f8cf019dfd8, record=0x7f8cf01a15b0 "\377\003") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8035
      #10 0x0000559e8f8b0fc4 in handler::ha_write_row (this=0x7f8cf019dfd8, buf=0x7f8cf01a15b0 "\377\003") at /data/src/10.4/sql/handler.cc:6675
      #11 0x0000559e8f4f6c3c in write_record (thd=0x7f8cf0000af0, table=0x7f8cf01a7110, info=0x7f8d3806b490) at /data/src/10.4/sql/sql_insert.cc:2056
      #12 0x0000559e8f4f3ba7 in mysql_insert (thd=0x7f8cf0000af0, table_list=0x7f8cf0013280, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1078
      #13 0x0000559e8f5420d3 in mysql_execute_command (thd=0x7f8cf0000af0) at /data/src/10.4/sql/sql_parse.cc:4529
      #14 0x0000559e8f54e85d in mysql_parse (thd=0x7f8cf0000af0, rawbuf=0x7f8cf0013198 "INSERT INTO t1 () VALUES ()", length=27, parser_state=0x7f8d3806c160, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7901
      #15 0x0000559e8f539a2a in dispatch_command (command=COM_QUERY, thd=0x7f8cf0000af0, packet=0x7f8cf01376f1 "INSERT INTO t1 () VALUES ()", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1842
      #16 0x0000559e8f5380b7 in do_command (thd=0x7f8cf0000af0) at /data/src/10.4/sql/sql_parse.cc:1360
      #17 0x0000559e8f6c10df in do_handle_one_connection (connect=0x559e9239bf60) at /data/src/10.4/sql/sql_connect.cc:1412
      #18 0x0000559e8f6c0e2e in handle_one_connection (arg=0x559e9239bf60) at /data/src/10.4/sql/sql_connect.cc:1316
      #19 0x0000559e900c93cd in pfs_spawn_thread (arg=0x559e923a4070) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #20 0x00007f8d40c244a4 in start_thread (arg=0x7f8d3806d700) at pthread_create.c:456
      #21 0x00007f8d3ed58d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Reproducible on 10.4-10.5.
      Not reproducible on 10.3.
      No obvious effect on a non-debug build.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              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.