| 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: | |
| 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 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.
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; }