[MDEV-19299] ASAN: heap-use-after-free upon LEAST(..CHARSET(..),..) Created: 2019-04-22  Updated: 2023-04-27

Status: Confirmed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-14041 Server crashes in String::length on q... Closed

 Description   

This issue was originally reported as a part of MDEV-14041, but then moved into a separate issue.

CREATE TABLE t1 (a DATE, b TIME);
 
INSERT INTO t1 VALUES ('2014-04-07','11:35:28');
 
SELECT * FROM t1 GROUP BY GREATEST( TRIM(LEADING '02:18:28' FROM CHARSET(a)), UPPER(b) ) WITH ROLLUP;
 
DROP TABLE t1;

10.4 7b33a6a1 ASAN

 
==23264==ERROR: AddressSanitizer: heap-use-after-free on address 0x60d000047cc0 at pc 0x55df6365aa61 bp 0x7fda286d69f0 sp 0x7fda286d69e8
 
READ of size 1 at 0x60d000047cc0 thread T5
 
    #0 0x55df6365aa60 in my_scan_weight_utf8_general_ci /data/src/10.4/strings/strcoll.ic:98
 
    #1 0x55df6365b2d6 in my_strnncollsp_utf8_general_ci /data/src/10.4/strings/strcoll.ic:254
 
    #2 0x55df61ead092 in sortcmp(String const*, String const*, charset_info_st const*) /data/src/10.4/sql/sql_string.cc:803
 
    #3 0x55df6259794a in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2679
 
    #4 0x55df62181568 in Type_handler_string_result::Item_func_min_max_val_str(Item_func_min_max*, String*) const /data/src/10.4/sql/sql_type.cc:5189
 
    #5 0x55df62560ec4 in Item_func_min_max::val_str(String*) /data/src/10.4/sql/item_func.h:1798
 
    #6 0x55df624ee7b6 in Cached_item_str::cmp() /data/src/10.4/sql/item_buff.cc:84
 
    #7 0x55df61df3a0a in test_if_group_changed(List<Cached_item>&) /data/src/10.4/sql/sql_select.cc:24413
 
    #8 0x55df61ddf82e in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:21403
 
    #9 0x55df61dd2562 in do_select /data/src/10.4/sql/sql_select.cc:19513
 
    #10 0x55df61d6be3c in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4371
 
    #11 0x55df61d69737 in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4153
 
    #12 0x55df61d6d214 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.4/sql/sql_select.cc:4585
 
    #13 0x55df61d437fa in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:424
 
    #14 0x55df61cc4537 in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6652
 
    #15 0x55df61cb10fe in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3889
 
    #16 0x55df61cccdda in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8205
 
    #17 0x55df61ca4ce5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1829
 
    #18 0x55df61ca1b36 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1358
 
    #19 0x55df620358a5 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1399
 
    #20 0x55df6203529e in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1302
 
    #21 0x55df62bfcbe2 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862
 
    #22 0x7fda33a86493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
 
    #23 0x7fda31e6c93e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
 
 
0x60d000047cc0 is located 112 bytes inside of 140-byte region [0x60d000047c50,0x60d000047cdc)
 
