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

Assertion `trid >= info->s->state.create_trid' failed in transid_store_packed

    XMLWordPrintable

Details

    Description

      Note: I'm not sure that versioning is important for the failure, it is just needed for the test case. Possibly the test case can be modified to avoid it.

      --source include/have_partition.inc
       
      CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=Aria WITH SYSTEM VERSIONING PARTITION BY system_time (PARTITION p1 HISTORY, PARTITION pn CURRENT);
      CREATE TABLE t2 (id INT AUTO_INCREMENT PRIMARY KEY) ENGINE=Aria;
      INSERT INTO t2 VALUES (NULL),(NULL),(NULL),(NULL);
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      INSERT INTO t2 SELECT NULL FROM t2;
      ALTER TABLE t2 ENABLE KEYS;
       
      --connect (con1,localhost,root,,test)
      DELETE FROM t2 WHERE id = 8803;
      --send
        OPTIMIZE TABLE t2;
       
      --connection default
      TRUNCATE TABLE t1;
      INSERT INTO t1 VALUES (1);
      DELETE FROM t1 WHERE id = 51771;
      INSERT INTO t1 VALUES (2);
       
      # Cleanup
      --connection con1
      --reap
      --disconnect con1
      --connection default
      DROP TABLE t1, t2;
      

      10.3 acf6f92a

      mysqld: /data/src/10.3/storage/maria/ma_key.c:103: transid_store_packed: Assertion `trid >= info->s->state.create_trid' failed.
      190430  3:02:00 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f34138b7ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000559a8ded6e4a in transid_store_packed (info=0x7f33fc058210, to=0x7f33fc05c995 '\245' <repeats 67 times>, trid=21) at /data/src/10.3/storage/maria/ma_key.c:103
      #9  0x0000559a8ded7790 in _ma_make_key (info=0x7f33fc058210, int_key=0x7f340dab6ee0, keynr=0, key=0x7f33fc05c990 "", record=0x7f33fc00a788 "\377\002", filepos=257, trid=21) at /data/src/10.3/storage/maria/ma_key.c:324
      #10 0x0000559a8def969d in maria_write (info=0x7f33fc058210, record=0x7f33fc00a788 "\377\002") at /data/src/10.3/storage/maria/ma_write.c:189
      #11 0x0000559a8de7dbd9 in ha_maria::write_row (this=0x7f33fc185828, buf=0x7f33fc00a788 "\377\002") at /data/src/10.3/storage/maria/ha_maria.cc:1291
      #12 0x0000559a8d866c58 in handler::ha_write_row (this=0x7f33fc185828, buf=0x7f33fc00a788 "\377\002") at /data/src/10.3/sql/handler.cc:6320
      #13 0x0000559a8dfb57a3 in ha_partition::write_row (this=0x7f33fc184828, buf=0x7f33fc00a788 "\377\002") at /data/src/10.3/sql/ha_partition.cc:4316
      #14 0x0000559a8d866c06 in handler::ha_write_row (this=0x7f33fc184828, buf=0x7f33fc00a788 "\377\002") at /data/src/10.3/sql/handler.cc:6320
      #15 0x0000559a8d520c9b in write_record (thd=0x7f33fc000b00, table=0x7f33fc183be0, info=0x7f340dab7360) at /data/src/10.3/sql/sql_insert.cc:2017
      #16 0x0000559a8d51e0b1 in mysql_insert (thd=0x7f33fc000b00, table_list=0x7f33fc014dc8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.3/sql/sql_insert.cc:1063
      #17 0x0000559a8d55fb39 in mysql_execute_command (thd=0x7f33fc000b00) at /data/src/10.3/sql/sql_parse.cc:4729
      #18 0x0000559a8d56a853 in mysql_parse (thd=0x7f33fc000b00, rawbuf=0x7f33fc014ce8 "INSERT INTO t1 VALUES (2)", length=25, parser_state=0x7f340dab85f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
      #19 0x0000559a8d557b22 in dispatch_command (command=COM_QUERY, thd=0x7f33fc000b00, packet=0x7f33fc1201b1 "INSERT INTO t1 VALUES (2)", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857
      #20 0x0000559a8d55650c in do_command (thd=0x7f33fc000b00) at /data/src/10.3/sql/sql_parse.cc:1403
      #21 0x0000559a8d6bf265 in do_handle_one_connection (connect=0x559a8ff01ce0) at /data/src/10.3/sql/sql_connect.cc:1402
      #22 0x0000559a8d6befe9 in handle_one_connection (arg=0x559a8ff01ce0) at /data/src/10.3/sql/sql_connect.cc:1308
      #23 0x0000559a8da95fcf in pfs_spawn_thread (arg=0x559a8fe5f660) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #24 0x00007f34159ac494 in start_thread (arg=0x7f340dab9700) at pthread_create.c:333
      #25 0x00007f341397493f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      No obvious failure on a non-debug build.
      Due to the nature of the test case, I couldn't check pre-10.3 versions.

      Attachments

        1. 14854.7z
          795 kB
          Alice Sherepa
        2. mysql.log
          2.96 MB
          Elena Stepanova
        3. threads
          53 kB
          Elena Stepanova
        4. trans1.test.gz
          1.24 MB
          Elena Stepanova

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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