[rt-users] Upgrade from 4.2.2 to 4.2.6 - simple search not using sphinx when searching

[Radu Tureac]

Hello,

I have fulltext search implemented with sphinx and mysql 5.6.15.

The problem is that after upgrade, I started to get these large queries in
mysql when using simple search:


# Time: 140725 13:15:31
# User at Host: rt_user[rt_user] @ localhost []  Id:    26
# Query_time: 10.390028  Lock_time: 0.000276 Rows_sent: 1  Rows_examined:
910059
SET timestamp=1406283331;
SELECT COUNT(DISTINCT main.id) FROM Tickets main JOIN Transactions
Transactions_1  ON ( Transactions_1.ObjectType = 'RT::Ticket' ) AND (
Transactions_1.ObjectId = main.id ) LEFT JOIN Attachments Attachments_2  ON
( Attachments_2.TransactionId = Transactions_1.id ) LEFT JOIN
AttachmentsIndex AttachmentsIndex_3  ON ( AttachmentsIndex_3.id =
Attachments_2.id )  WHERE (main.IsMerged IS NULL) AND (main.Status !=
'deleted') AND (main.Type = 'ticket') AND ( (  ( main.Subject LIKE '%*word*%'
OR  ( AttachmentsIndex_3.query = '*word*;limit=10000;maxmatches=10000' AND
Attachments_2.Filename IS NULL )  )  ) );


Is there any way that I could make the simple search use the sphinx engine
by default for all the queries? Or any way to revert it?

I also mention that the content search is still working with sphinx as
before, if I write fulltext:word I can find the query in the
RT_ROOT/var/sphinx/query.log

[Wed Jun 25 16:41:45.057 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)]
[rt,rtdelta] word
[Wed Jun 25 16:41:45.191 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)]
[rt,rtdelta] word
[Wed Jun 25 16:41:58.256 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)]
[rt,rtdelta] word
[Wed Jun 25 16:42:36.063 2014] 0.002 sec 0.002 sec [all/0/rel 3 (0,10000)]
[rt,rtdelta] word

Thank you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140729/04b6be29/attachment.htm>