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

ASAN errors in wsrep_create_trigger_query upon 2nd execution of PS with CREATE TRIGGER

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.7(EOL)
    • 10.6, 10.11, 11.4
    • wsrep
    • None

    Description

      Put the test case under mysql-test/suite/galera/t/, to pick up the galera config.

      --source include/have_innodb.inc
      --source include/have_wsrep_enabled.inc
       
      CREATE TABLE t (a INT);
      PREPARE stmt FROM 'CREATE OR REPLACE TRIGGER tr AFTER UPDATE ON t FOR EACH ROW BEGIN END';
      EXECUTE stmt;
      EXECUTE stmt;
       
      DROP TABLE t;
      

      10.6 831f5bc66f8d2147edd7991caf69e34058566b67

      ==762771==ERROR: AddressSanitizer: use-after-poison on address 0x62d0000d2578 at pc 0x55b6bdc1d159 bp 0x7fc27cee0d00 sp 0x7fc27cee0cf8
      READ of size 8 at 0x62d0000d2578 thread T17
          #0 0x55b6bdc1d158 in get_current_user(THD*, LEX_USER*, bool) /data/bld/10.6-asan/sql/sql_acl.cc:12955
          #1 0x55b6bf044214 in wsrep_create_trigger_query(THD*, unsigned char**, unsigned long*) /data/bld/10.6-asan/sql/wsrep_mysqld.cc:3586
          #2 0x55b6bf03db59 in wsrep_TOI_event_buf /data/bld/10.6-asan/sql/wsrep_mysqld.cc:2613
          #3 0x55b6bf03e324 in wsrep_TOI_begin /data/bld/10.6-asan/sql/wsrep_mysqld.cc:2694
          #4 0x55b6bf0402cb in wsrep_to_isolation_begin(THD*, char const*, char const*, TABLE_LIST const*, Alter_info const*, std::__debug::vector<wsrep::key, std::allocator<wsrep::key> > const*, HA_CREATE_INFO const*) /data/bld/10.6-asan/sql/wsrep_mysqld.cc:3004
          #5 0x55b6be0dd082 in mysql_create_or_drop_trigger(THD*, TABLE_LIST*, bool) /data/bld/10.6-asan/sql/sql_trigger.cc:571
          #6 0x55b6bde06b83 in mysql_execute_command(THD*, bool) /data/bld/10.6-asan/sql/sql_parse.cc:5988
          #7 0x55b6bde6ce13 in Prepared_statement::execute(String*, bool) /data/bld/10.6-asan/sql/sql_prepare.cc:5272
          #8 0x55b6bde67e0e in Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) /data/bld/10.6-asan/sql/sql_prepare.cc:4678
          #9 0x55b6bde61502 in mysql_sql_stmt_execute(THD*) /data/bld/10.6-asan/sql/sql_prepare.cc:3710
          #10 0x55b6bddf80db in mysql_execute_command(THD*, bool) /data/bld/10.6-asan/sql/sql_parse.cc:4029
          #11 0x55b6bde14d5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/10.6-asan/sql/sql_parse.cc:8208
          #12 0x55b6bde13ae1 in wsrep_mysql_parse /data/bld/10.6-asan/sql/sql_parse.cc:8019
          #13 0x55b6bdde9fd9 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/10.6-asan/sql/sql_parse.cc:1895
          #14 0x55b6bdde6e56 in do_command(THD*, bool) /data/bld/10.6-asan/sql/sql_parse.cc:1421
          #15 0x55b6be2698c0 in do_handle_one_connection(CONNECT*, bool) /data/bld/10.6-asan/sql/sql_connect.cc:1386
          #16 0x55b6be26941f in handle_one_connection /data/bld/10.6-asan/sql/sql_connect.cc:1298
          #17 0x55b6beee2965 in pfs_spawn_thread /data/bld/10.6-asan/storage/perfschema/pfs.cc:2201
          #18 0x7fc291aa81c3 in start_thread nptl/pthread_create.c:442
          #19 0x7fc291b2885b in clone3 ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
       
      0x62d0000d2578 is located 376 bytes inside of 32816-byte region [0x62d0000d2400,0x62d0000da430)
      allocated by thread T17 here:
          #0 0x7fc2924b89cf in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:69
          #1 0x55b6bfc5cf8d in my_malloc /data/bld/10.6-asan/mysys/my_malloc.c:91
          #2 0x55b6bfc30f59 in reset_root_defaults /data/bld/10.6-asan/mysys/my_alloc.c:155
          #3 0x55b6bdcb9d52 in THD::init_for_queries() /data/bld/10.6-asan/sql/sql_class.cc:1475
          #4 0x55b6be268cff in prepare_new_connection_state(THD*) /data/bld/10.6-asan/sql/sql_connect.cc:1225
          #5 0x55b6be2694a0 in thd_prepare_connection(THD*) /data/bld/10.6-asan/sql/sql_connect.cc:1319
          #6 0x55b6be269884 in do_handle_one_connection(CONNECT*, bool) /data/bld/10.6-asan/sql/sql_connect.cc:1376
          #7 0x55b6be26941f in handle_one_connection /data/bld/10.6-asan/sql/sql_connect.cc:1298
          #8 0x55b6beee2965 in pfs_spawn_thread /data/bld/10.6-asan/storage/perfschema/pfs.cc:2201
          #9 0x7fc291aa81c3 in start_thread nptl/pthread_create.c:442
       
      Thread T17 created by T0 here:
          #0 0x7fc292449726 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:207
          #1 0x55b6beede6a0 in my_thread_create /data/bld/10.6-asan/storage/perfschema/my_thread.h:52
          #2 0x55b6beee2d54 in pfs_spawn_thread_v1 /data/bld/10.6-asan/storage/perfschema/pfs.cc:2252
          #3 0x55b6bdaba6a0 in inline_mysql_thread_create /data/bld/10.6-asan/include/mysql/psi/mysql_thread.h:1139
          #4 0x55b6bdad176a in create_thread_to_handle_connection(CONNECT*) /data/bld/10.6-asan/sql/mysqld.cc:6016
          #5 0x55b6bdad1d7b in create_new_thread(CONNECT*) /data/bld/10.6-asan/sql/mysqld.cc:6075
          #6 0x55b6bdad2066 in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /data/bld/10.6-asan/sql/mysqld.cc:6137
          #7 0x55b6bdad2cfa in handle_connections_sockets() /data/bld/10.6-asan/sql/mysqld.cc:6260
          #8 0x55b6bdacfacf in run_main_loop /data/bld/10.6-asan/sql/mysqld.cc:5519
          #9 0x55b6bdad1039 in mysqld_main(int, char**) /data/bld/10.6-asan/sql/mysqld.cc:5917
          #10 0x55b6bdab9968 in main /data/bld/10.6-asan/sql/main.cc:34
          #11 0x7fc291a46249 in __libc_start_call_main ../sysdeps/nptl/libc_start_call_main.h:58
       
      SUMMARY: AddressSanitizer: use-after-poison /data/bld/10.6-asan/sql/sql_acl.cc:12955 in get_current_user(THD*, LEX_USER*, bool)
      Shadow bytes around the buggy address:
        0x0c5a80012450: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c5a80012460: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c5a80012470: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c5a80012480: 00 00 00 00 00 00 f7 00 00 00 00 00 00 00 00 00
        0x0c5a80012490: 00 00 00 03 f7 00 05 f7 05 f7 00 00 00 00 00 00
      =>0x0c5a800124a0: 00 00 00 00 00 00 00 00 00 00 00 00 00 04 f7[f7]
        0x0c5a800124b0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c5a800124c0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c5a800124d0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c5a800124e0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c5a800124f0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
      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
      ==762771==ABORTING
      

      Also reproducible on older minor releases, e.g. 10.6.12.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            sysprg Julius Goryavsky
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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