[MDEV-5754] MySQL 5.5 slaves cannot replicate from MariaDB 10.0 Created: 2014-02-27 Updated: 2014-03-04 Resolved: 2014-03-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.8 |
| Fix Version/s: | 10.0.9 |
| Type: | Bug | Priority: | Major |
| Reporter: | Tom Atkinson | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | gtid | ||
| Description |
|
I have a MariaDB 5.5 master and MySQL 5.5 slave. I updated MariaDB to 10.0.8 and replication failed on the slave with the following message: Got fatal error 1236 from master when reading data from binary log: 'Failed to replace GTID event with backwards-compatible event: currupt event.; the first event 'mysql-bin.000558' at 312, the last event read from 'mysql-bin.000559' at 2590451, the last byte read from 'mysql-bin.000559' at 2590451.' Is this expected to work? |
| Comments |
| Comment by Elena Stepanova [ 2014-02-27 ] | |||||||||||||||
|
We will check this particular failure and if we can reproduce it, quite possibly it will be fixed; but in general, replicating from a newer master to an older slave is not something you should rely on, especially if they are of different major versions. It is supported to some extent, but is never robust enough. The upgrade path is normally the other way round – you upgrade the slave first, then the master. Could you please upload your mysql-bin.000558 and mysql-bin.000559 to our FTP at ftp.askmonty.org/private? | |||||||||||||||
| Comment by Tom Atkinson [ 2014-02-27 ] | |||||||||||||||
|
Files uploaded. | |||||||||||||||
| Comment by Elena Stepanova [ 2014-02-27 ] | |||||||||||||||
|
Tom, The problem happens when the binlog event has a group-commit-ID, e.g.
On a debug server, the master goes down with the assertion failure:
| |||||||||||||||
| Comment by Kristian Nielsen [ 2014-03-04 ] | |||||||||||||||
|
Pushed to 10.0-base and 10.0 |