[MDEV-8573] Temporary Tables break replication in MIXED binlog_format Created: 2015-08-07 Updated: 2019-07-09 Resolved: 2019-07-02 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Temporary, Replication |
| Affects Version/s: | 10.0.20, 10.0, 10.1 |
| Fix Version/s: | 10.0.36, 10.1.35, 10.2.17, 10.3.9 |
| Type: | Bug | Priority: | Major |
| Reporter: | Derek Downey | Assignee: | Sujatha Sivakumar (Inactive) |
| Resolution: | Duplicate | Votes: | 1 |
| Labels: | replication | ||
| Environment: |
CentOS 6.4 |
||
| Attachments: |
|
| Description |
|
We have run into a scenario where replication breaks on slaves when using MIXED replication and temporary tables. After a session is switched to ROW due to temporary tables existing, all subsequent events for the session should be in ROW. DDL statements affecting Temporary Tables in ROW format should not be logged.
Expected behavior Actual behavior Attaching output from both mysql 5.6 and mariadb 10.0.20 attached, and the binlog from mariadb test. |
| Comments |
| Comment by Elena Stepanova [ 2015-08-07 ] |
|
Thanks for the report. |
| Comment by Sujatha Sivakumar (Inactive) [ 2019-07-02 ] |
|
The issue has been fixed as part of |