← Back to team overview

enterprise-support team mailing list archive

[Bug 1631816] [NEW] slave replication breaks after bug #74145 happens in master

 

Public bug reported:

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.

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed


** Tags: i142397

** Bug watch added: MySQL Bug System #83232
   http://bugs.mysql.com/bug.php?id=83232

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=83232
   Importance: Unknown
       Status: Unknown

** Changed in: percona-server
       Status: New => Confirmed

** Tags added: 142397

** Tags removed: 142397
** Tags added: i142397

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1631816

Title:
  slave replication breaks after bug #74145 happens in master

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1631816/+subscriptions


Follow ups