enterprise-support team mailing list archive
-
enterprise-support team
-
Mailing list archive
-
Message #05762
[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