Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_nogtid_encryption_read.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 FLUSH LOCAL LOGS;
7 include/assert.inc [Master status shall point to master-bin.000002]
8 include/rpl_stop_server.inc [server_number=1]
9 # Part 1
10 Try to restart the master with debug instrumentation
11 include/assert_grep.inc [Server reported: Cannot get file password for encrypted replication log file]
12 include/assert_grep.inc [Server failed to initialize binary log for recovery]
13 include/assert_grep.inc [Server aborted to start]
14 Try to restart the master with debug instrumentation
15 include/assert_grep.inc [Server reported: Cannot get file password for encrypted replication log file]
16 include/assert_grep.inc [Server failed to initialize binary log for recovery]
17 include/assert_grep.inc [Server aborted to start]
18 Try to restart the master with debug instrumentation
19 include/assert_grep.inc [Server reported: Binlog has bad magic number]
20 include/assert_grep.inc [Server failed to initialize binary log for recovery]
21 include/assert_grep.inc [Server aborted to start]
22 Try to restart the master with debug instrumentation
23 include/assert_grep.inc [Server reported: Fetched an invalid key from keyring]
24 include/assert_grep.inc [Server failed to initialize binary log for recovery]
25 include/assert_grep.inc [Server aborted to start]
26 Try to restart the master with debug instrumentation
27 include/assert_grep.inc [Server reported: Fetched an invalid key from keyring]
28 include/assert_grep.inc [Server failed to initialize binary log for recovery]
29 include/assert_grep.inc [Server aborted to start]
30 Try to restart the master with debug instrumentation
31 include/assert_grep.inc [Server reported: Unable to determine encryption header version]
32 include/assert_grep.inc [Server failed to initialize binary log for recovery]
33 include/assert_grep.inc [Server aborted to start]
34 Try to restart the master with debug instrumentation
35 include/assert_grep.inc [Server reported: Unsupported encryption header version]
36 include/assert_grep.inc [Server failed to initialize binary log for recovery]
37 include/assert_grep.inc [Server aborted to start]
38 Try to restart the master with debug instrumentation
39 include/assert_grep.inc [Server reported: Header is corrupted]
40 include/assert_grep.inc [Server failed to initialize binary log for recovery]
41 include/assert_grep.inc [Server aborted to start]
42 Try to restart the master with debug instrumentation
43 include/assert_grep.inc [Server reported: Unknown field type]
44 include/assert_grep.inc [Server failed to initialize binary log for recovery]
45 include/assert_grep.inc [Server aborted to start]
46 Try to restart the master with debug instrumentation
47 include/assert_grep.inc [Server reported: Header is missing the replication encryption key ID]
48 include/assert_grep.inc [Server failed to initialize binary log for recovery]
49 include/assert_grep.inc [Server aborted to start]
50 Try to restart the master with debug instrumentation
51 include/assert_grep.inc [Server reported: Header is missing the encrypted password]
52 include/assert_grep.inc [Server failed to initialize binary log for recovery]
53 include/assert_grep.inc [Server aborted to start]
54 Try to restart the master with debug instrumentation
55 include/assert_grep.inc [Server reported: Header is missing the IV]
56 include/assert_grep.inc [Server failed to initialize binary log for recovery]
57 include/assert_grep.inc [Server aborted to start]
58 Try to restart the master with debug instrumentation
59 include/assert_grep.inc [Server reported: Header is incomplete]
60 include/assert_grep.inc [Server failed to initialize binary log for recovery]
61 include/assert_grep.inc [Server aborted to start]
62 include/rpl_start_server.inc [server_number=1]
63 # Part 2
64 include/assert.inc [1st binary log is not encrypted]
65 include/assert.inc [2nd binary log is encrypted]
66 include/assert.inc [3rd binary log is not encrypted]
67 include/show_binlog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 master-bin.000002 # Previous_gtids # #
70 master-bin.000002 # Anonymous_Gtid # # SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
71 master-bin.000002 # Query # # use `test`; CREATE TABLE t1 (c1 INT PRIMARY KEY)
72 master-bin.000002 # Anonymous_Gtid # # SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
73 master-bin.000002 # Query # # BEGIN
74 master-bin.000002 # Table_map # # table_id: # (test.t1)
75 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
76 master-bin.000002 # Xid # # COMMIT /* XID */
77 master-bin.000002 # Anonymous_Gtid # # SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
78 master-bin.000002 # Query # # BEGIN
79 master-bin.000002 # Table_map # # table_id: # (test.t1)
80 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
81 master-bin.000002 # Xid # # COMMIT /* XID */
82 # Part 3
83 [connection slave]
84 include/start_slave.inc
85 [connection master]
86 include/sync_slave_sql_with_master.inc
87 include/assert.inc [Slave shall have t1 with a 6 rows on it]
88 DROP TABLE t1;
89 include/stop_slave.inc
90 # Part 4
91 [connection master]
92 # Part 4.1
93 # Part 4.1.1
94 # Adding debug point 'corrupt_replication_encryption_key' to @@GLOBAL.debug
95 SHOW BINLOG EVENTS IN 'master-bin.000002';
96 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Binlog has bad magic number; It's not a binary log file that can be used by this version of MySQL
97 # Removing debug point 'corrupt_replication_encryption_key' from @@GLOBAL.debug
98 # Part 4.1.2
99 # Adding debug point 'corrupt_replication_encryption_key_type' to @@GLOBAL.debug
100 SHOW BINLOG EVENTS IN 'master-bin.000002';
101 ERROR HY000: Fetched an invalid key from keyring.
102 # Removing debug point 'corrupt_replication_encryption_key_type' from @@GLOBAL.debug
103 # Part 4.1.3
104 # Adding debug point 'corrupt_replication_encryption_key_size' to @@GLOBAL.debug
105 SHOW BINLOG EVENTS IN 'master-bin.000002';
106 ERROR HY000: Fetched an invalid key from keyring.
107 # Removing debug point 'corrupt_replication_encryption_key_size' from @@GLOBAL.debug
108 # Part 4.1.4
109 # Adding debug point 'corrupt_encrypted_header_version' to @@GLOBAL.debug
110 SHOW BINLOG EVENTS IN 'master-bin.000002';
111 ERROR HY000: Error reading a replication log encryption header: Unable to determine encryption header version.
112 # Removing debug point 'corrupt_encrypted_header_version' from @@GLOBAL.debug
113 # Part 4.1.5
114 # Adding debug point 'force_encrypted_header_version_2' to @@GLOBAL.debug
115 SHOW BINLOG EVENTS IN 'master-bin.000002';
116 ERROR HY000: Error reading a replication log encryption header: Unsupported encryption header version.
117 # Removing debug point 'force_encrypted_header_version_2' from @@GLOBAL.debug
118 # Part 4.1.6
119 # Adding debug point 'corrupt_encryption_header_read_above_header_size' to @@GLOBAL.debug
120 SHOW BINLOG EVENTS IN 'master-bin.000002';
121 ERROR HY000: Error reading a replication log encryption header: Header is corrupted.
122 # Removing debug point 'corrupt_encryption_header_read_above_header_size' from @@GLOBAL.debug
123 # Part 4.1.7
124 # Adding debug point 'corrupt_encryption_header_unknown_field_type' to @@GLOBAL.debug
125 SHOW BINLOG EVENTS IN 'master-bin.000002';
126 ERROR HY000: Error reading a replication log encryption header: Unknown field type.
127 # Removing debug point 'corrupt_encryption_header_unknown_field_type' from @@GLOBAL.debug
128 # Part 4.1.8
129 # Adding debug point 'corrupt_encryption_header_missing_key_id' to @@GLOBAL.debug
130 SHOW BINLOG EVENTS IN 'master-bin.000002';
131 ERROR HY000: Error reading a replication log encryption header: Header is missing the replication encryption key ID.
132 # Removing debug point 'corrupt_encryption_header_missing_key_id' from @@GLOBAL.debug
133 # Part 4.1.9
134 # Adding debug point 'corrupt_encryption_header_missing_password' to @@GLOBAL.debug
135 SHOW BINLOG EVENTS IN 'master-bin.000002';
136 ERROR HY000: Error reading a replication log encryption header: Header is missing the encrypted password.
137 # Removing debug point 'corrupt_encryption_header_missing_password' from @@GLOBAL.debug
138 # Part 4.1.10
139 # Adding debug point 'corrupt_encryption_header_missing_iv' to @@GLOBAL.debug
140 SHOW BINLOG EVENTS IN 'master-bin.000002';
141 ERROR HY000: Error reading a replication log encryption header: Header is missing the IV.
142 # Removing debug point 'corrupt_encryption_header_missing_iv' from @@GLOBAL.debug
143 # Part 4.1.11
144 # Adding debug point 'force_incomplete_encryption_header' to @@GLOBAL.debug
145 SHOW BINLOG EVENTS IN 'master-bin.000002';
146 ERROR HY000: Error reading a replication log encryption header: Header is incomplete.
147 # Removing debug point 'force_incomplete_encryption_header' from @@GLOBAL.debug
148 # Part 4.2
149 UNINSTALL PLUGIN keyring_file;
150 include/rpl_stop_server.inc [server_number=1]
151 include/rpl_start_server.inc [server_number=1]
152 SHOW BINLOG EVENTS IN 'master-bin.000002';
153 ERROR HY000: Can't find key from keyring, please check in the server log if a keyring is loaded and initialized successfully.
154 # Part 4.3
155 UNINSTALL PLUGIN keyring_file;
156 SHOW BINLOG EVENTS IN 'master-bin.000002';
157 ERROR HY000: Failed to fetch key from keyring, please check if keyring is loaded.
158 # Part 5
159 include/assert_grep.inc [mysqlbinlog reported it does not support reading encrypted log files]
160 [connection slave]
161 include/start_slave.inc
162 include/rpl_end.inc