freed by thread T5 here:
 
    #0 0x7fda33cf0527 in __interceptor_free (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x54527)
 
    #1 0x55df635ae2e1 in free_memory /data/src/10.4/mysys/safemalloc.c:279
 
    #2 0x55df635ad8e7 in sf_free /data/src/10.4/mysys/safemalloc.c:197
 
    #3 0x55df6357e330 in my_free /data/src/10.4/mysys/my_malloc.c:222
 
    #4 0x55df61a0f733 in Binary_string::free() /data/src/10.4/sql/sql_string.h:604
 
    #5 0x55df61ea7d7a in Binary_string::real_alloc(unsigned long) /data/src/10.4/sql/sql_string.cc:43
 
    #6 0x55df61a2f575 in Binary_string::alloc(unsigned long) /data/src/10.4/sql/sql_string.h:613
 
    #7 0x55df624dfd8b in String::copy(charset_info_st const*, charset_info_st const*, char const*, unsigned long, unsigned long, String_copier*) /data/src/10.4/sql/sql_string.h:847
 
    #8 0x55df624bb433 in String_copier_for_item::copy_with_warn(charset_info_st const*, String*, charset_info_st const*, char const*, unsigned int, unsigned int) /data/src/10.4/sql/item.cc:6214
 
    #9 0x55df6261816c in Item_func_conv_charset::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:3446
 
    #10 0x55df625978fb in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2676
 
    #11 0x55df62181568 in Type_handler_string_result::Item_func_min_max_val_str(Item_func_min_max*, String*) const /data/src/10.4/sql/sql_type.cc:5189
 
    #12 0x55df62560ec4 in Item_func_min_max::val_str(String*) /data/src/10.4/sql/item_func.h:1798
 
    #13 0x55df624ee7b6 in Cached_item_str::cmp() /data/src/10.4/sql/item_buff.cc:84
 
    #14 0x55df61df3a0a in test_if_group_changed(List<Cached_item>&) /data/src/10.4/sql/sql_select.cc:24413
 
    #15 0x55df61ddf82e in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:21403
 
    #16 0x55df61dd2562 in do_select /data/src/10.4/sql/sql_select.cc:19513
 
    #17 0x55df61d6be3c in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4371
 
    #18 0x55df61d69737 in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4153
 
    #19 0x55df61d6d214 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.4/sql/sql_select.cc:4585
 
    #20 0x55df61d437fa in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:424
 
    #21 0x55df61cc4537 in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6652
 
    #22 0x55df61cb10fe in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3889
 
    #23 0x55df61cccdda in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8205
 
    #24 0x55df61ca4ce5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1829
 
    #25 0x55df61ca1b36 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1358
 
    #26 0x55df620358a5 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1399
 
    #27 0x55df6203529e in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1302
 
    #28 0x55df62bfcbe2 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862
 
    #29 0x7fda33a86493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
 
 
 
previously allocated by thread T5 here:
 
    #0 0x7fda33cf073f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
 
    #1 0x55df635ad057 in sf_malloc /data/src/10.4/mysys/safemalloc.c:118
 
    #2 0x55df6357d952 in my_malloc /data/src/10.4/mysys/my_malloc.c:101
 
    #3 0x55df61ea7dd9 in Binary_string::real_alloc(unsigned long) /data/src/10.4/sql/sql_string.cc:46
 
    #4 0x55df61a2f575 in Binary_string::alloc(unsigned long) /data/src/10.4/sql/sql_string.h:613
 
    #5 0x55df61eaa299 in String::copy(char const*, unsigned long, charset_info_st const*, charset_info_st const*, unsigned int*) /data/src/10.4/sql/sql_string.cc:443
 
    #6 0x55df626190de in Item_func_charset::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:3513
 
    #7 0x55df62608d13 in Item_func_ltrim::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:1938
 
    #8 0x55df62597791 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2672
 
    #9 0x55df62181568 in Type_handler_string_result::Item_func_min_max_val_str(Item_func_min_max*, String*) const /data/src/10.4/sql/sql_type.cc:5189
 
    #10 0x55df62560ec4 in Item_func_min_max::val_str(String*) /data/src/10.4/sql/item_func.h:1798
 
    #11 0x55df624ee7b6 in Cached_item_str::cmp() /data/src/10.4/sql/item_buff.cc:84
 
    #12 0x55df61df3a0a in test_if_group_changed(List<Cached_item>&) /data/src/10.4/sql/sql_select.cc:24413
 
    #13 0x55df61ddf82e in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:21403
 
    #14 0x55df61dd2562 in do_select /data/src/10.4/sql/sql_select.cc:19513
 
    #15 0x55df61d6be3c in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4371
 
    #16 0x55df61d69737 in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4153
 
    #17 0x55df61d6d214 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.4/sql/sql_select.cc:4585
 
    #18 0x55df61d437fa in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:424
 
    #19 0x55df61cc4537 in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6652
 
    #20 0x55df61cb10fe in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3889
 
    #21 0x55df61cccdda in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8205
 
    #22 0x55df61ca4ce5 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1829
 
    #23 0x55df61ca1b36 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1358
 
    #24 0x55df620358a5 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1399
 
    #25 0x55df6203529e in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1302
 
    #26 0x55df62bfcbe2 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862
 
    #27 0x7fda33a86493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
 
 
 
