[MDEV-6168] rpl.rpl_heartbeat_basic fails mtr internal check Created: 2014-04-24  Updated: 2014-04-26  Resolved: 2014-04-26

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.37
Fix Version/s: 5.5.38

Type: Bug Priority: Minor
Reporter: Rich Prohaska Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: upstream
Environment:

linux centos 6.2 debug build



 Description   

./mtr rpl.rpl_heartbeat_basic
 
rpl.rpl_heartbeat_basic 'mix'            [ pass ]  55221
 
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/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.log'.
mysqltest: Results saved in '/extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.result'.
mysqltest: Connecting to server localhost:16001 (socket /extra.home/prohaska/mariadb-5.5.37-install/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/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.result	2014-04-24 12:52:59.490405310 -0400
+++ /extra.home/prohaska/mariadb-5.5.37-install/mysql-test/var/tmp/check-mysqld_2.reject	2014-04-24 12:53:55.089530393 -0400
@@ -722,6 +722,9 @@
 mysql.user	plugin	41		NO	char	64	64	NULL	NULL	latin1	latin1_swedish_ci	char(64)			
 mysql.user	authentication_string	42	NULL	NO	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-04-24 12:53:16	NULL	SLAVESIDE_DISABLED	NOT PRESERVE	2014-04-24 12:53:16	2014-04-24 12:53:16	NULL		1	latin1	latin1_swedish_ci	latin1_swedish_ci
 TRIGGER_CATALOG	TRIGGER_SCHEMA	TRIGGER_NAME	EVENT_MANIPULATION	EVENT_OBJECT_CATALOG	EVENT_OBJECT_SCHEMA	EVENT_OBJECT_TABLE	ACTION_ORDER	ACTION_CONDITION	ACTION_STATEMENT	ACTION_ORIENTATION	ACTION_TIMING	ACTION_REFERENCE_OLD_TABLE	ACTION_REFERENCE_NEW_TABLE	ACTION_REFERENCE_OLD_ROW	ACTION_REFERENCE_NEW_ROW	CREATED	SQL_MODE	DEFINER	CHARACTER_SET_CLIENT	COLLATION_CONNECTION	DATABASE_COLLATION
 SPECIFIC_NAME	ROUTINE_CATALOG	ROUTINE_SCHEMA	ROUTINE_NAME	ROUTINE_TYPE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	DATETIME_PRECISION	CHARACTER_SET_NAME	COLLATION_NAME	DTD_IDENTIFIER	ROUTINE_BODY	ROUTINE_DEFINITION	EXTERNAL_NAME	EXTERNAL_LANGUAGE	PARAMETER_STYLE	IS_DETERMINISTIC	SQL_DATA_ACCESS	SQL_PATH	SECURITY_TYPE	CREATED	LAST_ALTERED	SQL_MODE	ROUTINE_COMMENT	DEFINER	CHARACTER_SET_CLIENT	COLLATION_CONNECTION	DATABASE_COLLATION
 add_suppression	def	mtr	add_suppression	PROCEDURE		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	SQL	BEGIN   INSERT INTO test_suppressions (pattern) VALUES (pattern); END	NULL	NULL	SQL	NO	CONTAINS SQL	NULL	DEFINER	2014-04-24 12:52:50	2014-04-24 12:52:50			root@localhost	utf8	utf8_general_ci	latin1_swedish_ci
 
mysqltest: Result length mismatch
 
not ok
 
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 55.221 of 70 seconds executing testcases
 
Check of testcase failed for: rpl.rpl_heartbeat_basic



 Comments   
Comment by Elena Stepanova [ 2014-04-26 ]

The problem appeared in the upstream tree after a check for events was added:

revno: 4558
revision-id: sayantan.dutta@oracle.com-20131212065057-xl4jjsx581mpnpv8
parent: guilhem.bichot@oracle.com-20131204113242-977a3wsclnh3uz7w
committer: sayantan dutta <sayantan.dutta@oracle.com>
branch nick: mysql-5.5
timestamp: Thu 2013-12-12 12:20:57 +0530
message:
  Bug #17827378 - MTR DOES NOT REPORT IF A TEST FAILS TO DROP CREATED EVENTS

Fix pushed into 5.5 tree:
http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4164

Generated at Thu Feb 08 07:09:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.