| Bug #52892 | MySQL Server Hangs on certain Full Text Boolean searches | ||
|---|---|---|---|
| Submitted: | 16 Apr 2010 17:33 | Modified: | 19 Apr 2010 18:04 |
| Reporter: | Neil | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S2 (Serious) |
| Version: | 5.1.37 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | boolean, Craches, full text, hangs, locks, MySQL, query, search | ||
[16 Apr 2010 19:49]
MySQL Verification Team
Thank you for the bug report. Could you please try 5.1.45 released version and if you continue to have the same issue, please provide a complete test case. Thanks in advance.
[19 Apr 2010 9:28]
Neil
I tried version 5.1.45 and it appears to fix the problem. However, how do we go about upgrading our version to 5.1.45 on Ubuntu OS
[19 Apr 2010 18:04]
MySQL Verification Team
Closing according last comment. You can use our tarball package or wait until Ubuntu makes it available for upgrade. Thanks in advance.
Description: We are attempting to run the following full text search on one of our tables. But on entering the keyword phrases below it appears to crash/hang the query. SELECT Country, County, Name, MATCH (Country, County, Name) AGAINST ('+st.* giles-* the* Court* New* York*' IN BOOLEAN MODE) AS Relevance FROM Properties WHERE MATCH (Country, County, Name) AGAINST ('+st.* giles-* the* Court* New* York*' IN BOOLEAN MODE) ORDER BY Relevance DESC Does anyone know of this problem ? How to repeat: By running the query using the keyword phrases +st.* giles-* the* Court* New* York* it will lock the search.