Bug #71631 rpl_heartbeat_basic check fails
Submitted: 7 Feb 2014 21:05 Modified: 3 Jul 2014 5:14
Reporter: richard prohaska Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.5.36 OS:Any
Assigned to: CPU Architecture:Any

[7 Feb 2014 21:05] richard prohaska
Description:
rpl.rpl_heartbeat_basic 'mix'            [ pass ]  59361

MTR's internal check of the test case 'rpl.rpl_heartbeat_basic' failed.
This means that the test case does not preserve the state that existed
before the test case was executed.  Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/extra.home/prohaska/distros/mysql-5.5.36-linux2.6-x86_64/mysql-test/var/tmp/check-mysqld_2.log'.
mysqltest: Results saved in '/extra.home/prohaska/distros/mysql-5.5.36-linux2.6-x86_64/mysql-test/var/tmp/check-mysqld_2.result'.
mysqltest: Connecting to server localhost:13001 (socket /extra.home/prohaska/distros/mysql-5.5.36-linux2.6-x86_64/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
--- /extra.home/prohaska/distros/mysql-5.5.36-linux2.6-x86_64/mysql-test/var/tmp/check-mysqld_2.result	2014-02-07 23:59:32.622460258 +0300
+++ /extra.home/prohaska/distros/mysql-5.5.36-linux2.6-x86_64/mysql-test/var/tmp/check-mysqld_2.reject	2014-02-08 00:00:32.305335525 +0300
@@ -612,6 +612,9 @@
 mysql.user	plugin	41		YES	char	64	192	NULL	NULL	utf8	utf8_bin	char(64)			
 mysql.user	authentication_string	42	NULL	YES	text	65535	65535	NULL	NULL	utf8	utf8_bin	text			
 EVENT_CATALOG	EVENT_SCHEMA	EVENT_NAME	DEFINER	TIME_ZONE	EVENT_BODY	EVENT_DEFINITION	EVENT_TYPE	EXECUTE_AT	INTERVAL_VALUE	INTERVAL_FIELD	SQL_MODE	STARTS	ENDSTATUS	ON_COMPLETION	CREATED	LAST_ALTERED	LAST_EXECUTED	EVENT_COMMENT	ORIGINATOR	CHARACTER_SET_CLIENT	COLLATION_CONNECTION	DATABASE_COLLATION
+def	test	e1	root@localhost	SYSTEM	SQL	BEGIN
+UPDATE test.t1 SET a = a + 1 WHERE a < 10;
+END	RECURRING	NULL	1	SECOND		2014-02-07 23:59:49	NULL	SLAVESIDE_DISABLED	NOT PRESERVE	2014-02-07 23:59:49	2014-02-07 23:59:49	NULL		1	latin1	latin1_swedish_ci	latin1_swedish_ci

How to repeat:
./mtr --suite=rpl rpl_heartbeat_basic
[8 Feb 2014 7:19] MySQL Verification Team
Hello Richard,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[26 Apr 2014 17:38] Elena Stepanova
=== modified file 'mysql-test/suite/rpl/t/rpl_heartbeat_basic.test'
--- mysql-test/suite/rpl/t/rpl_heartbeat_basic.test	2012-01-25 18:05:10 +0000
+++ mysql-test/suite/rpl/t/rpl_heartbeat_basic.test	2014-04-26 17:31:54 +0000
@@ -369,7 +369,7 @@
 
 
 # Check received heartbeat events while logs flushed on slave
---connection slave
+--sync_slave_with_master
 --echo *** Flush logs on slave ***
 STOP SLAVE;
 RESET SLAVE;
[3 Jul 2014 5:14] Erlend Dahl
This was fixed in 5.5.37 under the heading of bug#72212.