[MDEV-42085] Assertion `!return_error || thd->is_error() || thd->killed' failed - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11, 11.4, 11.8, 12.3, 13.0, 13.1
Fix Version/s: 10.11, 11.4, 11.8, 12.3, 13.0, 13.1
Component/s: Server
Labels:
None

Bug Category:
Can result in hang or crash

Description

INSTALL SONAME 'ha_blackhole';

CREATE TABLE t1 (a INT) ENGINE=BLACKHOLE;

DELETE FROM t1 WHERE MATCH (a) AGAINST ('a' IN BOOLEAN MODE);

Leads to:

CS 13.2.0 c894d97781b54fbf074677c9d67f81cd60a162ac (Debug, Clang 22.1.8-20260621) Build 26/10/2026
mariadbd: /test/13.1_dbg/sql/sql_delete.cc:1146: bool Sql_cmd_delete::delete_from_single_table(THD *): Assertion `!return_error \|\| thd->is_error() \|\| thd->killed' failed.

CS 13.2.0 c894d97781b54fbf074677c9d67f81cd60a162ac (Debug, Clang 22.1.8-20260621) Build 26/10/2026
Core was generated by `/test/MD261026-mariadb-13.2.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2586106)]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
#3 0x0000716372e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
#4 0x0000716372e288ff in __GI_abort () at ./stdlib/abort.c:79
#5 0x0000716372e2881b in __assert_fail_base (fmt=0x716372fd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5a9da2aba478 "!return_error \|\| thd->is_error() \|\| thd->killed", file=file@entry=0x5a9da2aba2e8 "/test/13.1_dbg/sql/sql_delete.cc", line=line@entry=1146, function=function@entry=0x5a9da2aba345 "bool Sql_cmd_delete::delete_from_single_table(THD *)") at ./assert/assert.c:96
#6 0x0000716372e3b517 in __assert_fail (assertion=0x5a9da2aba478 "!return_error \|\| thd->is_error() \|\| thd->killed", file=0x5a9da2aba2e8 "/test/13.1_dbg/sql/sql_delete.cc", line=1146, function=0x5a9da2aba345 "bool Sql_cmd_delete::delete_from_single_table(THD *)") at ./assert/assert.c:105
#7 0x00005a9da1a30407 in Sql_cmd_delete::delete_from_single_table (this=0x69623c01b810, thd=0x69623c000d60)at /test/13.1_dbg/sql/sql_delete.cc:1146
#8 0x00005a9da1a3382d in Sql_cmd_delete::execute_inner (this=0x69623c01b810, thd=0x69623c000d60) at /test/13.1_dbg/sql/sql_delete.cc:2186
#9 0x00005a9da1b628bd in Sql_cmd_dml::execute (this=0x69623c01b810, thd=0x69623c000d60) at /test/13.1_dbg/sql/sql_select.cc:36000
#10 0x00005a9da1aa9520 in mysql_execute_command (thd=0x69623c000d60, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:4493
#11 0x00005a9da1aa0718 in mysql_parse (thd=0x69623c000d60, rawbuf=0x69623c01a460 "DELETE FROM t1 WHERE MATCH (a) AGAINST ('a' IN BOOLEAN MODE)", length=60, parser_state=0x7163700739c0)at /test/13.1_dbg/sql/sql_parse.cc:8005
#12 0x00005a9da1a9dece in dispatch_command (command=COM_QUERY, thd=0x69623c000d60, packet=0x69623c00b691 "DELETE FROM t1 WHERE MATCH (a) AGAINST ('a' IN BOOLEAN MODE)", packet_length=60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1903
#13 0x00005a9da1aa119a in do_command (thd=0x69623c000d60, blocking=true)at /test/13.1_dbg/sql/sql_parse.cc:1437
#14 0x00005a9da1c7c0ce in do_handle_one_connection (connect=0x5a9daaa41170, put_in_cache=true) at /test/13.1_dbg/sql/sql_connect.cc:1514
#15 0x00005a9da1c7beb1 in handle_one_connection (arg=0x5a9daa9d9b20)at /test/13.1_dbg/sql/sql_connect.cc:1426
#16 0x0000716372e9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
#17 0x0000716372f29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.11 dbg 261026 6a063120d4d3d451bff3ea84b3ffbee288b33be8 !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|mysql_delete\|mysql_execute_command\|mysql_parse\|dispatch_command
CS 10.11 opt 261026 6a063120d4d3d451bff3ea84b3ffbee288b33be8 No bug found
CS 11.4 dbg 261026 b6406d42c8e26be3d86a4a743180f6b415a4559b !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
CS 11.4 opt 261026 b6406d42c8e26be3d86a4a743180f6b415a4559b No bug found
CS 11.8 dbg 261026 274dd0d8d90bc773090d13303b8d5e36d2390241 !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
CS 11.8 opt 261026 274dd0d8d90bc773090d13303b8d5e36d2390241 No bug found
CS 12.3 dbg 261026 788a07c52132d9f42b6991e599510c62d1625c0f !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
CS 12.3 opt 261026 788a07c52132d9f42b6991e599510c62d1625c0f No bug found
CS 13.0 dbg 261026 620a4b5624222048fece7fe1789978ae0675cae2 !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
CS 13.0 opt 261026 620a4b5624222048fece7fe1789978ae0675cae2 No bug found
CS 13.2 dbg 261026 c894d97781b54fbf074677c9d67f81cd60a162ac !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
CS 13.2 opt 261026 c894d97781b54fbf074677c9d67f81cd60a162ac No bug found
ES 10.6 dbg 261026 45fbb1583d8cdcc7da5a123a844b3bf512f31c9d !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|mysql_delete\|mysql_execute_command\|mysql_parse\|dispatch_command
ES 10.6 opt 261026 45fbb1583d8cdcc7da5a123a844b3bf512f31c9d No bug found
ES 11.4 dbg 261026 6b2ae48e6e2488060adfdd02a7114bb60d4d150c !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
ES 11.4 opt 261026 6b2ae48e6e2488060adfdd02a7114bb60d4d150c No bug found
ES 11.8 dbg 261026 6e6ba60bdc2b3f478513c5afa3faa062d8e73736 !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
ES 11.8 opt 261026 6e6ba60bdc2b3f478513c5afa3faa062d8e73736 No bug found
ES 12.3 dbg 261026 781803ca9943d806ecb4b3b3fb39264dfafe1cf0 !return_error \|\| thd->is_error() \|\| thd->killed\|SIGABRT\|Sql_cmd_delete::delete_from_single_table\|Sql_cmd_delete::execute_inner\|Sql_cmd_dml::execute\|mysql_execute_command
ES 12.3 opt 261026 781803ca9943d806ecb4b3b3fb39264dfafe1cf0 No bug found

Attachments

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Saahil Alam

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 6 days ago 19:21

Updated:: 5 days ago 06:07

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Git Integration

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