[MDEV-28098] incorrect key in "dup value" error after long unique Created: 2022-03-16  Updated: 2022-05-30  Resolved: 2022-04-28

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert, Data Manipulation - Update
Affects Version/s: 10.9.0, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.4.25, 10.5.16, 10.6.8, 10.7.4

Type: Bug Priority: Blocker
Reporter: Jingzhou Fu Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux jie-2 5.4.143-1-pve #1 SMP PVE 5.4.143-1 (Tue, 28 Sep 2021 09:10:37 +0200) x86_64 x86_64 x86_64 GNU/Linux

Issue Links:
Relates
relates to MDEV-371 Unique indexes for blobs Closed
relates to MDEV-25813 ASAN errors in err_conv / field_unpac... Confirmed

 Description   

PoC:

CREATE TABLE v0 ( v3 FLOAT PRIMARY KEY NULL , v2 TEXT UNIQUE NOT NULL , v1 INT UNIQUE ) ;
 
 CREATE TABLE v4 ( v6 INT UNIQUE UNIQUE PRIMARY KEY UNIQUE , v5 TEXT , VALUE INT NOT NULL ) ;
 
 INSERT INTO v0 VALUES ( -32768 , -128 , 58 ) , ( -1 , 44 , -128 ) ;
 
 INSERT INTO v4 VALUES ( 50 , 61 , -1 ) , ( -2147483648 , -128 , 0 ) ;
 
 UPDATE v0 AS v0 SET v2 = ( NOT ( ( v1 = 8 OR 'x' = -1 ) IS NULL ) ) , v3 = -128 ;
 
 UPDATE v0 AS ONE NATURAL JOIN v4 SET v1 = v2 , v5 = 0 ;
 
 UPDATE v4 NATURAL JOIN v0 VALUE SET v5 = v3 , v1 = 83 ;
 
 UPDATE v0 SET v2 = 'x' * 'x' , v1 = -1 WHERE v3 IN ( 16 , 36 , NULL , 0 ) ;

report (compiled with ASAN):

=================================================================
 
==9471==ERROR: AddressSanitizer: heap-use-after-free on address 0x6290000c3288 at pc 0x000002b12085 bp 0x7fe334a243c0 sp 0x7fe334a243b8
 
READ of size 1 at 0x6290000c3288 thread T16
 
    #0 0x2b12084 in my_mb_wc_latin1 /root/mariadb/strings/ctype-latin1.c:376:18
 
    #1 0x2bd45cb in my_convert_using_func /root/mariadb/strings/ctype.c:1161:18
 
    #2 0xb5b9b7 in err_conv(char*, unsigned int, char const*, unsigned int, charset_info_st const*) /root/mariadb/sql/sql_error.cc:931:10
 
    #3 0x1a06285 in ErrBuff::set_str(char const*, unsigned long, charset_info_st const*) const /root/mariadb/sql/sql_error.h:852:10
 
    #4 0x1a06285 in ErrConvString::lex_cstring() const /root/mariadb/sql/sql_error.h:890:12
 
    #5 0x1a06285 in field_unpack(String*, Field*, unsigned char const*, unsigned int, bool) /root/mariadb/sql/key.cc:396:20
 
    #6 0x1a06d36 in key_unpack(String*, TABLE*, st_key*) /root/mariadb/sql/key.cc:441:5
 
    #7 0x15cfdc3 in print_keydup_error(TABLE*, st_key*, char const*, unsigned long) /root/mariadb/sql/handler.cc:4246:5
 
    #8 0x15d2509 in print_keydup_error(TABLE*, st_key*, unsigned long) /root/mariadb/sql/handler.cc:4269:3
 
    #9 0x15d2509 in handler::print_error(int, unsigned long) /root/mariadb/sql/handler.cc:4345:9
 
    #10 0x100e249 in multi_update::send_data(List<Item>&) /root/mariadb/sql/sql_update.cc:2688:18
 
    #11 0xdb5094 in select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long) /root/mariadb/sql/sql_class.h:5612:12
 
    #12 0xdb5094 in end_send(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:22331:9
 
    #13 0xe315ff in evaluate_join_record(JOIN*, st_join_table*, int) /root/mariadb/sql/sql_select.cc:21325:11
 
    #14 0xd4c13a in sub_select(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:21095:9
 
    #15 0xe315ff in evaluate_join_record(JOIN*, st_join_table*, int) /root/mariadb/sql/sql_select.cc:21325:11
 
    #16 0xd4c13a in sub_select(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:21095:9
 
    #17 0xdc6797 in do_select(JOIN*, Procedure*) /root/mariadb/sql/sql_select.cc:20640:14
 
    #18 0xdc6797 in JOIN::exec_inner() /root/mariadb/sql/sql_select.cc:4749:50
 
    #19 0xdc344c in JOIN::exec() /root/mariadb/sql/sql_select.cc:4527:3
 
    #20 0xd4e4e8 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*) /root/mariadb/sql/sql_select.cc:5007:9
 
    #21 0x1006042 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**) /root/mariadb/sql/sql_update.cc:1968:8
 
    #22 0xc682e9 in mysql_execute_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:4486:12
 
    #23 0xc4a67e in mysql_parse(THD*, char*, unsigned int, Parser_state*) /root/mariadb/sql/sql_parse.cc:8027:18
 
    #24 0xc41ba9 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /root/mariadb/sql/sql_parse.cc:1894:7
 
    #25 0xc4b74b in do_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:1402:17
 
    #26 0x111f9f2 in do_handle_one_connection(CONNECT*, bool) /root/mariadb/sql/sql_connect.cc:1418:11
 
    #27 0x111f248 in handle_one_connection /root/mariadb/sql/sql_connect.cc:1312:5
 
    #28 0x1f3f9dd in pfs_spawn_thread /root/mariadb/storage/perfschema/pfs.cc:2201:3
 
    #29 0x7fe35a9ff608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477:8
 
    #30 0x7fe35a715162 in clone /build/glibc-sMfBJT/glibc-2.31/misc/../sysdeps/unix/sysv/linux/x86_64/clone.S:95
 
 
 
