| Bug #20438 | CREATE statements for views, stored routines and triggers can be not replicable | ||
|---|---|---|---|
| Submitted: | 13 Jun 2006 20:39 | Modified: | 15 Aug 2006 12:52 |
| Reporter: | Alexander Nozdrin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S2 (Serious) |
| Version: | 5.0.23 | OS: | Any (all) |
| Assigned to: | Alexander Nozdrin | CPU Architecture: | Any |
[13 Jun 2006 20:48]
Alexander Nozdrin
The same problem is with CREATE VIEW statements.
[27 Jun 2006 23: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 10: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 11:19]
Valeriy Kravchuk
Bug #20014 "CREATE VIEW w/ 'version comments' break in replication" mrked as a duplicate of this one.
[27 Jul 2006 22: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
[27 Jul 2006 22:52]
Alexander Nozdrin
Approved by Dmitry by IRC.
[2 Aug 2006 15:50]
Konstantin Osipov
Pushed into 5.0.25
[14 Aug 2006 20:37]
Konstantin Osipov
Merged into 5.1.12
[15 Aug 2006 12: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 2009 18: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 '*/'.