[MDEV-24877] Memory not freed, Indirect leak, Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed upon EXPLAIN with multi-table UPDATE - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Fix Version/s: N/A
Component/s: Data Manipulation - Update
Labels:
None

Description

CREATE TABLE t1 (a VARCHAR(8));

INSERT INTO t1 VALUES ('abc'),('def'),('ghi');

CREATE TABLE t2 (b INT);

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

EXPLAIN UPDATE t1, t2 SET t1.a = 'foo' WHERE t1.a IN (SELECT 'baz' UNION SELECT 'abc');

# Cleanup

DROP TABLE t1, t2;

10.2 da3211e4 debug
mysqld: /data/src/10.2/sql/sql_class.cc:1570: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 \|\| !debug_assert_on_not_freed_memory' failed.
210216 2:58:22 [ERROR] mysqld got signal 6 ;

#7 0x00007f3189329f36 in __GI___assert_fail (assertion=0x56130d7514a8 "status_var.local_memory_used == 0 \|\| !debug_assert_on_not_freed_memory", file=0x56130d751060 "/data/src/10.2/sql/sql_class.cc", line=1570, function=0x56130d7513c0 "virtual THD::~THD()") at assert.c:101
#8 0x000056130cc9ed4a in THD::~THD (this=0x7f3168000d90, __in_chrg=<optimized out>) at /data/src/10.2/sql/sql_class.cc:1570
#9 0x000056130cc9ef06 in THD::~THD (this=0x7f3168000d90, __in_chrg=<optimized out>) at /data/src/10.2/sql/sql_class.cc:1577
#10 0x000056130cbf0dd1 in one_thread_per_connection_end (thd=0x7f3168000d90, put_in_cache=true) at /data/src/10.2/sql/mysqld.cc:3111
#11 0x000056130ce3e9a3 in do_handle_one_connection (connect=0x56130f510980) at /data/src/10.2/sql/sql_connect.cc:1355
#12 0x000056130ce3e61f in handle_one_connection (arg=0x56130f510980) at /data/src/10.2/sql/sql_connect.cc:1241
#13 0x000056130d666d22 in pfs_spawn_thread (arg=0x56130f4f3d90) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#14 0x00007f3189839609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#15 0x00007f3189415293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.2 da3211e4 Valgrind, run with --mysqld=--debug_assert_on_not_freed_memory=0
2021-02-16 3:01:05 209307392 [ERROR] Plugin 'MEMORY' has ref_count=1 after shutdown.
Warning: Memory not freed: 104
==1042268== 16 bytes in 1 blocks are indirectly lost in loss record 1 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x713387: intern_plugin_lock(LEX, st_plugin_int*, unsigned int) (sql_plugin.cc:979)
==1042268== by 0x71351F: plugin_lock(THD, st_plugin_int*) (sql_plugin.cc:1026)
==1042268== by 0x98D493: ha_lock_engine(THD, handlerton const) (handler.cc:252)
==1042268== by 0x769DEE: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17099)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== by 0x6F6786: do_command(THD*) (sql_parse.cc:1381)
==1042268== by 0x856C4D: do_handle_one_connection(CONNECT*) (sql_connect.cc:1336)
==1042268== 48 bytes in 1 blocks are indirectly lost in loss record 2 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x992E8D: handler::ha_open(TABLE, char const, int, unsigned int) (handler.cc:2625)
==1042268== by 0x76BDEB: open_tmp_table(TABLE*) (sql_select.cc:17642)
==1042268== by 0x76E121: instantiate_tmp_table(TABLE, st_key, st_maria_columndef, st_maria_columndef*, unsigned long long) (sql_select.cc:18519)
==1042268== by 0x76B6C5: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17510)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== by 0x6F6786: do_command(THD*) (sql_parse.cc:1381)
==1042268== 88 bytes in 1 blocks are indirectly lost in loss record 3 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x112E9FB: my_strdup (my_malloc.c:241)
==1042268== by 0xB92E35: heap_create (hp_create.c:225)
==1042268== by 0xB85F75: ha_heap::open(char const*, int, unsigned int) (ha_heap.cc:105)
==1042268== by 0x992C8B: handler::ha_open(TABLE, char const, int, unsigned int) (handler.cc:2592)
==1042268== by 0x76BDEB: open_tmp_table(TABLE*) (sql_select.cc:17642)
==1042268== by 0x76E121: instantiate_tmp_table(TABLE, st_key, st_maria_columndef, st_maria_columndef*, unsigned long long) (sql_select.cc:18519)
==1042268== by 0x76B6C5: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17510)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== 104 bytes in 1 blocks are indirectly lost in loss record 4 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x76A016: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17143)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== by 0x6F6786: do_command(THD*) (sql_parse.cc:1381)
==1042268== by 0x856C4D: do_handle_one_connection(CONNECT*) (sql_connect.cc:1336)
==1042268== by 0x8569B2: handle_one_connection (sql_connect.cc:1241)
==1042268== by 0x10CE2B3: pfs_spawn_thread (pfs.cc:1869)
==1042268== 248 bytes in 1 blocks are indirectly lost in loss record 5 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x111F504: memdup_root (my_alloc.c:464)
==1042268== by 0x95BBAC: Field::make_new_field(st_mem_root, TABLE, bool) (field.cc:2387)
==1042268== by 0x9702DD: Field_string::make_new_field(st_mem_root, TABLE, bool) (field.cc:7645)
==1042268== by 0x7677BA: create_tmp_field_from_field(THD, Field, char const, TABLE, Item_field*) (sql_select.cc:16269)
==1042268== by 0x76828B: create_tmp_field(THD, TABLE, Item, Item::Type, Item, Field, Field**, bool, bool, bool, bool) (sql_select.cc:16525)
==1042268== by 0x7698D1: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:16973)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== 248 bytes in 1 blocks are indirectly lost in loss record 6 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x111F504: memdup_root (my_alloc.c:464)
==1042268== by 0x95BBAC: Field::make_new_field(st_mem_root, TABLE, bool) (field.cc:2387)
==1042268== by 0x971AA8: Field_varstring::make_new_field(st_mem_root, TABLE, bool) (field.cc:8116)
==1042268== by 0x7677BA: create_tmp_field_from_field(THD, Field, char const, TABLE, Item_field*) (sql_select.cc:16269)
==1042268== by 0x76828B: create_tmp_field(THD, TABLE, Item, Item::Type, Item, Field, Field**, bool, bool, bool, bool) (sql_select.cc:16525)
==1042268== by 0x7698D1: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:16973)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== 248 bytes in 1 blocks are indirectly lost in loss record 7 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x111F504: memdup_root (my_alloc.c:464)
==1042268== by 0x95BBAC: Field::make_new_field(st_mem_root, TABLE, bool) (field.cc:2387)
==1042268== by 0x9702DD: Field_string::make_new_field(st_mem_root, TABLE, bool) (field.cc:7645)
==1042268== by 0x95BCD9: Field::new_key_field(st_mem_root, TABLE, unsigned char, unsigned int, unsigned char, unsigned int) (field.cc:2413)
==1042268== by 0x76AC7F: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17327)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== 760 bytes in 1 blocks are indirectly lost in loss record 9 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0xB8BAD9: heap_open_from_share (hp_open.c:33)
==1042268== by 0xB85FC8: ha_heap::open(char const*, int, unsigned int) (ha_heap.cc:112)
==1042268== by 0x992C8B: handler::ha_open(TABLE, char const, int, unsigned int) (handler.cc:2592)
==1042268== by 0x76BDEB: open_tmp_table(TABLE*) (sql_select.cc:17642)
==1042268== by 0x76E121: instantiate_tmp_table(TABLE, st_key, st_maria_columndef, st_maria_columndef*, unsigned long long) (sql_select.cc:18519)
==1042268== by 0x76B6C5: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17510)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== 1,152 bytes in 1 blocks are indirectly lost in loss record 10 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x60BCB3: Sql_alloc::operator new(unsigned long, st_mem_root*) (sql_list.h:45)
==1042268== by 0xB85DA9: heap_create_handler(handlerton, TABLE_SHARE, st_mem_root*) (ha_heap.cc:66)
==1042268== by 0x98D625: get_new_handler(TABLE_SHARE, st_mem_root, handlerton*) (handler.cc:299)
==1042268== by 0x769E2E: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17100)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== by 0x6F6786: do_command(THD*) (sql_parse.cc:1381)
==1042268== 1,768 bytes in 1 blocks are indirectly lost in loss record 11 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0xB92A31: heap_create (hp_create.c:162)
==1042268== by 0xB85F75: ha_heap::open(char const*, int, unsigned int) (ha_heap.cc:105)
==1042268== by 0x992C8B: handler::ha_open(TABLE, char const, int, unsigned int) (handler.cc:2592)
==1042268== by 0x76BDEB: open_tmp_table(TABLE*) (sql_select.cc:17642)
==1042268== by 0x76E121: instantiate_tmp_table(TABLE, st_key, st_maria_columndef, st_maria_columndef*, unsigned long long) (sql_select.cc:18519)
==1042268== by 0x76B6C5: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:17510)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== 9,808 (5,128 direct, 4,680 indirect) bytes in 1 blocks are definitely lost in loss record 12 of 12
==1042268== at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
==1042268== by 0x112E2FC: my_malloc (my_malloc.c:101)
==1042268== by 0x111E9C6: alloc_root (my_alloc.c:189)
==1042268== by 0x111EBEB: multi_alloc_root (my_alloc.c:312)
==1042268== by 0x768D19: create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) (sql_select.cc:16797)
==1042268== by 0x7F7C20: multi_update::initialize_tables(JOIN*) (sql_update.cc:2077)
==1042268== by 0x7403B8: JOIN::optimize_inner() (sql_select.cc:1613)
==1042268== by 0x73E699: JOIN::optimize() (sql_select.cc:1118)
==1042268== by 0x747D29: mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex) (sql_select.cc:3823)
==1042268== by 0x7F649B: mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) (sql_update.cc:1641)
==1042268== by 0x6FDF6A: mysql_execute_command(THD*) (sql_parse.cc:4109)
==1042268== by 0x7099B2: mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:7763)
==1042268== by 0x6F7C8B: dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) (sql_parse.cc:1827)
==1042268== by 0x6F6786: do_command(THD*) (sql_parse.cc:1381)
==1042268== by 0x856C4D: do_handle_one_connection(CONNECT*) (sql_connect.cc:1336)
==1042268== by 0x8569B2: handle_one_connection (sql_connect.cc:1241)

