Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5115

RBR from MySQL 5.6 to MariaDB 10.0 does not work

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.4
    • Fix Version/s: 10.0.7
    • Component/s: None
    • Labels:

      Description

      Row-based replication from MySQL 5.6 (tried 5.6.10 and the current tree) to MariaDB 10.0 breaks immediately with

      Last_Errno: 1594
      Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
      

      It happens even if GTID is not enabled on MySQL master.
      SBR seems to work.

      SET binlog_format=ROW;
      CREATE TABLE t1 (i INT);
      INSERT INTO t1 VALUES (1);
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Hide
              serg Sergei Golubchik added a comment -

              This fails, because we didn't merge WL#5917 from 5.6. That task has added new binlog event types, that MariaDB is not aware of.

              We'll need to merge that feature.

              Meanwhile, one can set log_bin_use_v1_row_events=1 as a workaround (on the master side, in MySQL-5.6, on the command line, in the my.cnf, or using the SET GLOBAL statement).

              Show
              serg Sergei Golubchik added a comment - This fails, because we didn't merge WL#5917 from 5.6. That task has added new binlog event types, that MariaDB is not aware of. We'll need to merge that feature. Meanwhile, one can set log_bin_use_v1_row_events=1 as a workaround (on the master side, in MySQL-5.6, on the command line, in the my.cnf, or using the SET GLOBAL statement).

                People

                • Assignee:
                  serg Sergei Golubchik
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 7 hours, 30 minutes
                    7h 30m