rpl_deadlock_innodb.result 3.81 KB
Newer Older
1 2 3 4 5 6
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
7 8
CREATE TABLE t1 (a INT NOT NULL, KEY(a)) ENGINE=innodb;
CREATE TABLE t2 (a INT NOT NULL, KEY(a)) ENGINE=innodb;
9
CREATE TABLE t3 (a INT  UNIQUE) ENGINE=innodb;
10
CREATE TABLE t4 (a INT) ENGINE=innodb;
11 12
show variables like 'slave_transaction_retries';
Variable_name	Value
13
slave_transaction_retries	10
14 15 16
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
17
  `a` int(11) NOT NULL,
18 19 20 21 22
  KEY `a` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
show create table t2;
Table	Create Table
t2	CREATE TABLE `t2` (
23
  `a` int(11) NOT NULL,
24 25
  KEY `a` (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
26 27 28
show variables like 'slave_transaction_retries';
Variable_name	Value
slave_transaction_retries	2
29 30
stop slave;
begin;
31
insert into t2 values (0);
32 33 34 35 36 37
insert into t1 values(1);
commit;
begin;
select * from t1 for update;
a
start slave;
38 39
select * from t2 for update /* dl */;
a
40 41 42 43
commit;
select * from t1;
a
1
44
select * from t2 /* must be 1 */;
45
a
46
0
47
show slave status;
48 49 50 51 52 53
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_MYPORT
Connect_Retry	1
Master_Log_File	master-bin.000001
54
Read_Master_Log_Pos	#
55 56 57 58 59 60 61 62
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
63
Replicate_Ignore_Table	#
64 65 66 67 68
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
69
Exec_Master_Log_Pos	#
70 71 72 73 74 75 76 77 78 79 80
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
81
Master_SSL_Verify_Server_Cert	No
82
stop slave;
83 84
delete from t3;
change master to master_log_pos=544;
85 86 87
begin;
select * from t2 for update;
a
88
0
89
start slave;
90 91 92
select count(*) from t3  /* must be zero */;
count(*)
0
93 94 95 96 97 98 99
commit;
select * from t1;
a
1
1
select * from t2;
a
100 101
0
0
102
show slave status;
103 104 105 106 107 108
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_MYPORT
Connect_Retry	1
Master_Log_File	master-bin.000001
109
Read_Master_Log_Pos	#
110 111 112 113 114 115 116 117
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	#
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
118
Replicate_Ignore_Table	#
119 120 121 122 123
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
124
Exec_Master_Log_Pos	#
125 126 127 128 129 130 131 132 133 134 135
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
136
Master_SSL_Verify_Server_Cert	No
137
set @my_max_relay_log_size= @@global.max_relay_log_size;
138 139
set global max_relay_log_size=0;
stop slave;
140 141
delete from t3;
change master to master_log_pos=544;
142 143 144
begin;
select * from t2 for update;
a
145 146
0
0
147
start slave;
148 149 150
select count(*) from t3  /* must be zero */;
count(*)
0
151 152 153 154 155 156 157 158
commit;
select * from t1;
a
1
1
1
select * from t2;
a
159 160 161
0
0
0
162
show slave status;
163 164 165 166 167 168
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_MYPORT
Connect_Retry	1
Master_Log_File	master-bin.000001
169
Read_Master_Log_Pos	#
170 171 172 173 174 175 176 177
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	#
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
178
Replicate_Ignore_Table	#
179 180 181 182 183
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
184
Exec_Master_Log_Pos	#
185 186 187 188 189 190 191 192 193 194 195
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
196
Master_SSL_Verify_Server_Cert	No
197
drop table t1,t2,t3,t4;
198
set global max_relay_log_size= @my_max_relay_log_size;
199
End of 5.1 tests