[rt-users] Rt search does not work with sphinx main+delta index

[Ruslan Zakirov]

Hi,

RT defines index in the CONNECTION attribute of the table, so you have to
adjust it to use several indexes, see the following doc:

http://sphinxsearch.com/docs/2.0.9/sphinxse-using.html

It's not clear how, but it implies that you can do the following:

ALTER TABLE t1 CONNECTION="sphinx://NEWHOST:NEWPORT/index1,index2,index3";



On Wed, Sep 11, 2013 at 11:07 AM, Guadagnino Cristiano <
guadagnino.cristiano at creval.it> wrote:

>  Well, it turned out that the problem with 4.0.17 not returning any result
> was due to a stale searchd process.
> Restarting the daemon reverted behavior to that of RT 4.0.10, which was
> anyway wrong.
>
> So, to restate it clearly: *RT is only returning results from the main
> index, completely ignoring the delta index*.
>
> Please help.
>
> Bye
> Cris
>
>
>
> Guadagnino Cristiano wrote:
>
> I am having trouble with RT fulltext searches. I am using RT 4.0.17 with
> Mysql and Sphinx 4.0.8.
> Sphinx is configured to use a main+delta index (configuration attached).
> Main index is created once every morning, while the delta index is created
> every 5 minutes.
> If I search using the "search" command line tool from Sphinx everything is
> correct.
>
> Fulltext search with RT *4.0.10* instead seemed to return only the
> results from the main index, disregarding anything from the delta index.
> So I updated to the latest RT release (*4.0.17*) just to be sure. Now
> fulltext search with RT does not return anything at all!!
>
> *Example from the CLI: *
>
> search CrevalPublic --rsort=date -q -l 500
>
>  This returns 73 hits on the main index and 39 ihits on the delta index.
>
> *Simple search with RT:*
>
> fulltext:CrevalPublic any
>
>  This returns 0 results.
>
> Any suggestions?
>
> T.I.A.
> Bye
> Cris
> --
> *Cristiano Guadagnino*
> Servizio Data Administration
> Bankadati S.I.
> Gruppo Credito Valtellinese
>
> **
>
>
> --
> *Cristiano Guadagnino*
> Servizio Data Administration
> Bankadati S.I.
> Gruppo Credito Valtellinese
>
>
> **
>



-- 
Best regards, Ruslan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130911/336fcc6b/attachment.htm>