Page 1 of 1

Sphinx indexing returns data from new one only..............

Posted: 13 Apr 2015, 21:00
by transcend
I am new to indexing so appreciate your help in this regards......

Was able install sphinx successfully also everything was working fine & I added 150-200 new records so I indexed again whole data for which I used the command "indexer --rotate --all" & it was successful but sphinx returns results from new indexed data & ignoring the old data which has been indexed.

Does indexing consumes time to index the records as on command line it shows indexing has been done?

Appreciate help in the above issue?????

Re: Sphinx indexing returns data from new one only..........

Posted: 14 Apr 2015, 13:43
by RussH
ah-ha,

you've not followed the instructions here..
http://www.opencats.org/documentation/H ... all_Sphinx

the 'update incremental documents should have been via a cronjob using this command;

20,50 7-17 * * Mon,Tue,Wed,Thu,Fri root $PATH/indexer --rotate --config /srv/www/htdocs/cats/modules/search/sphinx.conf catsdelta >>/dev/null

If you want to reindex EVERYTHING, re-run the initial indexing;

/usr/local/bin/indexer --all --config /srv/www/htdocs/cats/modules/search/sphinx.conf

As with many opencats items - we have a user-contributed update to Sphinx search that will be in 0.9.2
https://github.com/opencats/OpenCATS/issues/13

Re: Sphinx indexing returns data from new one only..........

Posted: 15 Apr 2015, 14:03
by transcend
Russh,

Thanks for responding back so quickly & really appreciate your help in resolving the issue..........

You are right instead of doing delta by mistake I did whole indexing because of which this issue happened.

I already did reindexing from scratch but it's pulling new data only & ignoring the old one but in indexing it's showing all records indexing has been done.....

C:\wamp\www\smartrecruit\sphinx\bin>indexer --all --config sphinx.conf
Sphinx 2.2.7-id64-release (r4883)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file 'sphinx.conf'...
WARNING: key 'sql_query_info' was permanently removed from Sphinx configuration.
Refer to documentation for details.
WARNING: key 'charset_type' was permanently removed from Sphinx configuration. R
efer to documentation for details.
WARNING: key 'address' was permanently removed from Sphinx configuration. Refer
to documentation for details.
WARNING: key 'port' was permanently removed from Sphinx configuration. Refer to
documentation for details.
WARNING: key 'max_matches' was permanently removed from Sphinx configuration. Re
fer to documentation for details.
indexing index 'smartrecruitindex'...
collected 35936 docs, 513.3 MB
sorted 44.5 Mhits, 100.0% done
total 35936 docs, 513254301 bytes
total 63.363 sec, 8100118 bytes/sec, 567.13 docs/sec
indexing index 'catsdelta'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.011 sec, 0 bytes/sec, 0.00 docs/sec
total 16 reads, 0.096 sec, 10855.5 kb/call avg, 6.0 msec/call avg
total 399 writes, 2.452 sec, 864.3 kb/call avg, 6.1 msec/call avg

Will look froward for your help in resolving the above issue......

Thanks,
Nick