[Forum] Sphinx crashes on indexing

[performanceforum]

Tryign to setup Sphinx as per the instructions in here https://www.vbulletin.com/forum/show...-vBulletin-4-0

However, when im indexing the instance it crashes reliably in exactly the same spot:

using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
indexing index 'ThreadPostMain'...
collected 622000 docs, 186.1 MB

Never gets past that index, and locks up entirely before dropping the SSH session. If its popped into a screen term then it just stays locked up until you send sigterm.

Using VB 4.1.6, and latest Sphinx and latest downloads from the thread above.

Anyone have ideas?

[performanceforum]

Just rolled back to 0.9.8, and sphinx crashes at the same spot. 622000 docs, but 189.8mb instead.

[Mr.Tampax]

Tried to do "restore\optimize" tables?

[performanceforum]

I havnt, was thinking that was the next thing to try.

[performanceforum]

Restore/optimize changes nothing. Still jams up at the same place.

[Mr.Tampax]

Are there any entries in the searchd.log?
Also turn on "slow query" - it may be a problem in processing mysql.
Also try run second SSH session and run htop and sort processes to "CPU" - for analysis, which process loads memory or CPU

[performanceforum]

Yeah, already tried checking processes, doesnt load either. Jams up at 4.9% of system memory and dies a painful death.
No entries in searchd.log as sphinx daemon hasnt started yet.

Will give the slow query stuff a go, although the rest of the server responds fine after its locked up.

[Mr.Tampax]

Hmmm ... With this I have not yet encountered. Try to appeal to developers in sphinxsearch.com