Bug #32993 falcon_ts.test fails sporadically
Submitted: 5 Dec 2007 10:38 Modified: 29 Apr 2008 19:42
Reporter: Alexander Nozdrin
Status: Closed
Category:Server: Falcon Severity:S1 (Critical)
Version:6.0.4 OS:Any
Assigned to: Bugs System Target Version:
Triage: D3 (Medium)

[5 Dec 2007 10:38] Alexander Nozdrin 
Description:
falcon.falcon_ts               [ fail ]

mysqltest: At line 29: query 'CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon'
failed: 1656: Tablespace 'ts1' already exists

The result from queries just before the failure was:
DROP TABLE IF EXISTS t1;
DROP TABLESPACE ts1 ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=MyISAM;
ERROR HY000: Table storage engine 'MyISAM' does not support the create option 'TABLESPACE
or LOGFILE GROUP'
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts2.fts' ENGINE=falcon;
ERROR HY000: Tablespace 'ts1' already exists
DROP TABLESPACE ts1 ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon;

More results from queries before failure can be found in
e:\var-falcon-102\log\falcon_ts.log

Stopping All Servers
Restoring snapshot of databases
Resuming Tests

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=falcon.falcon_ts
[5 Dec 2007 11:35] Alexander Nozdrin 
The test case disabled in 6.0-runtime.
[5 Dec 2007 13:02] Hakan Kuecuekyilmaz 
Verified as described. Test case fails from time to time.
[5 Dec 2007 21:13] Kevin Lewis 
In the comment just added, falcon_ts.test fails for Bug#31296 where a tablespace is
created, dropped and immediately created again.  This should be P3 since it can be
re-created after waiting a little.

From: Jim Starkey 
Sent: Monday, December 03, 2007 11:49 AM

I've been looking at falcon_ts.   I've got a couple of inconsistent 
results, but they seem benign.  The differences are in selects from the 
falcon information schema "tables" table.  We should nail down what the 
problem is, but it isn't going to affect anyone during the first beta.
[6 Dec 2007 11:01] Bugs System 
Pushed into 6.0.5-alpha
[6 Feb 2008 21:30] Kevin Lewis 
Is this still hapening?
[11 Feb 2008 20:54] Hakan Kuecuekyilmaz 
Started to fail on Windows again:

falcon.falcon_ts               [ fail ]

mysqltest: At line 27: query 'CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon'
failed: 1656: Tablespace 'ts1' already exist

The result from queries just before the failure was:
DROP TABLE IF EXISTS t1;
DROP TABLESPACE ts1 ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=MyISAM;
ERROR HY000: Table storage engine 'MyISAM' does not support the create option 'TABLESPACE
or LOGFILE GROUP'
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts2.fts' ENGINE=falcon;
ERROR HY000: Tablespace 'ts1' already exist
DROP TABLESPACE ts1 ENGINE=falcon;
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=falcon;
[21 Apr 2008 11:57] Sergey Vojtovich 
Note that falcon_ts.test is now split into several tests. Current problem is repeatable
with falcon_bug_31296.test.
[21 Apr 2008 22:41] Kevin Lewis 
Sergey,  What is this current problem and what needs to be done to fix it?
[29 Apr 2008 19:42] Hakan Kuecuekyilmaz 
Closing this bug as I splitted falcon_ts.test into several smaller tests which correspond
directly to a bug report.