Description:
The test backup_xpfm_compat_backup_lctn2 will hang on the Windows platform. This can be seen in PB2 for mysql-6.0-backup-merge on the win x86_64_max platform.
I have also verified it occurs on Windows 7 32-bit.
NOTE: A workaround will be put in place to ensure the tables are flushed before the DROP DATABASE commands. The FLUSH TABLES command should be removed when this bug is fixed.
=== modified file 'mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc'
--- mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc 2009-07-20 09:27:48 +0000
+++ mysql-test/suite/backup/include/backup_xpfm_compat_backup.inc 2009-11-17 19:24:17 +0000
@@ -897,6 +897,9 @@ DROP USER 'no_user'@'%';
DROP USER 'bup_user1'@'%';
DROP USER 'BUP_USER2';
DROP USER 'BupUser3'@'%';
+--disable_query_log
+FLUSH TABLES;
+--enable_query_log
DROP DATABASE bup_xpfm_compat_db1;
DROP DATABASE BUP_XPFM_COMPAT_DB2;
DROP DATABASE BupXPfmCompat_db3;
How to repeat:
If you use manual debug you will see warnings like the following during the DROP DATABASE commands at the end of the included test.
091117 11:48:12 InnoDB: Warning: MySQL is trying to drop database `bup_xpfm_com
pat_db1`.`` InnoDB: though there are still open handles to table `bup_xpfm_compat_db1`.`table2`.
091117 11:48:13 InnoDB: Warning: MySQL is trying to drop database `bup_xpfm_com
pat_db1`.`` InnoDB: though there are still open handles to table `bup_xpfm_compat_db1`.`table2`.
091117 11:48:14 InnoDB: Warning: MySQL is trying to drop database `bup_xpfm_com
pat_db1`.`` InnoDB: though there are still open handles to table `bup_xpfm_compat_db1`.`table2`.
091117 11:48:17 InnoDB: Warning: MySQL is trying to drop database `bup_xpfm_com
pat_db1`.`` InnoDB: though there are still open handles to table `bup_xpfm_compat_db1`.`table2`.
091117 11:48:18 InnoDB: Warning: MySQL is trying to drop database `bup_xpfm_com
pat_db1`.`` InnoDB: though there are still open handles to table `bup_xpfm_compat_db1`.`table2`.
If you change InnoDB to MyISAM you get this:
CURRENT_TEST: backup.backup_xpfm_compat_backup_lctn2
mysqltest: In included file ".\suite\backup\include\backup_xpfm_compat_backup.in
c": At line 903: query 'DROP DATABASE bup_xpfm_compat_db1' failed: 1010: Error d
ropping database (can't rmdir '.\bup_xpfm_compat_db1', errno: 41)
An inspection of the folder shows the folder is empty.
Suggested fix:
Unknown.
