Debian Codegraph @

mysql-test/suite/innodb/r/dblwr_unencrypt.result

raw
1 #
2 # WL#13775 - InnoDB: Encrypt DBLWR files
3 #
4 #
5 # Test Begin: Test if recovery works if first page of user
6 # tablespace is corrupted. Valid copy of that page is there
7 # in DBLWR file.
8 #
9 SET GLOBAL innodb_monitor_enable = module_log;
10 # Wait for purge to complete
11 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 BLOB);
12 START TRANSACTION;
13 INSERT INTO t1 VALUES(1, repeat('#',12));
14 INSERT INTO t1 VALUES(2, repeat('+',12));
15 INSERT INTO t1 VALUES(3, repeat('/',12));
16 INSERT INTO t1 VALUES(4, repeat('-',12));
17 INSERT INTO t1 VALUES(5, repeat('.',12));
18 COMMIT WORK;
19 # Ensure that dirty pages of table t1 is flushed.
20 FLUSH TABLES t1 FOR EXPORT;
21 UNLOCK TABLES;
22 SET GLOBAL innodb_master_thread_disabled_debug=1;
23 SET GLOBAL innodb_checkpoint_disabled=1;
24 BEGIN;
25 INSERT INTO t1 VALUES (6, repeat('%', 12));
26 SET SESSION innodb_interpreter = 'init';
27 SET SESSION innodb_interpreter = 'find_tablespace_file_name test/t1';
28 SELECT @@session.innodb_interpreter_output INTO @space_file_name;
29 SET SESSION innodb_interpreter = 'destroy';
30 # Kill the server
31 # Corrupt the root page of table t1 in the user tablespace.
32 # restart
33 SET SESSION innodb_interpreter = 'init';
34 SET SESSION innodb_interpreter = 'print_dblwr_has_encrypted_pages';
35 SET SESSION innodb_interpreter = 'destroy';
36 Pattern "Double write file has encrypted pages" not found
37 Pattern "\[Note\] .* Restoring page \[page id: space=\d+, page number=0\] of datafile .* from the doublewrite buffer. Writing .*" found
38 CHECK TABLE t1;
39 Table Op Msg_type Msg_text
40 test.t1 check status OK
41 SELECT f1, f2 FROM t1;
42 f1 f2
43 1 ############
44 2 ++++++++++++
45 3 ////////////
46 4 ------------
47 5 ............
48 DROP TABLE t1;
49 # Test End