Thread T5 created by T0 here:
 
    #0 0x7fda33cbfbba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
 
    #1 0x55df62bfd1aa in spawn_thread_v1 /data/src/10.4/storage/perfschema/pfs.cc:1912
 
    #2 0x55df619ec846 in inline_mysql_thread_create /data/src/10.4/include/mysql/psi/mysql_thread.h:1268
 
    #7 0x55df61a01973 in mysqld_main(int, char**) /data/src/10.4/sql/mysqld.cc:5876
 
    #8 0x55df619ea6cf in main /data/src/10.4/sql/main.cc:25
 
    #9 0x7fda31da42b0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202b0)
 
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/10.4/strings/strcoll.ic:98 my_scan_weight_utf8_general_ci
 
Shadow bytes around the buggy address:
 
  0x0c1a80000f40: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c1a80000f50: fa fa fa fa fa fa 00 00 00 00 00 00 00 00 00 00
 
  0x0c1a80000f60: 00 00 00 00 00 00 04 fa fa fa fa fa fa fa fa fa
 
  0x0c1a80000f70: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
 
  0x0c1a80000f80: 04 fa fa fa fa fa fa fa fa fa fd fd fd fd fd fd
 
=>0x0c1a80000f90: fd fd fd fd fd fd fd fd[fd]fd fd fd fa fa fa fa
 
  0x0c1a80000fa0: fa fa fa fa 00 00 00 00 00 00 00 00 00 00 00 00
 
  0x0c1a80000fb0: 00 00 00 00 04 fa fa fa fa fa fa fa fa fa 00 00
 
  0x0c1a80000fc0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 04
 
  0x0c1a80000fd0: fa fa fa fa fa fa fa fa 00 00 00 00 00 00 00 00
 
  0x0c1a80000fe0: 00 00 00 00 00 00 00 00 00 04 fa fa fa fa fa fa
 
 
 
Shadow byte legend (one shadow byte represents 8 application bytes):
 
  Addressable:           00
 
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
 
  Heap right redzone:      fb
 
  Freed heap region:       fd
 
  Stack left redzone:      f1
 
  Stack mid redzone:       f2
 
  Stack right redzone:     f3
 
  Stack partial redzone:   f4
 
  Stack after return:      f5
 
  Stack use after scope:   f8
 
  Global redzone:          f9
 
  Global init order:       f6
 
  Poisoned by user:        f7
 
  Contiguous container OOB:fc
 
  ASan internal:           fe
 
==23264==ABORTING

5.5 8024f8c6 ASAN

 
==24172==ERROR: AddressSanitizer: heap-use-after-free on address 0x60c000012d60 at pc 0x1697c49 bp 0x7fa810ad8d30 sp 0x7fa810ad8d28
 
READ of size 1 at 0x60c000012d60 thread T5
 
    #0 0x1697c48 in my_utf8_uni /data/src/5.5/strings/ctype-utf8.c:2316
 
    #1 0x169b915 in my_strnncollsp_utf8 /data/src/5.5/strings/ctype-utf8.c:2761
 
    #2 0x809302 in sortcmp(String const*, String const*, charset_info_st const*) /data/src/5.5/sql/sql_string.cc:736
 
    #3 0xbc9d8a in Item_func_min_max::val_str(String*) /data/src/5.5/sql/item_func.cc:3000
 
    #4 0xb387ac in Cached_item_str::cmp() /data/src/5.5/sql/item_buff.cc:83
 
    #5 0x70ac75 in test_if_group_changed /data/src/5.5/sql/sql_select.cc:21404
 
    #6 0x788554 in end_send_group(JOIN*, st_join_table*, bool) /data/src/5.5/sql/sql_select.cc:18401
 
    #7 0x770d89 in do_select /data/src/5.5/sql/sql_select.cc:16742
 
    #8 0x7b0f3d in JOIN::exec() /data/src/5.5/sql/sql_select.cc:2912
 
    #9 0x79d8ac in mysql_select(THD*, Item***, 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/5.5/sql/sql_select.cc:3133
 
    #10 0x79df58 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/5.5/sql/sql_select.cc:323
 
    #11 0x690312 in execute_sqlcom_select /data/src/5.5/sql/sql_parse.cc:4679
 
    #12 0x6a70bb in mysql_execute_command(THD*) /data/src/5.5/sql/sql_parse.cc:2225
 
    #13 0x6bac31 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/src/5.5/sql/sql_parse.cc:5924
 
    #14 0x6be7ac in dispatch_command(enum_server_command, THD*, char*, unsigned int) /data/src/5.5/sql/sql_parse.cc:1067
 
    #15 0x6c29f4 in do_command(THD*) /data/src/5.5/sql/sql_parse.cc:793
 
    #16 0x91bf7a in do_handle_one_connection(THD*) /data/src/5.5/sql/sql_connect.cc:1268
 
    #17 0x91c1eb in handle_one_connection /data/src/5.5/sql/sql_connect.cc:1184
 
    #18 0x10ab47f in pfs_spawn_thread /data/src/5.5/storage/perfschema/pfs.cc:1015
 
