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

MariaDB fails to decode Anonymous_GTID entries

    XMLWordPrintable

Details

    Description

      When trying to replicate from 5.7.8 to 10.1.5:

                     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.

      Also mysqlbinlog from 10.1.5 fails:

      ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 61, event_type: 34

      From 5.7.8 mysqlbinlog output

      # at 327
      #150827 10:25:04 server id 5708  end_log_pos 388 	Anonymous_GTID	last_committed=1	sequence_number=2
      SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;

      mysql-5.7.8> show global variables like '%gtid%';
      +----------------------------------+-------+
      | Variable_name                    | Value |
      +----------------------------------+-------+
      | binlog_gtid_simple_recovery      | ON    |
      | enforce_gtid_consistency         | OFF   |
      | gtid_executed                    |       |
      | gtid_executed_compression_period | 1000  |
      | gtid_mode                        | OFF   |
      | gtid_owned                       |       |
      | gtid_purged                      |       |
      | session_track_gtids              | OFF   |
      +----------------------------------+-------+
      8 rows in set (0.00 sec)

      It would be nice if replication from 5.7.8 (w/o GTID) to 10.1 would work.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              dveeden Daniël van Eeden
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.