Misery

4670: Typing in search fields does not work with elasticsearch

Misery 
What version are you running?


3.0.3


What's the URL of the page containing the problem?


http://localhost/dashboard/


What steps will reproduce the problem?


    

  1. Go to search fields
    2. 

  2. type something but do not press enter
    3. 





What is the expected output? What do you see instead?


Some autocomplete values... but got nothing and see errors in log.


What operating system are you using? What browser?


Linux, Firefox


Please provide any additional information below.


Reviewboard:


2018-03-14 13:11:30,219 - DEBUG -  - urllib3.util.retry - Converted retries value: False -> Retry(total=False, connect=None, read=None, redirect=0, status=None)

2018-03-14 13:11:30,225 - DEBUG -  - urllib3.connectionpool - http://127.0.0.1:9200 "GET /reviewboard/modelresult/_search?_source=true HTTP/1.1" 400 436

2018-03-14 13:11:30,226 - WARNING -  - elasticsearch - GET /reviewboard/modelresult/_search?_source=true [status:400 request:0.006s]

2018-03-14 13:11:30,226 - DEBUG -  - elasticsearch - > {"sort": [{"last_updated": {"order": "desc"}}], "query": {"filtered": {"filter": {"terms": {"django_ct": ["auth.user"]}}, "query": {"query_string": {"query": "(test AND local_sites:(0))", "default_operator": "AND", "default_field": "text", "auto_generate_phrase_queries": true, "analyze_wildcard": true}}}}, "from": 0, "size": 25}

2018-03-14 13:11:30,226 - DEBUG -  - elasticsearch - < {"error":{"root_cause":[{"type":"search_parse_exception","reason":"No mapping found for [last_updated] in order to sort on"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"reviewboard","node":"xOgiSd45Tn-1a9TKLgh39w","reason":{"type":"search_parse_exception","reason":"No mapping found for [last_updated] in order to sort on"}}]},"status":400}

2018-03-14 13:11:30,226 - ERROR -  - haystack - Failed to query Elasticsearch using '(test AND local_sites:(0))': TransportError(400, u'search_phase_execution_exception', u'No mapping found for [last_updated] in order to sort on')

Traceback (most recent call last):

  File "/var/www/dist/lib/python2.7/site-packages/haystack/backends/elasticsearch_backend.py", line 516, in search

    _source=True)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/client/utils.py", line 69, in _wrapped

    return func(*args, params=params, kwargs)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/client/init.py", line 539, in search

    doc_type, '_search'), params=params, body=body)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/transport.py", line 327, in perform_request

    status, headers, data = connection.perform_request(method, url, params, body, ignore=ignore, timeout=timeout)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/connection/http_urllib3.py", line 110, in perform_request

    self._raise_error(response.status, raw_data)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/connection/base.py", line 114, in _raise_error

    raise HTTP_EXCEPTIONS.get(status_code, TransportError)(status_code, error_message, additional_info)

RequestError: TransportError(400, u'search_phase_execution_exception', u'No mapping found for [last_updated] in order to sort on')

2018-03-14 13:11:30,229 - DEBUG -  - urllib3.util.retry - Converted retries value: False -> Retry(total=False, connect=None, read=None, redirect=0, status=None)

2018-03-14 13:11:30,234 - DEBUG -  - urllib3.connectionpool - http://127.0.0.1:9200 "GET /reviewboard/modelresult/_search?_source=true HTTP/1.1" 400 436

2018-03-14 13:11:30,234 - WARNING -  - elasticsearch - GET /reviewboard/modelresult/_search?_source=true [status:400 request:0.005s]

2018-03-14 13:11:30,234 - DEBUG -  - elasticsearch - > {"sort": [{"last_updated": {"order": "desc"}}], "query": {"filtered": {"filter": {"terms": {"django_ct": ["reviews.reviewrequest"]}}, "query": {"query_string": {"query": "(test AND local_sites:(0))", "default_operator": "AND", "default_field": "text", "auto_generate_phrase_queries": true, "analyze_wildcard": true}}}}, "from": 0, "size": 25}

