Bug #80531 rpl.rpl_key_rotation test unstable
Submitted: 26 Feb 2016 14:24 Modified: 27 Jan 2017 4:47
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version:5.7.11 OS:Any
Assigned to: CPU Architecture:Any
Tags: mtr

[26 Feb 2016 14:24] Laurynas Biveinis
Description:
http://jenkins.percona.com/job/mysql-5.7-param/88/BUILD_TYPE=debug,Host=debian-jessie-64bi...:

rpl.rpl_key_rotation 'mix'               w2 [ fail ]
        Test ended at 2016-02-05 14:43:24

CURRENT_TEST: rpl.rpl_key_rotation
--- /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/debian-jessie-64bit/mysql-test/suite/rpl/r/rpl_key_rotation.result	2016-02-05 22:34:12.424000000 +0300
+++ /mnt/workspace/mysql-5.7-param/BUILD_TYPE/debug/Host/debian-jessie-64bit/build/mysql-test/var/2/log/rpl_key_rotation.reject	2016-02-05 22:43:23.972000000 +0300
@@ -100,7 +100,6 @@
 include/start_slave_sql.inc
 SELECT * FROM t4;
 c1	c2
-1	rpltest
 [On Master]
 # Uninstalling keyring_file plugin on master.
 UNINSTALL PLUGIN keyring_file;

mysqltest: Result content mismatch

safe_process[7104]: Child process: 7105, exit: 1

How to repeat:
Only seen once, debugged by code analysis. Might be repeatable by making many copies of the testcase and then --repeat --parallel --do-test=rpl_key_rotation, but I haven't tried.

Suggested fix:
Bit in question is:

--source include/start_slave_sql.inc
--sleep 2
SELECT * FROM t4;

SLEEP is immediately suspicious. Why not

--source include/start_slave_sql.inc
--connection master
--source include/sync_slave_sql_with_master.inc

instead ?
[26 Feb 2016 14:25] Laurynas Biveinis
Bug 80531 fix

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug80531.patch (application/octet-stream, text), 1.04 KiB.

[27 Feb 2016 9:39] Umesh Shastry
Hello Laurynas,

Thank you for the report and contribution.

Thanks,
Umesh
[27 Jan 2017 4:47] Paul Dubois
Posted by developer:
 
Fixed in 5.7.18, 8.0.1.

Work was done for test suite. No changelog entry needed.
[27 Jan 2017 4:52] Paul Dubois
Correction. Changelog entry:

The rpl.rpl_key_rotation test case did not synchronize properly with
the master server. Thanks to Laurynas Biveinis for the patch.