Details
-
Bug
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
N/A
Description
The test case is non-deterministic, run with --repeat=N. It fails for me in 5-10 attempts both on MSAN (with the MSAN error) and on plain debug build (with ER_NOT_KEYFILE), but it can vary a lot on different machines and builds, specifically on faster ones it may require some changes.
--source include/have_sequence.inc
|
|
|
SET max_heap_table_size= 1024*1024*1024; |
|
|
CREATE TABLE t1 (a INT, b BLOB) ENGINE=MEMORY; |
|
|
--connect (con1,localhost,root,,)
|
SET max_heap_table_size= 1024*1024*1024; |
--send INSERT INTO t1 SELECT seq, REPEAT('x',100) FROM seq_1_to_2000000
|
|
|
--connection default
|
|
|
let $wait_condition=
|
SELECT COUNT(*) FROM information_schema.PROCESSLIST |
WHERE COMMAND = 'Query' AND INFO LIKE 'INSERT INTO t1 SELECT%' |
AND STATE = 'Sending data'; |
--source include/wait_condition.inc
|
|
|
SET lock_wait_timeout=1; |
|
|
let $i= 10;
|
while ($i)
|
{
|
--error 0,ER_LOCK_WAIT_TIMEOUT |
INSERT INTO t1 VALUES (1, REPEAT('y',100)); |
dec $i; |
}
|
|
|
--connection con1
|
--error 0,ER_RECORD_FILE_FULL,ER_NOT_KEYFILE,126
|
--reap
|
--disconnect con1
|
|
|
--connection default
|
--error 0,ER_NOT_KEYFILE,126
|
CHECK TABLE t1; |
DROP TABLE t1; |
|
bb-blob-main-monty 06cfb8d0c36193e0abadb937899b2d249edc52a9 MSAN |
==3070126==WARNING: MemorySanitizer: use-of-uninitialized-value
|
#0 0x557b16626947 in heap_check_heap /data/bld/testing/bb-blob-main-monty-msan/storage/heap/_check.c:121:9
|
#1 0x557b1660e191 in ha_heap::external_lock(THD*, int) /data/bld/testing/bb-blob-main-monty-msan/storage/heap/ha_heap.cc:539:36
|
#2 0x557b15aebaf3 in handler::ha_external_lock(THD*, int) /data/bld/testing/bb-blob-main-monty-msan/sql/handler.cc:8030:3
|
#3 0x557b15f8268e in handler::ha_external_unlock(THD*) /data/bld/testing/bb-blob-main-monty-msan/sql/handler.h:3772:45
|
#4 0x557b15f8268e in unlock_external(THD*, TABLE**, unsigned int) /data/bld/testing/bb-blob-main-monty-msan/sql/lock.cc:791:11
|
#5 0x557b15f8268e in mysql_lock_tables(THD*, st_mysql_lock*, unsigned int) /data/bld/testing/bb-blob-main-monty-msan/sql/lock.cc:404:12
|
#6 0x557b15f80e59 in mysql_lock_tables(THD*, TABLE**, unsigned int, unsigned int) /data/bld/testing/bb-blob-main-monty-msan/sql/lock.cc:351:7
|
#7 0x557b14f2e760 in lock_tables(THD*, TABLE_LIST*, unsigned int, unsigned int) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_base.cc:6080:23
|
#8 0x557b14f303b8 in open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_base.cc:5802:7
|
#9 0x557b14ff90d6 in open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_base.h:545:10
|
#10 0x557b14ff90d6 in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item>>&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_insert.cc:812:9
|
#11 0x557b1510c480 in mysql_execute_command(THD*, bool) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_parse.cc:4502:10
|
#12 0x557b150f1089 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_parse.cc:7945:18
|
#13 0x557b150ea314 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_parse.cc:1903:7
|
#14 0x557b150f20ec in do_command(THD*, bool) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_parse.cc:1437:17
|
#15 0x557b155aeccc in do_handle_one_connection(CONNECT*, bool) /data/bld/testing/bb-blob-main-monty-msan/sql/sql_connect.cc:1503:11
|
#16 0x557b155ae7a6 in handle_one_connection /data/bld/testing/bb-blob-main-monty-msan/sql/sql_connect.cc:1415:5
|
#17 0x557b16420e17 in pfs_spawn_thread /data/bld/testing/bb-blob-main-monty-msan/storage/perfschema/pfs.cc:2198:3
|
#18 0x7f47835a71f4 in start_thread nptl/pthread_create.c:442:8
|
#19 0x7f47836278eb in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
|
|
Memory was marked as uninitialized
|
#0 0x557b14c7930d in __msan_allocated_memory (/share8t/bld/testing/bb-blob-main-monty-msan/sql/mariadbd+0x99c30d) (BuildId: 278fd5847d1b9376af8666aa771ee93ef4db7ba7)
|
#1 0x557b170424c4 in my_malloc /data/bld/testing/bb-blob-main-monty-msan/mysys/my_malloc.c:117:7
|
|
|
SUMMARY: MemorySanitizer: use-of-uninitialized-value /data/bld/testing/bb-blob-main-monty-msan/storage/heap/_check.c:121:9 in heap_check_heap
|
|
bb-blob-main-monty 06cfb8d0c36193e0abadb937899b2d249edc52a9 debug |
mysqltest: At line 27: query 'INSERT INTO t1 VALUES (1, REPEAT('y',100))' failed with wrong errno ER_NOT_KEYFILE (1034): 'Index for table 't1' is corrupt; try to repair it', instead of (0)...
|
Attachments
Issue Links
- is caused by
-
MDEV-38975 BLOBs in MEMORY (HEAP) Engine
-
- In Testing
-
-
MDEV-40431 heap_update() key-update loop does not roll back on non-duplicate-key failures, and hp_rb_write_key() masks allocation failure as HA_ERR_FOUND_DUPP_KEY
-
- In Testing
-
- relates to
-
MDEV-21373 ER_NOT_KEYFILE (Index for table is corrupt; try to repair it) or ASAN errors upon concurrent DELETE and LOCK
-
- Closed
-