The relevant error message is the following: "No mapping found for [id] in order to sort on".
It means that you are sorting on a field which does not exist on at least one of the queried indices. See http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-sort.html#_ignoring_unmapped_fields for more information. On Fri, Mar 6, 2015 at 6:49 AM, Vijayakumari B N <[email protected]> wrote: > Hi, > > I am trying to search some text using elastic search server, with some > indexing. I am using default shards and i did not modify anything in my > elasticsearch.yml. My application was working fine. I did another indexing > for another application where i want to load different data, I have not > tested this yet. I came back and trying to run my first application, i am > getting the below error. my elastic search is not working. > > Can someone please help me where i am doing wrong.? > > > Query 1 :: { > "multi_match" : { > "query" : "new year", > "fields" : [ "keywords", "symptom" ] > } > } > org.elasticsearch.action.search.SearchPhaseExecutionException: Failed to > execute phase [query], all shards failed; shardFailures > {[aslVcGTvTz68YZOza7Wqsg][problem][0]: SearchParseException[[problem][0]: > query[((keywords:new keywords:year) | (symptom:new > symptom:year))],from[0],size[10]: Parse Failure [Failed to parse source > [{"from":0,"size":10,"query":{"multi_match":{"query":"new > year","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}],"highlight":{"phrase_limit":1}}]]]; > nested: SearchParseException[[problem][0]: query[((keywords:new > keywords:year) | (symptom:new symptom:year))],from[0],size[10]: Parse > Failure [No mapping found for [id] in order to sort on]]; > }{[aslVcGTvTz68YZOza7Wqsg][problem][1]: SearchParseException[[problem][1]: > query[((keywords:new keywords:year) | (symptom:new > symptom:year))],from[0],size[10]: Parse Failure [Failed to parse source > [{"from":0,"size":10,"query":{"multi_match":{"query":"new > year","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}],"highlight":{"phrase_limit":1}}]]]; > nested: SearchParseException[[problem][1]: query[((keywords:new > keywords:year) | (symptom:new symptom:year))],from[0],size[10]: Parse > Failure [No mapping found for [id] in order to sort on]]; > }{[aslVcGTvTz68YZOza7Wqsg][problem][2]: SearchParseException[[problem][2]: > query[((keywords:new keywords:year) | (symptom:new > symptom:year))],from[0],size[10]: Parse Failure [Failed to parse source > [{"from":0,"size":10,"query":{"multi_match":{"query":"new > year","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}],"highlight":{"phrase_limit":1}}]]]; > nested: SearchParseException[[problem][2]: query[((keywords:new > keywords:year) | (symptom:new symptom:year))],from[0],size[10]: Parse > Failure [No mapping found for [id] in order to sort on]]; > }{[aslVcGTvTz68YZOza7Wqsg][problem][3]: SearchParseException[[problem][3]: > query[((keywords:new keywords:year) | (symptom:new > symptom:year))],from[0],size[10]: Parse Failure [Failed to parse source > [{"from":0,"size":10,"query":{"multi_match":{"query":"new > year","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}],"highlight":{"phrase_limit":1}}]]]; > nested: SearchParseException[[problem][3]: query[((keywords:new > keywords:year) | (symptom:new symptom:year))],from[0],size[10]: Parse > Failure [No mapping found for [id] in order to sort on]]; > }{[aslVcGTvTz68YZOza7Wqsg][problem][4]: SearchParseException[[problem][4]: > query[((keywords:new keywords:year) | (symptom:new > symptom:year))],from[0],size[10]: Parse Failure [Failed to parse source > [{"from":0,"size":10,"query":{"multi_match":{"query":"new > year","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}],"highlight":{"phrase_limit":1}}]]]; > nested: SearchParseException[[problem][4]: query[((keywords:new > keywords:year) | (symptom:new symptom:year))],from[0],size[10]: Parse > Failure [No mapping found for [id] in order to sort on]]; } > at > org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.onFirstPhaseResult(TransportSearchTypeAction.java:233) > at > org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$1.onFailure(TransportSearchTypeAction.java:179) > at > org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:565) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > > > > below is the error from elasticsearch server log file. > > [2015-03-06 11:17:24,997][DEBUG][action.search.type ] [Magma] > [problem][1], node[aslVcGTvTz68YZOza7Wqsg], [P], s[STARTED]: Failed to > execute [org.elasticsearch.action.search.SearchRequest@78fc50a1] > lastShard [true] > org.elasticsearch.search.SearchParseException: [problem][1]: > query[(keywords:jvm | symptom:jvm)],from[-1],size[-1]: Parse Failure > [Failed to parse source > [{"query":{"multi_match":{"query":"jvm","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}]}]] > at > org.elasticsearch.search.SearchService.parseSource(SearchService.java:681) > at > org.elasticsearch.search.SearchService.createContext(SearchService.java:537) > at > org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:509) > at > org.elasticsearch.search.SearchService.executeDfsPhase(SearchService.java:194) > at > org.elasticsearch.search.action.SearchServiceTransportAction$3.call(SearchServiceTransportAction.java:197) > at > org.elasticsearch.search.action.SearchServiceTransportAction$3.call(SearchServiceTransportAction.java:194) > at > org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:559) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.elasticsearch.search.SearchParseException: [problem][1]: > query[(keywords:jvm | symptom:jvm)],from[-1],size[-1]: Parse Failure [No > mapping found for [id] in order to sort on] > at > org.elasticsearch.search.sort.SortParseElement.addSortField(SortParseElement.java:210) > at > org.elasticsearch.search.sort.SortParseElement.addCompoundSortField(SortParseElement.java:184) > at > org.elasticsearch.search.sort.SortParseElement.parse(SortParseElement.java:86) > at > org.elasticsearch.search.SearchService.parseSource(SearchService.java:665) > ... 9 more > [2015-03-06 11:17:25,000][DEBUG][action.search.type ] [Magma] > [problem][4], node[aslVcGTvTz68YZOza7Wqsg], [P], s[STARTED]: Failed to > execute [org.elasticsearch.action.search.SearchRequest@78fc50a1] > org.elasticsearch.search.SearchParseException: [problem][4]: > query[(keywords:jvm | symptom:jvm)],from[-1],size[-1]: Parse Failure > [Failed to parse source > [{"query":{"multi_match":{"query":"jvm","fields":["keywords","symptom"]}},"sort":[{"id":{"order":"asc"}}]}]] > at > org.elasticsearch.search.SearchService.parseSource(SearchService.java:681) > > Thanks, > Vijaya > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/6a1b83d0-ace4-472c-be0a-c981adb101b5%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/6a1b83d0-ace4-472c-be0a-c981adb101b5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Adrien Grand -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAL6Z4j6ZteTSPA6Yk3mc0fGEQmK54N7noFdR8tYydicFV%2Bm5Pg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
