Bug #39675 rename tables on innodb tables with pending transactions causes slave data issue
| Submitted: | 26 Sep 2008 15:48 | Modified: | 8 Mar 2010 18:55 |
|---|---|---|---|
| Reporter: | Raj Thukral | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
| Version: | 5.0.51a, 4.1, 5.0, 5.1, 6.0 bzr | OS: | Any |
| Assigned to: | Jon Olav Hauglid | CPU Architecture: | Any |
| Tags: | binlog order, innodb, rename table, replication data integrity | ||
[26 Sep 2008 15:48]
Raj Thukral
[27 Sep 2008 7:04]
Shane Bester
i wonder if this is related to bug #989 ?
[27 Sep 2008 15:47]
Sveta Smirnova
Thank you for the report. Verified as described. Test case for our test suite: --source include/master-slave.inc --source include/have_innodb.inc CREATE TABLE `raj` ( `id` int(11) NOT NULL auto_increment, `b` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB; CREATE TABLE `raj_next` ( `id` int(11) NOT NULL auto_increment, `b` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB; insert into raj (b) values (1),(2),(3); begin; insert into raj(b) values (4); connect (addconroot, localhost, root,,); connection addconroot; rename table raj to raj_backup, raj_next to raj; connection master; commit; select * from raj; select * from raj_backup; sleep 1; connection slave; select * from raj; select * from raj_backup;
[27 Sep 2008 17:11]
Davi Arnaut
Will be fixed by WL#4284
[27 Jun 2009 17:12]
Konstantin Osipov
Jon Olav, please add the test case and close the bug (fixed in scope of Bug#989)
[29 Jun 2009 9:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/77435 2812 Jon Olav Hauglid 2009-06-29 Bug #39675 rename tables on innodb tables with pending transactions causes slave data issue Bug was already fixed as part of patch for Bug#989. Test case added to rename.test.
[1 Jul 2009 8:22]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/77621 2812 Jon Olav Hauglid 2009-07-01 Bug #39675 rename tables on innodb tables with pending transactions causes slave data issue Bug was already fixed as part of patch for Bug#989. Test case added to rpl_innodb.test.
[1 Jul 2009 8:46]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/77626 2812 Jon Olav Hauglid 2009-07-01 Bug #39675 rename tables on innodb tables with pending transactions causes slave data issue Bug was already fixed as part of patch for Bug#989 (If DROP TABLE while there's an active transaction, wrong binlog order) Test case added to rpl_innodb.test.
[2 Jul 2009 9:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/77752 2812 Jon Olav Hauglid 2009-07-02 Bug #39675 rename tables on innodb tables with pending transactions causes slave data issue Bug was already fixed as part of patch for Bug#989 (If DROP TABLE while there's an active transaction, wrong binlog order) Test case added to rpl_innodb.test.
[23 Jul 2009 10:24]
Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090723102221-ps4uaphwbxzj8p0q) (version source revid:jon.hauglid@sun.com-20090706071401-fmmqttomxw0v0gjd) (merge vers: 5.4.4-alpha) (pib:11)
[27 Jul 2009 10:51]
Jon Stephens
Documented fix in the 5.4.4 and 6.0.11 changelogs. See Bug #989 for details.
[12 Aug 2009 21:53]
Paul DuBois
Noted in 5.4.2 changelog because next 5.4 version will be 5.4.2 and not 5.4.4.
[14 Aug 2009 22:47]
Paul DuBois
Ignore previous comment about 5.4.2.
[8 Dec 2009 13:23]
Jon Olav Hauglid
Pushed to mysql-next-4284 (5.6.0-beta).
[16 Feb 2010 16:46]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100216101445-2ofzkh48aq2e0e8o) (version source revid:kostja@sun.com-20091211154405-c9yhiewr9o5d20rq) (merge vers: 6.0.14-alpha) (pib:16)
[16 Feb 2010 16:55]
Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100216101208-33qkfwdr0tep3pf2) (version source revid:kostja@sun.com-20091208135954-h6ipvx9mpzmpuipk) (pib:16)
[16 Feb 2010 19:39]
Jon Stephens
Already documented in changelogs for all applicable release series. Closed.
[6 Mar 2010 11:06]
Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100216221947-luyhph0txl2c5tc8) (merge vers: 5.5.99-m3) (pib:16)
[8 Mar 2010 18:55]
Jon Stephens
Also documented in the 5.5.3 changelog. Closed.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.