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

main.ctype_utf8mb4_innodb and main.ps_3innodb tests failed with --big-tables=1

    XMLWordPrintable

    Details

      Description

      ./mtr main.ctype_utf8mb4_innodb --mysqld=--big-tables=1
      

      5.5 c9b9d9f5152b2ec16e88

      mysqltest: In included file "/5.5/mysql-test/include/ctype_utf8mb4.inc": 
      included from /5.5/mysql-test/t/ctype_utf8mb4_innodb.test at line 6:
      At line 1169: query 'INSERT INTO t1 SELECT * FROM t1' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      < snip >
      9 aaaa  50
      SELECT id, a FROM t1 WHERE a='bbbbbb';
      id  a
      11  bbbbbb
      6 bbbbbb
      SELECT id, a FROM t1 WHERE a='bbbbbb' ORDER BY b;
      id  a
      6 bbbbbb
      11  bbbbbb
      DROP TABLE t1;
      SET NAMES utf8mb4;
      CREATE TABLE t1 (
      a CHAR(13) DEFAULT '',
      INDEX(a)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
      INSERT INTO t1 VALUES 
      ('Käli Käli 2-4'), ('Käli Käli 2-4'),
      ('Käli Käli 2+4'), ('Käli Käli 2+4'),
      ('Käli Käli 2-6'), ('Käli Käli 2-6');
      INSERT INTO t1 SELECT * FROM t1;
       
       
      Version: '5.5.64-MariaDB-debug'  socket: '/5.5/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      =================================================================
      ==16421==ERROR: AddressSanitizer: use-after-poison on address 0x7fc96dcf2000 at pc 0x7fc97d05d935 bp 0x7fc96e227f30 sp 0x7fc96e2276d8
      READ of size 53 at 0x7fc96dcf2000 thread T15
          #0 0x7fc97d05d934 in __asan_memcpy (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x8c934)
          #1 0xe1d4e8 in memcpy /usr/include/x86_64-linux-gnu/bits/string3.h:53
          #2 0xe1d4e8 in _ma_mmap_pread /5.5/storage/maria/ma_dynrec.c:143
          #3 0xee79ab in _ma_read_static_record /5.5/storage/maria/ma_statrec.c:183
          #4 0xee8172 in _ma_read_rnd_static_record /5.5/storage/maria/ma_statrec.c:271
          #5 0xee5927 in maria_scan /5.5/storage/maria/ma_scan.c:54
          #6 0xe360eb in ha_maria::rnd_next(unsigned char*) /5.5/storage/maria/ha_maria.cc:2435
          #7 0xd164ac in handler::ha_rnd_next(unsigned char*) /5.5/sql/sql_class.h:4359
          #8 0xd164ac in rr_sequential(READ_RECORD*) /5.5/sql/records.cc:468
          #9 0x7086c1 in join_init_read_record(st_join_table*) /5.5/sql/sql_select.cc:18012
          #10 0x707527 in sub_select(JOIN*, st_join_table*, bool) /5.5/sql/sql_select.cc:17112
          #11 0x73ec48 in do_select /5.5/sql/sql_select.cc:16777
          #12 0x779f38 in JOIN::exec() /5.5/sql/sql_select.cc:2912
          #13 0x7681f9 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*) /5.5/sql/sql_select.cc:3133
          #14 0x7688fd in handle_select(THD*, LEX*, select_result*, unsigned long) /5.5/sql/sql_select.cc:323
          #15 0x687cf9 in mysql_execute_command(THD*) /5.5/sql/sql_parse.cc:3052
          #16 0x69263f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /5.5/sql/sql_parse.cc:5924
          #17 0x695a3c in dispatch_command(enum_server_command, THD*, char*, unsigned int) /5.5/sql/sql_parse.cc:1067
          #18 0x699b1a in do_command(THD*) /5.5/sql/sql_parse.cc:793
          #19 0x8cbd07 in do_handle_one_connection(THD*) /5.5/sql/sql_connect.cc:1268
          #20 0x8cbf80 in handle_one_connection /5.5/sql/sql_connect.cc:1184
          #21 0x1439773 in pfs_spawn_thread /5.5/storage/perfschema/pfs.cc:1015
          #22 0x7fc97c7676b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
          #23 0x7fc97bc0e41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)
       
      AddressSanitizer can not describe address in more detail (wild memory access suspected).
      SUMMARY: AddressSanitizer: use-after-poison ??:0 __asan_memcpy
      Shadow bytes around the buggy address:
        0x0ff9adb963b0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb963c0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb963d0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb963e0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb963f0: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
      =>0x0ff9adb96400:[f7]f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb96410: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb96420: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb96430: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb96440: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0ff9adb96450: 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
        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
        Container overflow:      fc
        Array cookie:            ac
        Intra object redzone:    bb
        ASan internal:           fe
      Thread T15 created by T0 here:
          #0 0x7fc97d007253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)
          #1 0x143cd3d in spawn_thread_v1 /5.5/storage/perfschema/pfs.cc:1038
       
      ==16421==ABORTING
      ----------SERVER LOG END-------------
      

      main.ps_3innodb 'xtradb'                 [ fail ]
              Test ended at 2019-02-13 10:58:24
       
      CURRENT_TEST: main.ps_3innodb
      mysqltest: In included file "/5.5/mysql-test/include/ps_query.inc": 
      included from /5.5/mysql-test/t/ps_3innodb.test at line 24:
      At line 619: query 'execute stmt1 ' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      < snip >
      prepare stmt1 from @stmt ;
      execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
      @arg07, @arg08, @arg09 ;
      execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
      @arg07, @arg08, @arg09 ;
      drop table t2 ;
      select 1 < (select a from t1) ;
      ERROR 21000: Subquery returns more than 1 row
      prepare stmt1 from ' select 1 < (select a from t1) ' ;
      execute stmt1 ;
      ERROR 21000: Subquery returns more than 1 row
      select 1 as my_col ;
      my_col
      1
      test_sequence
      ------ union tests ------
      prepare stmt1 from ' select a FROM t1 where a=1
                           union distinct
                           select a FROM t1 where a=1 ';
      execute stmt1 ;
       
      More results from queries before failure can be found in /5.5/mysql-test/var/log/ps_3innodb.log
       
       
      Server [mysqld.1 - pid: 773, winpid: 773, exit: 256] failed during test run
      Server log from this test:
      ----------SERVER LOG START-----------
      InnoDB: DEBUG: update_statistics for test/t1.
      InnoDB: DEBUG: update_statistics for test/t9.
      InnoDB: DEBUG: update_statistics for test/t1.
      InnoDB: DEBUG: update_statistics for test/t9.
      InnoDB: DEBUG: update_statistics for test/t1.
      =================================================================
      ==774==ERROR: AddressSanitizer: use-after-poison on address 0x7f26e65a8000 at pc 0x7f26f69ec935 bp 0x7f26e731d470 sp 0x7f26e731cc18
      READ of size 5 at 0x7f26e65a8000 thread T64
          #0 0x7f26f69ec934 in __asan_memcpy (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x8c934)
          #1 0xe1d4e8 in memcpy /usr/include/x86_64-linux-gnu/bits/string3.h:53
          #2 0xe1d4e8 in _ma_mmap_pread /5.5/storage/maria/ma_dynrec.c:143
          #3 0xee79ab in _ma_read_static_record /5.5/storage/maria/ma_statrec.c:183
          #4 0xee8172 in _ma_read_rnd_static_record /5.5/storage/maria/ma_statrec.c:271
          #5 0xee5927 in maria_scan /5.5/storage/maria/ma_scan.c:54
          #6 0xe360eb in ha_maria::rnd_next(unsigned char*) /5.5/storage/maria/ha_maria.cc:2435
          #7 0xd164ac in handler::ha_rnd_next(unsigned char*) /5.5/sql/sql_class.h:4359
          #8 0xd164ac in rr_sequential(READ_RECORD*) /5.5/sql/records.cc:468
          #9 0x7086c1 in join_init_read_record(st_join_table*) /5.5/sql/sql_select.cc:18012
          #10 0x707527 in sub_select(JOIN*, st_join_table*, bool) /5.5/sql/sql_select.cc:17112
          #11 0x73ec48 in do_select /5.5/sql/sql_select.cc:16777
          #12 0x779f38 in JOIN::exec() /5.5/sql/sql_select.cc:2912
          #13 0x7681f9 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*) /5.5/sql/sql_select.cc:3133
          #14 0x812ee5 in st_select_lex_unit::exec() /5.5/sql/sql_union.cc:813
          #15 0x81ac8f in mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long) /5.5/sql/sql_union.cc:39
          #16 0x7686eb in handle_select(THD*, LEX*, select_result*, unsigned long) /5.5/sql/sql_select.cc:301
          #17 0x66ac24 in execute_sqlcom_select /5.5/sql/sql_parse.cc:4679
          #18 0x680966 in mysql_execute_command(THD*) /5.5/sql/sql_parse.cc:2225
          #19 0x6c06d6 in Prepared_statement::execute(String*, bool) /5.5/sql/sql_prepare.cc:3933
          #20 0x6c0fbe in Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*) /5.5/sql/sql_prepare.cc:3591
          #21 0x6c1cd4 in mysql_sql_stmt_execute(THD*) /5.5/sql/sql_prepare.cc:2740
          #22 0x68098a in mysql_execute_command(THD*) /5.5/sql/sql_parse.cc:2235
          #23 0x69263f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /5.5/sql/sql_parse.cc:5924
          #24 0x695a3c in dispatch_command(enum_server_command, THD*, char*, unsigned int) /5.5/sql/sql_parse.cc:1067
          #25 0x699b1a in do_command(THD*) /5.5/sql/sql_parse.cc:793
          #26 0x8cbd07 in do_handle_one_connection(THD*) /5.5/sql/sql_connect.cc:1268
          #27 0x8cbf80 in handle_one_connection /5.5/sql/sql_connect.cc:1184
          #28 0x1439773 in pfs_spawn_thread /5.5/storage/perfschema/pfs.cc:1015
          #29 0x7f26f60f66b9 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x76b9)
          #30 0x7f26f559d41c in clone (/lib/x86_64-linux-gnu/libc.so.6+0x10741c)
       
      AddressSanitizer can not describe address in more detail (wild memory access suspected).
      SUMMARY: AddressSanitizer: use-after-poison ??:0 __asan_memcpy
      Shadow bytes around the buggy address:
        0x0fe55ccacfb0: fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe
        0x0fe55ccacfc0: fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe
        0x0fe55ccacfd0: fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe
        0x0fe55ccacfe0: fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe
        0x0fe55ccacff0: fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe fe
      =>0x0fe55ccad000:[f7]f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0fe55ccad010: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0fe55ccad020: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0fe55ccad030: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0fe55ccad040: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0fe55ccad050: 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
        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
        Container overflow:      fc
        Array cookie:            ac
        Intra object redzone:    bb
        ASan internal:           fe
      Thread T64 created by T0 here:
          #0 0x7f26f6996253 in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.2+0x36253)
          #1 0x143cd3d in spawn_thread_v1 /5.5/storage/perfschema/pfs.cc:1038
       
      ==774==ABORTING
      ----------SERVER LOG END-------------
      

        Attachments

          Activity

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.