← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_stm_reset_slave.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_stm_reset_slave.result
1
 
stop slave;
2
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3
 
reset master;
4
 
reset slave;
5
 
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
 
start slave;
7
 
SHOW SLAVE STATUS;
8
 
Slave_IO_State  #
9
 
Master_Host     127.0.0.1
10
 
Master_User     root
11
 
Master_Port     MASTER_PORT
12
 
Connect_Retry   1
13
 
Master_Log_File master-bin.000001
14
 
Read_Master_Log_Pos     #
15
 
Relay_Log_File  #
16
 
Relay_Log_Pos   #
17
 
Relay_Master_Log_File   master-bin.000001
18
 
Slave_IO_Running        Yes
19
 
Slave_SQL_Running       Yes
20
 
Replicate_Do_DB 
21
 
Replicate_Ignore_DB     
22
 
Replicate_Do_Table      
23
 
Replicate_Ignore_Table  #
24
 
Replicate_Wild_Do_Table 
25
 
Replicate_Wild_Ignore_Table     
26
 
Last_Errno      0
27
 
Last_Error      
28
 
Skip_Counter    0
29
 
Exec_Master_Log_Pos     #
30
 
Relay_Log_Space #
31
 
Until_Condition None
32
 
Until_Log_File  
33
 
Until_Log_Pos   0
34
 
Master_SSL_Allowed      No
35
 
Master_SSL_CA_File      
36
 
Master_SSL_CA_Path      
37
 
Master_SSL_Cert 
38
 
Master_SSL_Cipher       
39
 
Master_SSL_Key  
40
 
Seconds_Behind_Master   #
41
 
Master_SSL_Verify_Server_Cert   No
42
 
Last_IO_Errno   #
43
 
Last_IO_Error   #
44
 
Last_SQL_Errno  0
45
 
Last_SQL_Error  
46
 
stop slave;
 
1
include/master-slave.inc
 
2
[connection master]
 
3
Master_User = 'root'
 
4
Master_Host = '127.0.0.1'
 
5
include/stop_slave.inc
47
6
change master to master_user='test';
48
 
SHOW SLAVE STATUS;
49
 
Slave_IO_State  #
50
 
Master_Host     127.0.0.1
51
 
Master_User     test
52
 
Master_Port     MASTER_PORT
53
 
Connect_Retry   1
54
 
Master_Log_File master-bin.000001
55
 
Read_Master_Log_Pos     #
56
 
Relay_Log_File  #
57
 
Relay_Log_Pos   #
58
 
Relay_Master_Log_File   master-bin.000001
59
 
Slave_IO_Running        No
60
 
Slave_SQL_Running       No
61
 
Replicate_Do_DB 
62
 
Replicate_Ignore_DB     
63
 
Replicate_Do_Table      
64
 
Replicate_Ignore_Table  #
65
 
Replicate_Wild_Do_Table 
66
 
Replicate_Wild_Ignore_Table     
67
 
Last_Errno      0
68
 
Last_Error      
69
 
Skip_Counter    0
70
 
Exec_Master_Log_Pos     #
71
 
Relay_Log_Space #
72
 
Until_Condition None
73
 
Until_Log_File  
74
 
Until_Log_Pos   0
75
 
Master_SSL_Allowed      No
76
 
Master_SSL_CA_File      
77
 
Master_SSL_CA_Path      
78
 
Master_SSL_Cert 
79
 
Master_SSL_Cipher       
80
 
Master_SSL_Key  
81
 
Seconds_Behind_Master   #
82
 
Master_SSL_Verify_Server_Cert   No
83
 
Last_IO_Errno   #
84
 
Last_IO_Error   #
85
 
Last_SQL_Errno  0
86
 
Last_SQL_Error  
87
 
reset slave;
88
 
SHOW SLAVE STATUS;
89
 
Slave_IO_State  #
90
 
Master_Host     127.0.0.1
91
 
Master_User     root
92
 
Master_Port     MASTER_PORT
93
 
Connect_Retry   1
94
 
Master_Log_File 
95
 
Read_Master_Log_Pos     #
96
 
Relay_Log_File  #
97
 
Relay_Log_Pos   #
98
 
Relay_Master_Log_File   
99
 
Slave_IO_Running        No
100
 
Slave_SQL_Running       No
101
 
Replicate_Do_DB 
102
 
Replicate_Ignore_DB     
103
 
Replicate_Do_Table      
104
 
Replicate_Ignore_Table  #
105
 
Replicate_Wild_Do_Table 
106
 
Replicate_Wild_Ignore_Table     
107
 