freed by thread T5 here:
 
    #0 0x7fa81878e527 in __interceptor_free (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x54527)
 
    #1 0x1658faa in free_memory /data/src/5.5/mysys/safemalloc.c:205
 
 
previously allocated by thread T5 here:
 
    #0 0x7fa81878e73f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
 
    #1 0x165908f in sf_malloc /data/src/5.5/mysys/safemalloc.c:105
 
 
Thread T5 created by T0 here:
 
    #0 0x7fa81875dbba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
 
    #1 0x10aeff4 in spawn_thread_v1 /data/src/5.5/storage/perfschema/pfs.cc:1038
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/5.5/strings/ctype-utf8.c:2316 my_utf8_uni
 
Shadow bytes around the buggy address:
 
  0x0c187fffa550: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c187fffa560: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c187fffa570: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c187fffa580: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c187fffa590: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
=>0x0c187fffa5a0: fd fd fd fd fd fd fd fd fd fd fd fd[fd]fd fd fd
 
  0x0c187fffa5b0: fa fa fa fa fa fa fa fa 00 00 00 00 00 00 00 00
 
  0x0c187fffa5c0: 00 00 00 00 00 00 07 fa fa fa fa fa fa fa fa fa
 
  0x0c187fffa5d0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 02 fa
 
  0x0c187fffa5e0: fa fa fa fa fa fa fa fa fd fd fd fd fd fd fd fd
 
  0x0c187fffa5f0: fd fd fd fd fd fd fd fa fa fa fa fa fa fa fa fa
 
Shadow byte legend (one shadow byte represents 8 application bytes):
 
  Addressable:           00
 
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
 
  Heap right redzone:      fb
 
  Freed heap region:       fd
 
  Stack left redzone:      f1
 
  Stack mid redzone:       f2
 
  Stack right redzone:     f3
 
  Stack partial redzone:   f4
 
  Stack after return:      f5
 
  Stack use after scope:   f8
 
  Global redzone:          f9
 
  Global init order:       f6
 
  Poisoned by user:        f7
 
  Contiguous container OOB:fc
 
  ASan internal:           fe
 
==24172==ABORTING



 Comments   
Comment by Alice Sherepa [ 2020-05-05 ]

I am getting smth similar (in case test is needed, I can try to do)

10.5 f544a712c8a2ef3f3ecba

 
    #0 0x55bf98a3a6ec in my_strnncollsp_simple /10.5/strings/ctype-simple.c:182
 
    #1 0x55bf96ec95b8 in charset_info_st::strnncollsp(char const*, unsigned long, char const*, unsigned long) const /10.5/include/m_ctype.h:776
 
    #2 0x55bf96eee687 in sortcmp(String const*, String const*, charset_info_st const*) /10.5/sql/sql_string.cc:824
 
    #3 0x55bf975c5c08 in Item_func_min_max::val_str_native(String*) /10.5/sql/item_func.cc:2766
 
    #4 0x55bf9722f950 in Type_handler_string_result::Item_func_min_max_val_str(Item_func_min_max*, String*) const /10.5/sql/sql_type.cc:5754
 
    #5 0x55bf975926a5 in Item_func_min_max::val_str(String*) /10.5/sql/item_func.h:1924
 
    #6 0x55bf974d8ddc in Item_copy_string::copy() /10.5/sql/item.cc:4855
 
    #7 0x55bf96e084ed in copy_fields(TMP_TABLE_PARAM*) /10.5/sql/sql_select.cc:25292
 
    #8 0x55bf96deff3b in end_send_group(JOIN*, st_join_table*, bool) /10.5/sql/sql_select.cc:22006
 
    #9 0x55bf96de2891 in do_select /10.5/sql/sql_select.cc:20096
 
    #10 0x55bf96d7102d in JOIN::exec_inner() /10.5/sql/sql_select.cc:4464
 
    #11 0x55bf96d6e67f in JOIN::exec() /10.5/sql/sql_select.cc:4245
 
    #12 0x55bf96d72594 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*) /10.5/sql/sql_select.cc:4669
 
    #13 0x55bf96d448d7 in handle_select(THD*, LEX*, select_result*, unsigned long) /10.5/sql/sql_select.cc:417
 
    #14 0x55bf96cb6fd4 in execute_sqlcom_select /10.5/sql/sql_parse.cc:6172
 
    #15 0x55bf96ca6398 in mysql_execute_command(THD*) /10.5/sql/sql_parse.cc:3901
 
    #16 0x55bf96cc1f18 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.5/sql/sql_parse.cc:7957
 
    #17 0x55bf96c99077 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.5/sql/sql_parse.cc:1839
 
    #18 0x55bf96c95afc in do_command(THD*) /10.5/sql/sql_parse.cc:1358
 
    #19 0x55bf970b4539 in do_handle_one_connection(CONNECT*, bool) /10.5/sql/sql_connect.cc:1422
 
    #20 0x55bf970b3dd4 in handle_one_connection /10.5/sql/sql_connect.cc:1319
 
    #21 0x55bf97d53c43 in pfs_spawn_thread /10.5/storage/perfschema/pfs.cc:2201
 
    #22 0x7f7eb4b4bfa2 in start_thread /build/glibc-vjB4T1/glibc-2.28/nptl/pthread_create.c:486
 
    #23 0x7f7eb41524ce in clone (/lib/x86_64-linux-gnu/libc.so.6+0xf94ce)

