Bug #40453 Search in Boolean mode doesn't work
Submitted: 31 Oct 2008 10:48 Modified: 31 Oct 2008 20:45
Reporter: Jakub Vrana (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Websites: bugs.mysql.com Severity:S3 (Non-critical)
Version:n/a OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[31 Oct 2008 10:48] Jakub Vrana
Search in Boolean mode at bugs.mysql.com leads to following error:

SELECT SQL_CALC_FOUND_ROWS bugdb.*, UNIX_TIMESTAMP(ts1) AS entered, UNIX_TIMESTAMP(ts2) AS modified, UNIX_TIMESTAMP(eta) AS eta, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged, CONCAT(user.firstname,' ',user.lastname) AS assign_name, user.firstname, user.lastname, user.email, CONCAT(u2.firstname, ' ', u2.lastname) AS lead_name, u2.firstname AS lead_firstname, u2.lastname AS lead_lastname, u2.email AS lead_email, MATCH (sdesc,ldesc) AGAINST ('+text +default' IN BOOLEAN MODE) AS relevance FROM bugdb LEFT JOIN user ON bugdb.assign = user.user_id AND bugdb.assign != 0 LEFT JOIN user AS u2 ON bugdb.lead = u2.user_id AND bugdb.lead != 0 WHERE 1 AND severity != 4 AND MATCH (sdesc,ldesc) AGAINST ('+text +default' IN BOOLEAN MODE) AND NOT private GROUP BY id ORDER BY relevance DESC LIMIT 0,10
Got error 28 from storage engine

How to repeat:
Search for '+text +default'.
[31 Oct 2008 17:34] Valeriy Kravchuk
Thank you for a problem report. Please, try again. In case of the same problem, please, describe what exct search fields you had set. I can not repeat the problem based on your description, hence the request.
[31 Oct 2008 20:45] Jim Winstead
I am pretty sure this was related to a temporary out-of-disk-space problem on the bugs database server.