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

Error messages written upon LOST EVENTS incident are corrupted

    XMLWordPrintable

    Details

      Description

      MySQL now uses LOST EVENTS incidents when s GRANT/REVOKE statement partially fails:
      http://bugs.mysql.com/bug.php?id=68892
      http://www.dbasquare.com/2013/04/09/granting-privileges-may-break-replication-in-mysql-5-6-10/

      Replication is supposed to abort, and the discrepancy to be treated manually.
      This works with 10.0 as a slave, but the error message which 10.0 writes into the error log and shows in SLAVE STATUS upon this incident is corrupted:

      Last_Error: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log�y�K
       
      Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log<E9>y<CD>K, Internal MariaDB error code: 1590

      MySQL writes a clean message:

      Last_SQL_Error: TThe incident LOST_EVENTS occured on the master. Message: error writing to the binary log
       
      Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code: 1590

      To reproduce:

      # Set up replication MySQL 5.6 => MariaDB 10.0
       
      # Execute on 5.6 master:
       
      grant all on db.* to user1, user2;
      revoke all on db.* from user1, user1;
      # An error will occur (expected):
      # ERROR 1141 (42000): There is no such grant defined for user 'user1' on host '%'
       
      # On 10.0 slave, wait till replication aborts (expected), see the error message

      revision-id: monty@askmonty.org-20140304183748-2wo25348vicg2qgp
      revno: 4028
      branch-nick: 10.0

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              knielsen Kristian Nielsen
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration