| Bug #28018 | The BlackHole cause replication's exception | ||
|---|---|---|---|
| Submitted: | 23 Apr 2007 6:48 | Modified: | 21 Mar 2008 20:21 |
| Reporter: | zhao yongchao | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 4.016;5.0.19;5.0.27, 4.1, 5.1 | OS: | Linux |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[23 Apr 2007 8:35]
Sveta Smirnova
Thank you for the report. Verified as described.
[23 Apr 2007 8:35]
Sveta Smirnova
test case
Attachment: rpl_bug28018.test (application/octet-stream, text), 593 bytes.
[23 Apr 2007 10:11]
Sveta Smirnova
Bug #28019 and Bug #28020 were marked as duplicates of this one
[23 Apr 2007 15:12]
gehaijiang gehaijiang
please resolve this problem
[25 Apr 2007 3:37]
zhao yongchao
thanks for your words!
if i do it like this ,it can recur my situation.
connection master ;
session 1
begin;
insert into t1 (c) values ('30');
open session 2
insert into t1 (c) values ('40');
then open session 1 again;
commit;
what you find may like this;
master :
mysql> select * from t1;
+-----+------+
| i | c |
+-----+------+
| 202 | 30 |
| 203 | 40 |
+-----+------+
2 rows in set (0.00 sec)
slave 00:
mysql> select * from t1;
+-----+------+
| i | c |
+-----+------+
| 202 | 40 |
| 203 | 30 |
+-----+------+
2 rows in set (0.00 sec)
my struction:
master --slave0(blackhole ) --slave 00
os:linux
db:5.0.27
[27 Apr 2007 6:37]
zhao yongchao
hi,Sveta Smirnova can you help me?
[19 Mar 2008 14:19]
Andrei Elkin
Bug #35178 is the parent.
Description: The count of tables was incorrect,when i use the BLACKHOLE engine. i tested it using 4.0.16,5.0.19,5.0.27. The struction of DB like this: /-slave00 /slave0 (blackhole) --slave01 master \slave1 all dbs use innODB(slave0 is not innoDB,of course).After i start the replication, i find the record of tables is not consistent, because the column using auto_increment(BLACKHOLE) take count itselef. when i used innodb's replication, it used the master's counter,so the slave's data is as the same as the master. but in BLACKHOLE it's not!!!!! Waitting for the way to resolve it! thanks! How to repeat: 1. /-slave00 /slave0 (blackhole) --slave01 master \slave1 2.test it!