MySQL Bugs: #37776: main.partition_falcon fails randomly on win2003-x86

Bug #37776	main.partition_falcon fails randomly on win2003-x86
Submitted:	1 Jul 2008 16:09	Modified:	4 Jul 2008 11:57
Reporter:	Alexander Nozdrin	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0-BK	OS:	Windows (win2003-x86)
Assigned to:	Hakan Küçükyılmaz	CPU Architecture:	Any
Tags:	pushbuild, sporadic, test failure

Description:
mysqltest: At line 14: query 'CREATE TABLE t1 (c1 VARCHAR(3))
ENGINE=Falcon
PARTITION BY KEY(c1)
PARTITIONS 1' failed: 1005: Can't create table 'test.t1' (errno: 1)

The result from queries just before the failure was:
DROP TABLE IF EXISTS t1;
SET storage_engine = Falcon;
# Bug #30480
CREATE TABLE t1 (c1 VARCHAR(3))
ENGINE=Falcon
PARTITION BY KEY(c1)
PARTITIONS 1;

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.partition_falcon

Hakan, Please look at this bug to determine if the test script needs to change to fix this intermittent failure.

Test is fine. Now I am analyzing the Pushbuild failures.

This is not Falcon related issue. I looked into 50 failures via xref. Most of them are complete test suite failures where every test fails. Seven of the failures are due to error: 1, which is "OS error code   1:  Operation not permitted", and two of the fifty failures are testsuite timeouts:

   https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.partition_falcon

- Pushbuild host failed to start all tests:
Failed 1007/1007 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 995/995 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 734/736 tests, 0.27% were successful.
Failed 749/752 tests, 0.40% were successful.
Failed 620/623 tests, 0.48% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 995/995 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 732/734 tests, 0.27% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 1007/1007 tests, 0.00% were successful.
Failed 779/779 tests, 0.00% were successful.
Failed 903/903 tests, 0.00% were successful.
Failed 739/741 tests, 0.27% were successful.
Failed 209/583 tests, 64.15% were successful.
Failed 739/741 tests, 0.27% were successful.
Failed 734/737 tests, 0.41% were successful.
Failed 429/1022 tests, 58.02% were successful.
Failed 85/983 tests, 91.35% were successful.
Failed 453/1033 tests, 56.15% were successful.
Failed 713/952 tests, 25.11% were successful.
Failed 731/936 tests, 21.90% were successful.
Failed 621/623 tests, 0.32% were successful.

Testsuite timeout:
TIMEOUT (1200 seconds), ABORTING.
TIMEOUT (1200 seconds), ABORTING.

win2003-x86 errno: 1 failures:
7 x
CURRENT_TEST: main.partition_falcon
mysqltest: At line 14: query 'CREATE TABLE t1 (c1 VARCHAR(3))
ENGINE=Falcon
PARTITION BY KEY(c1)
PARTITIONS 1' failed: 1005: Can't create table 'test.t1' (errno: 1)