2018-03-14 13:11:30,235 - DEBUG -  - elasticsearch - < {"error":{"root_cause":[{"type":"search_parse_exception","reason":"No mapping found for [last_updated] in order to sort on"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"reviewboard","node":"xOgiSd45Tn-1a9TKLgh39w","reason":{"type":"search_parse_exception","reason":"No mapping found for [last_updated] in order to sort on"}}]},"status":400}

2018-03-14 13:11:30,235 - ERROR -  - haystack - Failed to query Elasticsearch using '(test AND local_sites:(0))': TransportError(400, u'search_phase_execution_exception', u'No mapping found for [last_updated] in order to sort on')

Traceback (most recent call last):

  File "/var/www/dist/lib/python2.7/site-packages/haystack/backends/elasticsearch_backend.py", line 516, in search

    _source=True)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/client/utils.py", line 69, in _wrapped

    return func(*args, params=params, kwargs)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/client/init.py", line 539, in search

    doc_type, '_search'), params=params, body=body)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/transport.py", line 327, in perform_request

    status, headers, data = connection.perform_request(method, url, params, body, ignore=ignore, timeout=timeout)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/connection/http_urllib3.py", line 110, in perform_request

    self._raise_error(response.status, raw_data)

  File "/var/www/dist/lib/python2.7/site-packages/elasticsearch/connection/base.py", line 114, in _raise_error

    raise HTTP_EXCEPTIONS.get(status_code, TransportError)(status_code, error_message, additional_info)

RequestError: TransportError(400, u'search_phase_execution_exception', u'No mapping found for [last_updated] in order to sort on')


















Elasticsearch:

[2018-03-14 13:12:18,893][DEBUG][action.search            ] [Taskmaster] All shards failed for phase: [query]

RemoteTransportException[[Taskmaster][172.17.0.4:9300][indices:data/read/search[phase/query]]]; nested: SearchParseException[failed to parse search source [{"sort": [{"last_updated": {"order": "desc"}}], "query": {"filtered": {"filter": {"terms": {"django_ct": ["reviews.reviewrequest"]}}, "query": {"query_string": {"query": "(t AND local_sites:(0))", "default_operator": "AND", "default_field": "text", "auto_generate_phrase_queries": true, "analyze_wildcard": true}}}}, "from": 0, "size": 25}]]; nested: SearchParseException[No mapping found for [last_updated] in order to sort on];

Caused by: SearchParseException[failed to parse search source [{"sort": [{"last_updated": {"order": "desc"}}], "query": {"filtered": {"filter": {"terms": {"django_ct": ["reviews.reviewrequest"]}}, "query": {"query_string": {"query": "(t AND local_sites:(0))", "default_operator": "AND", "default_field": "text", "auto_generate_phrase_queries": true, "analyze_wildcard": true}}}}, "from": 0, "size": 25}]]; nested: SearchParseException[No mapping found for [last_updated] in order to sort on];

        at org.elasticsearch.search.SearchService.parseSource(SearchService.java:873)

        at org.elasticsearch.search.SearchService.createContext(SearchService.java:667)

        at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:633)

        at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:377)

        at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:368)

        at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:365)

        at org.elasticsearch.transport.TransportRequestHandler.messageReceived(TransportRequestHandler.java:33)

        at org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:77)

        at org.elasticsearch.transport.TransportService$4.doRun(TransportService.java:378)

        at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at java.lang.Thread.run(Thread.java:748)

Caused by: SearchParseException[No mapping found for [last_updated] in order to sort on]

        at org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:213)

        at org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:187)

        at org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:85)

        at org.elasticsearch.search.SearchService.parseSource(SearchService.java:856)

        ... 12 more
Misery
#1 Misery 
Used this docker image for elasticsearch:


docker run --rm -p 9200:9200 -p 9300:9300 elasticsearch:2-alpine
Misery
#2 Misery 
Calling "rb-site manage /var/www/rb/ rebuild_index" did the trick. Should be a message somewhere.