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

handler::ha_reset(): Assertion `bitmap_is_set_all(&table->s->all_set)' failed or server crash in mi_reset or buffer overrun or unexpected ER_CANT_REMOVE_ALL_FIELDS

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a INT) ENGINE=MyISAM;
      CREATE TABLE t2 (b INT) ENGINE=MyISAM;
      CREATE SCHEMA db1;
      CREATE TABLE t3 (c VARBINARY(4096)) ENGINE = MEMORY;
      INSERT INTO t3 () VALUES ();
      --error ER_NO_SUCH_TABLE
      RENAME TABLE t3 TO db2.t3, db2.t3 TO db2.t3;
       
      --connect (con1,localhost,root,,test)
      DROP DATABASE db1;
      CREATE DATABASE db2;
      CREATE TABLE db2.t3 (d INT);
      ALTER TABLE db2.t3 ENGINE = MEMORY;
      RENAME TABLE db2.t3 TO db1.t3;
      --error ER_BAD_FIELD_ERROR
      ALTER TABLE t2 CHANGE COLUMN x y TEXT NULL;
      SELECT * FROM t1;
      ALTER TABLE t2 STATS_AUTO_RECALC 0;
      --disconnect con1
       
      --connect (con2,localhost,root,,test)
      SELECT 1 FROM db2.t3;
      --error ER_KEY_COLUMN_DOES_NOT_EXITS
      ALTER TABLE t1 ADD KEY(e);
       
      # Cleanup
      --disconnect con2
      --connection default
      DROP DATABASE db2;
      DROP TABLE t1, t2, t3;
      

      10.0 debug a2c0376e08d

      Error: Freeing overrun buffer  maria/ma_search.c:1488, maria/ma_servicethread.c:65, psi/mysql_thread.h:761, 0x72cc00, 0x5e8537, 0x7ceb87, 0x6f6101, 0x622e16
      ^ Found warnings in /data/bld/10.0/mysql-test/var/log/mysqld.1.err
      

      10.0 ASAN a2c0376e08d

      ==2218==ERROR: AddressSanitizer: unknown-crash on address 0x61900010870d at pc 0x7f5a7032b7eb bp 0x7f5a58429690 sp 0x7f5a58428e50
      WRITE of size 4099 at 0x61900010870d thread T23
          #0 0x7f5a7032b7ea (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x2e7ea)
          #1 0x1847d9c in heap_scan /data/src/10.0/storage/heap/hp_scan.c:72
          #2 0x1839837 in ha_heap::rnd_next(unsigned char*) /data/src/10.0/storage/heap/ha_heap.cc:356
          #3 0xb71c74 in handler::ha_rnd_next(unsigned char*) /data/src/10.0/sql/handler.cc:2625
          #4 0xb74970 in handler::read_first_row(unsigned char*, unsigned int) /data/src/10.0/sql/handler.cc:2829
          #5 0x78c9f3 in handler::ha_read_first_row(unsigned char*, unsigned int) /data/src/10.0/sql/sql_class.h:5021
          #6 0x78c9f3 in join_read_system /data/src/10.0/sql/sql_select.cc:18516
          #7 0x7a0b10 in join_read_const_table /data/src/10.0/sql/sql_select.cc:18412
          #8 0x7cb067 in make_join_statistics /data/src/10.0/sql/sql_select.cc:3659
          #9 0x7cb067 in JOIN::optimize_inner() /data/src/10.0/sql/sql_select.cc:1365
          #10 0x7d3fa7 in JOIN::optimize() /data/src/10.0/sql/sql_select.cc:1041
          #11 0x7d5f63 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/10.0/sql/sql_select.cc:3327
          #12 0x7d670a in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.0/sql/sql_select.cc:377
          #13 0x6b6549 in execute_sqlcom_select /data/src/10.0/sql/sql_parse.cc:5298
          #14 0x6ce3ea in mysql_execute_command(THD*) /data/src/10.0/sql/sql_parse.cc:2554
          #15 0x6e4448 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/src/10.0/sql/sql_parse.cc:6634
          #16 0x6e8067 in dispatch_command(enum_server_command, THD*, char*, unsigned int) /data/src/10.0/sql/sql_parse.cc:1297
          #17 0x6ec960 in do_command(THD*) /data/src/10.0/sql/sql_parse.cc:1000
          #18 0x97b905 in do_handle_one_connection(THD*) /data/src/10.0/sql/sql_connect.cc:1377
          #19 0x97bb6c in handle_one_connection /data/src/10.0/sql/sql_connect.cc:1292
          #20 0x11b7b76 in pfs_spawn_thread /data/src/10.0/storage/perfschema/pfs.cc:1861
          #21 0x7f5a700e7493 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x7493)
          #22 0x7f5a6e4a093e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe893e)
       
      0x619000108acc is located 0 bytes to the right of 1100-byte region [0x619000108680,0x619000108acc)
      allocated by thread T23 here:
          #0 0x7f5a7035173f in malloc (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x5473f)
          #1 0x18f6642 in sf_malloc /data/src/10.0/mysys/safemalloc.c:115
          #2 0x19d98ca (/data/bld/10.0-asan/bin/mysqld+0x19d98ca)
       
      Thread T23 created by T0 here:
          #0 0x7f5a70320bba in pthread_create (/usr/lib/x86_64-linux-gnu/libasan.so.1+0x23bba)
          #1 0x11c33cd in spawn_thread_v1 /data/src/10.0/storage/perfschema/pfs.cc:1911
       
      SUMMARY: AddressSanitizer: unknown-crash ??:0 ??
      Shadow bytes around the buggy address:
        0x0c3280019090: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c32800190a0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c32800190b0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c32800190c0: fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa fa
        0x0c32800190d0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
      =>0x0c32800190e0: 00[05]05 00 00 00 00 00 00 00 00 00 00 00 00 00
        0x0c32800190f0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
        0x0c3280019100: 00 00 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c3280019110: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c3280019120: f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7 f7
        0x0c3280019130: 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
        Contiguous container OOB:fc
        ASan internal:           fe
      ==2218==ABORTING
      

      10.0 non-debug a2c0376e08d

      mysqltest: At line 26: query 'ALTER TABLE t1 ADD KEY(e)' failed with wrong errno 1090: 'You can't delete all columns with ALTER TABLE; use DROP TABLE instead', instead of 1072...
      

      10.1 debug 1d10c9afe

      mysqld: /data/src/10.1/sql/handler.cc:5908: int handler::ha_reset(): Assertion `bitmap_is_set_all(&table->s->all_set)' failed.
      180708 16:46:01 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f5be4209ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055a7073597c8 in handler::ha_reset (this=0x7f5bce478888) at /data/src/10.1/sql/handler.cc:5908
      #9  0x000055a7070a2a75 in close_thread_table (thd=0x7f5bdabde070, table_ptr=0x7f5bdabde130) at /data/src/10.1/sql/sql_base.cc:1079
      #10 0x000055a7070a2285 in close_open_tables (thd=0x7f5bdabde070) at /data/src/10.1/sql/sql_base.cc:812
      #11 0x000055a7070a2833 in close_thread_tables (thd=0x7f5bdabde070) at /data/src/10.1/sql/sql_base.cc:1036
      #12 0x000055a707117716 in mysql_execute_command (thd=0x7f5bdabde070) at /data/src/10.1/sql/sql_parse.cc:5774
      #13 0x000055a70711bbcb in mysql_parse (thd=0x7f5bdabde070, rawbuf=0x7f5bce468088 "ALTER TABLE t1 ADD KEY(e)", length=25, parser_state=0x7f5be62335e0) at /data/src/10.1/sql/sql_parse.cc:7449
      #14 0x000055a70710a605 in dispatch_command (command=COM_QUERY, thd=0x7f5bdabde070, packet=0x7f5bdabd9071 "ALTER TABLE t1 ADD KEY(e)", packet_length=25) at /data/src/10.1/sql/sql_parse.cc:1492
      #15 0x000055a70710938a in do_command (thd=0x7f5bdabde070) at /data/src/10.1/sql/sql_parse.cc:1121
      #16 0x000055a70724322d in do_handle_one_connection (thd_arg=0x7f5bdabde070) at /data/src/10.1/sql/sql_connect.cc:1330
      #17 0x000055a707242f91 in handle_one_connection (arg=0x7f5bdabde070) at /data/src/10.1/sql/sql_connect.cc:1242
      #18 0x000055a707600446 in pfs_spawn_thread (arg=0x7f5bdeff3070) at /data/src/10.1/storage/perfschema/pfs.cc:1861
      #19 0x00007f5be5f0d494 in start_thread (arg=0x7f5be6234b00) at pthread_create.c:333
      #20 0x00007f5be42c693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.1 non-debug 1d10c9afe

      #2  <signal handler called>
      #3  mi_reset (info=0x7f7ff2878808) at /data/src/10.1/storage/myisam/mi_extra.c:460
      #4  0x00005644d916b5c5 in close_thread_table (thd=thd@entry=0x7f7ffe2ed008, table_ptr=table_ptr@entry=0x7f7ffe2ed0c8) at /data/src/10.1/sql/sql_base.cc:1079
      #5  0x00005644d916b7d3 in close_open_tables (thd=<optimized out>) at /data/src/10.1/sql/sql_base.cc:812
      #6  close_thread_tables (thd=0x7f7ffe2ed008) at /data/src/10.1/sql/sql_base.cc:1036
      #7  0x00005644d91ac8a4 in mysql_execute_command (thd=0x7f7ffe2ed008) at /data/src/10.1/sql/sql_parse.cc:5774
      #8  0x00005644d91b512a in mysql_parse (thd=0x7f7ffe2ed008, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/10.1/sql/sql_parse.cc:7449
      #9  0x00005644d91b7fa7 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f7ffe2ed008, packet=packet@entry=0x7f7ffe2f3009 "ALTER TABLE t1 ADD KEY(e)", packet_length=packet_length@entry=25) at /data/src/10.1/sql/sql_parse.cc:1492
      #10 0x00005644d91b8862 in do_command (thd=0x7f7ffe2ed008) at /data/src/10.1/sql/sql_parse.cc:1121
      #11 0x00005644d927645c in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f7ffe2ed008) at /data/src/10.1/sql/sql_connect.cc:1330
      #12 0x00005644d9276617 in handle_one_connection (arg=arg@entry=0x7f7ffe2ed008) at /data/src/10.1/sql/sql_connect.cc:1242
      #13 0x00005644d94f0b24 in pfs_spawn_thread (arg=0x7f8007040008) at /data/src/10.1/storage/perfschema/pfs.cc:1861
      #14 0x00007f800972d494 in start_thread (arg=0x7f8009a0ab00) at pthread_create.c:333
      #15 0x00007f8007ae693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.2 debug 8b0d4cff07

      *** Error in `/data/bld/10.2/bin/mysqld': corrupted double-linked list: 0x00007f388c031f80 ***
      ======= Backtrace: =========
      /lib/x86_64-linux-gnu/libc.so.6(+0x70bcb)[0x7f38e12b8bcb]
      /lib/x86_64-linux-gnu/libc.so.6(+0x76f96)[0x7f38e12bef96]
      /lib/x86_64-linux-gnu/libc.so.6(+0x77f6f)[0x7f38e12bff6f]
      /data/bld/10.2/bin/mysqld(+0xf93fd6)[0x557f2dc2cfd6]
      /data/bld/10.2/bin/mysqld(sf_free+0x38)[0x557f2dc2cc8e]
      /data/bld/10.2/bin/mysqld(my_free+0x9e)[0x557f2dc1a471]
      /data/bld/10.2/bin/mysqld(free_root+0xc6)[0x557f2dc0e0b2]
      /data/bld/10.2/bin/mysqld(_Z8closefrmP5TABLE+0x1c3)[0x557f2d3535ff]
      /data/bld/10.2/bin/mysqld(+0x7a38cc)[0x557f2d43c8cc]
      /data/bld/10.2/bin/mysqld(_Z16tdc_remove_tableP3THD26enum_tdc_remove_table_typePKcS3_b+0x36b)[0x557f2d43f33e]
      /data/bld/10.2/bin/mysqld(_Z23mysql_rm_table_no_locksP3THDP10TABLE_LISTbbbbb+0xb51)[0x557f2d3115d3]
      /data/bld/10.2/bin/mysqld(+0x581190)[0x557f2d21a190]
      /data/bld/10.2/bin/mysqld(_Z11mysql_rm_dbP3THDPcb+0x2e)[0x557f2d21a86a]
      /data/bld/10.2/bin/mysqld(_Z21mysql_execute_commandP3THD+0x62bd)[0x557f2d252a70]
      /data/bld/10.2/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x29f)[0x557f2d25be89]
      /data/bld/10.2/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xfe2)[0x557f2d2499ae]
      /data/bld/10.2/bin/mysqld(_Z10do_commandP3THD+0x75a)[0x557f2d248311]
      /data/bld/10.2/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1bd)[0x557f2d3995d2]
      /data/bld/10.2/bin/mysqld(handle_one_connection+0x30)[0x557f2d39935f]
      /data/bld/10.2/bin/mysqld(+0xb22658)[0x557f2d7bb658]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f38e2f4a494]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f38e133093f]
      ======= Memory map: ========
      557f2cc99000-557f2e2e8000 r-xp 00000000 08:11 35693168                   /data/bld/10.2/bin/mysqld
      557f2e4e8000-557f2e5d2000 r--p 0164f000 08:11 35693168                   /data/bld/10.2/bin/mysqld
      557f2e5d2000-557f2e7d2000 rw-p 01739000 08:11 35693168                   /data/bld/10.2/bin/mysqld
      557f2e7d2000-557f2f071000 rw-p 00000000 00:00 0 
      557f2f9dc000-557f3032a000 rw-p 00000000 00:00 0                          [heap]
      7f3888000000-7f388819e000 rw-p 00000000 00:00 0 
      7f388819e000-7f388c000000 ---p 00000000 00:00 0 
      7f388c000000-7f388c034000 rw-p 00000000 00:00 0 
      7f388c034000-7f3890000000 ---p 00000000 00:00 0 
      7f3890000000-7f3890021000 rw-p 00000000 00:00 0 
      7f3890021000-7f3894000000 ---p 00000000 00:00 0 
      7f3894000000-7f3894021000 rw-p 00000000 00:00 0 
      7f3894021000-7f3898000000 ---p 00000000 00:00 0 
      7f3898000000-7f3898021000 rw-p 00000000 00:00 0 
      7f3898021000-7f389c000000 ---p 00000000 00:00 0 
      7f389c000000-7f389c021000 rw-p 00000000 00:00 0 
      7f389c021000-7f38a0000000 ---p 00000000 00:00 0 
      7f38a0000000-7f38a0021000 rw-p 00000000 00:00 0 
      7f38a0021000-7f38a4000000 ---p 00000000 00:00 0 
      7f38a4000000-7f38a4021000 rw-p 00000000 00:00 0 
      7f38a4021000-7f38a8000000 ---p 00000000 00:00 0 
      7f38a8000000-7f38a8021000 rw-p 00000000 00:00 0 
      7f38a8021000-7f38ac000000 ---p 00000000 00:00 0 
      7f38aeffe000-7f38aefff000 ---p 00000000 00:00 0 
      7f38aefff000-7f38af7ff000 rw-p 00000000 00:00 0                          [stack:3052]
      7f38af7ff000-7f38af800000 ---p 00000000 00:00 0 
      7f38af800000-7f38b0000000 rw-p 00000000 00:00 0                          [stack:3051]
      7f38b0000000-7f38b0021000 rw-p 00000000 00:00 0 
      7f38b0021000-7f38b4000000 ---p 00000000 00:00 0 
      7f38b4000000-7f38b4021000 rw-p 00000000 00:00 0 
      7f38b4021000-7f38b8000000 ---p 00000000 00:00 0 
      7f38b8000000-7f38b8021000 rw-p 00000000 00:00 0 
      7f38b8021000-7f38bc000000 ---p 00000000 00:00 0 
      7f38bc000000-7f38bc021000 rw-p 00000000 00:00 0 
      7f38bc021000-7f38c0000000 ---p 00000000 00:00 0 
      7f38c0000000-7f38c0021000 rw-p 00000000 00:00 0 
      7f38c0021000-7f38c4000000 ---p 00000000 00:00 0 
      7f38c47f9000-7f38c47fa000 ---p 00000000 00:00 0 
      7f38c47fa000-7f38c4ffa000 rw-p 00000000 00:00 0                          [stack:3050]
      7f38c4ffa000-7f38c4ffb000 ---p 00000000 00:00 0 
      7f38c4ffb000-7f38c57fb000 rw-p 00000000 00:00 0                          [stack:3049]
      7f38c57fb000-7f38c57fc000 ---p 00000000 00:00 0 
      7f38c57fc000-7f38c5ffc000 rw-p 00000000 00:00 0                          [stack:3048]
      7f38c5ffc000-7f38c5ffd000 ---p 00000000 00:00 0 
      7f38c5ffd000-7f38c67fd000 rw-p 00000000 00:00 0                          [stack:3047]
      7f38c67fd000-7f38c67fe000 ---p 00000000 00:00 0 
      7f38c67fe000-7f38c6ffe000 rw-p 00000000 00:00 0                          [stack:3046]
      7f38c6ffe000-7f38c6fff000 ---p 00000000 00:00 0 
      7f38c6fff000-7f38c77ff000 rw-p 00000000 00:00 0                          [stack:3045]
      7f38c77ff000-7f38c7800000 ---p 00000000 00:00 0 
      7f38c7800000-7f38c8000000 rw-p 00000000 00:00 0                          [stack:3044]
      7f38c8000000-7f38c8021000 rw-p 00000000 00:00 0 
      7f38c8021000-7f38cc000000 ---p 00000000 00:00 0 
      7f38cc5f4000-7f38cc5f5000 ---p 00000000 00:00 0 
      7f38cc5f5000-7f38ccdf5000 rw-p 00000000 00:00 0                          [stack:3043]
      7f38ccdf5000-7f38ccdf6000 ---p 00000000 00:00 0 
      7f38ccdf6000-7f38cd5f6000 rw-p 00000000 00:00 0                          [stack:3042]
      7f38cd5f6000-7f38cd5f7000 ---p 00000000 00:00 0 
      7f38cd5f7000-7f38cddf7000 rw-p 00000000 00:00 0                          [stack:3041]
      7f38cddf7000-7f38cddf8000 ---p 00000000 00:00 0 
      7f38cddf8000-7f38ce5f8000 rw-p 00000000 00:00 0                          [stack:3040]
      7f38ce5f8000-7f38ce5f9000 ---p 00000000 00:00 0 
      7f38ce5f9000-7f38ceffe000 rw-p 00000000 00:00 0                          [stack:3039]
      7f38ceffe000-7f38cefff000 ---p 00000000 00:00 0 
      7f38cefff000-7f38cf7ff000 rw-p 00000000 00:00 0                          [stack:3037]
      7f38cf7ff000-7f38cf800000 ---p 00000000 00:00 0 
      7f38cf800000-7f38d0000000 rw-p 00000000 00:00 0                          [stack:3036]
      7f38d0000000-7f38d0021000 rw-p 00000000 00:00 0 
      7f38d0021000-7f38d4000000 ---p 00000000 00:00 0 
      7f38d404b000-7f38d404c000 ---p 00000000 00:00 0 
      7f38d404c000-7f38d4095000 rw-p 00000000 00:00 0                          [stack:3060]
      7f38d4095000-7f38d4096000 ---p 00000000 00:00 0 
      7f38d4096000-7f38d40df000 rw-p 00000000 00:00 0                          [stack:3057]
      7f38d40df000-7f38d40e0000 ---p 00000000 00:00 0 
      7f38d40e0000-7f38d4129000 rw-p 00000000 00:00 0                          [stack:3054]
      7f38d4129000-7f38d412a000 ---p 00000000 00:00 0 
      7f38d412a000-7f38d492a000 rw-p 00000000 00:00 0                          [stack:3035]
      7f38d492a000-7f38d492b000 ---p 00000000 00:00 0 
      7f38d492b000-7f38d512b000 rw-p 00000000 00:00 0                          [stack:3034]
      7f38d512b000-7f38d512c000 ---p 00000000 00:00 0 
      7f38d512c000-7f38d592c000 rw-p 00000000 00:00 0                          [stack:3033]
      7f38d592c000-7f38d592d000 ---p 00000000 00:00 0 
      7f38d592d000-7f38d612d000 rw-p 00000000 00:00 0                          [stack:3032]
      7f38d612d000-7f38d612e000 ---p 00000000 00:00 0 
      7f38d612e000-7f38d7597000 rw-p 00000000 00:00 0                          [stack:3031]
      7f38d7597000-7f38d7598000 ---p 00000000 00:00 0 
      7f38d7598000-7f38d8000000 rw-p 00000000 00:00 0                          [stack:3030]
      7f38d8000000-7f38d8021000 rw-p 00000000 00:00 0 
      7f38d8021000-7f38dc000000 ---p 00000000 00:00 0 
      7f38dc004000-7f38dc005000 ---p 00000000 00:00 0 
      7f38dc005000-7f38dc94f000 rw-p 00000000 00:00 0                          [stack:3053]
      7f38dc94f000-7f38dc950000 ---p 00000000 00:00 0 
      7f38dc950000-7f38e1248000 rw-p 00000000 00:00 0                          [stack:3029]
      7f38e1248000-7f38e13dd000 r-xp 00000000 08:05 3152648                    /lib/x86_64-linux-gnu/libc-2.24.so
      7f38e13dd000-7f38e15dc000 ---p 00195000 08:05 3152648                    /lib/x86_64-linux-gnu/libc-2.24.so
      7f38e15dc000-7f38e15e0000 r--p 00194000 08:05 3152648                    /lib/x86_64-linux-gnu/libc-2.24.so
      7f38e15e0000-7f38e15e2000 rw-p 00198000 08:05 3152648                    /lib/x86_64-linux-gnu/libc-2.24.so
      7f38e15e2000-7f38e15e6000 rw-p 00000000 00:00 0 
      7f38e15e6000-7f38e15fc000 r-xp 00000000 08:05 3145732                    /lib/x86_64-linux-gnu/libgcc_s.so.1
      7f38e15fc000-7f38e17fb000 ---p 00016000 08:05 3145732                    /lib/x86_64-linux-gnu/libgcc_s.so.1
      7f38e17fb000-7f38e17fc000 rw-p 00015000 08:05 3145732                    /lib/x86_64-linux-gnu/libgcc_s.so.1
      7f38e17fc000-7f38e18ff000 r-xp 00000000 08:05 3152660                    /lib/x86_64-linux-gnu/libm-2.24.so
      7f38e18ff000-7f38e1afe000 ---p 00103000 08:05 3152660                    /lib/x86_64-linux-gnu/libm-2.24.so
      7f38e1afe000-7f38e1aff000 r--p 00102000 08:05 3152660                    /lib/x86_64-linux-gnu/libm-2.24.so
      7f38e1aff000-7f38e1b00000 rw-p 00103000 08:05 3152660                    /lib/x86_64-linux-gnu/libm-2.24.so
      7f38e1b00000-7f38e1c72000 r-xp 00000000 08:05 1577675                    /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.22
      7f38e1c72000-7f38e1e72000 ---p 00172000 08:05 1577675                    /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.22
      7f38e1e72000-7f38e1e7c000 r--p 00172000 08:05 1577675                    /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.22
      7f38e1e7c000-7f38e1e7e000 rw-p 0017c000 08:05 1577675                    /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.22
      7f38e1e7e000-7f38e1e82000 rw-p 00000000 00:00 0 
      7f38e1e82000-7f38e1e85000 r-xp 00000000 08:05 3152657                    /lib/x86_64-linux-gnu/libdl-2.24.so
      7f38e1e85000-7f38e2084000 ---p 00003000 08:05 3152657                    /lib/x86_64-linux-gnu/libdl-2.24.so
      7f38e2084000-7f38e2085000 r--p 00002000 08:05 3152657                    /lib/x86_64-linux-gnu/libdl-2.24.so
      7f38e2085000-7f38e2086000 rw-p 00003000 08:05 3152657                    /lib/x86_64-linux-gnu/libdl-2.24.so
      7f38e2086000-7f38e2253000 r-xp 00000000 08:05 1576357                    /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7f38e2253000-7f38e2452000 ---p 001cd000 08:05 1576357                    /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7f38e2452000-7f38e246f000 r--p 001cc000 08:05 1576357                    /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7f38e246f000-7f38e247f000 rw-p 001e9000 08:05 1576357                    /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
      7f38e247f000-7f38e2482000 rw-p 00000000 00:00 0 
      7f38e2482000-7f38e24d9000 r-xp 00000000 08:05 1576361                    /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7f38e24d9000-7f38e26d9000 ---p 00057000 08:05 1576361                    /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7f38e26d9000-7f38e26dc000 r--p 00057000 08:05 1576361                    /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7f38e26dc000-7f38e26e2000 rw-p 0005a000 08:05 1576361                    /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
      7f38e26e2000-7f38e26e3000 rw-p 00000000 00:00 0 
      7f38e26e3000-7f38e26eb000 r-xp 00000000 08:05 3152654                    /lib/x86_64-linux-gnu/libcrypt-2.24.so
      7f38e26eb000-7f38e28eb000 ---p 00008000 08:05 3152654                    /lib/x86_64-linux-gnu/libcrypt-2.24.so
      7f38e28eb000-7f38e28ec000 r--p 00008000 08:05 3152654                    /lib/x86_64-linux-gnu/libcrypt-2.24.so
      7f38e28ec000-7f38e28ed000 rw-p 00009000 08:05 3152654                    /lib/x86_64-linux-gnu/libcrypt-2.24.so
      7f38e28ed000-7f38e291b000 rw-p 00000000 00:00 0 
      7f38e291b000-7f38e2935000 r-xp 00000000 08:05 3145828                    /lib/x86_64-linux-gnu/libz.so.1.2.8
      7f38e2935000-7f38e2b34000 ---p 0001a000 08:05 3145828                    /lib/x86_64-linux-gnu/libz.so.1.2.8
      7f38e2b34000-7f38e2b35000 r--p 00019000 08:05 3145828                    /lib/x86_64-linux-gnu/libz.so.1.2.8
      7f38e2b35000-7f38e2b36000 rw-p 0001a000 08:05 3145828                    /lib/x86_64-linux-gnu/libz.so.1.2.8
      7f38e2b36000-7f38e2b40000 r-xp 00000000 08:05 1586559                    /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
      7f38e2b40000-7f38e2d3f000 ---p 0000a000 08:05 1586559                    /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
      7f38e2d3f000-7f38e2d40000 r--p 00009000 08:05 1586559                    /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
      7f38e2d40000-7f38e2d41000 rw-p 0000a000 08:05 1586559                    /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0
      7f38e2d41000-7f38e2d42000 r-xp 00000000 08:05 3152558                    /lib/x86_64-linux-gnu/libaio.so.1.0.1
      7f38e2d42000-7f38e2f41000 ---p 00001000 08:05 3152558                    /lib/x86_64-linux-gnu/libaio.so.1.0.1
      7f38e2f41000-7f38e2f42000 r--p 00000000 08:05 3152558                    /lib/x86_64-linux-gnu/libaio.so.1.0.1
      7f38e2f42000-7f38e2f43000 rw-p 00001000 08:05 3152558                    /lib/x86_64-linux-gnu/libaio.so.1.0.1
      7f38e2f43000-7f38e2f5b000 r-xp 00000000 08:05 3152800                    /lib/x86_64-linux-gnu/libpthread-2.24.so
      7f38e2f5b000-7f38e315a000 ---p 00018000 08:05 3152800                    /lib/x86_64-linux-gnu/libpthread-2.24.so
      7f38e315a000-7f38e315b000 r--p 00017000 08:05 3152800                    /lib/x86_64-linux-gnu/libpthread-2.24.so
      7f38e315b000-7f38e315c000 rw-p 00018000 08:05 3152800                    /lib/x86_64-linux-gnu/libpthread-2.24.so
      7f38e315c000-7f38e3160000 rw-p 00000000 00:00 0 
      7f38e3160000-7f38e3183000 r-xp 00000000 08:05 3145795                    /lib/x86_64-linux-gnu/ld-2.24.so
      7f38e3187000-7f38e3188000 rw-p 00000000 00:00 0 
      7f38e3188000-7f38e318e000 rw-s 00000000 00:11 86204202                   /dev/shm/var_auto_sZvq/mysqld.1/data/tc.log
      7f38e318e000-7f38e3193000 rw-s 00000000 00:0a 86204195                   /[aio] (deleted)
      7f38e3193000-7f38e3198000 rw-s 00000000 00:0a 86204194                   /[aio] (deleted)
      7f38e3198000-7f38e3369000 rw-p 00000000 00:00 0 
      7f38e3369000-7f38e336b000 rw-s 00000000 00:0a 86204196                   /[aio] (deleted)
      7f38e336b000-7f38e3370000 rw-s 00000000 00:0a 86204193                   /[aio] (deleted)
      7f38e3370000-7f38e3375000 rw-s 00000000 00:0a 86204192                   /[aio] (deleted)
      7f38e3375000-7f38e337a000 rw-s 00000000 00:0a 86204191                   /[aio] (deleted)
      7f38e337a000-7f38e337f000 rw-s 00000000 00:0a 86204190                   /[aio] (deleted)
      7f38e337f000-7f38e3380000 rw-s 00000000 00:0a 86204188                   /[aio] (deleted)
      7f38e3380000-7f38e3383000 rw-p 00000000 00:00 0 
      7f38e3383000-7f38e3384000 r--p 00023000 08:05 3145795                    /lib/x86_64-linux-gnu/ld-2.24.so
      7f38e3384000-7f38e3385000 rw-p 00024000 08:05 3145795                    /lib/x86_64-linux-gnu/ld-2.24.so
      7f38e3385000-7f38e3386000 rw-p 00000000 00:00 0 
      7ffe386ca000-7ffe386ed000 rw-p 00000000 00:00 0                          [stack]
      7ffe38783000-7ffe38785000 r-xp 00000000 00:00 0                          [vdso]
      7ffe38785000-7ffe38787000 r--p 00000000 00:00 0                          [vvar]
      ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
      

      10.2 non-debug 8b0d4cff0

      mysqld: malloc.c:2403: sysmalloc: Assertion `(old_top == initial_top (av) && old_size == 0) || ((unsigned long) (old_size) >= MINSIZE && prev_inuse (old_top) && ((unsigned long) old_end & (pagesize - 1)) == 0)' failed.
      

      10.3 debug 934d5f95d33

      #3  <signal handler called>
      #4  0x000056321e557f1c in get_lock_data (thd=0x7fc15c000b00, table_ptr=0x7fc15c015060, count=1, flags=6) at /data/src/10.3/sql/lock.cc:823
      #5  0x000056321e556faa in mysql_unlock_some_tables (thd=0x7fc15c000b00, table=0x7fc15c015060, count=1, flag=4) at /data/src/10.3/sql/lock.cc:457
      #6  0x000056321e183c86 in JOIN::optimize_stage2 (this=0x7fc15c014360) at /data/src/10.3/sql/sql_select.cc:1982
      #7  0x000056321e1837ce in JOIN::optimize_inner (this=0x7fc15c014360) at /data/src/10.3/sql/sql_select.cc:1907
      #8  0x000056321e181ea5 in JOIN::optimize (this=0x7fc15c014360) at /data/src/10.3/sql/sql_select.cc:1448
      #9  0x000056321e18b89c in mysql_select (thd=0x7fc15c000b00, tables=0x7fc15c013c18, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc15c014340, unit=0x7fc15c0049a8, select_lex=0x7fc15c005118) at /data/src/10.3/sql/sql_select.cc:4206
      #10 0x000056321e17d9f0 in handle_select (thd=0x7fc15c000b00, lex=0x7fc15c0048e0, result=0x7fc15c014340, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:382
      #11 0x000056321e148409 in execute_sqlcom_select (thd=0x7fc15c000b00, all_tables=0x7fc15c013c18) at /data/src/10.3/sql/sql_parse.cc:6542
      #12 0x000056321e13eb35 in mysql_execute_command (thd=0x7fc15c000b00) at /data/src/10.3/sql/sql_parse.cc:3765
      #13 0x000056321e14c2eb in mysql_parse (thd=0x7fc15c000b00, rawbuf=0x7fc15c013a90 "SELECT 1 FROM db2.t3", length=20, parser_state=0x7fc1ac0fd5f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8073
      #14 0x000056321e13964a in dispatch_command (command=COM_QUERY, thd=0x7fc15c000b00, packet=0x7fc15c00b211 "SELECT 1 FROM db2.t3", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1847
      #15 0x000056321e13806e in do_command (thd=0x7fc15c000b00) at /data/src/10.3/sql/sql_parse.cc:1392
      #16 0x000056321e29e39b in do_handle_one_connection (connect=0x563220ab99c0) at /data/src/10.3/sql/sql_connect.cc:1402
      #17 0x000056321e29e11f in handle_one_connection (arg=0x563220ab99c0) at /data/src/10.3/sql/sql_connect.cc:1308
      #18 0x000056321e72fb15 in pfs_spawn_thread (arg=0x563220b5b2a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #19 0x00007fc1b3676494 in start_thread (arg=0x7fc1ac0fe700) at pthread_create.c:333
      #20 0x00007fc1b1a5c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

        Attachments

          Activity

            People

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: