I installed the latest version of Sphinx 2.0.6. (was 0.9.9 and I upgraded for additional search support. My community searches for things like "p-51" "ys-F-1")

The following is the output when I start the search daemon. Is this even fixable or does anyone have Sphinx 2.0.6 running on IPB 3.3.4?

Thanks in advance.

# service searchd start

Starting searchd: Sphinx 2.0.6-id64-release (r3473)

Copyright © 2001-2012, Andrew Aksyonoff

Copyright © 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'...

WARNING: compat_sphinxql_magics=1 is deprecated; please update your application and config

listening on 127.0.0.1:9312

listening on all interfaces, port=9312

precaching index 'core_tags_search_main'

WARNING: id32 index loaded by id64 binary; attributes converted

precaching index 'core_tags_search_delta'

precaching index 'forums_search_posts_main'

WARNING: id32 index loaded by id64 binary; attributes converted

WARNING: index 'forums_search_posts_main': preload: broken index: mva docid verification failed, id=498048; NOT SERVING

precaching index 'forums_search_posts_delta'

WARNING: id32 index loaded by id64 binary; attributes converted

precaching index 'forums_search_archive_main'

precaching index 'forums_search_archive_delta'

precaching index 'blog_search_main'

WARNING: last message repeated 1 times

WARNING: index 'blog_search_main': preload: broken index: mva docid verification failed, id=11; NOT SERVING

precaching index 'blog_search_delta'

precaching index 'blog_comments_main'

WARNING: id32 index loaded by id64 binary; attributes converted

precaching index 'blog_comments_delta'

precaching index 'downloads_search_main'

WARNING: last message repeated 2 times

WARNING: index 'downloads_search_main': preload: broken index: mva docid verification failed, id=11977; NOT SERVING

precaching index 'downloads_search_delta'

precaching index 'downloads_comments_main'

WARNING: id32 index loaded by id64 binary; attributes converted

precaching index 'downloads_comments_delta'

precached 14 indexes in 11.744 sec

[ OK ]

I upgraded from Sphinx 2.0.5 to 2.0.6 last week. RPM upgrade on an Amazon EC2 instance running Amazon's AMI, which is RHEL6 compatible. It worked fine, as far as I can tell, no warnings or issues.

robert

Are the warnings actually causing you a problem?

I sorted this, thank you.

Indexer and search wasn't being upgraded using yum to install the rpm. I manually removed searchd, indexer, and search and then root installed the rpm for my OS. I started searchd, reindexed, and rotated the indexes then restarted searchd and everything works perfectly.

I'm still trying to find support for searching with the minus sign. When our members search using the minus sign (which is part of the model numbers they are looking for) they are unknowingly excluding part of their search as "AND NOT" (Example: They search model number FS-210NS and in human readable form they are searching for FS "AND NOT" 210NS)

Any ideas on how to support searching with the minus sign?

Thanks.

Interesting. In my case, the minus has no effect! What do your query logs look like? When I search for "miata -hallet", my log looks like this:

=====

[Mon Nov 12 08:26:54.455 2012] 0.001 sec [ext/6/ext 0 (0,25) @tid] [prodforums_search_posts_main, prodforums_search_posts_delta] @(post,title) +miata +&#8208hallet

=====

robert

try putting it in quotes to search for the whole string?

Interesting. In my case, the minus has no effect! What do your query logs look like? When I search for "miata -hallet", my log looks like this:

=====

[Mon Nov 12 08:26:54.455 2012] 0.001 sec [ext/6/ext 0 (0,25) @tid] [prodforums_search_posts_main, prodforums_search_posts_delta] @(post,title) +miata +&#8208hallet

=====

robert

That's weird. While the behaviour thompsone is experiencing is not what he wants, it's the intended behaviour.

That's weird. While the behaviour thompsone is experiencing is not what he wants, it's the intended behaviour.

That is interesting. I would actually prefer to have more control over searches, ie to be able to use the -, |, etc. I wonder if there's a setting that controls this.

robert

http://community.invisionpower.com/topic/357203-sphinx-search-issues-bug-or-unexpected-side-effect/IPB is working as I need it to now, but this post showed what I did to recognize the hyphen as a valid search character