| 1 |
CREATE TABLE t1(i int) ENGINE INNODB; |
| 2 |
INSERT into t1 values(1); |
| 3 |
CREATE TABLE t2(i int) ENGINE INNODB; |
| 4 |
INSERT INTO t2 values(2); |
| 5 |
CREATE TABLE t3(i int) ENGINE INNODB; |
| 6 |
CREATE TABLE t4(i int) ENGINE INNODB; |
| 7 |
CREATE TABLE t5(i int) ENGINE INNODB; |
| 8 |
INSERT INTO t5 VALUES(5); |
| 9 |
CREATE TABLE a(a int) ENGINE INNODB; |
| 10 |
INSERT INTO a values(1); |
| 11 |
CREATE TABLE b(b CHAR(1)) ENGINE INNODB; |
| 12 |
INSERT INTO b VALUES('b'); |
| 13 |
CREATE TABLE a1(a1 int) ENGINE INNODB; |
| 14 |
INSERT INTO a1 VALUES(1); |
| 15 |
CREATE TABLE b1(b1 CHAR(2)) ENGINE INNODB; |
| 16 |
INSERT INTO b1 VALUES('b1'); |
| 17 |
set global innodb_log_checkpoint_now = 1; |
| 18 |
# xtrabackup prepare |
| 19 |
# shutdown server |
| 20 |
# remove datadir |
| 21 |
# xtrabackup move back |
| 22 |
# restart |
| 23 |
CREATE TABLE t1(i int); |
| 24 |
DROP TABLE t1; |
| 25 |
SELECT * from t1_renamed; |
| 26 |
i |
| 27 |
1 |
| 28 |
DROP TABLE t1_renamed; |
| 29 |
CREATE TABLE t2(i int); |
| 30 |
DROP TABLE t2; |
| 31 |
SELECT * from t2_renamed; |
| 32 |
i |
| 33 |
2 |
| 34 |
DROP TABLE t2_renamed; |
| 35 |
SELECT * from t3; |
| 36 |
i |
| 37 |
3 |
| 38 |
DROP TABLE t3; |
| 39 |
SELECT * from t4; |
| 40 |
i |
| 41 |
DROP TABLE t4; |
| 42 |
CREATE TABLE tmp(i int); |
| 43 |
DROP TABLE tmp; |
| 44 |
SELECT * FROM a; |
| 45 |
b |
| 46 |
b |
| 47 |
SELECT * FROM b; |
| 48 |
a |
| 49 |
1 |
| 50 |
SELECT * FROM a1; |
| 51 |
b1 |
| 52 |
b1 |
| 53 |
SELECT * FROM b1; |
| 54 |
a1 |
| 55 |
1 |
| 56 |
DROP TABLE a,b,a1,b1; |
| 57 |
SELECT * from t5; |
| 58 |
i |
| 59 |
DROP TABLE t5; |
| 60 |
SELECT * from t6; |
| 61 |
i |
| 62 |
5 |
| 63 |
DROP TABLE t6; |
| 64 |
# |
| 65 |
# MDEV-33011 mariabackup --backup: FATAL ERROR: ... Can't open datafile cool_down/t3 |
| 66 |
# |
| 67 |
# Simulate zero initialized page to defer tablespace load after rename log is found |
| 68 |
SET @save_dbug = @@SESSION.debug_dbug; |
| 69 |
SET DEBUG_DBUG="+d,checkpoint_after_file_create"; |
| 70 |
CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB; |
| 71 |
INSERT INTO t1 VALUES(1); |
| 72 |
# RENAME that fails after redo log entry is written and flushed |
| 73 |
RENAME TABLE t1 TO non_existing_db.t1; |
| 74 |
ERROR HY000: Error on rename of './test/t1' to './non_existing_db/t1' (errno: 168 "Unknown (generic) error from engine") |
| 75 |
DROP TABLE t1; |