Comment by Elena Stepanova [ 2022-04-23 ]

It seems to be fixed or otherwise have disappeared in 10.6+, but still happens on 10.2-10.5.

Here is also a variation without CHARSET, fails on 10.2-10.4.

CREATE TABLE t (a SET('Missouri', 'Oregon')) CHARSET utf8 COLLATE utf8_vietnamese_ci;
 
INSERT INTO t VALUES ('Missouri');
 
SELECT LEAST(LTRIM(UUID()),a) f FROM t GROUP BY f;
 
 
 
# Cleanup
 
DROP TABLE t;

10.4 a83c7ab1

 
==2932844==ERROR: AddressSanitizer: heap-use-after-free on address 0x60400000ad98 at pc 0x55f28803d90d bp 0x7f4b01ddcf70 sp 0x7f4b01ddcf68
 
READ of size 1 at 0x60400000ad98 thread T5
 
    #0 0x55f28803d90c in my_uca_scanner_next_no_contractions_utf8mb3 /data/src/10.4/strings/ctype-uca-scanner_next.inl:88
 
    #1 0x55f28803d90c in my_uca_scanner_next_no_contractions_utf8mb3 /data/src/10.4/strings/ctype-uca-scanner_next.inl:49
 
    #2 0x55f28803d90c in my_uca_strnncollsp_onelevel_no_contractions_utf8mb3 /data/src/10.4/strings/ctype-uca.ic:207
 
    #3 0x55f2870b6fd5 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2912
 
    #4 0x55f286f68300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #5 0x55f28698f9f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #6 0x55f2869a787b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #7 0x55f2869dea08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #8 0x55f2869dea08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #9 0x55f2869dfaee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #10 0x55f2869d76c4 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.4/sql/sql_select.cc:4766
 
    #11 0x55f2869da258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #12 0x55f286857dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #13 0x55f28687e028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #14 0x55f2868865ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #15 0x55f28688d55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #16 0x55f2868922b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #17 0x55f286be0ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #18 0x55f286be136a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #19 0x55f28774df64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #20 0x7f4b0b898ea6 in start_thread nptl/pthread_create.c:477
 
    #21 0x7f4b0b495dee in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xfddee)
 
 
 
0x60400000ad98 is located 8 bytes inside of 48-byte region [0x60400000ad90,0x60400000adc0)
 
