Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1017

LP #1631816: slave replication breaks after bug #74145 happens in master

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Jericho Rivera last update 28-11-2017 02:47:15

      Originally filed upstream.

      Description:
      On a master-slave replication environment, following the steps to reproduce https://bugs.mysql.com/bug.php?id=74145 using FLUSH SLOW LOGS and not FLUSH LOGS. Slave replication breaks with:

      Last_SQL_Errno: 0
      Last_SQL_Error: Query caused different errors on master and slave. Error on master: message (format)='Invalid error code' error code=29 ; Error on slave: actual message='no error', error code=0. Default database: ''. Query: 'flush slow logs'

      How to repeat:
      Setup master-slave replication servers.

      Do how-to-repeat steps in bug #74145 but use FLUSH SLOW LOGS instead of FLUSH LOGS.
      [root@c7a mysql-5.6.32-linux-glibc2.5-x86_64]# chmod 000 data/c7a-slow.log
      mysql> flush slow logs;
      ERROR 29 (HY000): File './c7a-slow.log' not found (Errcode: 13 - Permission denied)

      Check replication slave status.
      Last_SQL_Error: Query caused different errors on master and slave. Error on master: message (format)='Invalid error code' error code=29 ; Error on slave: actual message='no error', error code=0. Default database: ''. Query: 'flush slow logs'

      Suggested fix:
      Same as FLUSH LOGS, avoid writing FLUSH SLOW LOGS to the binary log.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: