MySQL Bugs: #38743: falcon.falcon_tablespace_priv fails randomly on Windows

Bug #38743	falcon.falcon_tablespace_priv fails randomly on Windows
Submitted:	12 Aug 2008 10:51	Modified:	18 Oct 2008 16:07
Reporter:	Alexander Nozdrin
Status:	Closed
Category:	Server: Falcon	Severity:	S3 (Non-critical)
Version:	6.0-BK	OS:	Any (Windows, Linux)
Assigned to:	Vladislav Vaintroub	Target Version:	6.0.7
Tags:	pushbuild, test failure, single
Triage:	D2 (Serious)

Description:
Symptoms:
----------------------------------------
falcon.falcon_tablespace_priv  [ fail ]

mysqltest: At line 76: query 'CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
ENGINE = Falcon' failed: 1718: Tablespace data file 'datafile.dat' already exists

The result from queries just before the failure was:
< snip >
# -- Connection: root@localhost

DROP USER mysqltest_u1@localhost;
DROP USER mysqltest_u2@localhost;
# --
# -- Bug#31302: USE information_schema disables DROP tablespace
# --
GRANT CREATE TABLESPACE ON *.* TO mysqltest_u1@localhost;

# -- Connection: mysqltest_u1@localhost

# -- Grants for mysqltest_u1@localhost:
SHOW GRANTS;
Grants for mysqltest_u1@localhost
GRANT CREATE TABLESPACE ON *.* TO 'mysqltest_u1'@'localhost'

# -- CREATE TABLESPACE...
CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
ENGINE = Falcon;
----------------------------------------

This bug has nothing to do with Falcon. See also WL#4300.

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

recently fixed in mysql-6.0-falcon

This looks like the same issue as Bug #38186 (falcon_bug_31295 fails on pushbuild). I have
seen this test (falcon_tablespace_priv) failing during manual test runs on a busy Linux
host, but the failures seemed to stop occurring with the patch for Bug#38186 applied.

This fix is in version 6.0.7

Noted along with Bug#38186 changelog entry. Closed.