← 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_deadlock_innodb.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_deadlock_innodb.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;
 
1
include/master-slave.inc
 
2
[connection master]
7
3
*** Prepare tables and data ***
8
4
CREATE TABLE t1 (a INT NOT NULL, KEY(a)) ENGINE=innodb;
9
5
CREATE TABLE t2 (a INT) ENGINE=innodb;
50
46
SELECT * FROM t3;
51
47
a
52
48
3
53
 
SHOW SLAVE STATUS;
54
 
Slave_IO_State  #
55
 
Master_Host     127.0.0.1
56
 
Master_User     root
57
 
Master_Port     MASTER_PORT
58
 
Connect_Retry   1
59
 
Master_Log_File master-bin.000001
60
 
Read_Master_Log_Pos     #
61
 
Relay_Log_File  #
62
 
Relay_Log_Pos   #
63
 
Relay_Master_Log_File   master-bin.000001
64
 
Slave_IO_Running        Yes
65
 
Slave_SQL_Running       Yes
66
 
Replicate_Do_DB 
67
 
Replicate_Ignore_DB     
68
 
Replicate_Do_Table      
69
 
Replicate_Ignore_Table  #
70
 
Replicate_Wild_Do_Table 
71
 
Replicate_Wild_Ignore_Table     
72
 
Last_Errno      0
73
 
Last_Error      
74
 
Skip_Counter    0
75
 
Exec_Master_Log_Pos     #
76
 
Relay_Log_Space #
77
 
Until_Condition None
78
 
Until_Log_File  
79
 
Until_Log_Pos   0
80
 
Master_SSL_Allowed      No
81
 
Master_SSL_CA_File      
82
 
Master_SSL_CA_Path      
83
 
Master_SSL_Cert 
84
 
Master_SSL_Cipher       
85
 
Master_SSL_Key  
86
 
Seconds_Behind_Master   #
87
 
Master_SSL_Verify_Server_Cert   No
88
 
Last_IO_Errno   #
89
 
Last_IO_Error   #
90
 
Last_SQL_Errno  0
91
 
Last_SQL_Error  
 
49
include/check_slave_is_running.inc
92
50
 
93
51
*** Test lock wait timeout ***
94
52
include/stop_slave.inc
99
57
a
100
58
1
101
59
START SLAVE;
 
60
include/wait_for_slave_sql_error.inc [errno=1205]
102
61
SELECT COUNT(*) FROM t2;
103
62
COUNT(*)
104
63
0
112
71
a
113
72
3
114
73
3
115
 
SHOW SLAVE STATUS;
116
 
Slave_IO_State  #
117
 
Master_Host     127.0.0.1
118
 
Master_User     root
119
 
Master_Port     MASTER_PORT
120
 
Connect_Retry   1
121
 
Master_Log_File master-bin.000001
122
 
Read_Master_Log_Pos     #
123
 
Relay_Log_File  #
124
 
Relay_Log_Pos   #
125
 
Relay_Master_Log_File   master-bin.000001
126
 
Slave_IO_Running        Yes
127
 
Slave_SQL_Running       Yes
128
 
Replicate_Do_DB 
129
 
Replicate_Ignore_DB     
130
 
Replicate_Do_Table      
131
 
Replicate_Ignore_Table  #
132
 
Replicate_Wild_Do_Table 
133
 
Replicate_Wild_Ignore_Table     
134
 
Last_Errno      0
135
 
Last_Error      
136
 
Skip_Counter    0
137
 
Exec_Master_Log_Pos     #
138
 
Relay_Log_Space #
139
 
Until_Condition None
140
 
Until_Log_File  
141
 
Until_Log_Pos   0
142
 
Master_SSL_Allowed      No
143
 
Master_SSL_CA_File      
144
 
Master_SSL_CA_Path      
145
 
Master_SSL_Cert 
146
 
Master_SSL_Cipher       
147
 
Master_SSL_Key  
148
 
Seconds_Behind_Master   #
149
 
Master_SSL_Verify_Server_Cert   No
150
 
Last_IO_Errno   #
151
 
Last_IO_Error   #
152
 
Last_SQL_Errno  0
153
 
Last_SQL_Error  
 
74
include/check_slave_is_running.inc
154
75
 
155
76
*** Test lock wait timeout and purged relay logs ***
156
77
SET @my_max_relay_log_size= @@global.max_relay_log_size;
157
78
SET global max_relay_log_size=0;
158
79
include/stop_slave.inc
159
80
DELETE FROM t2;
160
 
CHANGE MASTER TO MASTER_LOG_POS=440;
 
81
CHANGE MASTER TO MASTER_LOG_POS=MASTER_POS_BEGIN;
161
82
BEGIN;
162
83
SELECT * FROM t1 FOR UPDATE;
163
84
a
164
85
1
165
86
1
166
87
START SLAVE;
 
88
include/wait_for_slave_sql_error.inc [errno=1205]
167
89
SELECT COUNT(*) FROM t2;
168
90
COUNT(*)
169
91
0
179
101
3
180
102
3
181
103
3
182
 
SHOW SLAVE STATUS;
183
 
Slave_IO_State  #
184
 
Master_Host     127.0.0.1
185
 
Master_User     root
186
 
Master_Port     MASTER_PORT
187
 
Connect_Retry   1
188
 
Master_Log_File master-bin.000001
189
 
Read_Master_Log_Pos     #
190
 
Relay_Log_File  #
191
 
Relay_Log_Pos   #
192
 
Relay_Master_Log_File   master-bin.000001
193
 
Slave_IO_Running        Yes
194
 
Slave_SQL_Running       Yes
195
 
Replicate_Do_DB 
196
 
Replicate_Ignore_DB     
197
 
Replicate_Do_Table      
198
 
Replicate_Ignore_Table  #
199
 
Replicate_Wild_Do_Table 
200
 
Replicate_Wild_Ignore_Table     
201
 
Last_Errno      0
202
 
Last_Error      
203
 
Skip_Counter    0
204
 
Exec_Master_Log_Pos     #
205
 
Relay_Log_Space #
206
 
Until_Condition None
207
 
Until_Log_File  
208
 
Until_Log_Pos   0
209
 
Master_SSL_Allowed      No
210
 
Master_SSL_CA_File      
211
 
Master_SSL_CA_Path      
212
 
Master_SSL_Cert 
213
 
Master_SSL_Cipher       
214
 
Master_SSL_Key  
215
 
Seconds_Behind_Master   #
216
 
Master_SSL_Verify_Server_Cert   No
217
 
Last_IO_Errno   #
218
 
Last_IO_Error   #
219
 
Last_SQL_Errno  0
220
 
Last_SQL_Error  
 
104
include/check_slave_is_running.inc
221
105
 
222
106
*** Clean up ***
223
107
DROP TABLE t1,t2,t3;
224
108
SET global max_relay_log_size= @my_max_relay_log_size;
225
109
End of 5.1 tests
 
110
include/rpl_end.inc