• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Elasticsearch error: SearchPhaseExecutionException

Andy.N

Well-known member
#1
When members search for things like "MS OR", I will get errors like these in ACP

XenForo_Exception: Elasticsearch error: SearchPhaseExecutionException[Failed to execute phase [query], total failure; shardFailures {[gdZ3yYajTjmHFpGgacRD8Q][quantnet_xf][0]: SearchParseException[[quantnet_xf][0]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"filter":{"and":[{"term":{"node":78}}]},"query":{"query_string":{"query":"Columbia MS OR","fields":["title","message"],"default_operator":"and"}}}},"sort":[{"date":"desc"}],"size":200,"fields":["discussion_id","user","date"]}]]]; nested: QueryParsingException[[quantnet_xf] Failed to parse query [Columbia MS OR]]; nested: ParseException[Cannot parse 'Columbia MS OR': Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; nested: ParseException[Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; }{[gdZ3yYajTjmHFpGgacRD8Q][quantnet_xf][1]: SearchParseException[[quantnet_xf][1]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"filter":{"and":[{"term":{"node":78}}]},"query":{"query_string":{"query":"Columbia MS OR","fields":["title","message"],"default_operator":"and"}}}},"sort":[{"date":"desc"}],"size":200,"fields":["discussion_id","user","date"]}]]]; nested: QueryParsingException[[quantnet_xf] Failed to parse query [Columbia MS OR]]; nested: ParseException[Cannot parse 'Columbia MS OR': Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; nested: ParseException[Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; }{[gdZ3yYajTjmHFpGgacRD8Q][quantnet_xf][2]: SearchParseException[[quantnet_xf][2]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"filter":{"and":[{"term":{"node":78}}]},"query":{"query_string":{"query":"Columbia MS OR","fields":["title","message"],"default_operator":"and"}}}},"sort":[{"date":"desc"}],"size":200,"fields":["discussion_id","user","date"]}]]]; nested: QueryParsingException[[quantnet_xf] Failed to parse query [Columbia MS OR]]; nested: ParseException[Cannot parse 'Columbia MS OR': Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; nested: ParseException[Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; }{[gdZ3yYajTjmHFpGgacRD8Q][quantnet_xf][3]: SearchParseException[[quantnet_xf][3]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"filter":{"and":[{"term":{"node":78}}]},"query":{"query_string":{"query":"Columbia MS OR","fields":["title","message"],"default_operator":"and"}}}},"sort":[{"date":"desc"}],"size":200,"fields":["discussion_id","user","date"]}]]]; nested: QueryParsingException[[quantnet_xf] Failed to parse query [Columbia MS OR]]; nested: ParseException[Cannot parse 'Columbia MS OR': Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; nested: ParseException[Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; }{[gdZ3yYajTjmHFpGgacRD8Q][quantnet_xf][4]: SearchParseException[[quantnet_xf][4]: from[-1],size[-1]: Parse Failure [Failed to parse source [{"query":{"filtered":{"filter":{"and":[{"term":{"node":78}}]},"query":{"query_string":{"query":"Columbia MS OR","fields":["title","message"],"default_operator":"and"}}}},"sort":[{"date":"desc"}],"size":200,"fields":["discussion_id","user","date"]}]]]; nested: QueryParsingException[[quantnet_xf] Failed to parse query [Columbia MS OR]]; nested: ParseException[Cannot parse 'Columbia MS OR': Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; nested: ParseException[Encountered "<EOF>" at line 1, column 14. Was expecting one of: <NOT> ... "+" ... "-" ... "(" ... "*" ... <QUOTED> ... <TERM> ... <PREFIXTERM> ... <WILDTERM> ... "[" ... "{" ... <NUMBER> ... <TERM> ... "*" ... ]; }] - library/XenES/Search/SourceHandler/ElasticSearch.php:716
 

Andy.N

Well-known member
#3
Looks like your shard has been corrupted.

Stop ES. Delete the data directory, restart ES and reindex.
1) I followed your installation guide for Ubuntu to install data in /var/elasticsearch/ folder but there is no data in there so I don't know how to delete the data directory
I simply stop and restart the elastic search and it seems to be ok now.
2) What is the step to upgrade the elastic binary. I think the version in the guide is outdated.