[MDEV-33257]  Assertion `!return_error || thd->is_error() || thd->killed' failed in mysql_delete Created: 2024-01-16  Updated: 2024-01-16  Resolved: 2024-01-16

Status: Closed
Project: MariaDB Server
Component/s: Sequences
Affects Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3, 11.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-29580 Assertion failures and change in beha... Confirmed

 Description   

CREATE SEQUENCE s;
DELETE FROM s WHERE MATCH (cache_size) AGAINST ('a' IN BOOLEAN MODE);

 
mysqld: /10.4/src/sql/sql_delete.cc:988: bool mysql_delete(THD*, TABLE_LIST*, COND*, SQL_I_List<st_order>*, ha_rows, ulonglong, select_result*): Assertion `!return_error || thd->is_error() || thd->killed' failed.
240116 18:19:53 [ERROR] mysqld got signal 6 ;
 
Server version: 10.4.33-MariaDB-debug-log source revision: 653cb195d30bca678b5b175157f0f34206c3761d
 
sql/signal_handler.cc:235(handle_fatal_signal)[0x5577a4e8a99d]
sigaction.c:0(__restore_rt)[0x7f6c795da420]
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f6c790b3fd6]
sql/sql_delete.cc:989(mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*))[0x5577a5331030]
sql/sql_parse.cc:4819(mysql_execute_command(THD*))[0x5577a46cca75]
sql/sql_parse.cc:8062(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5577a46e2ef3]
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5577a46b909f]
sql/sql_parse.cc:1378(do_command(THD*))[0x5577a46b5bca]
sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x5577a4acac46]
sql/sql_connect.cc:1324(handle_one_connection)[0x5577a4aca4ea]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5577a576930e]
nptl/pthread_create.c:478(start_thread)[0x7f6c795ce609]
 
Query (0x62b0000a1290): DELETE FROM s WHERE MATCH (cache_size) AGAINST ('a' IN BOOLEAN MODE)


Generated at Thu Feb 08 10:37:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.