0x6290000c3288 is located 136 bytes inside of 16512-byte region [0x6290000c3200,0x6290000c7280)
 
freed by thread T16 here:
 
    #0 0x80f732 in free (/usr/local/mysql/bin/mariadbd+0x80f732)
 
    #1 0x243e1b8 in mem_heap_free(mem_block_info_t*) /root/mariadb/storage/innobase/include/mem0mem.inl:419:3
 
    #2 0x243e1b8 in row_mysql_prebuilt_free_blob_heap(row_prebuilt_t*) /root/mariadb/storage/innobase/row/row0mysql.cc:101:2
 
    #3 0x24b554c in row_sel_store_mysql_rec(unsigned char*, row_prebuilt_t*, unsigned char const*, dtuple_t const*, bool, dict_index_t const*, unsigned short const*) /root/mariadb/storage/innobase/row/row0sel.cc:3109:3
 
    #4 0x24afa37 in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) /root/mariadb/storage/innobase/row/row0sel.cc:5656:9
 
    #5 0x21739c3 in ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) /root/mariadb/storage/innobase/handler/ha_innodb.cc:8970:5
 
    #6 0x15c539a in handler::ha_rnd_pos(unsigned char*, unsigned char*) /root/mariadb/sql/handler.cc:3425:3
 
    #7 0x1002a33 in prepare_record_for_error_message(int, TABLE*) /root/mariadb/sql/sql_update.cc:304:23
 
    #8 0x100e1fd in multi_update::send_data(List<Item>&) /root/mariadb/sql/sql_update.cc:2687:5
 
    #9 0xdb5094 in select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long) /root/mariadb/sql/sql_class.h:5612:12
 
    #10 0xdb5094 in end_send(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:22331:9
 
    #11 0xe315ff in evaluate_join_record(JOIN*, st_join_table*, int) /root/mariadb/sql/sql_select.cc:21325:11
 
    #12 0xd4c13a in sub_select(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:21095:9
 
    #13 0xe315ff in evaluate_join_record(JOIN*, st_join_table*, int) /root/mariadb/sql/sql_select.cc:21325:11
 
    #14 0xd4c13a in sub_select(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:21095:9
 
    #15 0xdc6797 in do_select(JOIN*, Procedure*) /root/mariadb/sql/sql_select.cc:20640:14
 
    #16 0xdc6797 in JOIN::exec_inner() /root/mariadb/sql/sql_select.cc:4749:50
 
    #17 0xdc344c in JOIN::exec() /root/mariadb/sql/sql_select.cc:4527:3
 
    #18 0xd4e4e8 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*) /root/mariadb/sql/sql_select.cc:5007:9
 
    #19 0x1006042 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**) /root/mariadb/sql/sql_update.cc:1968:8
 
    #20 0xc682e9 in mysql_execute_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:4486:12
 
    #21 0xc4a67e in mysql_parse(THD*, char*, unsigned int, Parser_state*) /root/mariadb/sql/sql_parse.cc:8027:18
 
    #22 0xc41ba9 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /root/mariadb/sql/sql_parse.cc:1894:7
 
    #23 0xc4b74b in do_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:1402:17
 
    #24 0x111f9f2 in do_handle_one_connection(CONNECT*, bool) /root/mariadb/sql/sql_connect.cc:1418:11
 
    #25 0x111f248 in handle_one_connection /root/mariadb/sql/sql_connect.cc:1312:5
 
    #26 0x1f3f9dd in pfs_spawn_thread /root/mariadb/storage/perfschema/pfs.cc:2201:3
 
    #27 0x7fe35a9ff608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477:8
 
 
 
