1# 2# PXB-1936: --prepare cannot decrypt table but "completed ok" 3# 4 5require_server_version_higher_than 5.7.10 6 7. inc/keyring_file.sh 8 9start_server 10 11mysql -e "CREATE TABLE t (a INT) ENCRYPTION='y'" test 12 13mysql -e "INSERT INTO t VALUES (1), (2), (3), (4)" test 14 15( while true ; do 16 mysql -e "INSERT INTO t SELECT a + 10*$i FROM t ORDER BY a LIMIT 4" test 17 mysql -e "ALTER INSTANCE ROTATE INNODB MASTER KEY" 18 sleep 1 19done ) 2>/dev/null & 20 21xtrabackup --backup --target-dir=$topdir/backup 22 23stop_server 24 25run_cmd_expect_failure $XB_BIN $XB_ARGS --prepare --target-dir=$topdir/backup 26 27rm -rf $mysql_datadir 28rm -rf $topdir/backup 29 30start_server 31 32mysql -e "CREATE TABLE t (a INT) ENCRYPTION='y'" test 33 34mysql -e "INSERT INTO t VALUES (1), (2), (3), (4)" test 35 36shutdown_server 37start_server 38 39( while true ; do 40 mysql -e "INSERT INTO t SELECT a + 10*$i FROM t ORDER BY a LIMIT 4" test 41 sleep 1 42done ) 2>/dev/null & 43 44xtrabackup --backup --target-dir=$topdir/backup 45 46stop_server 47 48run_cmd_expect_failure $XB_BIN $XB_ARGS --prepare --target-dir=$topdir/backup 49