Bug #28829 replication breaks due to binlogs events written in wrong order
| Submitted: | 1 Jun 2007 10:01 | Modified: | 13 Jun 2007 13:35 |
|---|---|---|---|
| Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 4.1.21,5.0.44 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | replication | ||
[1 Jun 2007 10:01]
Shane Bester
[1 Jun 2007 10:09]
Shane Bester
testcase. point it to the master server and run. watch slave error logs. . see compile, host, user examples a top of the file.
Attachment: bug28829.c (text/plain), 7.19 KiB.
[1 Jun 2007 10:12]
Shane Bester
I started master with clean datadir on 192.168.250.2 ./bin/mysqld_safe --skip-grant-tables --server-id=5 --log-bin --port=3307 --skip-name-resolve & I started slave on 127.0.0.1 with clean datadir: mysqld-debug --console --skip-grant-tables --server-id=3 --log --log-bin --port=3306 On slave, initialized replication: CHANGE MASTER TO MASTER_HOST='192.168.250.2', MASTER_PORT=3307, MASTER_USER='root', MASTER_PASSWORD='12345'; START SLAVE; Then, ran the attached testcase. Slave logs show error in < 1 minute.
[5 Jun 2007 11:16]
Shane Bester
Possibly related to: bug #25144 bug #989
[13 Jun 2007 13:35]
Konstantin Osipov
This bug is a duplicate of Bug#989 "If DROP TABLE while there's an active transaction, wrong binlog order". Please subscribe to the older bug if you're interested in progress on this problem. Thank you.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 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.