10.2 da3211e4 non-debug ASAN

=================================================================
==1042389==ERROR: LeakSanitizer: detected memory leaks

Indirect leak of 4872 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc83efacb in alloc_root /data/src/10.2/mysys/my_alloc.c:243
#3 0x55dfc83efeff in multi_alloc_root /data/src/10.2/mysys/my_alloc.c:312
#4 0x55dfc6e3941d in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:16797
#5 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#6 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#7 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#8 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#9 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#10 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#11 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#12 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#13 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#14 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#15 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#16 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#17 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#18 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 1512 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc78b5a10 in heap_create /data/src/10.2/storage/heap/hp_create.c:162
#3 0x55dfc78a41dd in ha_heap::open(char const*, int, unsigned int) /data/src/10.2/storage/heap/ha_heap.cc:105
#4 0x55dfc7305d45 in handler::ha_open(TABLE, char const, int, unsigned int) /data/src/10.2/sql/handler.cc:2592
#5 0x55dfc6e2611e in open_tmp_table(TABLE*) /data/src/10.2/sql/sql_select.cc:17642
#6 0x55dfc6e3e1b4 in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:17510
#7 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#8 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#9 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#10 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#11 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#12 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#13 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#14 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#15 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#16 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#17 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#18 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#19 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#20 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 1152 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc83efacb in alloc_root /data/src/10.2/mysys/my_alloc.c:243
#3 0x55dfc78a0ea3 in Sql_alloc::operator new(unsigned long, st_mem_root*) /data/src/10.2/sql/sql_list.h:45
#4 0x55dfc78a0ea3 in heap_create_handler /data/src/10.2/storage/heap/ha_heap.cc:66
#5 0x55dfc72fef14 in get_new_handler(TABLE_SHARE, st_mem_root, handlerton*) /data/src/10.2/sql/handler.cc:299
#6 0x55dfc6e3b332 in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:17100
#7 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#8 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#9 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#10 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#11 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#12 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#13 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#14 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#15 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#16 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#17 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#18 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#19 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#20 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 992 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc83efacb in alloc_root /data/src/10.2/mysys/my_alloc.c:243
#3 0x55dfc83f0939 in memdup_root /data/src/10.2/mysys/my_alloc.c:464
#4 0x55dfc729e7c1 in Field::make_new_field(st_mem_root, TABLE, bool) /data/src/10.2/sql/field.cc:2387
#5 0x55dfc6e2314f in create_tmp_field_from_field(THD, Field, char const, TABLE, Item_field*) /data/src/10.2/sql/sql_select.cc:16269
#6 0x55dfc6e24428 in create_tmp_field(THD, TABLE, Item, Item::Type, Item, Field, Field**, bool, bool, bool, bool) /data/src/10.2/sql/sql_select.cc:16525
#7 0x55dfc6e3a46d in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:16973
#8 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#9 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#10 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#11 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#12 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#13 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#14 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#15 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#16 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#17 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#18 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#19 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#20 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#21 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 760 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc78ad87e in heap_open_from_share /data/src/10.2/storage/heap/hp_open.c:33
#3 0x55dfc78a42e7 in ha_heap::open(char const*, int, unsigned int) /data/src/10.2/storage/heap/ha_heap.cc:112
#4 0x55dfc7305d45 in handler::ha_open(TABLE, char const, int, unsigned int) /data/src/10.2/sql/handler.cc:2592
#5 0x55dfc6e2611e in open_tmp_table(TABLE*) /data/src/10.2/sql/sql_select.cc:17642
#6 0x55dfc6e3e1b4 in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:17510
#7 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#8 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#9 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#10 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#11 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#12 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#13 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#14 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#15 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#16 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#17 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#18 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#19 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#20 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