previously allocated by thread T16 here:
 
    #0 0x80f99d in malloc (/usr/local/mysql/bin/mariadbd+0x80f99d)
 
    #1 0x215c51e in ut_allocator<unsigned char, true>::allocate(unsigned long, unsigned char const*, unsigned int, bool, bool) /root/mariadb/storage/innobase/include/ut0new.h:375:11
 
    #2 0x2301754 in mem_heap_create_block_func(mem_block_info_t*, unsigned long, unsigned long) /root/mariadb/storage/innobase/mem/mem0mem.cc:277:37
 
    #3 0x24be2fc in mem_heap_create_func(unsigned long, unsigned long) /root/mariadb/storage/innobase/include/mem0mem.inl:377:10
 
    #4 0x24be2fc in row_sel_store_mysql_field(unsigned char*, row_prebuilt_t*, unsigned char const*, dict_index_t const*, unsigned short const*, unsigned long, mysql_row_templ_t const*) /root/mariadb/storage/innobase/row/row0sel.cc:3050:27
 
    #5 0x24b4ea9 in row_sel_store_mysql_rec(unsigned char*, row_prebuilt_t*, unsigned char const*, dtuple_t const*, bool, dict_index_t const*, unsigned short const*) /root/mariadb/storage/innobase/row/row0sel.cc:3196:8
 
    #6 0x24afa37 in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) /root/mariadb/storage/innobase/row/row0sel.cc:5656:9
 
    #7 0x21739c3 in ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) /root/mariadb/storage/innobase/handler/ha_innodb.cc:8970:5
 
    #8 0x2174d99 in ha_innobase::index_first(unsigned char*) /root/mariadb/storage/innobase/handler/ha_innodb.cc:9339:14
 
    #9 0x2174d99 in ha_innobase::rnd_next(unsigned char*) /root/mariadb/storage/innobase/handler/ha_innodb.cc:9432:11
 
    #10 0x15c44c3 in handler::ha_rnd_next(unsigned char*) /root/mariadb/sql/handler.cc:3393:5
 
    #11 0x930064 in rr_sequential(READ_RECORD*) /root/mariadb/sql/records.cc:519:35
 
    #12 0xd4c04d in sub_select(JOIN*, st_join_table*, bool) /root/mariadb/sql/sql_select.cc:21092:12
 
    #13 0xdc6797 in do_select(JOIN*, Procedure*) /root/mariadb/sql/sql_select.cc:20640:14
 
    #14 0xdc6797 in JOIN::exec_inner() /root/mariadb/sql/sql_select.cc:4749:50
 
    #15 0xdc344c in JOIN::exec() /root/mariadb/sql/sql_select.cc:4527:3
 
    #16 0xd4e4e8 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*) /root/mariadb/sql/sql_select.cc:5007:9
 
    #17 0x1006042 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**) /root/mariadb/sql/sql_update.cc:1968:8
 
    #18 0xc682e9 in mysql_execute_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:4486:12
 
    #19 0xc4a67e in mysql_parse(THD*, char*, unsigned int, Parser_state*) /root/mariadb/sql/sql_parse.cc:8027:18
 
    #20 0xc41ba9 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /root/mariadb/sql/sql_parse.cc:1894:7
 
    #21 0xc4b74b in do_command(THD*, bool) /root/mariadb/sql/sql_parse.cc:1402:17
 
    #22 0x111f9f2 in do_handle_one_connection(CONNECT*, bool) /root/mariadb/sql/sql_connect.cc:1418:11
 
    #23 0x111f248 in handle_one_connection /root/mariadb/sql/sql_connect.cc:1312:5
 
    #24 0x1f3f9dd in pfs_spawn_thread /root/mariadb/storage/perfschema/pfs.cc:2201:3
 
    #25 0x7fe35a9ff608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477:8
 
 
 
