Sphinx get agent schema -
it's first question, forgive errors:). framework i'm using yii2 , @ beginning of requests, have problem of receiving answer of distributed index agent in sphinx command:
describe `10.0.0.22:9312:indexname`;
i get:
error 1064 (42000): sphinxql: syntax error, unexpected $undefined, expecting ident (or 49 other tokens) near '`10.0.0.22:9312:indexname`'
my distributed conf:
index indexname { type = distributed agent = 10.0.13.24:9312|10.0.0.22:9312:indexname ha_strategy = noerrors }
other conf:
index indexname { type = rt path = /var/lib/sphinxsearch/data/indexname rt_field = code rt_field = title rt_field = article rt_field = docket rt_attr_uint = code rt_attr_string = title rt_attr_string = article rt_attr_string = docket morphology = lemmatize_ru, stem_enru charset_table = 0..9, u+410..u+42f->u+430..u+44f, u+430..u+44f, _ blend_chars = +, &, @ dict = keywords min_word_len = 1 min_prefix_len = 1 }
my searchd conf default.
also have problem of queries fields names backquotes, such as:
select `id`, weight() relevance indexname match('asus');
i get:
error 1064 (42000): index indexname: agent 10.0.0.22:9312: remote error: select: syntax error, unexpected '`', expecting $end near '`, weight() relevance'
i tried queries in console , same errors appears. if make simple queries "select * indexname match('asus')" works fine.
alas pretty sure sphinx can't 'proxy' though 'describe' requests. can describe local indexes, , distributed index (to components).
cant feilds/attributes of remote indexes, client have directly connect remote agent setting. (although can of course list of attributes @ least, running query (select * dist limit 1)
as issue quotes, known bug, dont know status on fixing it. running query without backquotes works better.
Comments
Post a Comment