[MDEV-739] LP:872754 - Annotate rows events on slave doesnt' work without slave's binlog Created: 2011-10-12 Updated: 2012-10-04 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 10.0.0 |
| Type: | Bug | ||
| Reporter: | Oleg Tsarev (Inactive) | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
master: --binlog_annotate_rows_log_events slave fails with error: if master idle more than --slave_net_timeout. Test-case in attachment. I investigated it, and found the following: Possible fixes: |
| Comments |
| Comment by Oleg Tsarev (Inactive) [ 2011-10-12 ] |
|
Re: Annotate rows events on slave doesnt' work without slave's binlog |
| Comment by Oleg Tsarev (Inactive) [ 2011-10-12 ] |
|
Re: Annotate rows events on slave doesnt' work without slave's binlog |
| Comment by Oleg Tsarev (Inactive) [ 2011-10-12 ] |
|
Test-case for MariaDB |
| Comment by Oleg Tsarev (Inactive) [ 2011-10-12 ] |
|
Re: Annotate rows events on slave doesnt' work without slave's binlog |
| Comment by Oleg Tsarev (Inactive) [ 2011-10-12 ] |
|
Test-case for Percona-Server rnt-5.1 |
| Comment by Kristian Nielsen [ 2011-10-12 ] |
|
Re: Annotate rows events on slave doesnt' work without slave's binlog |
| Comment by Rasmus Johansson (Inactive) [ 2011-10-24 ] |
|
Launchpad bug id: 872754 |
| Comment by Kristian Nielsen [ 2012-10-04 ] |
|
This is fixed in 10.0. If master chooses not to send the annotate event, and the slave is an old MariaDB or MySQL server that will get confused about "holes" in the event stream sent, then a dummy event (empty query event containing just a comment) is sent instead. |