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

Assertions failed in Diagnostics_area upon actions with transactional Aria table under parallel BACKUP STAGE BLOCK_COMMIT or FTWRL

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (a INT) ENGINE=Aria TRANSACTIONAL=1;
      BACKUP STAGE START;
      BACKUP STAGE BLOCK_COMMIT;
       
      --connect (con1,localhost,root,,test)
      SET lock_wait_timeout= 1;
      --error 0,ER_LOCK_WAIT_TIMEOUT
      UPDATE t1 SET a = 1;
       
      # Cleanup
      --disconnect con1
      --connection default
      BACKUP STAGE END;
      DROP TABLE t1;
      

      10.4 05d62518

      mysqld: /data/src/10.4/sql/sql_error.cc:445: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*): Assertion `! is_set() || m_can_overwrite_status' failed.
      200728  2:35:56 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f6bfc12ef12 in __GI___assert_fail (assertion=0x555ab4660d98 "! is_set() || m_can_overwrite_status", file=0x555ab4660c68 "/data/src/10.4/sql/sql_error.cc", line=445, function=0x555ab4661100 <Diagnostics_area::set_error_status(unsigned int, char const*, char const*, Sql_user_condition_identity const&, Sql_condition const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_user_condition_identity&, const Sql_condition*)") at assert.c:101
      #8  0x0000555ab391cd9c in Diagnostics_area::set_error_status (this=0x7f6bd80064d8, sql_errno=1205, message=0x7f6bf628c660 "Lock wait timeout exceeded; try restarting transaction", sqlstate=0x555ab468897d "HY000", ucid=..., error_condition=0x0) at /data/src/10.4/sql/sql_error.cc:445
      #9  0x0000555ab38f7f27 in THD::raise_condition (this=0x7f6bd8000af0, sql_errno=1205, sqlstate=0x555ab468897d "HY000", level=Sql_state_errno_level::WARN_LEVEL_ERROR, ucid=..., msg=0x7f6bf628c660 "Lock wait timeout exceeded; try restarting transaction") at /data/src/10.4/sql/sql_class.cc:1100
      #10 0x0000555ab383e184 in THD::raise_condition (this=0x7f6bd8000af0, sql_errno=1205, sqlstate=0x0, level=Sql_state_errno_level::WARN_LEVEL_ERROR, msg=0x7f6bf628c660 "Lock wait timeout exceeded; try restarting transaction") at /data/src/10.4/sql/sql_class.h:4372
      #11 0x0000555ab3830e46 in my_message_sql (error=1205, str=0x7f6bf628c660 "Lock wait timeout exceeded; try restarting transaction", MyFlags=0) at /data/src/10.4/sql/mysqld.cc:3377
      #12 0x0000555ab4555d6e in my_error (nr=1205, MyFlags=0) at /data/src/10.4/mysys/my_error.c:125
      #13 0x0000555ab3b01d04 in MDL_context::acquire_lock (this=0x7f6bd8000c10, mdl_request=0x7f6bf628ca00, lock_wait_timeout=1) at /data/src/10.4/sql/mdl.cc:2365
      #14 0x0000555ab3cc846f in ha_maria_implicit_commit (thd=0x7f6bd8000af0, new_trn=false) at /data/src/10.4/sql/handler.cc:144
      #15 0x0000555ab3979e0d in mysql_execute_command (thd=0x7f6bd8000af0) at /data/src/10.4/sql/sql_parse.cc:6159
      #16 0x0000555ab397ec91 in mysql_parse (thd=0x7f6bd8000af0, rawbuf=0x7f6bd8011dd8 "UPDATE t1 SET a = 1", length=19, parser_state=0x7f6bf628d570, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7896
      #17 0x0000555ab396b1c6 in dispatch_command (command=COM_QUERY, thd=0x7f6bd8000af0, packet=0x7f6bd80083a1 "UPDATE t1 SET a = 1", packet_length=19, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1835
      #18 0x0000555ab3969968 in do_command (thd=0x7f6bd8000af0) at /data/src/10.4/sql/sql_parse.cc:1353
      #19 0x0000555ab3af2b0c in do_handle_one_connection (connect=0x555ab74f4520) at /data/src/10.4/sql/sql_connect.cc:1412
      #20 0x0000555ab3af285b in handle_one_connection (arg=0x555ab74f4520) at /data/src/10.4/sql/sql_connect.cc:1316
      #21 0x0000555ab44f2879 in pfs_spawn_thread (arg=0x555ab7452190) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #22 0x00007f6bfe0b74a4 in start_thread (arg=0x7f6bf628e700) at pthread_create.c:456
      #23 0x00007f6bfc1ebd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      No obvious problem on a non-debug build.
      Not reproducible on 10.5.
      The test case is not applicable to earlier versions due to backup stages.

      Attachments

        Activity

          People

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