ERROR 1064 (42000): unknown local index(es) in search request

General Discussions - English
#1

Please help! I am currently using Manticore 3.4.2 in ubuntu/bionic64

I have distributed, template and plain indexes. All of them passed indextool --check. indextool --checkconfig also passed. indexer --rotate --all --sighup-each also successful.

But upon entering mysql -h0 -P9306 to select from the indexes, I got an error saying ERROR 1064 (42000): unknown local index(es) *index_name* in search request

What do you think is wrong?

#2

seems there is no such index at your daemon. Could you check the output of SHOW tables SphinxQL statement?

#3

only the template indexes were returned.

#4

then you need to look at your searchd.log and figure our why all other indexes were not loaded