Attached test case can be used to repeat the issue. In the end it will print something like:
[connection server_1] select count(*) from t1; count(*) 1325 <<<<<<<< ==== Number of rows on master [connection server_4] start slave; select OBJECT_NAME, count_star, AVG_TIMER_WAIT/1024/1024/1024 from performance_schema.table_io_waits_summary_by_table where OBJECT_SCHEMA='mysql' and OBJECT_NAME ='slave_master_info'; OBJECT_NAME count_star AVG_TIMER_WAIT/1024/1024/1024 slave_master_info 36 11.149680108763 <<<< Remember IO numbers select table_name, io_write_requests, io_write from sys.schema_table_statistics where table_name='slave_master_info'; table_name io_write_requests io_write slave_master_info 11 176.00 KiB <<<< Remeber IO numbers select * from performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID THREAD_ID SERVICE_STATE COUNT_RECEIVED_HEARTBEATS LAST_HEARTBEAT_TIMESTAMP RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP channel_1 922a4d56-7701-11e7-8781-30b5c2208a0f 64 ON 4 2017-08-02 00:43:22 922a4d56-7701-11e7-8781-30b5c2208a0f:1-357 0 0000-00-00 00:00:00 channel_2 925a4dbc-7701-11e7-8691-30b5c2208a0f 70 ON 4 2017-08-02 00:43:24 922a4d56-7701-11e7-8781-30b5c2208a0f:1-53 0 0000-00-00 00:00:00 channel_3 92a8be79-7701-11e7-86b1-30b5c2208a0f 76 ON 4 2017-08-02 00:43:26 922a4d56-7701-11e7-8781-30b5c2208a0f:1-57 0 0000-00-00 00:00:00 select count(*) from t1; count(*) 1325 <<<<<<<< ==== Slave D received all changes from A [connection server_2] start slave; [connection server_3] start slave; [connection server_4] select OBJECT_NAME, count_star, AVG_TIMER_WAIT/1024/1024/1024 from performance_schema.table_io_waits_summary_by_table where OBJECT_SCHEMA='mysql' and OBJECT_NAME ='slave_master_info'; OBJECT_NAME count_star AVG_TIMER_WAIT/1024/1024/1024 slave_master_info 46 22.199227280915 <<<<< 46 > 36 select table_name, io_write_requests, io_write from sys.schema_table_statistics where table_name='slave_master_info'; table_name io_write_requests io_write slave_master_info 15 240.00 KiB <<<<< 15 > 11 select * from performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID THREAD_ID SERVICE_STATE COUNT_RECEIVED_HEARTBEATS LAST_HEARTBEAT_TIMESTAMP RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP channel_1 922a4d56-7701-11e7-8781-30b5c2208a0f 64 ON 7 2017-08-02 00:46:22 922a4d56-7701-11e7-8781-30b5c2208a0f:1-357 0 0000-00-00 00:00:00 channel_2 925a4dbc-7701-11e7-8691-30b5c2208a0f 70 ON 10 2017-08-02 00:45:29 922a4d56-7701-11e7-8781-30b5c2208a0f:1-53:58-81 0 0000-00-00 00:00:00 channel_3 92a8be79-7701-11e7-86b1-30b5c2208a0f 76 ON 7 2017-08-02 00:45:33 922a4d56-7701-11e7-8781-30b5c2208a0f:1-57:59-80 0 0000-00-00 00:00:00 select count(*) from t1; count(*) 1325 <<<<<<<< ==== No new rows added ** Attachment added: "configuration file" https://bugs.launchpad.net/percona-server/+bug/1708033/+attachment/4925536/+files/rpl_bug85158.cnf ** Also affects: percona-server/5.6 Importance: Undecided Status: New ** Also affects: percona-server/5.5 Importance: Undecided Status: New ** Also affects: percona-server/5.7 Importance: Undecided Status: Confirmed ** Changed in: percona-server/5.5 Status: New => Invalid ** Changed in: percona-server/5.6 Status: New => Invalid ** Bug watch added: MySQL Bug System #85158 http://bugs.mysql.com/bug.php?id=85158 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=85158 Importance: Unknown Status: Unknown -- 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/1708033 Title: heartbeats/fakerotate cause a forced sync_master_info To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1708033/+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
