[MDEV-368] Feature Request: Switch to ROW format if a query is logged with a replication-critical error, like ER_QUERY_INTERRUPTED Created: 2012-06-26 Updated: 2012-06-27 Resolved: 2012-06-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | 5.5.27 |
| Type: | Task | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Kristian Nielsen |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
In case of SBR/MBR, if a query executed on master has already modified something that cannot be rolled back, and it gets interrupted in the middle, it is written to the binlog with the corresponding error code.
This happens on maria/5.5 revno 3458, and of course before it too, as well as on MySQL 5.5/5.6. (5.1-based versions too, but it obviously makes no sense to touch them). In case of SBR it is probably unavoidable. But if MBR is used, it could make sense to log such changes in row mode, which works perfectly fine (only updated rows are written, no error code is needed, replication goes as usual). Test case
|
| Comments |
| Comment by Kristian Nielsen [ 2012-06-27 ] |
|
I do not think this will work. When the query is killed, we do not have the necessary row data available. Mixed-mode binlogging is based on determining whether statement or row should |