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

Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q4/2026 Server Maintenance, Q4/2026 Server Development

    Description

      Issue:

      ---------
      mariadbd: /home/ppandith/wl-39226/sql/sql_error.cc:357: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed.

      Version used:

      ----------------
      Debug build
      Branch : 13.2-MDEV-41243-fedx-pushdown-assert-for-upd-del-prepared-stmts
      commit: e7d83013b31c4cc97a0003a0e58b707d94cba042
      Version : 13.1.0

      Stack trace:

      ---------------

      #11 __assert_fail_base (fmt="%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
          assertion=assertion@entry="!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", 
          file=file@entry="/home/ppandith/wl-39226/sql/sql_error.cc", line=line@entry=357, 
          function=function@entry="void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at ./assert/assert.c:96
      #12 __assert_fail (assertion="!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file="/home/ppandith/wl-39226/sql/sql_error.cc", 
          line=357, function="void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at ./assert/assert.c:105
      #13 Diagnostics_area::set_ok_status (this=, affected_rows=57, last_insert_id=0, message=)
          at /home/ppandith/wl-39226/sql/sql_error.cc:357
      #14 my_ok (thd=, affected_rows_arg=57, id=0, message=) at /home/ppandith/wl-39226/sql/sql_class.h:6635
      #15 multi_delete::send_eof (this=) at /home/ppandith/wl-39226/sql/sql_delete.cc:1866
      #16 do_select (join=, procedure=) at /home/ppandith/wl-39226/sql/sql_select.cc:24210
      #17 JOIN::exec_inner (this=) at /home/ppandith/wl-39226/sql/sql_select.cc:5126
      #18 JOIN::exec (this=) at /home/ppandith/wl-39226/sql/sql_select.cc:4914
      #19 Sql_cmd_dml::execute_inner (this=, thd=) at /home/ppandith/wl-39226/sql/sql_select.cc:35061
      #20 Sql_cmd_delete::execute_inner (this=, thd=) at /home/ppandith/wl-39226/sql/sql_delete.cc:2219
      #21 Sql_cmd_dml::execute (this=, thd=) at /home/ppandith/wl-39226/sql/sql_select.cc:34978
      #22 mysql_execute_command (thd=, is_called_from_prepared_stmt=false) at /home/ppandith/wl-39226/sql/sql_parse.cc:4452
      #23 mysql_parse (thd=, 
          rawbuf="DELETE IGNORE OUTR1 FROM D AS OUTR1 JOIN D AS OUTR2 USING ( col_varchar_key ) WHERE ( OUTR1.col_varchar_nokey <= 'tdjm' XOR OUTR1.col_int_uniq > OUTR2.pk ) OR OUTR1.col_int_uniq IN ( SELECT DISTINCT I"..., length=271, parser_state=)
          at /home/ppandith/wl-39226/sql/sql_parse.cc:7968
      #24 dispatch_command (command=COM_QUERY, thd=, 
          packet="DELETE IGNORE OUTR1 FROM D AS OUTR1 JOIN D AS OUTR2 USING ( col_varchar_key ) WHERE ( OUTR1.col_varchar_nokey <= 'tdjm' XOR OUTR1.col_int_uniq > OUTR2.pk ) OR OUTR1.col_int_uniq IN ( SELECT DISTINCT I"..., packet_length=271, blocking=true)
          at /home/ppandith/wl-39226/sql/sql_parse.cc:1903
      #25 do_command (thd=, blocking=true) at /home/ppandith/wl-39226/sql/sql_parse.cc:1437
      #26 do_handle_one_connection (connect=, put_in_cache=true) at /home/ppandith/wl-39226/sql/sql_connect.cc:1514
      #27 handle_one_connection (arg=) at /home/ppandith/wl-39226/sql/sql_connect.cc:1426
      #28 pfs_spawn_thread (arg=) at /home/ppandith/wl-39226/storage/perfschema/pfs.cc:2198
      #29 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
      #30 clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      How to repeat:

      ----------------
      Remote Server:

      Start server on port:3306
      create user r1@localhost;
      grant all on *.* to r1@localhost;
      drop database test1;create database test1;use test1;
      source tables_remote.sql;
      

      Federated server: Start server with federated engine enabled

      drop database test1;create database test1;use test1;
      source tables_federated.sql;
       
      Start server with --net_read_timeout=1
      source queries.sql //Server crashes :Refer [MDEV-41293|https://jira.mariadb.org/browse/MDEV-41293] (Assertion `sp > last_savepoint()' failed)
       
      Restart server with --net_read_timeout=1
       
      source queries.sql //Server crashes (Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed)
      

      Attachments

        1. tables_remote.sql
          388 kB
        2. queries.sql
          2 kB
        3. tables_federated.sql
          11 kB

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1d 7h 26m
                  1d 7h 26m
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5d Time Not Required
                  0.5d

                  Git Integration

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