Thread T16 created by T0 here:
 
    #0 0x7f9cfc in pthread_create (/usr/local/mysql/bin/mariadbd+0x7f9cfc)
 
    #1 0x1f3fd39 in my_thread_create(unsigned long*, pthread_attr_t const*, void* (*)(void*), void*) /root/mariadb/storage/perfschema/my_thread.h:52:10
 
    #2 0x1f3fd39 in pfs_spawn_thread_v1 /root/mariadb/storage/perfschema/pfs.cc:2252:15
 
    #3 0x85cef4 in inline_mysql_thread_create(unsigned int, unsigned long*, pthread_attr_t const*, void* (*)(void*), void*) /root/mariadb/include/mysql/psi/mysql_thread.h:1139:11
 
    #4 0x85cef4 in create_thread_to_handle_connection(CONNECT*) /root/mariadb/sql/mysqld.cc:5975:19
 
    #5 0x85e72a in create_new_thread(CONNECT*) /root/mariadb/sql/mysqld.cc:6034:3
 
    #6 0x85e72a in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /root/mariadb/sql/mysqld.cc:6096:5
 
    #7 0x85a34c in handle_connections_sockets() /root/mariadb/sql/mysqld.cc:6220:9
 
    #8 0x84e9ef in mysqld_main(int, char**) /root/mariadb/sql/mysqld.cc:5870:3
 
    #9 0x7fe35a61a0b2 in __libc_start_main /build/glibc-sMfBJT/glibc-2.31/csu/../csu/libc-start.c:308:16
 
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /root/mariadb/strings/ctype-latin1.c:376:18 in my_mb_wc_latin1
 
Shadow bytes around the buggy address:
 
  0x0c5280010600: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280010610: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280010620: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280010630: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280010640: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
=>0x0c5280010650: fd[fd]fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280010660: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280010670: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280010680: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280010690: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c52800106a0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
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
 
==9471==ABORTING



 Comments   
Comment by Alice Sherepa [ 2022-03-17 ]

Thank you for the report!
It is reproducible on 10.4-10.9, with InnoDB.
no visible effect on non-debug build.

--source include/have_innodb.inc
 
CREATE TABLE t1 (v3 int PRIMARY KEY, v2 text(100) UNIQUE NOT NULL, v1 INT UNIQUE) engine=innodb;
 
INSERT INTO t1 VALUES ( -32768 , -128 , 58 ) , ( -1 , 44 , -128 );
 
 
 
CREATE TABLE t2 (v6 INT PRIMARY KEY, v5 TEXT, a INT NOT NULL) engine=innodb;
 
INSERT INTO t2 VALUES ( 50 , 61 , -1 ) , ( -2147483648 , -128 , 0 );
 
 
 
--error 1062
 
UPDATE t1 SET v2 = ( NOT ( ( v1 = 8 OR 'x' = -1 ) IS NULL ) ) , v3 = -128;
 
--error 1062
 
UPDATE t1 NATURAL JOIN t2 SET v1 = v2 , v5 = 0;
 
--error 1062
 
UPDATE t2 NATURAL JOIN t1 a SET v5 = v3 , v1 = 83;
 
 
 
UPDATE t1 SET v2 = 'x' * 'x' , v1 = -1 WHERE v3 IN (16,36,NULL,0);

10.4 069139a549a62f26d566c1ae

 
Version: '10.4.25-MariaDB-debug-log'  
=================================================================
 
==501721==ERROR: AddressSanitizer: heap-use-after-free on address 0x6290002da288 at pc 0x558133133d42 bp 0x7fc5f3f24760 sp 0x7fc5f3f24750
 
