[MDEV-25490] Memory leaks after INSERT .. RETURNING with subquery - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.6
Fix Version/s: 10.5.18, 10.6.11, 10.8.6, 10.9.4, 10.10.2
Component/s: Data Manipulation - Insert
Labels:
None

Description

CREATE TABLE t (a INT);

INSERT INTO t SELECT 1 FROM DUAL WHERE 2 IN (SELECT 3 UNION SELECT 4) RETURNING a;

# Cleanup

DROP TABLE t;

10.5 9abc6fd7 non-debug ASAN
Warning: Memory not freed: 120

=================================================================
==2557170==ERROR: LeakSanitizer: detected memory leaks

Indirect leak of 2936 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x560726a5525d in alloc_root /data/src/10.5/mysys/my_alloc.c:244
#3 0x560726a5563f in multi_alloc_root /data/src/10.5/mysys/my_alloc.c:317
#4 0x5607250ab736 in Create_tmp_table::start(THD, TMP_TABLE_PARAM, st_mysql_const_lex_string const*) /data/src/10.5/sql/sql_select.cc:18508
#5 0x5607250c9b6e in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19349
#6 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#7 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#8 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#9 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#10 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#11 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#12 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#13 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#14 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#15 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#16 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#17 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#18 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#19 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#20 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#21 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#22 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#23 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#24 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#25 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#26 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#27 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 1488 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x56072613e289 in heap_create /data/src/10.5/storage/heap/hp_create.c:162
#3 0x56072612cbd5 in ha_heap::open(char const*, int, unsigned int) /data/src/10.5/storage/heap/ha_heap.cc:104
#4 0x5607256d6ef3 in handler::ha_open(TABLE, char const, int, unsigned int, st_mem_root, List<String>) /data/src/10.5/sql/handler.cc:2983
#5 0x5607250b0177 in open_tmp_table(TABLE*) /data/src/10.5/sql/sql_select.cc:19552
#6 0x5607250c8b8d in Create_tmp_table::finalize(THD, TABLE, TMP_TABLE_PARAM*, bool, bool) /data/src/10.5/sql/sql_select.cc:19257
#7 0x5607250c9bcd in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19351
#8 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#9 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#10 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#11 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#12 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#13 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#14 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#15 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#16 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#17 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#18 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#19 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#20 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#21 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#22 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#23 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#24 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#25 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#26 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#27 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#28 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#29 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 1336 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x560726a5525d in alloc_root /data/src/10.5/mysys/my_alloc.c:244
#3 0x5607261290c3 in Sql_alloc::operator new(unsigned long, st_mem_root*) /data/src/10.5/sql/sql_alloc.h:39
#4 0x5607261290c3 in heap_create_handler /data/src/10.5/storage/heap/ha_heap.cc:65
#5 0x5607256cea0c in get_new_handler(TABLE_SHARE, st_mem_root, handlerton*) /data/src/10.5/sql/handler.cc:375
#6 0x5607250c56cb in Create_tmp_table::finalize(THD, TABLE, TMP_TABLE_PARAM*, bool, bool) /data/src/10.5/sql/sql_select.cc:18837
#7 0x5607250c9bcd in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19351
#8 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#9 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#10 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#11 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#12 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#13 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#14 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#15 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#16 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#17 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#18 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#19 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#20 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#21 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#22 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#23 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#24 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#25 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#26 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#27 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#28 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#29 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 1008 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x560726a5525d in alloc_root /data/src/10.5/mysys/my_alloc.c:244
#3 0x5607254e1aeb in Field::operator new(unsigned long, st_mem_root*) /data/src/10.5/sql/field.h:761
#4 0x5607254a517e in Type_handler_long::make_table_field_from_def(TABLE_SHARE, st_mem_root, st_mysql_const_lex_string const, Record_addr const&, Bit_addr const&, Column_definition_attributes const, unsigned int) const /data/src/10.5/sql/sql_type.cc:8129
#5 0x56072549639a in Type_handler_int_result::make_table_field(st_mem_root, st_mysql_const_lex_string const, Record_addr const&, Type_all_attributes const&, TABLE_SHARE*) const /data/src/10.5/sql/sql_type.cc:3561
#6 0x5607254cfc71 in Type_handler::make_and_init_table_field(st_mem_root, st_mysql_const_lex_string const, Record_addr const&, Type_all_attributes const&, TABLE*) const /data/src/10.5/sql/sql_type.cc:3546
#7 0x56072576bc23 in Item_type_holder::create_tmp_field_ex(st_mem_root, TABLE, Tmp_field_src, Tmp_field_param const) /data/src/10.5/sql/item.h:7384
#8 0x5607250aa5a4 in create_tmp_field(TABLE, Item, Item*, Field, Field**, bool, bool, bool, bool) /data/src/10.5/sql/sql_select.cc:18225
#9 0x5607250acd07 in Create_tmp_table::add_fields(THD, TABLE, TMP_TABLE_PARAM*, List<Item>&) /data/src/10.5/sql/sql_select.cc:18713
#10 0x5607250c9ba0 in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19350
#11 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#12 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#13 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#14 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#15 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#16 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#17 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#18 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#19 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#20 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#21 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#22 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#23 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#24 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#25 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#26 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#27 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#28 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#29 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#30 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#31 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#32 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 768 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x56072613621a in heap_open_from_share /data/src/10.5/storage/heap/hp_open.c:33
#3 0x56072612ccdf in ha_heap::open(char const*, int, unsigned int) /data/src/10.5/storage/heap/ha_heap.cc:111
#4 0x5607256d6ef3 in handler::ha_open(TABLE, char const, int, unsigned int, st_mem_root, List<String>) /data/src/10.5/sql/handler.cc:2983
#5 0x5607250b0177 in open_tmp_table(TABLE*) /data/src/10.5/sql/sql_select.cc:19552
#6 0x5607250c8b8d in Create_tmp_table::finalize(THD, TABLE, TMP_TABLE_PARAM*, bool, bool) /data/src/10.5/sql/sql_select.cc:19257
#7 0x5607250c9bcd in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19351
#8 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#9 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#10 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#11 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#12 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#13 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#14 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#15 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#16 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#17 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#18 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#19 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#20 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#21 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#22 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#23 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#24 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#25 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#26 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#27 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#28 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#29 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 120 byte(s) in 1 object(s) allocated from:
#0 0x7f401a53bbc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x560726a693ac in my_malloc /data/src/10.5/mysys/my_malloc.c:90
#2 0x560726a69962 in my_strdup /data/src/10.5/mysys/my_malloc.c:233
#3 0x56072613ec72 in heap_create /data/src/10.5/storage/heap/hp_create.c:226
#4 0x56072612cbd5 in ha_heap::open(char const*, int, unsigned int) /data/src/10.5/storage/heap/ha_heap.cc:104
#5 0x5607256d6ef3 in handler::ha_open(TABLE, char const, int, unsigned int, st_mem_root, List<String>) /data/src/10.5/sql/handler.cc:2983
#6 0x5607250b0177 in open_tmp_table(TABLE*) /data/src/10.5/sql/sql_select.cc:19552
#7 0x5607250c8b8d in Create_tmp_table::finalize(THD, TABLE, TMP_TABLE_PARAM*, bool, bool) /data/src/10.5/sql/sql_select.cc:19257
#8 0x5607250c9bcd in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const, bool, bool) /data/src/10.5/sql/sql_select.cc:19351
#9 0x5607252545fd in select_unit::create_result_table(THD, List<Item>, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int) /data/src/10.5/sql/sql_union.cc:329
#10 0x56072526dac8 in st_select_lex_unit::prepare(TABLE_LIST, select_result, unsigned long long) /data/src/10.5/sql/sql_union.cc:1755
#11 0x5607259c88b1 in subselect_union_engine::prepare(THD*) /data/src/10.5/sql/item_subselect.cc:3881
#12 0x5607259c6eab in Item_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:289
#13 0x5607259c7f29 in Item_in_subselect::fix_fields(THD, Item*) /data/src/10.5/sql/item_subselect.cc:3525
#14 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:988
#15 0x560724e5f86c in Item::fix_fields_if_needed(THD, Item*) /data/src/10.5/sql/item.h:986
#16 0x560724e5f86c in Item::fix_fields_if_needed_for_scalar(THD, Item*) /data/src/10.5/sql/item.h:992
#17 0x560724e5f86c in Item::fix_fields_if_needed_for_bool(THD, Item*) /data/src/10.5/sql/item.h:996
#18 0x560724e5f86c in setup_conds(THD, TABLE_LIST, List<TABLE_LIST>&, Item**) /data/src/10.5/sql/sql_base.cc:8384
#19 0x5607250f6eb0 in setup_without_group /data/src/10.5/sql/sql_select.cc:722
#20 0x5607250f6eb0 in JOIN::prepare(TABLE_LIST, Item, unsigned int, st_order, bool, st_order, Item, st_order, st_select_lex, st_select_lex_unit) /data/src/10.5/sql/sql_select.cc:1274
#21 0x560725140256 in 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) /data/src/10.5/sql/sql_select.cc:4726
#22 0x560725140eef in handle_select(THD, LEX, select_result*, unsigned long) /data/src/10.5/sql/sql_select.cc:443
#23 0x560724fdb2b2 in mysql_execute_command(THD*) /data/src/10.5/sql/sql_parse.cc:4774
#24 0x560724f9518c in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.5/sql/sql_parse.cc:8101
#25 0x560724fc273a in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.5/sql/sql_parse.cc:1891
#26 0x560724fc99fa in do_command(THD*) /data/src/10.5/sql/sql_parse.cc:1370
#27 0x56072536b6ec in do_handle_one_connection(CONNECT*, bool) /data/src/10.5/sql/sql_connect.cc:1410
#28 0x56072536c284 in handle_one_connection /data/src/10.5/sql/sql_connect.cc:1312
#29 0x560725f676c8 in pfs_spawn_thread /data/src/10.5/storage/perfschema/pfs.cc:2201
#30 0x7f4019f3c608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

