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

Assertion `trn->trid != 0' failed in write_hook_for_undo upon concurrent DML and DROP on Aria table

    XMLWordPrintable

Details

    Description

      Note: The test case is non-deterministic, run with --repeat=N. It usually fails for me within ~5 attempts on a regular debug, but it can vary on different machines and builds.

      CREATE TABLE t1 (a varchar(257), FULLTEXT(a)) ENGINE=Aria;
      SELECT * INTO OUTFILE 'f' FROM t1;
       
      --connect (con1,localhost,root,,test)
      --connect (con2,localhost,root,,test)
      --send
        LOAD DATA INFILE 'f' INTO TABLE t1;
      --connection con1
      --send
        LOAD DATA INFILE 'f' INTO TABLE t1;
       
      --connection default
      DROP TABLE t1;
      --let $datadir= `select @@datadir`
      --remove_file $datadir/test/f
      

      10.5 35977e81 debug

      mariadbd: /data/src/10.5/storage/maria/ma_blockrec.c:6149: write_hook_for_undo: Assertion `trn->trid != 0' failed.
      210509  2:17:06 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f81dd79bf36 in __GI___assert_fail (assertion=0x564fa1a6e45c "trn->trid != 0", file=0x564fa1a6c588 "/data/src/10.5/storage/maria/ma_blockrec.c", line=6149, function=0x564fa1a6ed00 <__PRETTY_FUNCTION__.20162> "write_hook_for_undo") at assert.c:101
      #8  0x0000564fa10a4915 in write_hook_for_undo (type=LOGREC_UNDO_BULK_INSERT, trn=0x564fa2ca6840 <dummy_transaction_object>, tbl_info=0x7f81b801f1b8, lsn=0x7f81cb6d8460, hook_arg=0x0) at /data/src/10.5/storage/maria/ma_blockrec.c:6149
      #9  0x0000564fa10a4b68 in write_hook_for_undo_bulk_insert (type=LOGREC_UNDO_BULK_INSERT, trn=0x564fa2ca6840 <dummy_transaction_object>, tbl_info=0x7f81b801f1b8, lsn=0x7f81cb6d8460, hook_arg=0x0) at /data/src/10.5/storage/maria/ma_blockrec.c:6246
      #10 0x0000564fa1047537 in translog_write_variable_record_1chunk (lsn=0x7f81cb6d8460, type=LOGREC_UNDO_BULK_INSERT, tbl_info=0x7f81b801f1b8, short_trid=0, parts=0x7f81cb6d83d0, buffer_to_flush=0x0, header_length=6, trn=0x564fa2ca6840 <dummy_transaction_object>, hook_arg=0x0) at /data/src/10.5/storage/maria/ma_loghandler.c:5284
      #11 0x0000564fa1049f43 in translog_write_variable_record (lsn=0x7f81cb6d8460, type=LOGREC_UNDO_BULK_INSERT, tbl_info=0x7f81b801f1b8, short_trid=0, parts=0x7f81cb6d83d0, trn=0x564fa2ca6840 <dummy_transaction_object>, hook_arg=0x0) at /data/src/10.5/storage/maria/ma_loghandler.c:6195
      #12 0x0000564fa104b056 in translog_write_record (lsn=0x7f81cb6d8460, type=LOGREC_UNDO_BULK_INSERT, trn=0x564fa2ca6840 <dummy_transaction_object>, tbl_info=0x7f81b801f1b8, rec_len=9, part_no=3, parts_data=0x7f81cb6d8470, store_share_id=0x7f81cb6d84b6 "7", hook_arg=0x0) at /data/src/10.5/storage/maria/ma_loghandler.c:6505
      #13 0x0000564fa10d97a7 in write_log_record_for_bulk_insert (info=0x7f81b801f1b8) at /data/src/10.5/storage/maria/ma_check.c:6959
      #14 0x0000564fa102ca83 in ha_maria::start_bulk_insert (this=0x7f81b817fde0, rows=0, flags=0) at /data/src/10.5/storage/maria/ha_maria.cc:2240
      #15 0x0000564fa09d0fc5 in handler::ha_start_bulk_insert (this=0x7f81b817fde0, rows=0, flags=0) at /data/src/10.5/sql/handler.h:3452
      #16 0x0000564fa0a02aa7 in mysql_load (thd=0x7f81b8000db8, ex=0x7f81b80140c0, table_list=0x7f81b8014148, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_ERROR, ignore=false, read_file_from_client=false) at /data/src/10.5/sql/sql_load.cc:649
      #17 0x0000564fa0a199fc in mysql_execute_command (thd=0x7f81b8000db8) at /data/src/10.5/sql/sql_parse.cc:5086
      #18 0x0000564fa0a236aa in mysql_parse (thd=0x7f81b8000db8, rawbuf=0x7f81b8014000 "LOAD DATA INFILE 'f' INTO TABLE t1", length=34, parser_state=0x7f81cb6d9490, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:8099
      #19 0x0000564fa0a0f621 in dispatch_command (command=COM_QUERY, thd=0x7f81b8000db8, packet=0x7f81b800b5b9 "LOAD DATA INFILE 'f' INTO TABLE t1", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1891
      #20 0x0000564fa0a0de13 in do_command (thd=0x7f81b8000db8) at /data/src/10.5/sql/sql_parse.cc:1370
      #21 0x0000564fa0bbda2b in do_handle_one_connection (connect=0x564fa35a6208, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1410
      #22 0x0000564fa0bbd78e in handle_one_connection (arg=0x564fa35a4098) at /data/src/10.5/sql/sql_connect.cc:1312
      #23 0x0000564fa1121f69 in pfs_spawn_thread (arg=0x564fa35a5428) at /data/src/10.5/storage/perfschema/pfs.cc:2201
      #24 0x00007f81ddcb3609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #25 0x00007f81dd887293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on 10.5-10.6.
      No obvious problem on a non-debug build.

      The failure started happening after this commit in 10.5:

      commit 25fa2a68313046b638aaf1779d45d3e8c8757b07
      Author: Monty
      Date:   Fri Apr 30 15:37:00 2021 +0300
       
          MDEV-25507 CHECK on encrypted Aria table complains about "Wrong LSN"
      

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.