Bug #31725 | Slave runs replication queries in wrong schema | ||
---|---|---|---|
Submitted: | 20 Oct 2007 12:16 | Modified: | 23 Oct 2007 15:18 |
Reporter: | Patrick Galbraith | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.0.22 | OS: | Any (ubuntu 6.0.1 LTS Dapper) |
Assigned to: | CPU Architecture: | Any | |
Tags: | 5.0.22-Debian_0ubuntu6.06.3-log |
[20 Oct 2007 12:16]
Patrick Galbraith
[20 Oct 2007 12:22]
Patrick Galbraith
master my.cnf: # replication server-id = 1 #slave-skip-errors = all log-bin = /var/lib/mysql/bin.log log-bin-index = /var/lib/mysql/log-bin.index expire-logs-days = 5 auto_increment_increment = 10 auto_increment_offset = 1 slave my.cnf (I tried to use "wildcard" but it doesn't replicate if I do): # The following can be used as easy to replay backup logs or for replication. server-id = 2 expire-logs-days = 4 #max_binlog_size = 104857600 # replication log-error = /var/lib/mysql/error.log log-warnings = 2 #slave-skip-errors = all relay-log = /var/lib/mysql/relay.log relay-log-info-file = /var/lib/mysql/relay-log.info relay-log-index = /var/lib/mysql/relay-log.index auto_increment_increment = 10 auto_increment_offset = 2 master-host = host master-user = user master-password = pass #replicate-wild-do-table = grazrserver.* #replicate-wild-do-table = grazr_accounts.* #replicate-wild-ignore-table = test.* #replicate-wild-ignore-table = regression.* #replicate-wild-ignore-table = mysql.* replicate-do-db = grazr_accounts replicate-do-db = grazrserver
[20 Oct 2007 12:37]
Sveta Smirnova
Thank you for the report. But version 5.0.22 is quite old and many replication bugs have been fixed since. Please try with current version 5.0.45 and if problem still persists provide binary log file.
[22 Oct 2007 14:15]
Patrick Galbraith
Sveta, Spasibo - thank you for you reply. I was hoping to keep within the confines of Ubuntu's package management for MySQL, but there doesn't seem to be a deb package for 5.0.45, only 5.0.22, so I will try source compile. I'll test with that version, and note my findings in this bug report about the results.
[23 Oct 2007 14:24]
Patrick Galbraith
This bug is not a problem with latest 5.0.45. We will upgrade to 5.0.45. Also, bug #20614 is fixed in 5.0.45.
[23 Oct 2007 15:18]
Sveta Smirnova
Thank you for the feedback. The report closed as "Can't repeat" because last comment.