diff options
| author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2020-07-14 13:22:59 +0530 |
|---|---|---|
| committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2020-07-14 13:24:37 +0530 |
| commit | e80183dbd595984a42e1265d7a257d8ca14b3bb8 (patch) | |
| tree | 3d2a0e0d1eb9dc4bb391c7419d184fbdc034b4f2 | |
| parent | 194a720e28ed426552558b32c68577db9f29ab2e (diff) | |
| download | mariadb-git-e80183dbd595984a42e1265d7a257d8ca14b3bb8.tar.gz | |
MDEV-15662 mariabackup.huge_lsn fails sporadically with "log sequence number is in the future"
- Problem is that test case creates iblogfile* files. So existing
ibdata pages could point to future LSN. Fix is that taking the
backup of data before iblogfile* creation and apply it before
exiting the test case.
| -rw-r--r-- | mysql-test/suite/mariabackup/huge_lsn.result | 4 | ||||
| -rw-r--r-- | mysql-test/suite/mariabackup/huge_lsn.test | 8 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/mariabackup/huge_lsn.result b/mysql-test/suite/mariabackup/huge_lsn.result index f2202c20968..b519fb1e961 100644 --- a/mysql-test/suite/mariabackup/huge_lsn.result +++ b/mysql-test/suite/mariabackup/huge_lsn.result @@ -17,3 +17,7 @@ SELECT * FROM t; i 1 DROP TABLE t; +# shutdown server +# remove datadir +# xtrabackup move back +# restart server diff --git a/mysql-test/suite/mariabackup/huge_lsn.test b/mysql-test/suite/mariabackup/huge_lsn.test index baf577769c0..9b89530a7f1 100644 --- a/mysql-test/suite/mariabackup/huge_lsn.test +++ b/mysql-test/suite/mariabackup/huge_lsn.test @@ -9,6 +9,10 @@ let INNODB_PAGE_SIZE=`select @@innodb_page_size`; let MYSQLD_DATADIR=`select @@datadir`; call mtr.add_suppression("InnoDB: New log files created"); +let $targetdir_old=$MYSQLTEST_VARDIR/tmp/backup_1; +--disable_result_log +exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir_old; +--enable_result_log --source include/shutdown_mysqld.inc perl; @@ -52,3 +56,7 @@ exec $XTRABACKUP --prepare --target-dir=$targetdir; SELECT * FROM t; DROP TABLE t; rmdir $targetdir; +let $targetdir= $targetdir_old; +exec $XTRABACKUP --prepare --target-dir=$targetdir; +--source include/restart_and_restore.inc +rmdir $targetdir_old; |