freed by thread T5 here:
 
    #0 0x7f4b0be07b6f in __interceptor_free ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:123
 
    #1 0x55f2866257a6 in Binary_string::free() /data/src/10.4/sql/sql_string.h:610
 
    #2 0x55f286ebaa6b in Binary_string::set_alloced(char*, unsigned long, unsigned long) /data/src/10.4/sql/sql_string.h:456
 
    #3 0x55f286ebaa6b in Binary_string::operator=(Binary_string const&) /data/src/10.4/sql/sql_string.h:514
 
    #4 0x55f286ebaa6b in Binary_string::operator=(Binary_string const&) /data/src/10.4/sql/sql_string.h:505
 
    #5 0x55f286ebaa6b in String::operator=(String const&) /data/src/10.4/sql/sql_string.h:816
 
    #6 0x55f286ebaa6b in Field_set::val_str(String*, String*) /data/src/10.4/sql/field.cc:9612
 
    #7 0x55f2870b6fa8 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2909
 
    #8 0x55f286f68300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #9 0x55f28698f9f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #10 0x55f2869a787b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #11 0x55f2869dea08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #12 0x55f2869dea08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #13 0x55f2869dfaee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #14 0x55f2869d76c4 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.4/sql/sql_select.cc:4766
 
    #15 0x55f2869da258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #16 0x55f286857dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #17 0x55f28687e028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #18 0x55f2868865ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #19 0x55f28688d55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #20 0x55f2868922b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #21 0x55f286be0ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #22 0x55f286be136a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #23 0x55f28774df64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #24 0x7f4b0b898ea6 in start_thread nptl/pthread_create.c:477
 
 
 
previously allocated by thread T5 here:
 
    #0 0x7f4b0be07e8f in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:145
 
    #1 0x55f287fcb942 in my_malloc /data/src/10.4/mysys/my_malloc.c:101
 
    #2 0x55f286a63943 in Binary_string::real_alloc(unsigned long) /data/src/10.4/sql/sql_string.cc:44
 
    #3 0x55f287156aa8 in Binary_string::alloc(unsigned long) /data/src/10.4/sql/sql_string.h:619
 
    #4 0x55f287156aa8 in Item_func_uuid::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:4377
 
    #5 0x55f28717321b in Item_func_ltrim::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:1959
 
    #6 0x55f2870b6e76 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2905
 
    #7 0x55f286f68300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #8 0x55f28698f9f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #9 0x55f2869a787b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #10 0x55f2869dea08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #11 0x55f2869dea08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #12 0x55f2869dfaee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #13 0x55f2869d76c4 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.4/sql/sql_select.cc:4766
 
    #14 0x55f2869da258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #15 0x55f286857dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #16 0x55f28687e028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #17 0x55f2868865ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #18 0x55f28688d55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #19 0x55f2868922b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #20 0x55f286be0ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #21 0x55f286be136a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #22 0x55f28774df64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #23 0x7f4b0b898ea6 in start_thread nptl/pthread_create.c:477
 
 
 
Thread T5 created by T0 here:
 
    #0 0x7f4b0bdb32a2 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:214
 
    #1 0x55f2877525ba in spawn_thread_v1 /data/src/10.4/storage/perfschema/pfs.cc:1919
 
    #2 0x55f2865fbf0b in inline_mysql_thread_create /data/src/10.4/include/mysql/psi/mysql_thread.h:1275
 
    #3 0x55f2865fbf0b in create_thread_to_handle_connection(CONNECT*) /data/src/10.4/sql/mysqld.cc:6280
 
    #4 0x55f28660812f in create_new_thread(CONNECT*) /data/src/10.4/sql/mysqld.cc:6350
 
    #5 0x55f28660876a in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/src/10.4/sql/mysqld.cc:6448
 
    #6 0x55f286609879 in handle_connections_sockets() /data/src/10.4/sql/mysqld.cc:6606
 
    #7 0x55f28660b2e7 in mysqld_main(int, char**) /data/src/10.4/sql/mysqld.cc:5938
 
    #8 0x7f4b0b3bed09 in __libc_start_main ../csu/libc-start.c:308
 
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/10.4/strings/ctype-uca-scanner_next.inl:88 in my_uca_scanner_next_no_contractions_utf8mb3
 
Shadow bytes around the buggy address:
 
  0x0c087fff9560: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 fa
 
  0x0c087fff9570: fa fa 00 00 00 00 00 00 fa fa 00 00 00 00 00 fa
 
  0x0c087fff9580: fa fa fd fd fd fd fd fa fa fa 00 00 00 00 00 fa
 
  0x0c087fff9590: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 fa
 
  0x0c087fff95a0: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 00
 
=>0x0c087fff95b0: fa fa fd[fd]fd fd fd fd fa fa fa fa fa fa fa fa
 
  0x0c087fff95c0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95d0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95e0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95f0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff9600: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
