Debian Codegraph @

mysql-test/suite/binlog_encryption/encrypted_master_lost_key.result

raw
1 #################
2 # Initialization
3 #################
4 include/rpl_init.inc [topology=1->2]
5 connection server_2;
6 include/stop_slave.inc
7 #####################################################
8 # Pre-test 1: Initial key value
9 #####################################################
10 connection server_1;
11 CREATE TABLE table1_to_encrypt (
12 pk INT AUTO_INCREMENT PRIMARY KEY,
13 ts TIMESTAMP NULL,
14 b BLOB
15 ) ENGINE=MyISAM;
16 INSERT INTO table1_to_encrypt VALUES (NULL,NOW(),'data_to_encrypt');
17 INSERT INTO table1_to_encrypt SELECT NULL,NOW(),b FROM table1_to_encrypt;
18 SET binlog_format=ROW;
19 INSERT INTO table1_to_encrypt SELECT NULL,NOW(),b FROM table1_to_encrypt;
20 INSERT INTO table1_to_encrypt SELECT NULL,NOW(),b FROM table1_to_encrypt;
21 NOT FOUND /table1_to_encrypt/ in master-bin.0*
22 #######################################################
23 # Pre-test 2: restart master with a different key value
24 #######################################################
25 connection default;
26 connection server_1;
27 CREATE TABLE table2_to_encrypt (
28 pk INT AUTO_INCREMENT PRIMARY KEY,
29 ts TIMESTAMP NULL,
30 b BLOB
31 ) ENGINE=MyISAM;
32 INSERT INTO table2_to_encrypt VALUES (NULL,NOW(),'data_to_encrypt');
33 INSERT INTO table2_to_encrypt SELECT NULL,NOW(),b FROM table2_to_encrypt;
34 SET binlog_format=ROW;
35 INSERT INTO table2_to_encrypt SELECT NULL,NOW(),b FROM table2_to_encrypt;
36 INSERT INTO table2_to_encrypt SELECT NULL,NOW(),b FROM table2_to_encrypt;
37 NOT FOUND /table2_to_encrypt/ in master-bin.0*
38 #####################################################
39 # Pre-test 3: restart master again with the right key
40 #####################################################
41 connection default;
42 connection server_1;
43 CREATE TABLE table3_to_encrypt (
44 pk INT AUTO_INCREMENT PRIMARY KEY,
45 ts TIMESTAMP NULL,
46 b BLOB
47 ) ENGINE=MyISAM;
48 INSERT INTO table3_to_encrypt VALUES (NULL,NOW(),'data_to_encrypt');
49 INSERT INTO table3_to_encrypt SELECT NULL,NOW(),b FROM table3_to_encrypt;
50 INSERT INTO table3_to_encrypt SELECT NULL,NOW(),b FROM table3_to_encrypt;
51 FLUSH BINARY LOGS;
52 INSERT INTO table3_to_encrypt SELECT NULL,NOW(),b FROM table3_to_encrypt;
53 #####################################################
54 # Test 1: Check that if master has an encrypted
55 # binary log which it cannot decrypt, it
56 # still feeds events to the slave, and SQL
57 # thread produces an expected error upon
58 # receiving these unreadable events .
59 # This behavior is confirmed in MDEV-11323
60 #####################################################
61 connection server_2;
62 START SLAVE IO_THREAD;
63 include/wait_for_slave_io_to_start.inc
64 START SLAVE SQL_THREAD;
65 include/wait_for_slave_sql_error.inc [errno=1594]
66 SHOW TABLES;
67 Tables_in_test
68 table1_to_encrypt
69 SELECT COUNT(*) FROM table1_to_encrypt;
70 COUNT(*)
71 8
72 #####################################################
73 # Test 2: check that replication works if it starts
74 # from a good binary log
75 #####################################################
76 connection server_2;
77 include/stop_slave.inc
78 RESET SLAVE ALL;
79 DROP DATABASE test;
80 CREATE DATABASE test;
81 USE test;
82 CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=<MASTER_PORT>, MASTER_USER='root', MASTER_LOG_FILE='master-bin.000003';
83 include/start_slave.inc
84 SHOW TABLES;
85 Tables_in_test
86 table3_to_encrypt
87 #####################################################
88 # Test 3: check that replication works if we purge
89 # master logs up to the good one
90 #####################################################
91 connection server_2;
92 connection server_1;
93 PURGE BINARY LOGS TO 'master-bin.000003';
94 connection server_2;
95 include/stop_slave.inc
96 RESET SLAVE ALL;
97 DROP DATABASE test;
98 CREATE DATABASE test;
99 USE test;
100 CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=<MASTER_PORT>, MASTER_USER='root';
101 include/start_slave.inc
102 SHOW TABLES;
103 Tables_in_test
104 table3_to_encrypt
105 ##########
106 # Cleanup
107 ##########
108 connection server_1;
109 DROP TABLE table1_to_encrypt, table2_to_encrypt, table3_to_encrypt;
110 connection server_2;
111 include/rpl_end.inc