READ of size 4 at 0x6290002da288 thread T27
 
    #0 0x558133133d41 in my_convert /10.4/src/strings/ctype.c:1109
 
    #1 0x55813111549e in copy_and_convert(char*, unsigned long, charset_info_st const*, char const*, unsigned long, charset_info_st const*, unsigned int*) /10.4/src/sql/sql_string.h:44
 
    #2 0x55813130bc36 in err_conv(char*, unsigned int, char const*, unsigned int, charset_info_st const*) /10.4/src/sql/sql_error.cc:897
 
    #3 0x55813113a720 in ErrBuff::set_str(char const*, unsigned long, charset_info_st const*) const /10.4/src/sql/sql_error.h:846
 
    #4 0x55813113aabc in ErrConvString::ptr() const /10.4/src/sql/sql_error.h:878
 
    #5 0x558131e51961 in field_unpack(String*, Field*, unsigned char const*, unsigned int, bool) /10.4/src/sql/key.cc:397
 
    #6 0x558131e52055 in key_unpack(String*, TABLE*, st_key*) /10.4/src/sql/key.cc:442
 
    #7 0x558131b95a75 in print_keydup_error(TABLE*, st_key*, char const*, unsigned long) /10.4/src/sql/handler.cc:3726
 
    #8 0x558131b95d30 in print_keydup_error(TABLE*, st_key*, unsigned long) /10.4/src/sql/handler.cc:3749
 
    #9 0x558131b96301 in handler::print_error(int, unsigned long) /10.4/src/sql/handler.cc:3825
 
    #10 0x5581316b664a in multi_update::send_data(List<Item>&) /10.4/src/sql/sql_update.cc:2682
 
    #11 0x558131525a7a in end_send /10.4/src/sql/sql_select.cc:21823
 
    #12 0x55813151de36 in evaluate_join_record /10.4/src/sql/sql_select.cc:20855
 
    #13 0x55813151c76b in sub_select(JOIN*, st_join_table*, bool) /10.4/src/sql/sql_select.cc:20628
 
    #14 0x55813151de36 in evaluate_join_record /10.4/src/sql/sql_select.cc:20855
 
    #15 0x55813151c76b in sub_select(JOIN*, st_join_table*, bool) /10.4/src/sql/sql_select.cc:20628
 
    #16 0x55813151a71b in do_select /10.4/src/sql/sql_select.cc:20164
 
    #17 0x5581314a93ad in JOIN::exec_inner() /10.4/src/sql/sql_select.cc:4542
 
    #18 0x5581314a69d9 in JOIN::exec() /10.4/src/sql/sql_select.cc:4324
 
    #19 0x5581314aabb9 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*) /10.4/src/sql/sql_select.cc:4763
 
    #20 0x5581316aecfc 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**) /10.4/src/sql/sql_update.cc:1962
 
    #21 0x5581313db034 in mysql_execute_command(THD*) /10.4/src/sql/sql_parse.cc:4515
 
    #22 0x5581313f374c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/src/sql/sql_parse.cc:7995
 
    #23 0x5581313c9ed3 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/src/sql/sql_parse.cc:1857
 
    #24 0x5581313c6950 in do_command(THD*) /10.4/src/sql/sql_parse.cc:1373
 
    #25 0x5581317c230c in do_handle_one_connection(CONNECT*) /10.4/src/sql/sql_connect.cc:1420
 
    #26 0x5581317c1a65 in handle_one_connection /10.4/src/sql/sql_connect.cc:1316
 
    #27 0x5581324c309c in pfs_spawn_thread /10.4/src/storage/perfschema/pfs.cc:1869
 
    #28 0x7fc60aaf8608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477
 
    #29 0x7fc60a6c9162 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f162)
 
 
 
0x6290002da288 is located 136 bytes inside of 16512-byte region [0x6290002da200,0x6290002de280)
 
freed by thread T27 here:
 
    #0 0x7fc60b08340f in __interceptor_free ../../../../src/libsanitizer/asan/asan_malloc_linux.cc:122
 
    #1 0x5581327c1eec in mem_heap_block_free(mem_block_info_t*, mem_block_info_t*) /10.4/src/storage/innobase/mem/mem0mem.cc:416
 
    #2 0x558132933e11 in mem_heap_free /10.4/src/storage/innobase/include/mem0mem.inl:417
 
    #3 0x55813293b3ea in row_mysql_prebuilt_free_blob_heap(row_prebuilt_t*) /10.4/src/storage/innobase/row/row0mysql.cc:143
 
    #4 0x5581329c8e09 in row_sel_store_mysql_rec /10.4/src/storage/innobase/row/row0sel.cc:3107
 
    #5 0x5581329d926b in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) /10.4/src/storage/innobase/row/row0sel.cc:5594
 
    #6 0x5581325d4d17 in ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) /10.4/src/storage/innobase/handler/ha_innodb.cc:9348
 
    #7 0x5581325d89b1 in ha_innobase::rnd_pos(unsigned char*, unsigned char*) /10.4/src/storage/innobase/handler/ha_innodb.cc:9858
 
    #8 0x558131b8d87f in handler::ha_rnd_pos(unsigned char*, unsigned char*) /10.4/src/sql/handler.cc:2912
 
    #9 0x5581316a0a22 in prepare_record_for_error_message /10.4/src/sql/sql_update.cc:305
 
    #10 0x5581316b65ab in multi_update::send_data(List<Item>&) /10.4/src/sql/sql_update.cc:2681
 
    #11 0x558131525a7a in end_send /10.4/src/sql/sql_select.cc:21823
 
    #12 0x55813151de36 in evaluate_join_record /10.4/src/sql/sql_select.cc:20855
 
    #13 0x55813151c76b in sub_select(JOIN*, st_join_table*, bool) /10.4/src/sql/sql_select.cc:20628
 
    #14 0x55813151de36 in evaluate_join_record /10.4/src/sql/sql_select.cc:20855
 
    #15 0x55813151c76b in sub_select(JOIN*, st_join_table*, bool) /10.4/src/sql/sql_select.cc:20628
 
    #16 0x55813151a71b in do_select /10.4/src/sql/sql_select.cc:20164
 
    #17 0x5581314a93ad in JOIN::exec_inner() /10.4/src/sql/sql_select.cc:4542
 
    #18 0x5581314a69d9 in JOIN::exec() /10.4/src/sql/sql_select.cc:4324
 
    #19 0x5581314aabb9 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*) /10.4/src/sql/sql_select.cc:4763
 
    #20 0x5581316aecfc 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**) /10.4/src/sql/sql_update.cc:1962
 
    #21 0x5581313db034 in mysql_execute_command(THD*) /10.4/src/sql/sql_parse.cc:4515
 
    #22 0x5581313f374c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/src/sql/sql_parse.cc:7995
 
    #23 0x5581313c9ed3 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/src/sql/sql_parse.cc:1857
 
    #24 0x5581313c6950 in do_command(THD*) /10.4/src/sql/sql_parse.cc:1373
 
    #25 0x5581317c230c in do_handle_one_connection(CONNECT*) /10.4/src/sql/sql_connect.cc:1420
 
    #26 0x5581317c1a65 in handle_one_connection /10.4/src/sql/sql_connect.cc:1316
 
    #27 0x5581324c309c in pfs_spawn_thread /10.4/src/storage/perfschema/pfs.cc:1869
 
    #28 0x7fc60aaf8608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477
 
 
 
