| Bug #59276 | Test "partition_exch_qa_14" fails, because "EXCHANGE PARTITION" succeeds | ||
|---|---|---|---|
| Submitted: | 4 Jan 2011 12:08 | Modified: | 10 Jan 2013 12:04 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Tests: Server | Severity: | S3 (Non-critical) |
| Version: | 5.6.1-m5,mysql-trunk | OS: | Windows |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | partition, pb2, windows | ||
[7 Jan 2011 4:07]
Anitha Gopi
Failing everyday in daily-trunk run
[7 Jan 2011 9:55]
Mattias Jonsson
I think this is because data/index directory is no supported on windows, since it is not supported, there are no differences between the tables.
[7 Jan 2011 18:32]
Bugs System
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/128193 3447 Horst.Hunger 2011-01-07 bug#59276: Test must not run on Windows platforms, as directory options in partitions are ignored there.
[24 Jan 2011 11:55]
Horst Hunger
Pushed to mysql-5.6.1-m5-release. Merged to mysql-trunk and pushed.
[27 Jan 2011 3:51]
Anitha Gopi
The test is now skipped on windows. http://pb2.norway.sun.com/?action=archive_download&archive_id=2884508&pretty=please
Description: Test failure in the release build of 5.6.1-m5, on Windows only: ===== parts.partition_exch_qa_14 [ fail ] Test ended at 2010-12-29 22:34:29 CURRENT_TEST: parts.partition_exch_qa_14 mysqltest: At line 33: query 'ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10' succeeded - should have failed with errno 1710... The result from queries just before the failure was: use test; - saving '/PATH/mysql-test/var/log/parts.partition_exch_qa_14/' to '/PATH/mysql-test/var/log/parts.partition_exch_qa_14/' ===== When the test is then retried, it fails different: ===== CURRENT_TEST: parts.partition_exch_qa_14 mysqltest: At line 13: command "mkdir" failed with error 1. my_errno=17 ===== I suspect this is because the directory already exists, as the "--rmdir" of the first run may have failed because the succeeding command left a file. All this is identical for 32 and 64 bit, and it already happened at the first build (no source change to the second build). How to repeat: Run the test suite ... Suggested fix: Check the test on Windows, I suspect some Windows-specific difference may make the "EXCHANGE PARTITION" pass. Also, check whether the test file is correct and minimal: The same sequence of commands occurs 3 times with a very minor difference in setting variables, to me this looks like a merge error. If this is really intentional, it definitely is worth an explanatory comment (in fact, the whole test should get a description of the intended check).