2019-06-20 19:17:52 0 [Note] mysqld: Aria engine: starting recovery

recovered pages: 0% 10% 20% 31% 41% 51% 61% 72% 83% 94% 100% (0.0 seconds); transactions to roll back: 12019-06-20 19:17:52 0 [ERROR] mysqld: Index for table './test/t2.MAI' is corrupt; try to repair it

2019-06-20 19:17:52 0 [ERROR] mysqld: Got error 126 when executing undo undo_key_insert

2019-06-20 19:17:52 0 [ERROR] mysqld: Aria engine: Undo phase failed

 --repeat=100 --mysqld=--aria-encrypt-tables=1  --mysqld=--file-key-management --mysqld=--file-key-management-filename=`pwd`/std_data/keys.txt --mysqld=--plugin-load-add=file_key_management --mysqld=--aria-checkpoint-interval=5

CREATE TABLE t1 (

    pk integer auto_increment,

    f char(32),

    key (f),

    primary key (pk)

) ENGINE=Aria;

CREATE TABLE t2 (

    f char(32),

    i int,

    pk integer auto_increment,

    key (f),

    primary key (pk)

) ENGINE=Aria;

ALTER TABLE t2 DISABLE KEYS;

INSERT INTO t2 VALUES

('symbolic', -1177681920, NULL),('who', 4, NULL),('w', 828571648, NULL),

('unemployment', 9, NULL),('wtdnoraf', 9, NULL),('tdnoraf', 1, NULL),

('nor', 1249640448, NULL),('p', NULL, NULL),('t', -465436672, NULL),

('orafbz', 0, NULL),('p', -505348096, NULL),('greet', 330039296, NULL),

('p', -991035392, NULL),('rafbz', 5, NULL),('afbzau', 1, NULL),

('fb', 371326976, NULL),('product', NULL, NULL),('bzau', 32178176, NULL),

('zaup', 1, NULL),('upuaxoa', 19464192, NULL),('puaxoa', NULL, NULL),

('l', NULL, NULL),('a', 2077491200, NULL),('oahaenad', NULL, NULL),

('explosion', NULL, NULL),('d', 9, NULL),('d', NULL, NULL),

('aenadu', 5, NULL),('y', 1, NULL),('m', 2, NULL),

('week', -1846804480, NULL),('spokesman', -1024983040, NULL),

('r', 210829312, NULL),('uwkygxpqzxi', NULL, NULL),('r', 4, NULL),

('w', 1166671872, NULL),('kygxp', -1138753536, NULL),

('absorb', -2141716480, NULL),('ygx', 1515061248, NULL),('m', 2, NULL),

('x', 9, NULL),('consider', -771424256, NULL),('z', NULL, NULL),

('cue', NULL, NULL),('institutional', 9, NULL),('wait', 895942656, NULL),

('p', 0, NULL),('ymfzlm', NULL, NULL),('specialty', -913768448, NULL),

('v', 543424512, NULL);

ALTER TABLE t2 ENABLE KEYS;

--connect (con1,localhost,root,,test)

--connect (con2,localhost,root,,test)

--connect (con3,localhost,root,,test)

SELECT * INTO OUTFILE 'load.data' FROM t2;

DELETE FROM t2 ORDER BY pk LIMIT 2;

--connection con1

INSERT INTO t2 () VALUES ();

--error ER_DUP_ENTRY

INSERT INTO t1 (pk, f) SELECT i, f FROM t2;

--send

  UPDATE t1 SET f = 'foo';

--connection con2

--send

  LOAD DATA INFILE 'load.data' REPLACE INTO TABLE t2;

--connection default

--let $shutdown_timeout= 0

--source include/restart_mysqld.inc

DROP TABLE t1, t2;

--let $datadir= `SELECT @@datadir`

--remove_file $datadir/test/load.data