SUMMARY: AddressSanitizer: 7656 byte(s) leaked in 6 allocation(s).
210422 15:44:38 [ERROR] mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.5.10-MariaDB-log
read_buffer_size=131072
max_used_connections=1
thread_count=0
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x5fc00
??:0(__interceptor_tcgetattr)[0x7f401a49ad30]
mysys/stacktrace.c:213(my_print_stacktrace)[0x560726a72916]
sql/signal_handler.cc:221(handle_fatal_signal)[0x5607256c5e44]
sigaction.c:0(__restore_rt)[0x7f4019f483c0]
??:0(gsignal)[0x7f4019a3418b]
??:0(abort)[0x7f4019a13859]
??:0(__sanitizer_set_report_fd)[0x7f401a5596a2]
??:0(__sanitizer_get_module_and_offset_for_pc)[0x7f401a56424c]
??:0(__lsan_do_recoverable_leak_check)[0x7f401a569b9c]
??:0(__lsan_enable)[0x7f401a5693dd]
??:0(__cxa_finalize)[0x7f4019a3815e]
/lib/x86_64-linux-gnu/libasan.so.5(+0x22be7)[0x7f401a450be7]
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file...
Working directory at /dev/shm/var_auto_femX/mysqld.1/data
Resource Limits:
Fatal signal 11 while backtracing

