← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_deadlock_innodb.result
50
50
SELECT * FROM t3;
51
51
a
52
52
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  
 
53
Checking that both slave threads are running.
92
54
 
93
55
*** Test lock wait timeout ***
94
56
include/stop_slave.inc
112
74
a
113
75
3
114
76
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  
 
77
Checking that both slave threads are running.
154
78
 
155
79
*** Test lock wait timeout and purged relay logs ***
156
80
SET @my_max_relay_log_size= @@global.max_relay_log_size;
157
81
SET global max_relay_log_size=0;
158
82
include/stop_slave.inc
159
83
DELETE FROM t2;
160
 
CHANGE MASTER TO MASTER_LOG_POS=440;
 
84
CHANGE MASTER TO MASTER_LOG_POS=MASTER_POS_BEGIN;
161
85
BEGIN;
162
86
SELECT * FROM t1 FOR UPDATE;
163
87
a
179
103
3
180
104
3
181
105
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  
 
106
Checking that both slave threads are running.
221
107
 
222
108
*** Clean up ***
223
109
DROP TABLE t1,t2,t3;