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 -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
