Answer the question
In order to leave comments, you need to log in
Why can't Sphinx 3 see the index?
successfully indexes, creates files with indexes, starts the service,
but when we make a request, we get [Err] 1064 - no enabled local indexes to search and it falls into the logs
[Wed Mar 28 09:26:07.739 2018] [4348] listening on all interfaces, port=9312
[Wed Mar 28 09:26:07.743 2018] [4348] listening on all interfaces, port=9306
[Wed Mar 28 09:26:07.765 2018] [4348] WARNING: No extra index definitions found in data folder
[Wed Mar 28 09:26:07.769 2018] [4348] WARNING: index 'adsSphinx': lock: failed to lock c:/sphinx3/data/project/ads.spl: Bad file descriptor; INDEX UNUSABLE
source dbconnection
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = project
sql_port = 3306 #optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query_pre = SET CHARACTER SET utf8
}
source ads : dbconnection
{
sql_query = SELECT \
A.id as id, \
A.user_id, \
A.name, \
A.created_at, \
A.updated_at, \
FROM ads as A \
WHERE A.is_deleted != 1
sql_attr_uint = id
sql_attr_string = name
}
index adsSphinx
{
source = ads
path = c:/sphinx3/data/project/ads
morphology = stem_enru
charset_table = 0..9, A..Z->a..z, _, -, a..z, \
U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
blend_chars = +, U+23, &
min_word_len = 1
min_infix_len = 2
index_exact_words = 1
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 9312
listen = 9306:mysql41
log = c:/sphinx3/log/searchd.log
query_log = c:/sphinx3/log/query.log
binlog_path = c:/sphinx3/data
read_timeout = 5
max_children = 30
pid_file = c:/sphinx3/log/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
}
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question