Last_Errno      0
108
 
Last_Error      
109
 
Skip_Counter    0
110
 
Exec_Master_Log_Pos     #
111
 
Relay_Log_Space #
112
 
Until_Condition None
113
 
Until_Log_File  
114
 
Until_Log_Pos   0
115
 
Master_SSL_Allowed      No
116
 
Master_SSL_CA_File      
117
 
Master_SSL_CA_Path      
118
 
Master_SSL_Cert 
119
 
Master_SSL_Cipher       
120
 
Master_SSL_Key  
121
 
Seconds_Behind_Master   #
122
 
Master_SSL_Verify_Server_Cert   No
123
 
Last_IO_Errno   #
124
 
Last_IO_Error   #
125
 
Last_SQL_Errno  0
126
 
Last_SQL_Error  
127
 
start slave;
128
 
SHOW SLAVE STATUS;
129
 
Slave_IO_State  #
130
 
Master_Host     127.0.0.1
131
 
Master_User     root
132
 
Master_Port     MASTER_PORT
133
 
Connect_Retry   1
134
 
Master_Log_File master-bin.000001
135
 
Read_Master_Log_Pos     #
136
 
Relay_Log_File  #
137
 
Relay_Log_Pos   #
138
 
Relay_Master_Log_File   master-bin.000001
139
 
Slave_IO_Running        Yes
140
 
Slave_SQL_Running       Yes
141
 
Replicate_Do_DB 
142
 
Replicate_Ignore_DB     
143
 
Replicate_Do_Table      
144
 
Replicate_Ignore_Table  #
145
 
Replicate_Wild_Do_Table 
146
 
Replicate_Wild_Ignore_Table     
147
 
Last_Errno      0
148
 
Last_Error      
149
 
Skip_Counter    0
150
 
Exec_Master_Log_Pos     #
151
 
Relay_Log_Space #
152
 
Until_Condition None
153
 
Until_Log_File  
154
 
Until_Log_Pos   0
155
 
Master_SSL_Allowed      No
156
 
Master_SSL_CA_File      
157
 
Master_SSL_CA_Path      
158
 
Master_SSL_Cert 
159
 
Master_SSL_Cipher       
160
 
Master_SSL_Key  
161
 
Seconds_Behind_Master   #
162
 
Master_SSL_Verify_Server_Cert   No
163
 
Last_IO_Errno   #
164
 
Last_IO_Error   #
165
 
Last_SQL_Errno  0
166
 
Last_SQL_Error  
167
 
stop slave;
168
 
reset slave;
169
 
start slave;
 
7
Master_User = 'test'
 
8
Master_Host = '127.0.0.1'
 
9
reset slave;
 
10
Master_User = 'root'
 
11
Master_Host = '127.0.0.1'
 
12
include/start_slave.inc
 
13
Master_User = 'root'
 
14
Master_Host = '127.0.0.1'
 
15
include/stop_slave.inc
 
16
reset slave;
 
17
include/start_slave.inc
170
18
create temporary table t1 (a int);
171
 
stop slave;
 
19
include/stop_slave.inc
172
20
reset slave;
173
 
start slave;
 
21
include/start_slave.inc
174
22
show status like 'slave_open_temp_tables';
175
23
Variable_name   Value
176
24
Slave_open_temp_tables  1
177
 
stop slave;
 
25
include/stop_slave.inc
178
26
reset slave;
179
 
*** errno must be zero: 0 ***
 
27
include/check_slave_no_error.inc
180
28
change master to master_user='impossible_user_name';
181
29
start slave;
182
 
ONE
183
 
1
184
 
include/stop_slave.inc
 
30
include/wait_for_slave_io_error.inc [errno=1045]
 
31
include/stop_slave_sql.inc
185
32
change master to master_user='root';
186
33
include/start_slave.inc
187
 
*** last errno must be  zero: 0 ***
188
 
*** last error must be blank:  ***
 
34
include/check_slave_no_error.inc
189
35
include/stop_slave.inc
190
36
change master to master_user='impossible_user_name';
191
37
start slave;
192
 
ONE
193
 
1
194
 
include/stop_slave.inc
 
38
include/wait_for_slave_io_error.inc [errno=1045]
 
39
include/stop_slave_sql.inc
195
40
reset slave;
196
 
*** io  last errno must be  zero: 0  ***
197
 
*** io  last error must be blank:   ***
198
 
*** sql last errno must be  zero: 0 ***
199
 
*** sql last error must be blank:  ***
 
41
include/check_slave_no_error.inc
 
42
include/rpl_end.inc