Bug #38743 falcon.falcon_tablespace_priv fails randomly on Windows
Submitted: 12 Aug 2008 8:51 Modified: 18 Oct 2008 14:07
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0-BK OS:Any (Windows, Linux)
Assigned to: Vladislav Vaintroub CPU Architecture:Any
Tags: pushbuild, single, test failure
Triage: D2 (Serious)

[12 Aug 2008 8:51] Alexander Nozdrin
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...
[12 Aug 2008 9:11] Vladislav Vaintroub
recently fixed in mysql-6.0-falcon
[12 Aug 2008 12:47] John Embretsen
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.
[22 Aug 2008 22:09] Kevin Lewis
This fix is in version 6.0.7
[18 Oct 2008 14:07] Jon Stephens
Noted along with Bug#38186 changelog entry. Closed.