Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
The test is non-deterministic, run with --repeat=N. It usually fails for me within first 5 attempts, but it can vary on different machines and builds.
CREATE TABLE t (pk INT) ENGINE=Aria; |
INSERT INTO t VALUES (1),(2); |
SELECT * FROM t INTO OUTFILE 'load.data'; |
|
--connect (con1,localhost,root,,test)
|
|
CREATE TEMPORARY TABLE tmp (pk INT) ENGINE=Aria; |
REPLACE INTO tmp (pk) VALUES (1); |
SELECT pk FROM tmp UNION ALL SELECT pk FROM tmp; |
DELETE FROM tmp LIMIT 3; |
|
--send
|
OPTIMIZE TABLE tmp; |
|
--connection default
|
|
DROP TABLE t; |
|
--connection con1
|
--reap
|
LOAD DATA INFILE 'load.data' IGNORE INTO TABLE tmp; |
|
DELETE FROM tmp LIMIT 1; |
|
--error 0,1030
|
SELECT pk FROM tmp WHERE pk IN ( SELECT pk FROM tmp ); |
|
--connection default
|
--source include/restart_mysqld.inc
|
|
# Cleanup
|
--let $datadir= `select @@datadir`
|
--remove_file $datadir/test/load.data |
10.2 af9649c722810 |
mysqld: /data/src/10.2/storage/maria/ma_pagecache.c:1142: check_pagecache_is_cleaned_up: Assertion `pagecache->block_root[i].status == 0' failed.
|
181107 16:34:08 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f0c4263dee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000563faf4bc20a in check_pagecache_is_cleaned_up (pagecache=0x563fb0e39100 <maria_pagecache_var>) at /data/src/10.2/storage/maria/ma_pagecache.c:1142
|
#9 0x0000563faf4bc311 in end_pagecache (pagecache=0x563fb0e39100 <maria_pagecache_var>, cleanup=1 '\001') at /data/src/10.2/storage/maria/ma_pagecache.c:1175
|
#10 0x0000563faf4d478a in maria_end () at /data/src/10.2/storage/maria/ma_init.c:109
|
#11 0x0000563faf51b584 in maria_panic (flag=HA_PANIC_CLOSE) at /data/src/10.2/storage/maria/ma_panic.c:135
|
#12 0x0000563faf49d1db in maria_hton_panic (hton=0x563fb2449d10, flag=HA_PANIC_CLOSE) at /data/src/10.2/storage/maria/ha_maria.cc:3308
|
#13 0x0000563faf28db21 in ha_finalize_handlerton (plugin=0x563fb241cba8) at /data/src/10.2/sql/handler.cc:460
|
#14 0x0000563faf02e67b in plugin_deinitialize (plugin=0x563fb241cba8, ref_check=true) at /data/src/10.2/sql/sql_plugin.cc:1219
|
#15 0x0000563faf02eae8 in reap_plugins () at /data/src/10.2/sql/sql_plugin.cc:1295
|
#16 0x0000563faf030b2f in plugin_shutdown () at /data/src/10.2/sql/sql_plugin.cc:1953
|
#17 0x0000563faef31ad4 in clean_up (print_message=true) at /data/src/10.2/sql/mysqld.cc:2220
|
#18 0x0000563faef315fe in unireg_end () at /data/src/10.2/sql/mysqld.cc:2094
|
#19 0x0000563faef314fb in kill_server (sig_ptr=0x0) at /data/src/10.2/sql/mysqld.cc:2021
|
#20 0x0000563faef3153d in kill_server_thread (arg=0x7f0c3c9ade00) at /data/src/10.2/sql/mysqld.cc:2044
|
#21 0x0000563faf5857ac in pfs_spawn_thread (arg=0x7f0c340013f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#22 0x00007f0c44314494 in start_thread (arg=0x7f0c3c886700) at pthread_create.c:333
|
#23 0x00007f0c426fa93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible with the provided test case on 10.4, possibly fixed by all the Aria changes.
Not reproducible with the provided test case on 10.1, because the temporary table cannot be re-opened there.
No obvious effect on a non-debug build.
Attachments
Issue Links
- duplicates
-
MDEV-19055 Assertion `(_my_thread_var())->thr_errno != 0' failed in pagecache_read
- Closed
- relates to
-
MDEV-17622 Assertion `block->type == PAGECACHE_EMPTY_PAGE || block->type == type || type == PAGECACHE_LSN_PAGE || type == PAGECACHE_READ_UNKNOWN_PAGE || block->type == PAGECACHE_READ_UNKNOWN_PAGE' failed in pagecache_read or ER_CRASHED_ON_USAGE
- Closed
-
MDEV-17659 Error 175 "File too short; Expected more data in file" upon SELECT with re-opened temporary table after concurrent OPTIMIZE and DDL
- Closed