T
T
tigra2018-03-28 09:42:09
MySQL
tigra, 2018-03-28 09:42:09

Why can't Sphinx 3 see the index?

successfully indexes, creates files with indexes, starts the service,
5abb3689417bf151866490.png
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

who faced this? in the second version everything is identical and everything is ok
config
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

1 answer(s)
S
Sanovskiy, 2018-03-28
@Sanovskiy

indexer delta --rotate

Did you?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question