Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mix_row_reset_slave.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 Master_User = 'root'
7 Master_Host = '127.0.0.1'
8 include/stop_slave.inc
9 CHANGE REPLICATION SOURCE to SOURCE_USER='test';
10 Warnings:
11 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
12 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.
13 Master_User = 'test'
14 Master_Host = '127.0.0.1'
15 reset slave;
16 Warnings:
17 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
18 Master_User = 'test'
19 Master_Host = '127.0.0.1'
20 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
21 Warnings:
22 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
23 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.
24 include/start_slave.inc
25 Master_User = 'root'
26 Master_Host = '127.0.0.1'
27 include/stop_slave.inc
28 reset slave;
29 Warnings:
30 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
31 include/start_slave.inc
32 create temporary table t1 (a int);
33 include/stop_slave.inc
34 reset slave;
35 Warnings:
36 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
37 reset master;
38 include/start_slave.inc
39 show status like 'replica_open_temp_tables';
40 Variable_name Value
41 Replica_open_temp_tables 0
42 drop temporary table if exists t1;
43 include/stop_slave.inc
44 reset slave;
45 Warnings:
46 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
47 include/check_slave_no_error.inc
48 CHANGE REPLICATION SOURCE to SOURCE_USER='impossible_user_name';
49 Warnings:
50 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
51 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.
52 start slave;
53 Warnings:
54 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
55 include/wait_for_slave_io_error.inc [errno=1045]
56 include/stop_slave_sql.inc
57 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
58 Warnings:
59 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
60 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.
61 include/start_slave.inc
62 include/check_slave_no_error.inc
63
64 Sync slave, else STOP SLAVE may complain about open temporary table.
65
66 [connection master]
67 include/sync_slave_sql_with_master.inc
68 include/stop_slave.inc
69 CHANGE REPLICATION SOURCE to SOURCE_USER='impossible_user_name';
70 Warnings:
71 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
72 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.
73 start slave;
74 Warnings:
75 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
76 include/wait_for_slave_io_error.inc [errno=1045]
77 include/stop_slave_sql.inc
78 reset slave;
79 Warnings:
80 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
81 include/check_slave_no_error.inc
82 CHANGE REPLICATION SOURCE to SOURCE_USER='root';
83 Warnings:
84 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
85 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.
86 reset slave;
87 Warnings:
88 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
89
90 Sync slave, else STOP SLAVE may complain about open temporary table.
91
92 include/start_slave.inc
93 [connection master]
94 include/sync_slave_sql_with_master.inc
95 include/stop_slave.inc
96 reset slave all;
97 Warnings:
98 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
99 start slave;
100 ERROR HY000: The server is not configured as replica; fix in config file or with CHANGE REPLICATION SOURCE TO
101 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT;
102 Warnings:
103 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
104 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.
105 include/start_slave.inc
106 [connection master]
107 include/sync_slave_sql_with_master.inc
108 include/stop_slave.inc
109 include/rpl_reset_slave.inc
110 # Configure the slave with an empty user
111 CHANGE REPLICATION SOURCE TO SOURCE_USER='', SOURCE_PORT=MASTER_PORT, SOURCE_HOST='localhost';
112 Warnings:
113 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
114 Note 1760 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.
115 # Issue a RESET SLAVE instruction and try to start the slave IO thread that will error out
116 include/rpl_reset_slave.inc
117 START SLAVE IO_THREAD;
118 Warnings:
119 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
120 include/wait_for_slave_io_error.inc [errno=13117]
121 # Check the user is still empty
122 include/assert.inc [User_name in slave_master_info is empty]
123 # Cleanup
124 include/rpl_reset_slave.inc
125 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
126 Warnings:
127 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
128 Note 1760 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.
129 include/start_slave.inc
130 call mtr.add_suppression("Replica I/O for channel '': Fatal error: Invalid .* username when attempting to connect to the source server*");
131 include/rpl_end.inc