Problem
When running the MySQL test suite, the rpl_rotate_logs test fails.
Cause
This has been reported to MySQL under bugID 9763:
http://bugs.mysql.com/bug.php?id=9763This report states that this problem occurs when running these tests as root.
Solution
After running the test suite as root, you will need to take some steps to clean up the test database so that you can re-run the tests as the 'mysql' user.
The mysql-test subdirectory is in differnt locations depending on the version installed, and how it was installed.
On OSR6 the mysql-test directory is at: /usr/mysql/mysql-test
On UW7 the mysql-test directory is at: /usr/share/mysql-test
If you don't find the mysql-test directory in one of these
locations then you can locate it by using the command:
find / -type d -name mysql-test(as root)
change directory to the appropriate path for your install
rm -fr mysql-test/var/(as mysql)
(use the path that is appropriate for your install)
cd mysql-test
mkdir var
./install_test_db --bin
./mysql-test-runThe tests should run through until completion.
See also
http://bugs.mysql.com/bug.php?id=9763/usr/mysql/mysql-test/README