Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
-
None
Description
--source include/have_partition.inc
|
|
CREATE TABLE t (a int, b int, c int, key (a), key (b)) |
ENGINE=Aria
|
PARTITION BY range (c) ( |
partition p0 values less than (10), |
partition pm values less than maxvalue |
);
|
INSERT INTO t VALUES (1,2,0),(2,2,0),(3,0,0); |
|
--delimiter $
|
CREATE FUNCTION f() RETURNS INT NOT DETERMINISTIC |
BEGIN
|
DELETE FROM t PARTITION (p0) WHERE t.b = 7 OR t.a = 0; |
RETURN 0; |
END $ |
--delimiter ;
|
SELECT f(); |
|
# Cleanup
|
DROP FUNCTION f; |
DROP TABLE t; |
10.4 f5dceafd |
mysqld: /data/src/10.4/storage/maria/ha_maria.cc:1239: virtual int ha_maria::close(): Assertion `file->trn == 0 || file->trn == &dummy_transaction_object' failed.
|
230628 1:21:46 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007fe8a1a53df2 in __GI___assert_fail (assertion=0x562b9058aba0 "file->trn == 0 || file->trn == &dummy_transaction_object", file=0x562b9058a140 "/data/src/10.4/storage/maria/ha_maria.cc", line=1239, function=0x562b9058ac00 "virtual int ha_maria::close()") at ./assert/assert.c:101
|
#10 0x0000562b8edc2fce in ha_maria::close (this=0x621000096890) at /data/src/10.4/storage/maria/ha_maria.cc:1239
|
#11 0x0000562b8e82af9c in handler::ha_close (this=0x621000096890) at /data/src/10.4/sql/handler.cc:2874
|
#12 0x0000562b8f00bc14 in ha_partition::close (this=0x621000094f90) at /data/src/10.4/sql/ha_partition.cc:3937
|
#13 0x0000562b8e82af9c in handler::ha_close (this=0x621000094f90) at /data/src/10.4/sql/handler.cc:2874
|
#14 0x0000562b8ebcdf61 in QUICK_RANGE_SELECT::~QUICK_RANGE_SELECT (this=0x613000050d80, __in_chrg=<optimized out>) at /data/src/10.4/sql/opt_range.cc:1350
|
#15 0x0000562b8ebce13e in QUICK_RANGE_SELECT::~QUICK_RANGE_SELECT (this=0x613000050d80, __in_chrg=<optimized out>) at /data/src/10.4/sql/opt_range.cc:1359
|
#16 0x0000562b8ec3f4cd in List<QUICK_SELECT_I>::delete_elements (this=0x61100002d1c0) at /data/src/10.4/sql/sql_list.h:525
|
#17 0x0000562b8ebd2c48 in QUICK_ROR_UNION_SELECT::~QUICK_ROR_UNION_SELECT (this=0x61100002d180, __in_chrg=<optimized out>) at /data/src/10.4/sql/opt_range.cc:1853
|
#18 0x0000562b8ebd2e14 in QUICK_ROR_UNION_SELECT::~QUICK_ROR_UNION_SELECT (this=0x61100002d180, __in_chrg=<optimized out>) at /data/src/10.4/sql/opt_range.cc:1858
|
#19 0x0000562b8ebcccc3 in SQL_SELECT::cleanup (this=0x625000110b60) at /data/src/10.4/sql/opt_range.cc:1233
|
#20 0x0000562b8ebcce20 in SQL_SELECT::~SQL_SELECT (this=0x625000110b60, __in_chrg=<optimized out>) at /data/src/10.4/sql/opt_range.cc:1247
|
#21 0x0000562b8ec9d312 in mysql_delete (thd=0x62b00005b208, table_list=0x6250001029c0, conds=0x62500010ae08, order_list=0x625000104cc8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.4/sql/sql_delete.cc:908
|
#22 0x0000562b8e0803da in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4815
|
#23 0x0000562b8de3b5bc in sp_instr_stmt::exec_core (this=0x625000103828, thd=0x62b00005b208, nextp=0x7fe899cf5e90) at /data/src/10.4/sql/sp_head.cc:3694
|
#24 0x0000562b8de39cdd in sp_lex_keeper::reset_lex_and_exec_core (this=0x625000103870, thd=0x62b00005b208, nextp=0x7fe899cf5e90, open_tables=false, instr=0x625000103828) at /data/src/10.4/sql/sp_head.cc:3424
|
#25 0x0000562b8de3ad53 in sp_instr_stmt::execute (this=0x625000103828, thd=0x62b00005b208, nextp=0x7fe899cf5e90) at /data/src/10.4/sql/sp_head.cc:3600
|
#26 0x0000562b8de2c379 in sp_head::execute (this=0x625000101928, thd=0x62b00005b208, merge_da_on_success=true) at /data/src/10.4/sql/sp_head.cc:1365
|
#27 0x0000562b8de3057a in sp_head::execute_function (this=0x625000101928, thd=0x62b00005b208, argp=0x0, argcount=0, return_value_fld=0x62b000065aa8, func_ctx=0x62b000062ac0, call_arena=0x62b000063ea8) at /data/src/10.4/sql/sp_head.cc:2088
|
#28 0x0000562b8e879bbd in Item_sp::execute_impl (this=0x62b000062a60, thd=0x62b00005b208, args=0x0, arg_count=0) at /data/src/10.4/sql/item.cc:2846
|
#29 0x0000562b8e879157 in Item_sp::execute (this=0x62b000062a60, thd=0x62b00005b208, null_value=0x62b000062a16, args=0x0, arg_count=0) at /data/src/10.4/sql/item.cc:2761
|
#30 0x0000562b8e9ad5db in Item_func_sp::execute (this=0x62b0000629a0) at /data/src/10.4/sql/item_func.cc:6510
|
#31 0x0000562b8e9bd33a in Item_func_sp::val_int (this=0x62b0000629a0) at /data/src/10.4/sql/item_func.h:3292
|
#32 0x0000562b8e5ed7d2 in Type_handler::Item_send_long (this=0x562b91233000 <type_handler_long>, item=0x62b0000629a0, protocol=0x62b00005b808, buf=0x7fe899cf6d70) at /data/src/10.4/sql/sql_type.cc:7106
|
#33 0x0000562b8e606d02 in Type_handler_long::Item_send (this=0x562b91233000 <type_handler_long>, item=0x62b0000629a0, protocol=0x62b00005b808, buf=0x7fe899cf6d70) at /data/src/10.4/sql/sql_type.h:5191
|
#34 0x0000562b8ddc484c in Item::send (this=0x62b0000629a0, protocol=0x62b00005b808, buffer=0x7fe899cf6d70) at /data/src/10.4/sql/item.h:1044
|
#35 0x0000562b8ddb68e9 in Protocol::send_result_set_row (this=0x62b00005b808, row_items=0x62b000062410) at /data/src/10.4/sql/protocol.cc:1038
|
#36 0x0000562b8df613bb in select_send::send_data (this=0x62b000065308, items=...) at /data/src/10.4/sql/sql_class.cc:3139
|
#37 0x0000562b8e149bf0 in JOIN::exec_inner (this=0x62b000065338) at /data/src/10.4/sql/sql_select.cc:4473
|
#38 0x0000562b8e1487c4 in JOIN::exec (this=0x62b000065338) at /data/src/10.4/sql/sql_select.cc:4387
|
#39 0x0000562b8e14c856 in mysql_select (thd=0x62b00005b208, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b000065308, unit=0x62b00005f140, select_lex=0x62b0000622b0) at /data/src/10.4/sql/sql_select.cc:4826
|
#40 0x0000562b8e11d461 in handle_select (thd=0x62b00005b208, lex=0x62b00005f080, result=0x62b000065308, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:442
|
#41 0x0000562b8e08d28b in execute_sqlcom_select (thd=0x62b00005b208, all_tables=0x0) at /data/src/10.4/sql/sql_parse.cc:6473
|
#42 0x0000562b8e07a7a0 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:3976
|
#43 0x0000562b8e096463 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "SELECT f()", length=10, parser_state=0x7fe899cf9860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
|
#44 0x0000562b8e06c7a6 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629000230209 "", packet_length=10, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
|
#45 0x0000562b8e069315 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
|
#46 0x0000562b8e4680ba in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
|
#47 0x0000562b8e4679d1 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
|
#48 0x0000562b8f0d4aee in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
#49 0x00007fe8a1aa7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#50 0x00007fe8a1b285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Reproducible on all existing versions, also on earlier minor releases.
No obvious immediate problem on a non-debug build.
No obvious problems with InnoDB or MyISAM.