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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.4
    • 10.0.7
    • None

    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);

      Attachments

        Issue Links

          Activity

            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).

            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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.