[MDEV-23113] Server crashes in update_ref_and_keys or make_select on 2nd execution of PS/SP - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.6, 10.11, 10.4(EOL), 10.5(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.6.16, 10.11.6
Component/s: Prepared Statements, Stored routines
Labels:
None

Bug Category:
Not for Release Notes

Description

CREATE TABLE t1 (a int, b int);

INSERT INTO t1 VALUES (1,1),(2,2);

CREATE TABLE t2 (c timestamp, primary key (c));

INSERT INTO t2 VALUES ('2023-01-01') , ('2023-02-02');

CREATE TABLE t3 (d int);

INSERT INTO t3 VALUES (3),(4);

CREATE PROCEDURE pr() UPDATE t1 LEFT JOIN t2 ON (1) SET t1.a = 38 WHERE (t1.b <= ALL (SELECT d FROM t3)) AND t2.c = 1 AND t2.c IS NULL;

--error ER_TRUNCATED_WRONG_VALUE

CALL pr();

CALL pr();

10.4 f5dceafd
#3 <signal handler called>
#4 0x0000564ec514e5b4 in make_select (head=0x0, const_tables=0, read_tables=0, conds=0x0, filesort=0x0, allow_null_cond=true, error=0x62500011b890) at /data/src/10.4/sql/opt_range.cc:1199
#5 0x0000564ec46b5e91 in JOIN::optimize_stage2 (this=0x62500011b4a8) at /data/src/10.4/sql/sql_select.cc:2490
#6 0x0000564ec46b4af3 in JOIN::optimize_inner (this=0x62500011b4a8) at /data/src/10.4/sql/sql_select.cc:2394
#7 0x0000564ec46ad791 in JOIN::optimize (this=0x62500011b4a8) at /data/src/10.4/sql/sql_select.cc:1711
#8 0x0000564ec458b8c2 in st_select_lex::optimize_unflattened_subqueries (this=0x625000107218, const_only=false) at /data/src/10.4/sql/sql_lex.cc:4236
#9 0x0000564ec4ae8639 in JOIN::optimize_unflattened_subqueries (this=0x62500011ada8) at /data/src/10.4/sql/opt_subselect.cc:5602
#10 0x0000564ec46bca1f in JOIN::optimize_stage2 (this=0x62500011ada8) at /data/src/10.4/sql/sql_select.cc:3165
#11 0x0000564ec46b4af3 in JOIN::optimize_inner (this=0x62500011ada8) at /data/src/10.4/sql/sql_select.cc:2394
#12 0x0000564ec46ad791 in JOIN::optimize (this=0x62500011ada8) at /data/src/10.4/sql/sql_select.cc:1711
#13 0x0000564ec46ce665 in mysql_select (thd=0x62b00005b208, tables=0x625000105048, wild_num=0, fields=..., conds=0x62500011a9f8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x62500011ac68, unit=0x6250001069e8, select_lex=0x625000107218) at /data/src/10.4/sql/sql_select.cc:4812
#14 0x0000564ec48d4c49 in mysql_multi_update (thd=0x62b00005b208, table_list=0x625000105048, fields=0x625000107378, values=0x625000107938, conds=0x62500011a9f8, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x6250001069e8, select_lex=0x625000107218, result=0x7fbd47a950c0) at /data/src/10.4/sql/sql_update.cc:1965
#15 0x0000564ec45ffd7b in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4530
#16 0x0000564ec43bd5bc in sp_instr_stmt::exec_core (this=0x62500010c0b0, thd=0x62b00005b208, nextp=0x7fbd47a96a50) at /data/src/10.4/sql/sp_head.cc:3694
#17 0x0000564ec43bbcdd in sp_lex_keeper::reset_lex_and_exec_core (this=0x62500010c0f8, thd=0x62b00005b208, nextp=0x7fbd47a96a50, open_tables=false, instr=0x62500010c0b0) at /data/src/10.4/sql/sp_head.cc:3424
#18 0x0000564ec43bcd53 in sp_instr_stmt::execute (this=0x62500010c0b0, thd=0x62b00005b208, nextp=0x7fbd47a96a50) at /data/src/10.4/sql/sp_head.cc:3600
#19 0x0000564ec43ae379 in sp_head::execute (this=0x625000104128, thd=0x62b00005b208, merge_da_on_success=true) at /data/src/10.4/sql/sp_head.cc:1365
#20 0x0000564ec43b4446 in sp_head::execute_procedure (this=0x625000104128, thd=0x62b00005b208, args=0x62b000060090) at /data/src/10.4/sql/sp_head.cc:2371
#21 0x0000564ec45f5abd in do_execute_sp (thd=0x62b00005b208, sp=0x625000104128) at /data/src/10.4/sql/sql_parse.cc:3062
#22 0x0000564ec45f765e in Sql_cmd_call::execute (this=0x62b0000622f8, thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:3304
#23 0x0000564ec460cc61 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:6216
#24 0x0000564ec4618463 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "CALL pr()", length=9, parser_state=0x7fbd47a99860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
#25 0x0000564ec45ee7a6 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629000230209 "CALL pr()", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#26 0x0000564ec45eb315 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#27 0x0000564ec49ea0ba in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#28 0x0000564ec49e99d1 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#29 0x0000564ec5656aee in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#30 0x00007fbd4f8a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#31 0x00007fbd4f9285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

The same test case, only with additional WHERE clause in the subquery, produces a different stack trace:

CREATE TABLE t1 (a int, b int);

INSERT INTO t1 VALUES (1,1),(2,2);

CREATE TABLE t2 (c timestamp, primary key (c));

INSERT INTO t2 VALUES ('2023-01-01') , ('2023-02-02');

CREATE TABLE t3 (d int);

INSERT INTO t3 VALUES (3),(4);

CREATE PROCEDURE pr() UPDATE t1 LEFT JOIN t2 ON (1) SET t1.a = 38 WHERE (t1.b <= ALL (SELECT d FROM t3 WHERE d > 1)) AND t2.c = 1 AND t2.c IS NULL;

--error ER_TRUNCATED_WRONG_VALUE

CALL pr();

CALL pr();

10.4 f5dceafd
#3 <signal handler called>
#4 0x0000557091a44b26 in update_ref_and_keys (thd=0x62b00005b208, keyuse=0x62500011b7d8, join_tab=0x62500011fa18, tables=0, cond=0x62500010a700, normal_tables=18446744073709551615, select_lex=0x625000109890, sargables=0x7fd5157ac010) at /data/src/10.4/sql/sql_select.cc:6902
#5 0x0000557091a349c6 in make_join_statistics (join=0x62500011b4e8, tables_list=..., keyuse_array=0x62500011b7d8) at /data/src/10.4/sql/sql_select.cc:5206
#6 0x0000557091a177da in JOIN::optimize_inner (this=0x62500011b4e8) at /data/src/10.4/sql/sql_select.cc:2368
#7 0x0000557091a10791 in JOIN::optimize (this=0x62500011b4e8) at /data/src/10.4/sql/sql_select.cc:1711
#8 0x00005570918ee8c2 in st_select_lex::optimize_unflattened_subqueries (this=0x625000107218, const_only=false) at /data/src/10.4/sql/sql_lex.cc:4236
#9 0x0000557091e4b639 in JOIN::optimize_unflattened_subqueries (this=0x62500011ade8) at /data/src/10.4/sql/opt_subselect.cc:5602
#10 0x0000557091a1fa1f in JOIN::optimize_stage2 (this=0x62500011ade8) at /data/src/10.4/sql/sql_select.cc:3165
#11 0x0000557091a17af3 in JOIN::optimize_inner (this=0x62500011ade8) at /data/src/10.4/sql/sql_select.cc:2394
#12 0x0000557091a10791 in JOIN::optimize (this=0x62500011ade8) at /data/src/10.4/sql/sql_select.cc:1711
#13 0x0000557091a31665 in mysql_select (thd=0x62b00005b208, tables=0x625000105090, wild_num=0, fields=..., conds=0x62500011aa38, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x62500011aca8, unit=0x6250001069e8, select_lex=0x625000107218) at /data/src/10.4/sql/sql_select.cc:4812
#14 0x0000557091c37c49 in mysql_multi_update (thd=0x62b00005b208, table_list=0x625000105090, fields=0x625000107378, values=0x625000107938, conds=0x62500011aa38, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=0x6250001069e8, select_lex=0x625000107218, result=0x7fd5157ad0c0) at /data/src/10.4/sql/sql_update.cc:1965
#15 0x0000557091962d7b in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4530
#16 0x00005570917205bc in sp_instr_stmt::exec_core (this=0x62500010b068, thd=0x62b00005b208, nextp=0x7fd5157aea50) at /data/src/10.4/sql/sp_head.cc:3694
#17 0x000055709171ecdd in sp_lex_keeper::reset_lex_and_exec_core (this=0x62500010b0b0, thd=0x62b00005b208, nextp=0x7fd5157aea50, open_tables=false, instr=0x62500010b068) at /data/src/10.4/sql/sp_head.cc:3424
#18 0x000055709171fd53 in sp_instr_stmt::execute (this=0x62500010b068, thd=0x62b00005b208, nextp=0x7fd5157aea50) at /data/src/10.4/sql/sp_head.cc:3600
#19 0x0000557091711379 in sp_head::execute (this=0x625000104128, thd=0x62b00005b208, merge_da_on_success=true) at /data/src/10.4/sql/sp_head.cc:1365
#20 0x0000557091717446 in sp_head::execute_procedure (this=0x625000104128, thd=0x62b00005b208, args=0x62b000060090) at /data/src/10.4/sql/sp_head.cc:2371
#21 0x0000557091958abd in do_execute_sp (thd=0x62b00005b208, sp=0x625000104128) at /data/src/10.4/sql/sql_parse.cc:3062
#22 0x000055709195a65e in Sql_cmd_call::execute (this=0x62b0000622f8, thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:3304
#23 0x000055709196fc61 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:6216
#24 0x000055709197b463 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "CALL pr()", length=9, parser_state=0x7fd5157b1860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
#25 0x00005570919517a6 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629000230209 "CALL pr()", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#26 0x000055709194e315 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#27 0x0000557091d4d0ba in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#28 0x0000557091d4c9d1 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#29 0x00005570929b9aee in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#30 0x00007fd51d4a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#31 0x00007fd51d5285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Both are also reproducible with a prepared statement instead of a stored procedure, with the corresponding difference in the stack trace.
Reproducible with at least MyISAM, InnoDB, Aria, on debug and non-debug builds.

We don't have a test case for the assertion failure from the original description, it was removed from summary (but kept it below in stack traces for the reference). Anyway it shouldn't be important. If the assertion failure indicated the same problem, then SIGSEGVs above should be enough. If the assertion failure was a different problem, it should be in a separate report anyway.

Original description

crash on debug and non-debug versions:

10.5 1ae008d272ad3f4
200707 14:12:34 [ERROR] mysqld got signal 11 ;

Server version: 10.5.5-MariaDB-debug-log

??:0(__restore_rt)[0x7fe7478e7730]
/10.5/sql/mysqld(+0x1bb2f16)[0x55930af4df16]
sql/sql_select.cc:6739(update_ref_and_keys(THD, st_dynamic_array, st_join_table, unsigned int, Item, unsigned long long, st_select_lex, SARGABLE_PARAM*))[0x55930af3dede]
sql/sql_select.cc:5040(make_join_statistics(JOIN, List<TABLE_LIST>&, st_dynamic_array))[0x55930af21292]
sql/sql_select.cc:2242(JOIN::optimize_inner())[0x55930af1a83d]
sql/sql_select.cc:1618(JOIN::optimize())[0x55930adfa630]
sql/sql_lex.cc:4792(st_select_lex::optimize_unflattened_subqueries(bool))[0x55930b38d06b]
sql/opt_subselect.cc:5558(JOIN::optimize_unflattened_subqueries())[0x55930af2753a]
sql/sql_select.cc:2813(JOIN::optimize_stage2())[0x55930af215a6]
sql/sql_select.cc:2268(JOIN::optimize_inner())[0x55930af1a83d]
sql/sql_select.cc:1618(JOIN::optimize())[0x55930af3a852]
sql/sql_select.cc:4641(mysql_select(THD, TABLE_LIST, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55930af0d1c2]
sql/sql_select.cc:417(handle_select(THD, LEX, select_result*, unsigned long))[0x55930ae73ea2]
sql/sql_parse.cc:4691(mysql_execute_command(THD*))[0x55930ac2d788]
sql/sp_head.cc:3765(sp_instr_stmt::exec_core(THD, unsigned int))[0x55930ac2be92]
sql/sp_head.cc:3492(sp_lex_keeper::reset_lex_and_exec_core(THD, unsigned int, bool, sp_instr*))[0x55930ac2cf36]
sql/sp_head.cc:3671(sp_instr_stmt::execute(THD, unsigned int))[0x55930ac1e3da]
sql/sp_head.cc:1435(sp_head::execute(THD*, bool))[0x55930ac2147d]
sql/sp_head.cc:1913(sp_head::execute_trigger(THD, st_mysql_const_lex_string const, st_mysql_const_lex_string const, st_grant_info))[0x55930b12d2cc]
sql/sql_trigger.cc:2239(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x55930acff7ab]
sql/sql_base.cc:8621(fill_record_n_invoke_before_triggers(THD, TABLE, List<Item>&, List<Item>&, bool, trg_event_type))[0x55930adae79f]
sql/sql_insert.cc:984(mysql_insert(THD, TABLE_LIST, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55930ae728b7]
sql/sql_parse.cc:4545(mysql_execute_command(THD*))[0x55930ae8a6c6]
sql/sql_parse.cc:7993(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x55930ae615df]
sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x55930ae5def7]
sql/sql_parse.cc:1347(do_command(THD*))[0x55930b28267d]
sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x55930b281fda]
sql/sql_connect.cc:1315(handle_one_connection)[0x55930bf38f0a]
nptl/pthread_create.c:487(start_thread)[0x7fe7478dcfa3]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fe746ee34cf]

