CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT,
8
4
UNIQUE(b));
9
5
INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10;
11
7
a b
12
8
1 10
13
9
2 2
14
show slave status;;
15
Slave_IO_State #
16
Master_Host 127.0.0.1
17
Master_User root
18
Master_Port #
19
Connect_Retry 1
20
Master_Log_File master-bin.000001
21
Read_Master_Log_Pos #
22
Relay_Log_File #
23
Relay_Log_Pos #
24
Relay_Master_Log_File master-bin.000001
25
Slave_IO_Running Yes
26
Slave_SQL_Running No
27
Replicate_Do_DB
28
Replicate_Ignore_DB
29
Replicate_Do_Table
30
Replicate_Ignore_Table
31
Replicate_Wild_Do_Table
32
Replicate_Wild_Ignore_Table
33
Last_Errno 1105
34
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'
35
Skip_Counter 0
36
Exec_Master_Log_Pos 246
37
Relay_Log_Space #
38
Until_Condition None
39
Until_Log_File
40
Until_Log_Pos 0
41
Master_SSL_Allowed No
42
Master_SSL_CA_File
43
Master_SSL_CA_Path
44
Master_SSL_Cert
45
Master_SSL_Cipher
46
Master_SSL_Key
47
Seconds_Behind_Master #
48
Master_SSL_Verify_Server_Cert No
49
Last_IO_Errno 0
50
Last_IO_Error
51
Last_SQL_Errno 1105
52
Last_SQL_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10'
Last_SQL_Error = 'Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1(b) VALUES(1),(1),(2) ON DUPLICATE KEY UPDATE t1.b=10''
53
13
SELECT * FROM t1;
54
14
a b
55
15
stop slave;
94
54
4 4 d 4d
95
55
5 5 e 5e
96
56
6 6 f 6f
97
show slave status;;
98
Slave_IO_State #
99
Master_Host 127.0.0.1
100
Master_User root
101
Master_Port #
102
Connect_Retry 1
103
Master_Log_File master-bin.000001
104
Read_Master_Log_Pos #
105
Relay_Log_File #
106
Relay_Log_Pos #
107
Relay_Master_Log_File master-bin.000001
108
Slave_IO_Running Yes
109
Slave_SQL_Running No
110
Replicate_Do_DB
111
Replicate_Ignore_DB
112
Replicate_Do_Table
113
Replicate_Ignore_Table
114
Replicate_Wild_Do_Table
115
Replicate_Wild_Ignore_Table
116
Last_Errno 1105
117
Last_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)
118
SELECT t2.field_a, t2.field_b, t2.field_c
119
FROM t2
120
ON DUPLICATE KEY UPDATE
121
t1.field_3 = t2.field_c'
122
Skip_Counter 0
123
Exec_Master_Log_Pos 1278
124
Relay_Log_Space #
125
Until_Condition None
126
Until_Log_File
127
Until_Log_Pos 0
128
Master_SSL_Allowed No
129
Master_SSL_CA_File
130
Master_SSL_CA_Path
131
Master_SSL_Cert
132
Master_SSL_Cipher
133
Master_SSL_Key
134
Seconds_Behind_Master #
135
Master_SSL_Verify_Server_Cert No
136
Last_IO_Errno 0
137
Last_IO_Error
138
Last_SQL_Errno 1105
139
Last_SQL_Error Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)
140
SELECT t2.field_a, t2.field_b, t2.field_c
141
FROM t2
142
ON DUPLICATE KEY UPDATE
143
t1.field_3 = t2.field_c'
57
include/wait_for_slave_sql_error.inc [errno=1105]
58
Last_SQL_Error = 'Error 'master may suffer from http://bugs.mysql.com/bug.php?id=24432 so slave stops; check error log on slave for more info' on query. Default database: 'test'. Query: 'INSERT INTO t1 (field_1, field_2, field_3)