[MDEV-7192] binlog_annotate_row_events not completely compatible with galera Created: 2014-11-24 Updated: 2015-03-11 Resolved: 2015-03-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.0.14-galera |
| Fix Version/s: | 5.5.43-galera, 10.0.17-galera |
| Type: | Bug | Priority: | Minor |
| Reporter: | Brad Jorgensen | Assignee: | Nirbhay Choubey (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | galera | ||
| Environment: |
CentOS 6.5 |
||
| Attachments: |
|
| Description |
|
When using binlog_annotate_row_events in a galera cluster, row events in the binlog originating from the local node are annotated correctly. However, events originating on other nodes are annotated with an incorrect query. This makes sense since I don't think galera provides information about the query that generated an event. Without adding significant overhead to galera replication, the only thing I can think of for this would be to disable annotations for events originating from other nodes. This way, not every event would be annotated, but the ones that are would at least be correct. I attached some lightly redacted decoded binlog events. If needed, I can find some events I can leave intact with some more searching. |
| Comments |
| Comment by Nirbhay Choubey (Inactive) [ 2015-03-05 ] | |||||
|
http://lists.askmonty.org/pipermail/commits/2015-March/007518.html | |||||
| Comment by Jan Lindström (Inactive) [ 2015-03-05 ] | |||||
|
So I take this patch fixes the annotiation originating from other nodes. Patch is fine there is maybe a small error on test in following:
| |||||
| Comment by Nirbhay Choubey (Inactive) [ 2015-03-05 ] | |||||
|
Hi jplindst! Yes, that was an omissions. While fixing it, I also found some of the rpl_group_info's http://lists.askmonty.org/pipermail/commits/2015-March/007524.html | |||||
| Comment by Nirbhay Choubey (Inactive) [ 2015-03-05 ] | |||||
|
https://github.com/MariaDB/server/commit/9af42db6138a555454b7631761b81f8d259f014e |