10.5 9abc6fd7
mariadbd: /data/src/10.5/sql/sql_class.cc:1760: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 \|\| !debug_assert_on_not_freed_memory' failed.
210422 15:45:46 [ERROR] mysqld got signal 6 ;

#7 0x00007f008cdf0f36 in __GI___assert_fail (assertion=0x559ed5f26500 "status_var.local_memory_used == 0 \|\| !debug_assert_on_not_freed_memory", file=0x559ed5f25fd0 "/data/src/10.5/sql/sql_class.cc", line=1760, function=0x559ed5f264a6 "virtual THD::~THD()") at assert.c:101
#8 0x0000559ed50d6a34 in THD::~THD (this=0x7f006c000db8, __in_chrg=<optimized out>) at /data/src/10.5/sql/sql_class.cc:1760
#9 0x0000559ed50d6c6e in THD::~THD (this=0x7f006c000db8, __in_chrg=<optimized out>) at /data/src/10.5/sql/sql_class.cc:1766
#10 0x0000559ed52fdd80 in do_handle_one_connection (connect=0x0, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1451
#11 0x0000559ed52fd93a in handle_one_connection (arg=0x559ed8822c18) at /data/src/10.5/sql/sql_connect.cc:1312
#12 0x0000559ed5861ca3 in pfs_spawn_thread (arg=0x559ed891b978) at /data/src/10.5/storage/perfschema/pfs.cc:2201
#13 0x00007f008d308609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#14 0x00007f008cedc293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Query (0x0): (null)
Connection ID (thread ID): 7
Status: KILL_CONNECTION

Reproducible on 10.5, 10.6.
Not applicable to previous versions due to the use of INSERT .. RETURNING.

Attachments

Issue Links

relates to

MDEV-28515 Assertion `field->table == table' failed in Create_tmp_table::finalize and create_tmp_table and SIGSEGV in hp_rec_hashnr

Closed

Activity

People

Assignee:: Rucha Deodhar

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2021-04-22 12:47

Updated:: 2023-06-08 17:44

Resolved:: 2023-06-08 17:44

Git Integration

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