Indirect leak of 88 byte(s) in 1 object(s) allocated from:
#0 0x7f3c96997bc8 in malloc (/lib/x86_64-linux-gnu/libasan.so.5+0x10dbc8)
#1 0x55dfc8404276 in my_malloc /data/src/10.2/mysys/my_malloc.c:101
#2 0x55dfc840469b in my_strdup /data/src/10.2/mysys/my_malloc.c:241
#3 0x55dfc78b63f5 in heap_create /data/src/10.2/storage/heap/hp_create.c:225
#4 0x55dfc78a41dd in ha_heap::open(char const*, int, unsigned int) /data/src/10.2/storage/heap/ha_heap.cc:105
#5 0x55dfc7305d45 in handler::ha_open(TABLE, char const, int, unsigned int) /data/src/10.2/sql/handler.cc:2592
#6 0x55dfc6e2611e in open_tmp_table(TABLE*) /data/src/10.2/sql/sql_select.cc:17642
#7 0x55dfc6e3e1b4 in create_tmp_table(THD, TMP_TABLE_PARAM, List<Item>&, st_order, bool, bool, unsigned long long, unsigned long long, char const, bool, bool) /data/src/10.2/sql/sql_select.cc:17510
#8 0x55dfc6fb1c22 in multi_update::initialize_tables(JOIN*) /data/src/10.2/sql/sql_update.cc:2077
#9 0x55dfc6e99017 in JOIN::optimize_inner() /data/src/10.2/sql/sql_select.cc:1613
#10 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1118
#11 0x55dfc6ea07dd in JOIN::optimize() /data/src/10.2/sql/sql_select.cc:1110
#12 0x55dfc6ea89cc in mysql_select(THD, TABLE_LIST, unsigned int, 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.2/sql/sql_select.cc:3823
#13 0x55dfc6fbe079 in mysql_multi_update(THD, TABLE_LIST, List<Item>, List<Item>, Item, unsigned long long, enum_duplicates, bool, st_select_lex_unit, st_select_lex, multi_update*) /data/src/10.2/sql/sql_update.cc:1641
#14 0x55dfc6d5bf33 in mysql_execute_command(THD*) /data/src/10.2/sql/sql_parse.cc:4109
#15 0x55dfc6d6f24f in mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool) /data/src/10.2/sql/sql_parse.cc:7763
#16 0x55dfc6d787db in dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool) /data/src/10.2/sql/sql_parse.cc:1827
#17 0x55dfc6d7d6b5 in do_command(THD*) /data/src/10.2/sql/sql_parse.cc:1381
#18 0x55dfc707d666 in do_handle_one_connection(CONNECT*) /data/src/10.2/sql/sql_connect.cc:1336
#19 0x55dfc707ddae in handle_one_connection /data/src/10.2/sql/sql_connect.cc:1241
#20 0x55dfc834b8e8 in pfs_spawn_thread /data/src/10.2/storage/perfschema/pfs.cc:1869
#21 0x7f3c96430608 in start_thread /build/glibc-eX1tMB/glibc-2.31/nptl/pthread_create.c:477

SUMMARY: AddressSanitizer: 9376 byte(s) leaked in 6 allocation(s).
210216 3:02:10 [ERROR] mysqld got signal 6 ;

Reproducible on 10.2-10.6 with at least MyISAM, InnoDB, Aria for table engines.

Attachments

Issue Links

is duplicated by

MDEV-16694 Memory leak with EXPLAIN UPDATE, crash in multi_update::initialize_tables

Confirmed

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2021-02-16 01:03

Updated:: 2021-05-10 21:06

Resolved:: 2021-05-10 21:06

Git Integration

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