[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 Created: 2017-01-07  Updated: 2018-07-19  Resolved: 2018-07-19

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - Memory
Affects Version/s: 10.0, 10.1, 10.2, 10.3
Fix Version/s: 10.0.36, 10.1.35, 10.2.17, 10.3.9

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 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


Generated at Thu Feb 08 07:52:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.