Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18962

ASAN heap-buffer-overflow in Single_line_formatting_helper::on_add_str with optimizer trace

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.4
    • Optimizer
    • None

    Description

      --source include/have_innodb.inc
      		 
       
      		 
      CREATE TABLE t1 (a date not null, b time, key(a), key(b)) ENGINE=InnoDB;
      		 
      INSERT INTO t1 VALUES ('1991-09-09','00:00:00'),('2032-08-24','02:22:24');
      		 
      SET SESSION optimizer_trace = 'enabled=on';
      		 
      SELECT * FROM t1 WHERE b IS NULL AND a = '2000-01-01';
      		 
       
      		 
      DROP TABLE t1;

      10.4 ASAN 09b2d37a

      		 
      ==10080==ERROR: AddressSanitizer: heap-buffer-overflow on address 0x611000046b3c at pc 0x7fcce534c568 bp 0x7fccd972a760 sp 0x7fccd972a738
      		 
      READ of size 141 at 0x611000046b3c thread T27
      		 
          #0 0x7fcce534c567 in strlen (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x31567)
      		 
          #1 0x55a575cbc83c in Single_line_formatting_helper::on_add_str(char const*, unsigned long) /data/src/10.4/sql/my_json_writer.cc:343
      		 
          #2 0x55a575cbbc1d in Json_writer::add_str(char const*) /data/src/10.4/sql/my_json_writer.cc:187
      		 
          #3 0x55a575d68f9e in Json_value_helper::add_str(char const*, unsigned long) /data/src/10.4/sql/my_json_writer.h:262
      		 
          #4 0x55a576398c33 in Json_writer_array::add(char const*, unsigned long) /data/src/10.4/sql/my_json_writer.h:526
      		 
          #5 0x55a5763540c9 in TRP_ROR_INTERSECT::trace_basic_info(PARAM const*, Json_writer_object*) const /data/src/10.4/sql/opt_range.cc:6406
      		 
          #6 0x55a576340d15 in SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool) /data/src/10.4/sql/opt_range.cc:3008
      		 
          #7 0x55a5758f3261 in get_quick_record_count /data/src/10.4/sql/sql_select.cc:4629
      		 
          #8 0x55a5758f95dc in make_join_statistics /data/src/10.4/sql/sql_select.cc:5355
      		 
          #9 0x55a5758db332 in JOIN::optimize_inner() /data/src/10.4/sql/sql_select.cc:2174
      		 
          #10 0x55a5758d5312 in JOIN::optimize() /data/src/10.4/sql/sql_select.cc:1551
      		 
          #11 0x55a5758f2a93 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:4571
      		 
          #12 0x55a5758c9270 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:424
      		 
          #13 0x55a575849fad in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6652
      		 
          #14 0x55a575836b74 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3889
      		 
          #15 0x55a575852850 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8205
      		 
          #16 0x55a57582a75b in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1829
      		 
          #17 0x55a5758275ac in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1358
      		 
          #18 0x55a575bbb403 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1399
      		 
          #19 0x55a575bbadfc in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1302
      		 
          #20 0x55a576782b7e in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862
      		 
          #21 0x7fcce5105493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
      		 
          #22 0x7fcce34eb93e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
      		 
       
      		 
      0x611000046b3c is located 0 bytes to the right of 252-byte region [0x611000046a40,0x611000046b3c)
      		 
      allocated by thread T27 here:
      		 
          #0 0x7fcce536f73f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
      		 
          #1 0x55a577133073 in sf_malloc /data/src/10.4/mysys/safemalloc.c:118
      		 
          #2 0x55a57710396e in my_malloc /data/src/10.4/mysys/my_malloc.c:101
      		 
          #3 0x55a575a2dbd3 in Binary_string::realloc_raw(unsigned long) /data/src/10.4/sql/sql_string.cc:101
      		 
          #4 0x55a5755b503e in Binary_string::realloc_with_extra(unsigned long) /data/src/10.4/sql/sql_string.h:628
      		 
          #5 0x55a5756312ae in Binary_string::realloc_with_extra_if_needed(unsigned long) /data/src/10.4/sql/sql_string.h:640
      		 
          #6 0x55a575631162 in Binary_string::append(char const*, unsigned long) /data/src/10.4/sql/sql_string.h:529
      		 
          #7 0x55a575a306bb in String::append(char const*, unsigned long) /data/src/10.4/sql/sql_string.cc:536
      		 
          #8 0x55a5755b57df in String::append(char const*) /data/src/10.4/sql/sql_string.h:883
      		 
          #9 0x55a5763922d1 in print_key_value /data/src/10.4/sql/opt_range.cc:15877
      		 
          #10 0x55a5763919b3 in append_range /data/src/10.4/sql/opt_range.cc:15748
      		 
          #11 0x55a576354049 in TRP_ROR_INTERSECT::trace_basic_info(PARAM const*, Json_writer_object*) const /data/src/10.4/sql/opt_range.cc:6404
      		 
          #12 0x55a576340d15 in SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool, bool, bool) /data/src/10.4/sql/opt_range.cc:3008
      		 
          #13 0x55a5758f3261 in get_quick_record_count /data/src/10.4/sql/sql_select.cc:4629
      		 
          #14 0x55a5758f95dc in make_join_statistics /data/src/10.4/sql/sql_select.cc:5355
      		 
          #15 0x55a5758db332 in JOIN::optimize_inner() /data/src/10.4/sql/sql_select.cc:2174
      		 
          #16 0x55a5758d5312 in JOIN::optimize() /data/src/10.4/sql/sql_select.cc:1551
      		 
          #17 0x55a5758f2a93 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:4571
      		 
          #18 0x55a5758c9270 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.4/sql/sql_select.cc:424
      		 
          #19 0x55a575849fad in execute_sqlcom_select /data/src/10.4/sql/sql_parse.cc:6652
      		 
          #20 0x55a575836b74 in mysql_execute_command(THD*) /data/src/10.4/sql/sql_parse.cc:3889
      		 
          #21 0x55a575852850 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.4/sql/sql_parse.cc:8205
      		 
          #22 0x55a57582a75b in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.4/sql/sql_parse.cc:1829
      		 
          #23 0x55a5758275ac in do_command(THD*) /data/src/10.4/sql/sql_parse.cc:1358
      		 
          #24 0x55a575bbb403 in do_handle_one_connection(CONNECT*) /data/src/10.4/sql/sql_connect.cc:1399
      		 
          #25 0x55a575bbadfc in handle_one_connection /data/src/10.4/sql/sql_connect.cc:1302
      		 
          #26 0x55a576782b7e in pfs_spawn_thread /data/src/10.4/storage/perfschema/pfs.cc:1862
      		 
          #27 0x7fcce5105493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
      		 
       
      		 
      Thread T27 created by T0 here:
      		 
          #0 0x7fcce533ebba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
      		 
          #1 0x55a576783146 in spawn_thread_v1 /data/src/10.4/storage/perfschema/pfs.cc:1912
      		 
          #2 0x55a575572246 in inline_mysql_thread_create /data/src/10.4/include/mysql/psi/mysql_thread.h:1268
      		 
          #3 0x55a575587b38 in create_thread_to_handle_connection(CONNECT*) /data/src/10.4/sql/mysqld.cc:6218
      		 
          #4 0x55a57558823d in create_new_thread(CONNECT*) /data/src/10.4/sql/mysqld.cc:6288
      		 
          #5 0x55a5755885cd in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/src/10.4/sql/mysqld.cc:6386
      		 
          #6 0x55a575589219 in handle_connections_sockets() /data/src/10.4/sql/mysqld.cc:6544
      		 
          #7 0x55a575587373 in mysqld_main(int, char**) /data/src/10.4/sql/mysqld.cc:5876
      		 
          #8 0x55a5755700cf in main /data/src/10.4/sql/main.cc:25
      		 
          #9 0x7fcce34232b0 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x202b0)
      		 
       
      		 
      SUMMARY: AddressSanitizer: heap-buffer-overflow ??:0 strlen
      		 
      Shadow bytes around the buggy address:
      		 
        0x0c2280000d10: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
      		 
        0x0c2280000d20: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
      		 
        0x0c2280000d30: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
      		 
        0x0c2280000d40: fa fa fa fa fa fa fa fa 00 00 00 00 00 00 00 00
      		 
        0x0c2280000d50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
      		 
      =>0x0c2280000d60: 00 00 00 00 00 00 00[04]fa fa fa fa fa fa fa fa
      		 
        0x0c2280000d70: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c2280000d80: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c2280000d90: fa fa fa fa fa fa fa fa fd fd fd fd fd fd fd fd
      		 
        0x0c2280000da0: fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd fd
      		 
        0x0c2280000db0: fd fd fd fd fd fd fd fd 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
      		 
      ==10080==ABORTING

      Attachments

        Activity

          People

            varun Varun Gupta (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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