[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 - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.0.36, 10.1.35, 10.2.17, 10.3.9
Component/s: Data Definition - Alter Table, Storage Engine - Memory
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

Attachments

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2017-01-07 17:37

Elena Stepanova made changes - 2017-01-24 11:57

Field	Original Value	New Value
Fix Version/s	10.2 [ 14601 ]

Elena Stepanova made changes - 2018-04-23 16:17

Affects Version/s

10.3 [ 22126 ]

Elena Stepanova made changes - 2018-07-08 13:38

Comment

[ New occurrence on 10.3: https://api.travis-ci.org/v3/job/369638459/log.txt ]

Elena Stepanova made changes - 2018-07-08 13:38

Comment

[ New occurrence in 10.3: https://api.travis-ci.org/v3/job/346863807/log.txt ]

Elena Stepanova made changes - 2018-07-08 13:39

Comment

[ Recent occurrence:
http://buildbot.askmonty.org/buildbot/builders/qa-win-debug/builds/836/steps/crash_tests/logs/stdio

{noformat}
2017-11-22 12:39:42 9548 [Warning] 'user' entry 'root@mariadb-04' ignored in --skip-name-resolve mode.
2017-11-22 12:39:42 9548 [Warning] 'proxies_priv' entry '@% root@mariadb-04' ignored in --skip-name-resolve mode.
Version: '10.2.11-MariaDB-debug-log' socket: '' port: 11500 Source distribution
2017-11-22 12:41:52 3992 [Warning] Sort aborted, host: 127.0.0.1, user: root, thread: 18, query: DELETE FROM view2 ORDER BY field1, field2, field3, field4 LIMIT 3 /* QNO 8251 CON_ID 18 */
2017-11-22 12:41:56 5736 [ERROR] mysqld.exe: Deadlock found when trying to get lock; try restarting transaction
2017-11-22 12:41:56 5736 [Warning] Sort aborted, host: 127.0.0.1, user: root, thread: 18, query: DELETE FROM view1 ORDER BY field1, field2, field3, field4 LIMIT 3 /* QNO 8635 CON_ID 18 */
Assertion failed: bitmap_is_set_all(&table->s->all_set), file D:\qa-win-debug\build\sql\handler.cc, line 5962
171122 12:42:36 [ERROR] mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.2.11-MariaDB-debug-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=7
max_threads=65537
thread_count=12
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4240 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0xdf31ee9cc8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Assertion failed: bitmap_is_set_all(&table->s->all_set), file D:\qa-win-debug\build\sql\handler.cc, line 5962
{noformat} ]

Elena Stepanova made changes - 2018-07-08 13:39

Attachment

mysql.err [ 43212 ]

Elena Stepanova made changes - 2018-07-08 13:39

Attachment

mysql.log.gz [ 43211 ]

Elena Stepanova made changes - 2018-07-08 13:39

Attachment

threads [ 43210 ]

Elena Stepanova made changes - 2018-07-08 13:53

Component/s		Data Definition - Alter Table [ 10114 ]
Fix Version/s		10.0 [ 16000 ]
Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Affects Version/s		10.0 [ 16000 ]
Affects Version/s		10.1 [ 16100 ]
Description	Encountered during tests on bb-10.2-monty. Information in the report is related to that test run, but I couldn't reproduce it so far neither on the same tree, nor on 10.2. {noformat:title=bb-10.2-monty 4ec3e60ae3734 of Jan 6} mysqld: /home/elenst/git/bb-10.2-monty/sql/handler.cc:5906: int handler::ha_reset(): Assertion `bitmap_is_set_all(&table->s->all_set)' failed. 170107 8:19:53 [ERROR] mysqld got signal 6 ; # 2017-01-07T08:20:22 [15176] #7 0x00007f8cd8066192 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 # 2017-01-07T08:20:22 [15176] #8 0x00007f8cdab50d8c in handler::ha_reset (this=0x7f8c96880088) at /home/elenst/git/bb-10.2-monty/sql/handler.cc:5906 # 2017-01-07T08:20:22 [15176] #9 0x00007f8cda85e6fc in close_thread_table (thd=0x7f8c968e9070, table_ptr=0x7f8c968e9130) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:874 # 2017-01-07T08:20:22 [15176] #10 0x00007f8cda85e486 in close_thread_tables (thd=0x7f8c968e9070) at /home/elenst/git/bb-10.2-monty/sql/sql_base.cc:831 # 2017-01-07T08:20:22 [15176] #11 0x00007f8cdaa2958d in mysql_admin_table(THD , TABLE_LIST , HA_CHECK_OPT , const char , thr_lock_type, bool, bool, uint, int ()(THD , TABLE_LIST , HA_CHECK_OPT ), struct {...}, int ()(THD , TABLE_LIST , HA_CHECK_OPT )) (thd=0x7f8c968e9070, tables=0x7f8c969321e8, check_opt=0x7f8c968eda08, operator_name=0x7f8cdb3d26ff "analyze", lock_type=TL_READ_NO_INS ERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::)(handler const, THD , HA_CHECK_OPT )) 0x7f8cdab4ca2c <handler::ha_ana lyze(THD, st_ha_check_opt)>, view_operator_func=0x0) at /home/elenst/git/bb-10.2-monty/sql/sql_admin.cc:1155 # 2017-01-07T08:20:22 [15176] #12 0x00007f8cdaa29cb9 in Sql_cmd_analyze_table::execute (this=0x7f8c96932810, thd=0x7f8c968e9070) at /home/elenst/git/bb-10.2-monty/sql/sql_admin.cc:1284 # 2017-01-07T08:20:22 [15176] #13 0x00007f8cda8da38f in mysql_execute_command (thd=0x7f8c968e9070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:6165 # 2017-01-07T08:20:22 [15176] #14 0x00007f8cda8ded45 in mysql_parse (thd=0x7f8c968e9070, rawbuf=0x7f8c96932088 "ANALYZE TABLE `t7` PERSISTENT FOR COLUMNS ( ) INDEXES ALL /* QNO 1268 CON_ID 19 /", le ngth=82, parser_state=0x7f8cd6f68db0, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:7839 # 2017-01-07T08:20:22 [15176] #15 0x00007f8cda8cc7e6 in dispatch_command (command=COM_QUERY, thd=0x7f8c968e9070, packet=0x7f8c96926071 "", packet_length=83, is_com_multi=false, is_next_command=false) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1799 # 2017-01-07T08:20:22 [15176] #16 0x00007f8cda8cb1a6 in do_command (thd=0x7f8c968e9070) at /home/elenst/git/bb-10.2-monty/sql/sql_parse.cc:1359 # 2017-01-07T08:20:22 [15176] #17 0x00007f8cdaa15894 in do_handle_one_connection (connect=0x7f8cd785c830) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1354 # 2017-01-07T08:20:22 [15176] #18 0x00007f8cdaa15621 in handle_one_connection (arg=0x7f8cd785c830) at /home/elenst/git/bb-10.2-monty/sql/sql_connect.cc:1260 # 2017-01-07T08:20:22 [15176] #19 0x00007f8cd8c13e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 # 2017-01-07T08:20:22 [15176] #20 0x00007f8cd812acbd in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} {noformat} Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f8c96932088): ANALYZE TABLE `t7` PERSISTENT FOR COLUMNS ( ) INDEXES ALL / QNO 1268 CON_ID 19 */ Connection ID (thread ID): 14 Status: NOT_KILLED {noformat} {noformat:title=RQG experimental 67b190f486} perl /home/elenst/git/rqg/runall-new.pl --no-mask --seed=1483769555 --threads=8 --duration=600 --queries=100M --validators=TransformerNoComparator --transformers=ExecuteAsPreparedTwice,DisableOptimizations,EnableOptimizations,InlineVirtualColumns,ExecuteAsTrigger --redefine=conf/mariadb/general-workarounds.yy --redefine=conf/mariadb/10.0-features-redefine.yy --mysqld=--log_output=FILE --grammar=conf/replication/replication-ddl_sql.yy --gendata=conf/replication/replication-ddl_data.zz --gendata-advanced --vcols --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,CrashRestart --restart-timeout=20 --mtr-build-thread=72 --basedir1=/home/elenst/git/bb-10.2-monty --vardir1=/home/elenst/test_results/monty-4/current1_1 {noformat}	{code:sql} --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; {code} {noformat:title=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 {noformat} {noformat:title=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 {noformat} {noformat:title=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... {noformat} {noformat:title=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 {noformat} {noformat:title=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 {noformat} {noformat:title=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] {noformat} {noformat:title=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. {noformat} {noformat:title=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 {noformat}
Summary	[Draft] handler::ha_reset(): Assertion `bitmap_is_set_all(&table->s->all_set)' failed	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

Elena Stepanova made changes - 2018-07-08 13:55

Assignee

Elena Stepanova [ elenst ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2018-07-13 14:55

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2018-07-13 14:55

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2018-07-19 10:33

Component/s		Storage Engine - Memory [ 10300 ]
Fix Version/s		10.0.36 [ 22916 ]
Fix Version/s		10.1.35 [ 23116 ]
Fix Version/s		10.2.17 [ 23111 ]
Fix Version/s		10.3.9 [ 23114 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.0 [ 16000 ]
Fix Version/s	10.1 [ 16100 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:44

Workflow

MariaDB v3 [ 79123 ]

MariaDB v4 [ 151500 ]

People

Assignee:: Sergei Golubchik

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2017-01-07 17:37

Updated:: 2018-07-19 10:33

Resolved:: 2018-07-19 10:33

Git Integration

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

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration