If i use hitless_words = all then searchd crashs…
source srcVor
{
type = mysql
sql_db = ...
sql_port = 3306
sql_query = SELECT SQL_NO_CACHE Nr,Grp,keyWord,keyWordSingle,Spez,Counter FROM tLinkKeys
sql_host = localhost
sql_user = ...
sql_pass = ...
sql_field_string = keyWord
sql_field_string = keyWordSingle
sql_attr_uint = Spez
sql_attr_uint = Counter
sql_attr_uint = Grp
sql_query_pre = SET NAMES utf8
}
index tVor
{
source = srcVor
path = d:/sphIndex/sphVor
charset_table = 0..9, A..Z->a..z, _, a..z, U+A8->U+B8, U+B8, U+C0..U+DF->U+E0..U+FF, U+E0..U+FF, U+40
ignore_chars = U+0060
min_word_len = 0
min_prefix_len = 2
min_infix_len = 0
hitless_words = all
}
searchd
{
listen = 3357:mysql41
log = d:/sphIndex/Log/sphVor.log
read_timeout = 5
pid_file = d:/sphIndex/Log/sphVor.pid
workers = thread_pool
net_workers = 2
mysql_version_string = 5.7.26
binlog_path =
seamless_rotate = 1
access_plain_attrs = mmap_preread
access_blob_attrs = mmap_preread
access_doclists = mmap
access_hitlists = mmap
preopen_indexes = 1
}
------- FATAL: CRASH DUMP -------
[Fri Nov 29 18:52:41.775 2019] [18388]
--- crashed SphinxQL request dump ---
SELECT keyWord,Spez FROM tVor WHERE MATCH('@Keyword maler* lu*') GROUP BY Grp ORDER
BY Spez DESC,Counter DESC LIMIT 7
--- request dump end ---
--- local index:tVor
Manticore 3.2.0 e526a014@191017 release
minidump located at: d:/sphIndex/Log/sphVor.pid.18388.0000022FA279BA30.mdmp
--- 1 active threads ---
thd 0, proto sphinxql, state query, command select
------- CRASH DUMP END -------