previously allocated by thread T27 here:
 
    #0 0x7fc60b083808 in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cc:144
 
    #1 0x5581327c12e9 in mem_heap_create_block_func(mem_block_info_t*, unsigned long, char const*, unsigned int, unsigned long) /10.4/src/storage/innobase/mem/mem0mem.cc:277
 
    #2 0x5581329b1109 in mem_heap_create_func /10.4/src/storage/innobase/include/mem0mem.inl:375
 
    #3 0x5581329c86ca in row_sel_store_mysql_field /10.4/src/storage/innobase/row/row0sel.cc:3048
 
    #4 0x5581329c97ef in row_sel_store_mysql_rec /10.4/src/storage/innobase/row/row0sel.cc:3179
 
    #5 0x5581329d926b in row_search_mvcc(unsigned char*, page_cur_mode_t, row_prebuilt_t*, unsigned long, unsigned long) /10.4/src/storage/innobase/row/row0sel.cc:5594
 
    #6 0x5581325d4d17 in ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) /10.4/src/storage/innobase/handler/ha_innodb.cc:9348
 
    #7 0x5581325d806d in ha_innobase::index_first(unsigned char*) /10.4/src/storage/innobase/handler/ha_innodb.cc:9730
 
    #8 0x5581325d85fd in ha_innobase::rnd_next(unsigned char*) /10.4/src/storage/innobase/handler/ha_innodb.cc:9823
 
    #9 0x558131b8cde7 in handler::ha_rnd_next(unsigned char*) /10.4/src/sql/handler.cc:2880
 
    #10 0x558131fbb4fe in rr_sequential(READ_RECORD*) /10.4/src/sql/records.cc:485
 
    #11 0x558131222c13 in READ_RECORD::read_record() /10.4/src/sql/records.h:70
 
    #12 0x558131523390 in join_init_read_record(st_join_table*) /10.4/src/sql/sql_select.cc:21576
 
    #13 0x55813151c5af in sub_select(JOIN*, st_join_table*, bool) /10.4/src/sql/sql_select.cc:20625
 
    #14 0x55813151a71b in do_select /10.4/src/sql/sql_select.cc:20164
 
    #15 0x5581314a93ad in JOIN::exec_inner() /10.4/src/sql/sql_select.cc:4542
 
    #16 0x5581314a69d9 in JOIN::exec() /10.4/src/sql/sql_select.cc:4324
 
    #17 0x5581314aabb9 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*) /10.4/src/sql/sql_select.cc:4763
 
    #18 0x5581316aecfc 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**) /10.4/src/sql/sql_update.cc:1962
 
    #19 0x5581313db034 in mysql_execute_command(THD*) /10.4/src/sql/sql_parse.cc:4515
 
    #20 0x5581313f374c in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /10.4/src/sql/sql_parse.cc:7995
 
    #21 0x5581313c9ed3 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /10.4/src/sql/sql_parse.cc:1857
 
    #22 0x5581313c6950 in do_command(THD*) /10.4/src/sql/sql_parse.cc:1373
 
    #23 0x5581317c230c in do_handle_one_connection(CONNECT*) /10.4/src/sql/sql_connect.cc:1420
 
    #24 0x5581317c1a65 in handle_one_connection /10.4/src/sql/sql_connect.cc:1316
 
    #25 0x5581324c309c in pfs_spawn_thread /10.4/src/storage/perfschema/pfs.cc:1869
 
    #26 0x7fc60aaf8608 in start_thread /build/glibc-sMfBJT/glibc-2.31/nptl/pthread_create.c:477
 
 
 
Thread T27 created by T0 here:
 
    #0 0x7fc60afb0815 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cc:208
 
    #1 0x5581324c348d in spawn_thread_v1 /10.4/src/storage/perfschema/pfs.cc:1919
 
    #2 0x5581310cbb6f in inline_mysql_thread_create /10.4/src/include/mysql/psi/mysql_thread.h:1275
 
    #3 0x5581310e3a79 in create_thread_to_handle_connection(CONNECT*) /10.4/src/sql/mysqld.cc:6249
 
    #4 0x5581310e4214 in create_new_thread(CONNECT*) /10.4/src/sql/mysqld.cc:6319
 
    #5 0x5581310e46fa in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /10.4/src/sql/mysqld.cc:6417
 
    #6 0x5581310e55b6 in handle_connections_sockets() /10.4/src/sql/mysqld.cc:6575
 
    #7 0x5581310e317e in mysqld_main(int, char**) /10.4/src/sql/mysqld.cc:5907
 
    #8 0x5581310c9dbc in main /10.4/src/sql/main.cc:25
 
    #9 0x7fc60a5ce0b2 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x240b2)
 
 
 
SUMMARY: AddressSanitizer: heap-use-after-free /10.4/src/strings/ctype.c:1109 in my_convert
 
Shadow bytes around the buggy address:
 
  0x0c5280053400: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280053410: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280053420: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280053430: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
 
  0x0c5280053440: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
=>0x0c5280053450: fd[fd]fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280053460: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280053470: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280053480: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c5280053490: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
  0x0c52800534a0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
 
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
 
==501721==ABORTING
 
----------SERVER LOG END-------------

Generated at Thu Feb 08 09:58:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.