MySQL Bugs: #42891: RPL tests do not clean up after themselves

Bug #42891	RPL tests do not clean up after themselves
Submitted:	16 Feb 2009 16:16	Modified:	12 Nov 2009 12:07
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S3 (Non-critical)
Version:	6.0-TRUNK	OS:	Any
Assigned to:	Serge Kozlov	CPU Architecture:	Any

Description:
After pushing MTR2 there are warnings that the following tests do not
return environment to its original state:
  - rpl.rpl_bug31076
  - rpl.rpl_heartbeat
  - rpl.rpl_incident
  - rpl.rpl_known_bugs_detection
  - rpl.rpl_loaddata_fatal
  - rpl.rpl_row_4_bytes
  - rpl.rpl_row_stop_middle_update
  - rpl.rpl_spec_variables
  - rpl.rpl_temporary_errors

Complains are as follows:
  - rpl.rpl_bug31076
-----------------------------------------------------------------
@@ -314,7 +314,6 @@
 NULL	mysql	latin1	latin1_swedish_ci	NULL
 NULL	test	latin1	latin1_swedish_ci	NULL
 tables_in_test
-t1
 tables_in_mysql
 mysql.backup_history
 mysql.backup_progress
-----------------------------------------------------------------

  - rpl.rpl_heartbeat
-----------------------------------------------------------------
@@ -251,7 +251,7 @@
 SLAVE_COMPRESSED_PROTOCOL	OFF
 SLAVE_EXEC_MODE	STRICT
 SLAVE_LOAD_TMPDIR	../../tmp
-SLAVE_NET_TIMEOUT	120
+SLAVE_NET_TIMEOUT	10
 SLAVE_SKIP_ERRORS	
 SLAVE_TRANSACTION_RETRIES	10
 SLOW_LAUNCH_TIME	2
-----------------------------------------------------------------

  - rpl.rpl_incident
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,incident_database_resync_on_replace
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

  - rpl.rpl_known_bugs_detection
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,pretend_version_50034_in_binlog
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

  - rpl.rpl_loaddata_fatal
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,LOAD_DATA_INFILE_has_fatal_error
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

  - rpl.rpl_row_4_bytes
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,old_row_based_repl_4_byte_map_id_master
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

  - rpl.rpl_row_stop_middle_update
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,STOP_SLAVE_after_first_Rows_event
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

  - rpl.rpl_spec_variables
-----------------------------------------------------------------
@@ -314,7 +314,7 @@
 SSL_CERT	/data0/pushbuild/pb/bzr_mysql-6.0/126/bzr_mysql-6.0-exp/mysql-test/std_data/server-cert.pem
 SSL_CIPHER	
 SSL_KEY	/data0/pushbuild/pb/bzr_mysql-6.0/126/bzr_mysql-6.0-exp/mysql-test/std_data/server-key.pem
-STORAGE_ENGINE	MyISAM
+STORAGE_ENGINE	InnoDB
 SYNC_BINLOG	0
 SYNC_FRM	OFF
 SYNC_RELAY_LOG	0
-----------------------------------------------------------------

  - rpl.rpl_temporary_errors
-----------------------------------------------------------------
@@ -37,7 +37,7 @@
 DEADLOCK_SEARCH_DEPTH_SHORT	4
 DEADLOCK_TIMEOUT_LONG	50000000
 DEADLOCK_TIMEOUT_SHORT	10000
-DEBUG	d,all_errors_are_temporary_errors
+DEBUG	
 DEBUG_SYNC	ON - current signal: ''
 DEFAULT_WEEK_FORMAT	0
 DELAYED_INSERT_LIMIT	100
-----------------------------------------------------------------

How to repeat:
Run the test suite.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/69345

3117 Serge Kozlov	2009-03-16
      Bug#42891: Clean up for rpl_heartbeat, rpl_spec_variables
      modified:
        mysql-test/suite/rpl/r/rpl_heartbeat.result
        mysql-test/suite/rpl/r/rpl_spec_variables.result
        mysql-test/suite/rpl/t/rpl_heartbeat.test
        mysql-test/suite/rpl/t/rpl_spec_variables.test

Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:joro@sun.com-20090317133112-41qn6aly7arljtlq) (merge vers: 6.0.11-alpha) (pib:6)

Change was in test only; no user-facing changes. Closed bug without taking any further action.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/86482

3133 Serge Kozlov	2009-10-10
      Bug#42891: Tests cleanup
      Fix for backport into mysql-5.1-rep+2
      modified:
        mysql-test/suite/rpl/r/rpl_heartbeat.result
        mysql-test/suite/rpl/t/rpl_heartbeat.test

Pushed into 6.0.14-alpha (revid:alik@sun.com-20091027094604-9p7kplu1vd2cvcju) (version source revid:zhenxing.he@sun.com-20091026140226-uhnqejkyqx1aeilc) (merge vers: 6.0.14-alpha) (pib:13)

Closed w/o further action; see my previous comment.

Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:alik@sun.com-20091027095744-rf45u3x3q5d1f5y0) (merge vers: 5.5.0-beta) (pib:13)

Re-closed w/o further action; see previous comments.