Bug #39470 CREATE VIEW gets written to binlog even on error
| Submitted: | 16 Sep 2008 7:24 | Modified: | 16 Sep 2008 8:22 |
|---|---|---|---|
| Reporter: | Arjen Lentz | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 5.0.38 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | binlog, create view, replication | ||
[16 Sep 2008 8:22]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior with version 5.0.67, although bug is repeatable with earlier versions. Please consider to upgrade.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.046 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.
Description: A CREATE VIEW statement is written to the binlog and processed by slave(s) even if the statement failed. How to repeat: mysql@master> create view Holland as select * from Country; Query OK, 0 rows affected (0.00 sec) mysql@master> show tables; +-----------------+ | Tables_in_world | +-----------------+ | City | | Country | | CountryLanguage | | Holland | +-----------------+ 6 rows in set (0.00 sec) mysql@master> create view Holland as select * from Country; ERROR 1050 (42S01): Table 'Holland' already exists mysql@slave> show slave status\G [...] Last_Errno: 0 Last_Error: Query caused different errors on master and slave. Error on master: 'Table '%-.64s' already exists' (1050), Error on slave: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' (1064). Default database: 'world'. Query: 'CREATE ALGORITHM=UNDEFINED DEFINER=``@`` SQL SECURITY INVOKER VIEW `Holland` AS ' [...] Suggested fix: Do not write unsuccessful CREATE VIEW statements to the binlog.