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

Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed upon CREATE TEMPORARY SEQUENCE under XA

    XMLWordPrintable

Details

    Description

      XA BEGIN 'xid';
      --error ER_XAER_RMFAIL
      CREATE TEMPORARY SEQUENCE s;
       
      # Cleanup
      XA END 'xid';
      

      10.3 debug fd5c36be

      mysqld: /data/src/10.3/sql/sql_error.cc:335: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.
      200322 20:19:08 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f694e299e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x564e4496cba8 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x564e4496caf0 "/data/src/10.3/sql/sql_error.cc", line=line@entry=335, function=function@entry=0x564e4496cea0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
      #7  0x00007f694e299f12 in __GI___assert_fail (assertion=0x564e4496cba8 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x564e4496caf0 "/data/src/10.3/sql/sql_error.cc", line=335, function=0x564e4496cea0 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x0000564e43ccd666 in Diagnostics_area::set_ok_status (this=0x7f6938006080, affected_rows=0, last_insert_id=0, message=0x0) at /data/src/10.3/sql/sql_error.cc:335
      #9  0x0000564e43c78822 in my_ok (thd=0x7f6938000af0, affected_rows_arg=0, id=0, message=0x0) at /data/src/10.3/sql/sql_class.h:4892
      #10 0x0000564e43e055f2 in Sql_cmd_create_table_like::execute (this=0x7f69380128f8, thd=0x7f6938000af0) at /data/src/10.3/sql/sql_table.cc:11263
      #11 0x0000564e43d2091a in mysql_execute_command (thd=0x7f6938000af0) at /data/src/10.3/sql/sql_parse.cc:6030
      #12 0x0000564e43d2607b in mysql_parse (thd=0x7f6938000af0, rawbuf=0x7f6938012818 "CREATE TEMPORARY SEQUENCE s", length=27, parser_state=0x7f69484985e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7817
      #13 0x0000564e43d12c07 in dispatch_command (command=COM_QUERY, thd=0x7f6938000af0, packet=0x7f6938123201 "CREATE TEMPORARY SEQUENCE s", packet_length=27, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      #14 0x0000564e43d1154f in do_command (thd=0x7f6938000af0) at /data/src/10.3/sql/sql_parse.cc:1401
      #15 0x0000564e43e890c8 in do_handle_one_connection (connect=0x564e46210110) at /data/src/10.3/sql/sql_connect.cc:1403
      #16 0x0000564e43e88e2a in handle_one_connection (arg=0x564e46210110) at /data/src/10.3/sql/sql_connect.cc:1308
      #17 0x0000564e44839368 in pfs_spawn_thread (arg=0x564e4622b1c0) at /data/src/10.3/storage/perfschema/pfs.cc:1869
      #18 0x00007f69502224a4 in start_thread (arg=0x7f6948499700) at pthread_create.c:456
      #19 0x00007f694e356d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      Reproducible on 10.3-10.5.
      The test case is not applicable to 10.2.
      No obvious problem on a non-debug build.

      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.