Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
13.2
-
None
-
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
Issue Links
- is caused by
-
MDEV-39226 Direct multi-table update/delete interface and FederatedX implementation
-
- Closed
-