mysqld: /10.5/sql/item_subselect.cc:3367: virtual bool Item_in_subselect::fix_fields(THD*, Item**): Assertion `unit->thd == thd' failed.

200707 16:18:56 [ERROR] mysqld got signal 6 ;

Server version: 10.5.5-MariaDB-debug-log

linux/raise.c:51(__GI_raise)[0x7f15a85767bb]

stdlib/abort.c:81(__GI_abort)[0x7f15a8561535]

intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f15a856140f]

??:0(__assert_fail)[0x7f15a856f102]

sql/item_subselect.cc:3369(Item_in_subselect::fix_fields(THD*, Item**))[0x55a003997dd1]

sql/item.h:979(Item::fix_fields_if_needed(THD*, Item**))[0x55a0044e8fe7]

sql/item.h:982(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55a003997dd1]

sql/item.h:987(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x55a003997dff]

sql/item_cmpfunc.cc:4899(Item_cond::fix_fields(THD*, Item**))[0x55a003ac76d1]

sql/item.h:979(Item::fix_fields_if_needed(THD*, Item**))[0x55a003abe977]

sql/item.h:982(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55a003ccfe8c]

sql/sql_base.cc:8333(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x55a003cd6d9b]

sql/sql_select.cc:693(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x55a00463bba7]

sql/sql_select.cc:1255(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55a0046169d9]

sql/item_subselect.cc:285(Item_subselect::fix_fields(THD*, Item**))[0x55a00463804b]

sql/item_subselect.cc:3355(Item_exists_subselect::fix_fields(THD*, Item**))[0x55a003997dd1]

sql/item.h:979(Item::fix_fields_if_needed(THD*, Item**))[0x55a003997dff]

sql/item.h:982(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55a003ac76d1]

sql/item.h:987(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x55a0044e8fe7]

sql/item_cmpfunc.cc:4899(Item_cond::fix_fields(THD*, Item**))[0x55a003997dd1]

sql/item.h:979(Item::fix_fields_if_needed(THD*, Item**))[0x55a003997dff]

sql/item.h:982(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x55a003ac76d1]

sql/item.h:987(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x55a003abe977]

sql/sql_base.cc:8333(setup_conds(THD*, TABLE_LIST*, List<TABLE_LIST>&, Item**))[0x55a003ccfe8c]

sql/sql_select.cc:693(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x55a003cd6d9b]

sql/sql_select.cc:1255(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55a003cfb5d3]

sql/sql_select.cc:4619(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55a003cce1c2]

sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55a003c34ea2]

sql/sql_parse.cc:4691(mysql_execute_command(THD*))[0x55a0039ee788]

sql/sp_head.cc:3765(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x55a0039ece92]

sql/sp_head.cc:3492(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x55a0039edf36]

sql/sp_head.cc:3671(sp_instr_stmt::execute(THD*, unsigned int*))[0x55a0039df3da]

sql/sp_head.cc:1435(sp_head::execute(THD*, bool))[0x55a0039e247d]

sql/sp_head.cc:1913(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x55a003eee2cc]

sql/sql_trigger.cc:2239(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x55a003ac07ab]

sql/sql_base.cc:8621(fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type))[0x55a003b6f79f]

sql/sql_insert.cc:984(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x55a003c338b7]

sql/sql_parse.cc:4545(mysql_execute_command(THD*))[0x55a003c4b6c6]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55a003c225df]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55a003c1eef7]

sql/sql_parse.cc:1347(do_command(THD*))[0x55a00404367d]

sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x55a004042fda]

sql/sql_connect.cc:1315(handle_one_connection)[0x55a004cf9f0a]

nptl/pthread_create.c:487(start_thread)[0x7f15a9031fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f15a86384cf]

200707 16:06:13 [ERROR] mysqld got signal 11 ;

Server version: 10.5.5-MariaDB-debug-log

sql/opt_range.cc:1198(make_select(TABLE*, unsigned long long, unsigned long long, Item*, SORT_INFO*, bool, int*))[0x562f7ff24964]

sql/sql_select.cc:2365(JOIN::optimize_stage2())[0x562f7ff235a6]

sql/sql_select.cc:2268(JOIN::optimize_inner())[0x562f7ff1c83d]

sql/sql_select.cc:1618(JOIN::optimize())[0x562f7fdfc630]

sql/sql_lex.cc:4792(st_select_lex::optimize_unflattened_subqueries(bool))[0x562f8038f06b]

sql/opt_subselect.cc:5558(JOIN::optimize_unflattened_subqueries())[0x562f7ff2b317]

sql/sql_select.cc:3028(JOIN::optimize_stage2())[0x562f7ff235a6]

sql/sql_select.cc:2268(JOIN::optimize_inner())[0x562f7ff1c83d]

sql/sql_select.cc:1618(JOIN::optimize())[0x562f7ff3c852]

sql/sql_select.cc:4641(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x562f7ff0f1c2]

sql/sql_select.cc:417(handle_select(THD*, LEX*, select_result*, unsigned long))[0x562f7fe75ea2]

sql/sql_parse.cc:4691(mysql_execute_command(THD*))[0x562f7fc2f788]

sql/sp_head.cc:3765(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x562f7fc2de92]

sql/sp_head.cc:3492(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x562f7fc2ef36]

sql/sp_head.cc:3671(sp_instr_stmt::execute(THD*, unsigned int*))[0x562f7fc203da]

sql/sp_head.cc:1435(sp_head::execute(THD*, bool))[0x562f7fc2347d]

sql/sp_head.cc:1913(sp_head::execute_trigger(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, st_grant_info*))[0x562f8012f2cc]

sql/sql_trigger.cc:2239(Table_triggers_list::process_triggers(THD*, trg_event_type, trg_action_time_type, bool))[0x562f7fd017ab]

sql/sql_base.cc:8621(fill_record_n_invoke_before_triggers(THD*, TABLE*, List<Item>&, List<Item>&, bool, trg_event_type))[0x562f7fdb079f]

sql/sql_insert.cc:984(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*))[0x562f7fe748b7]

sql/sql_parse.cc:4545(mysql_execute_command(THD*))[0x562f7fe8c6c6]

sql/sql_parse.cc:7993(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562f7fe635df]

sql/sql_parse.cc:1869(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562f7fe5fef7]

sql/sql_parse.cc:1347(do_command(THD*))[0x562f8028467d]

sql/sql_connect.cc:1411(do_handle_one_connection(CONNECT*, bool))[0x562f80283fda]

sql/sql_connect.cc:1315(handle_one_connection)[0x562f80f3af0a]

nptl/pthread_create.c:487(start_thread)[0x7f4a0da08fa3]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f4a0d00f4cf]

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

1.7z
2020-07-08 11:11
8.84 MB
Alice Sherepa

Issue Links

relates to

MDEV-32164 Server crashes in JOIN::cleanup after erroneous query with view

Closed

Activity

People

Assignee:: Alice Sherepa

Reporter:: Alice Sherepa

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2020-07-07 14:24

Updated:: 2025-08-01 12:06

Resolved:: 2025-08-01 12:06

Git Integration

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