| Bug #36200 | fulltext2.test fails randomly | ||
|---|---|---|---|
| Submitted: | 18 Apr 2008 9:05 | Modified: | 3 Sep 2008 19:00 |
| Reporter: | Sergey Vojtovich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 6.0 | OS: | Any |
| Assigned to: | Rafal Somla | CPU Architecture: | Any |
[10 Jul 2008 10:13]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/49413 2659 Rafal Somla 2008-07-10 BUG#36200 (fulltext2 fails randomly): Test gave wrong results from time to time. It has been determined that the problem was missing FLUSH TABLE statement. The patch adds it.
[3 Sep 2008 10:17]
Rafal Somla
The patch has reached the main 6.0 tree already. It is present in 6.0.7.
[3 Sep 2008 19:00]
Paul DuBois
Test case changes. No changelog entry needed.
[13 Sep 2008 20:41]
Bugs System
Pushed into 6.0.7-alpha (revid:rsomla@mysql.com-20080710101124-lenvwksmtkwp1w1o) (version source revid:hakan@mysql.com-20080725175322-8wgujj5xuzrjz3ke) (pib:3)
Description: --- /export/home/pushbuild/pb/mysql-5.1-engines/350/mysql-5.1.25-rc-pb350/mysql-test/r/fulltext2.result Thu Apr 17 18:40:16 2008 +++ /export/home/pushbuild/pb/mysql-5.1-engines/350/mysql-5.1.25-rc-pb350/mysql-test/r/fulltext2.reject Fri Apr 18 02:51:53 2008 @@ -468,7 +468,6 @@ aaayyy aaayyy aaayyy - aaayyy => 255 aaazzz select count(*) from t1 where match a against ('aaaxxx'); count(*) mysqltest: Result content mismatch How to repeat: See 5.1-engines pushbuild page on 'sol10-sparc-a' -max. Suggested fix: The very likely reason for this failure is the same as in BUG#35788. Either disable concurrent inserts or flush a table before accessing it by an external process.