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

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