| Bug #20438 | CREATE statements for views, stored routines and triggers can be not replicable | ||
|---|---|---|---|
| Submitted: | 13 Jun 2006 22:39 | Modified: | 15 Aug 2006 14:52 |
| Reporter: | Alexander Nozdrin | ||
| Status: | Closed | ||
| Category: | Server: SP | Severity: | S2 (Serious) |
| Version: | 5.0.23 | OS: | Any (all) |
| Assigned to: | Alexander Nozdrin | Target Version: | |
[13 Jun 2006 22:48]
Alexander Nozdrin
The same problem is with CREATE VIEW statements.
[28 Jun 2006 1:12]
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/8357
[19 Jul 2006 12:36]
Alexander Nozdrin
BUG#21035 "Restoring a database from a dump containing triggers breaks the replication" has been marked as a duplicate of this bug.
[19 Jul 2006 13:19]
Valeriy Kravchuk
Bug #20014 "CREATE VIEW w/ 'version comments' break in replication" mrked as a duplicate of this one.
[28 Jul 2006 0:50]
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/9686
[28 Jul 2006 0:52]
Alexander Nozdrin
Approved by Dmitry by IRC.
[2 Aug 2006 17:50]
Konstantin Osipov
Pushed into 5.0.25
[14 Aug 2006 22:37]
Konstantin Osipov
Merged into 5.1.12
[15 Aug 2006 14:52]
Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.
If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at
http://dev.mysql.com/doc/en/installing-source.html
Documented bugfix in 5.0.25 and 5.1.12 changelogs.
[6 Feb 19:25]
Valeriy Kravchuk
Bug #42653 was marked as a duplicate of this one.
Description: CREATE-statements for stored routines and triggers that contain comments (/* ... */) are dumped incorrectly in binlog, thus are not replicable. The problem is in a way of creating bin-log-record for such statements -- there is an error in handling comments. In particular, this bug means that mysqldump-generated CREATE-statements are not replicable for stored routines and triggers. How to repeat: - Start master and slave; - Execute the code with comments; - Examine slave log; For example: The code: /*!50003 CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1 */; This statement is logged as: CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a = 1 */ The problem is in the trailing '*/'.