Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
I am getting following crash occasionally while restore encrypted backup with (empty) FULLTEXT index:
161205 11:52:04 [01] Copying ./test/film_text.ibd to F:/git/mysql-test/var/tmp/backup/test/film_text.ibd
161205 11:52:04 [01] ...done
161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000000000000001e_index_1.ibd to F:/git/mysql-test/var/tmp/backup/test/fts_0000000000000014_000000000000001e_index_1.ibd
161205 11:52:04 [01] ...done
161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000000000000001e_index_2.ibd to F:/git/mysql-test/var/tmp/backup/test/fts_0000000000000014_000000000000001e_index_2.ibd
161205 11:52:04 [01] ...done
161205 11:52:04 [01] Copying ./test/fts_0000000000000014_000161205 11:52:04 [ERROR] mysqld got exception 0x80000003 ;
...
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
ucrtbase.DLL!abort()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
xtrabackup.exe!?getByteOrder@SHA512@TaoCrypt@@UBE?AW4ByteOrder@2@XZ()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlInitializeExceptionChain()
ntdll.dll!RtlInitializeExceptionChain()
Mtr test below reproduces the problem (I added two more FULLTEXT indexes to increase chance of crash, but it crashes with single first index as well - just with smaller probability):
.opt file:
--plugin-load-add=$FILE_KEY_MANAGEMENT_SO
--innodb_strict_mode
--innodb_file_per_table
--innodb-encrypt-log=ON
--innodb-encryption-rotate-key-age=2
--innodb-encryption-threads=4
--innodb-tablespaces-encryption
--innodb-encrypt-tables=FORCE
--loose-file-key-management
--loose-file-key-management-filename=$MYSQL_TEST_DIR/std_data/logkey.txt
.test file:
CREATE TABLE film_text (
film_id SMALLINT NOT NULL,
title VARCHAR(255) NOT NULL,
description TEXT,
PRIMARY KEY (film_id),
FULLTEXT KEY idx_title_description (title,description),
FULLTEXT KEY (description),
FULLTEXT KEY (title)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
exec $XTRABACKUP --innobackupex --defaults-file=$MYSQLTEST_VARDIR/my.cnf --no-timestamp $targetdir;
exec $XTRABACKUP --innobackupex --apply-log --rebuild-indexes --rebuild-threads=2 $targetdir;
– source include/restart_and_restore.inc