Shadow byte legend (one shadow byte represents 8 application bytes):
 
  Addressable:           00
 
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
 
  Freed heap region:       fd
 
  Stack left redzone:      f1
 
  Stack mid redzone:       f2
 
  Stack right redzone:     f3
 
  Stack after return:      f5
 
  Stack use after scope:   f8
 
  Global redzone:          f9
 
  Global init order:       f6
 
  Poisoned by user:        f7
 
  Container overflow:      fc
 
  Array cookie:            ac
 
  Intra object redzone:    bb
 
  ASan internal:           fe
 
  Left alloca redzone:     ca
 
  Right alloca redzone:    cb
 
  Shadow gap:              cc
 
==2932844==ABORTING

or without the Vietnamese collation,

==2932956==ERROR: AddressSanitizer: heap-use-after-free on address 0x60400000ad18 at pc 0x560f799d5700 bp 0x7fdc1b51e230 sp 0x7fdc1b51e228
 
READ of size 1 at 0x60400000ad18 thread T5
 
    #0 0x560f799d56ff in my_scan_weight_utf8_general_ci /data/src/10.4/strings/strcoll.inl:98
 
    #1 0x560f799d56ff in my_scan_weight_utf8_general_ci /data/src/10.4/strings/strcoll.inl:89
 
    #2 0x560f799d56ff in my_strnncollsp_utf8_general_ci /data/src/10.4/strings/strcoll.inl:254
 
    #3 0x560f78a07fd5 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2912
 
    #4 0x560f788b9300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #5 0x560f782e09f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #6 0x560f782f887b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #7 0x560f7832fa08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #8 0x560f7832fa08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #9 0x560f78330aee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #10 0x560f783286c4 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.4/sql/sql_select.cc:4766
 
    #11 0x560f7832b258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #12 0x560f781a8dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #13 0x560f781cf028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #14 0x560f781d75ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #15 0x560f781de55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #16 0x560f781e32b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #17 0x560f78531ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #18 0x560f7853236a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #19 0x560f7909ef64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #20 0x7fdc24fdfea6 in start_thread nptl/pthread_create.c:477
 
    #21 0x7fdc24bdcdee in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xfddee)
 
 
 
0x60400000ad18 is located 8 bytes inside of 48-byte region [0x60400000ad10,0x60400000ad40)
 
freed by thread T5 here:
 
    #0 0x7fdc2554eb6f in __interceptor_free ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:123
 
    #1 0x560f77f767a6 in Binary_string::free() /data/src/10.4/sql/sql_string.h:610
 
    #2 0x560f7880ba6b in Binary_string::set_alloced(char*, unsigned long, unsigned long) /data/src/10.4/sql/sql_string.h:456
 
    #3 0x560f7880ba6b in Binary_string::operator=(Binary_string const&) /data/src/10.4/sql/sql_string.h:514
 
    #4 0x560f7880ba6b in Binary_string::operator=(Binary_string const&) /data/src/10.4/sql/sql_string.h:505
 
    #5 0x560f7880ba6b in String::operator=(String const&) /data/src/10.4/sql/sql_string.h:816
 
    #6 0x560f7880ba6b in Field_set::val_str(String*, String*) /data/src/10.4/sql/field.cc:9612
 
    #7 0x560f78a07fa8 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2909
 
    #8 0x560f788b9300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #9 0x560f782e09f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #10 0x560f782f887b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #11 0x560f7832fa08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #12 0x560f7832fa08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #13 0x560f78330aee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #14 0x560f783286c4 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.4/sql/sql_select.cc:4766
 
    #15 0x560f7832b258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #16 0x560f781a8dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #17 0x560f781cf028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #18 0x560f781d75ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #19 0x560f781de55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #20 0x560f781e32b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #21 0x560f78531ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #22 0x560f7853236a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #23 0x560f7909ef64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #24 0x7fdc24fdfea6 in start_thread nptl/pthread_create.c:477
 
 
 
