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

Replication 5.6=>10.0 fails with binlog_rows_query_log_events=ON on master

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.8
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None

          Description

          master:

          MySQL [test]> set binlog_rows_query_log_events=ON;
Query OK, 0 rows affected (0.00 sec)

MySQL [test]> create table t1 (i int, c varchar(8));
Query OK, 0 rows affected (0.56 sec)

MySQL [test]> insert into t1 values (1,'a'),(2,'b');
Query OK, 2 rows affected (0.07 sec)
Records: 2  Duplicates: 0  Warnings: 0

          Slave:

                         Last_SQL_Errno: 1594
               Last_SQL_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 might be an unavoidable limitation, in which case it needs to be documented (as it is in MySQL docs for replicating to pre-5.6.2 slaves).

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Task - A task that needs to be done. MDEV-5705 replication testing: 5.6->10.0

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      2 Vote for this issue
                      Watchers:
                      8 Start watching this issue

                      Dates

                      • Created:
                        Updated: