Warnings: Unable to make query after 3 attempts, last error: DBD::mysql::st fetchrow_hashref failed: unknown local index 'temp_201' in search request at /usr/local/elsa/web/lib/SyncMysql.pm line 143.

[GoogleCodeExporter]

What steps will reproduce the problem?
1.follow the recommendation in Issue 65:
2.follow the recommendation in the documentaion

If you set num_indexes to be larger than 200, you should increase the open 
files limit for searchd (Sphinx). You can do this on Linux by editing 
/etc/security/limits.conf and adding:

root soft nofile 100000
root hard nofile 200000

What is the expected output?

search resulat

What do you see instead?

Warnings: Unable to make query after 3 attempts, last error: DBD::mysql::st 
fetchrow_hashref failed: unknown local index 'temp_201' in search request at 
/usr/local/elsa/web/lib/SyncMysql.pm line 143. 

Rev 812

Original issue reported on code.google.com by jacobrav...@gmail.com on 26 Apr 2013 at 2:08

[GoogleCodeExporter]

You need to regenerate your sphinx.conf file if you change the number of 
indexes.  Delete /usr/local/etc/sphinx.conf, run echo "" | perl 
/usr/local/elsa/node/elsa.pl -on, then restart searchd.

Original comment by mchol...@gmail.com on 26 Apr 2013 at 4:21

• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

I get this error from index 200 to 400

WARNING: index 'temp_400': preload: failed to open /data/sphinx/temp_400.sph: 
No such file or directory; NOT SERVING
precached 804 indexes in 43.766 sec

Original comment by jacobrav...@gmail.com on 26 Apr 2013 at 9:23

[GoogleCodeExporter]

Right, those indexes don't yet exist because they haven't been needed yet.  As 
200-400 are needed, they will be created and served.

Original comment by mchol...@gmail.com on 26 Apr 2013 at 9:29