Bug #32993 falcon_ts.test fails sporadically

• Submitted: 5 Dec 2007 9:38
• Modified: 29 Apr 2008 17:42
• Reporter: Alexander Nozdrin
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S1 (Critical)
• Version: 6.0.4
• OS: Any
• Assigned to: Hakan Küçükyılmaz
• CPU Architecture: Any

[5 Dec 2007 9: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 10:35] Alexander Nozdrin

The test case disabled in 6.0-runtime.

[5 Dec 2007 12:02] Hakan Küçükyılmaz

Verified as described. Test case fails from time to time.

[5 Dec 2007 20: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 10:01] Bugs System

Pushed into 6.0.5-alpha

[6 Feb 2008 20:30] Kevin Lewis

Is this still hapening?

[11 Feb 2008 19:54] Hakan Küçükyılmaz

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 9: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 20:41] Kevin Lewis

Sergey,  What is this current problem and what needs to be done to fix it?

[29 Apr 2008 17:42] Hakan Küçükyılmaz

Closing this bug as I splitted falcon_ts.test into several smaller tests which correspond directly to a bug report.