Bug #22877 | replication character sets get out of sync using replicate-wild-ignore-table | ||
---|---|---|---|
Submitted: | 2 Oct 2006 4:07 | Modified: | 17 Nov 2006 18:41 |
Reporter: | Sean Pringle | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.24a | OS: | Linux (Linux) |
Assigned to: | Alexander Barkov | CPU Architecture: | Any |
[2 Oct 2006 4:07]
Sean Pringle
[2 Oct 2006 4:22]
Sean Pringle
Test Case
Attachment: test_case.sql (text/x-sql), 403 bytes.
[2 Oct 2006 11:37]
Sveta Smirnova
Thank you for the report. Verified on Linux as described using last BK sources.
[2 Oct 2006 11:49]
Sveta Smirnova
Character sets both on master and slave before test were in default latin1.
[20 Oct 2006 10:40]
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/14043 ChangeSet@1.2299, 2006-10-20 15:40:48+05:00, bar@mysql.com +4 -0 Bug#22877 replication character sets get out of sync using replicate-wild-ignore-table Problem: changes in character set variables before an action on an replication-ignored table makes slave to forget new variable values. Fix: don't initialize one_shot variables when all_tables_not_ok() - new variable values must affect further queries as well.
[1 Nov 2006 8:29]
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/14651 ChangeSet@1.2299, 2006-11-01 12:30:01+04:00, bar@mysql.com +5 -0 Bug#22877 replication character sets get out of sync using replicate-wild-ignore-table Problem: changes in character set variables before an action on an replication-ignored table makes slave to forget new variable values. Fix: initialize one_shot variables only when 4.1 -> 5.x replication is running.
[3 Nov 2006 9:12]
Alexander Barkov
Merged into 5.1.13-rpl
[16 Nov 2006 16:47]
Alexander Barkov
Appeared in 5.0.32 common Appeared in 5.1.14 common
[17 Nov 2006 18:41]
Paul DuBois
Noted in 5.0.32, 5.1.14 changelogs. Changes to character set variables prior to an action on a replication-ignored table were forgotten by slave servers. I also marked ONE_SHOT as deprecated in the SET OPTION page.