Bug #32621 falcon_ts.test fails
Submitted: 22 Nov 2007 12:42 Modified: 3 Dec 2007 14:27
Reporter: Sergey Vojtovich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Jim Starkey CPU Architecture:Any
Tags: pbfail

[22 Nov 2007 12:42] Sergey Vojtovich
Description:
The test fails likely due to frequent create/drop tablespace statements.

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon.falcon_ts               [ fail ]

mysqltest: At line 21: 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:
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 /home/svoj/devel/mysql/BUG31311/mysql-6.0-engines/mysql-test/var/log/falcon_ts.log

How to repeat:
Run falcon_ts.test several times or using test suite:

--source include/have_falcon.inc

let $i=100;
while ($i)
{
  CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=Falcon;
  DROP TABLESPACE ts1 ENGINE=Falcon;
  let $i= $i - 1;
}
[22 Nov 2007 13:58] MySQL Verification Team
Thank you for the bug report.
[26 Nov 2007 17:48] Ingo Strüwing
Happened in pushbuild https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-engines&entry=istruewi...

Disabling the test case. Please re-enable after fix.
[28 Nov 2007 10:24] Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 16:15] Jim Starkey
Problem was a recently introduced bug where gopher threads were not wakened on demand preventing the table space file from being delete which, in turn, prevented the a new table space with the same file from being created.
[28 Nov 2007 16:20] Kevin Lewis
Code Reviewed
[1 Dec 2007 13:12] Hakan Küçükyılmaz
falcon_ts.test passes now
[3 Dec 2007 14:27] MC Brown
A note has been added to the 6.0.4 changelog: 

Repeatedly creating and dropping Falcon tablespaces would fail because a dropped tablespace would not be dropped before the new tablespace file was created.