previously allocated by thread T5 here:
 
    #0 0x7fdc2554ee8f in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:145
 
    #1 0x560f7991c942 in my_malloc /data/src/10.4/mysys/my_malloc.c:101
 
    #2 0x560f783b4943 in Binary_string::real_alloc(unsigned long) /data/src/10.4/sql/sql_string.cc:44
 
    #3 0x560f78aa7aa8 in Binary_string::alloc(unsigned long) /data/src/10.4/sql/sql_string.h:619
 
    #4 0x560f78aa7aa8 in Item_func_uuid::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:4377
 
    #5 0x560f78ac421b in Item_func_ltrim::val_str(String*) /data/src/10.4/sql/item_strfunc.cc:1959
 
    #6 0x560f78a07e76 in Item_func_min_max::val_str_native(String*) /data/src/10.4/sql/item_func.cc:2905
 
    #7 0x560f788b9300 in Item_copy_string::copy() /data/src/10.4/sql/item.cc:4987
 
    #8 0x560f782e09f7 in copy_fields(TMP_TABLE_PARAM*) /data/src/10.4/sql/sql_select.cc:25347
 
    #9 0x560f782f887b in end_send_group(JOIN*, st_join_table*, bool) /data/src/10.4/sql/sql_select.cc:22031
 
    #10 0x560f7832fa08 in do_select /data/src/10.4/sql/sql_select.cc:20108
 
    #11 0x560f7832fa08 in JOIN::exec_inner() /data/src/10.4/sql/sql_select.cc:4545
 
    #12 0x560f78330aee in JOIN::exec() /data/src/10.4/sql/sql_select.cc:4327
 
    #13 0x560f783286c4 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.4/sql/sql_select.cc:4766
 
    #14 0x560f7832b258 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:436
 
    #15 0x560f781a8dbf in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6465
 
    #16 0x560f781cf028 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3979
 
    #17 0x560f781d75ee in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8011
 
    #18 0x560f781de55a in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1873
 
    #19 0x560f781e32b8 in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1378
 
    #20 0x560f78531ea8 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1420
 
    #21 0x560f7853236a in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1316
 
    #22 0x560f7909ef64 in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1869
 
    #23 0x7fdc24fdfea6 in start_thread nptl/pthread_create.c:477
 
 
 
Thread T5 created by T0 here:
 
    #0 0x7fdc254fa2a2 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:214
 
    #1 0x560f790a35ba in spawn_thread_v1 /data/src/10.4/storage/perfschema/pfs.cc:1919
 
    #2 0x560f77f4cf0b in inline_mysql_thread_create /data/src/10.4/include/mysql/psi/mysql_thread.h:1275
 
    #3 0x560f77f4cf0b in create_thread_to_handle_connection(CONNECT*) /data/src/10.4/sql/mysqld.cc:6280
 
    #4 0x560f77f5912f in create_new_thread(CONNECT*) /data/src/10.4/sql/mysqld.cc:6350
 
    #5 0x560f77f5976a in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/src/10.4/sql/mysqld.cc:6448
 
    #6 0x560f77f5a879 in handle_connections_sockets() /data/src/10.4/sql/mysqld.cc:6606
 
    #7 0x560f77f5c2e7 in mysqld_main(int, char**) /data/src/10.4/sql/mysqld.cc:5938
 
    #8 0x7fdc24b05d09 in __libc_start_main ../csu/libc-start.c:308
 
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /data/src/10.4/strings/strcoll.inl:98 in my_scan_weight_utf8_general_ci
 
Shadow bytes around the buggy address:
 
  0x0c087fff9550: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 00
 
  0x0c087fff9560: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 fa
 
  0x0c087fff9570: fa fa 00 00 00 00 00 00 fa fa fd fd fd fd fd fa
 
  0x0c087fff9580: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 fa
 
  0x0c087fff9590: fa fa 00 00 00 00 00 fa fa fa 00 00 00 00 00 00
 
=>0x0c087fff95a0: fa fa fd[fd]fd fd fd fd fa fa fa fa fa fa fa fa
 
  0x0c087fff95b0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95c0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95d0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95e0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c087fff95f0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
Shadow byte legend (one shadow byte represents 8 application bytes):
 
  Addressable:           00
 
  Partially addressable: 01 02 03 04 05 06 07 
  Heap left redzone:       fa
 
  Freed heap region:       fd
 
  Stack left redzone:      f1
 
  Stack mid redzone:       f2
 
  Stack right redzone:     f3
 
  Stack after return:      f5
 
  Stack use after scope:   f8
 
  Global redzone:          f9
 
  Global init order:       f6
 
  Poisoned by user:        f7
 
  Container overflow:      fc
 
  Array cookie:            ac
 
  Intra object redzone:    bb
 
  ASan internal:           fe
 
  Left alloca redzone:     ca
 
  Right alloca redzone:    cb
 
  Shadow gap:              cc
 
==2932956==ABORTING

Generated at Thu Feb 08 08:50:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.