Bug #42889 Backup tests do not clean up afer themselves

• Submitted: 16 Feb 2009 16:08
• Modified: 26 Mar 2009 15:29
• Reporter: Alexander Nozdrin
• Status: Can't repeat
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 6.0-TRUNK
• OS: Any
• Assigned to: Jørgen Løland
• CPU Architecture: Any

[16 Feb 2009 16:08] Alexander Nozdrin

Description:
After pushing MTR2 there are warnings that the following tests do not return environment to its original state:
  - backup.backup_logs
  - backup.backup_logs_output

Complains are as follows:
- backup.backup_logs:
---------------------------------------------------------------------------
MTR's internal check of the test case 'backup.backup_logs' 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.
This is the diff of the states of the servers before and after the
test case was executed:
--- /dev/shm/var-n_mix-110/tmp/check-mysqld_1.result	2009-02-15 00:39:09.503884500 +0300
+++ /dev/shm/var-n_mix-110/tmp/check-mysqld_1.reject	2009-02-15 00:39:13.420129250 +0300
@@ -162,7 +162,7 @@
 LOCAL_INFILE	ON
 LOCKED_IN_MEMORY	OFF
 LOG	ON
-LOG_BACKUP_OUTPUT	TABLE
+LOG_BACKUP_OUTPUT	FILE,TABLE
 LOG_BIN	ON
 LOG_BIN_TRUST_FUNCTION_CREATORS	ON
 LOG_ERROR	/dev/shm/var-n_mix-110/mysqld.1/mysqld.err
@@ -635,4 +635,4 @@
 mysql.time_zone_name	4114777634
 mysql.time_zone_transition	3895294076
 mysql.time_zone_transition_type	2971017514
-mysql.user	1791318475
+mysql.user	4249335447
---------------------------------------------------------------------------

- backup.backup_logs_output:
---------------------------------------------------------------------------
--- /dev/shm/t0/var/tmp/check-mysqld_1.result	2009-02-16 15:41:56.701241177 +0300
+++ /dev/shm/t0/var/tmp/check-mysqld_1.reject	2009-02-16 15:41:58.725241461 +0300
@@ -6,9 +6,9 @@
 AUTO_INCREMENT_OFFSET	1
 BACKUPDIR	/dev/shm/t0/var/mysqld.1/data/
 BACKUP_HISTORY_LOG	ON
-BACKUP_HISTORY_LOG_FILE	/dev/shm/t0/var/master-data/history.txt
+BACKUP_HISTORY_LOG_FILE	/dev/shm/t0/var/mysqld.1/data/backup_history.log
 BACKUP_PROGRESS_LOG	ON
-BACKUP_PROGRESS_LOG_FILE	/dev/shm/t0/var/master-data/progress.txt
+BACKUP_PROGRESS_LOG_FILE	/dev/shm/t0/var/mysqld.1/data/backup_progress.log
 BACKUP_WAIT_TIMEOUT	50
 BACK_LOG	50
 BASEDIR	/mnt/raid/alik/MySQL/bzr/bug42384/6.0-rt-bug42384/
---------------------------------------------------------------------------

How to repeat:
Run the test suite.