Dear All,
I have integrated elasticsearch with magento2 following all the official documents. I can see indices are being created , but whenever I try to search anything I get below error
[DEBUG][o.e.a.s.TransportSearchAction] [D_HnZg_] [stu22_product_1_v2][4], node[D_HnZg_xQuWUe5avniqpCg], [P], s[STARTED], a[id=jJSY3o0LREW-qWWRQmPGJw]: Failed to execute [SearchRequest{searchType=QUERY_THEN_FETCH, indices=[stu22_product_1], indicesOptions=IndicesOptions[id=38, ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false], types=[document], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=5, batchedReduceSize=512, preFilterShardSize=128, source={
"from" : 0,
"size" : 32,
"query" : {
"bool" : {
"must" : [
{
"terms" : {
"visibility" : [
"3",
"4"
],
"boost" : 1.0
}
}
],
"should" : [
{
"match" : {
"sku" : {
"query" : "alta",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 2.0
}
}
},
{
"match" : {
"_search" : {
"query" : "alta",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 2.0
}
}
},
{
"match" : {
"name" : {
"query" : "alta",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 6.0
}
}
},
{
"match" : {
"description" : {
"query" : "alta",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 2.0
}
}
},
{
"match" : {
"short_description" : {
"query" : "alta",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"boost" : 2.0
}
}
}
],
"adjust_pure_negative" : true,
"minimum_should_match" : "1",
"boost" : 1.0
}
},
"stored_fields" : [
"_id",
"score"
],
"sort" : [
{
"am_relevance" : {
"order" : "desc"
}
}
],
"aggregations" : {
"prices" : {
"histogram" : {
"field" : "price_0_1",
"interval" : 1000.0,
"offset" : 0.0,
"order" : {
"key" : "asc"
},
"keyed" : false,
"min_doc_count" : 1
}
}
}
}}]
org.elasticsearch.transport.RemoteTransportException: [D_HnZg][127.0.0.1:9300][indices:data/read/search[phase/query]]
Caused by: org.elasticsearch.index.query.QueryShardException: No mapping found for [am_relevance] in order to sort on
at org.elasticsearch.search.sort.FieldSortBuilder.build(FieldSortBuilder.java:263) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.sort.SortBuilder.buildSort(SortBuilder.java:154) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService.parseSource(SearchService.java:686) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService.createContext(SearchService.java:530) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:506) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:302) ~[elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:288) [elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:284) [elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.search.SearchService$3.doRun(SearchService.java:964) [elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:638) [elasticsearch-6.0.1.jar:6.0.1]
at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) [elasticsearch-6.0.1.jar:6.0.1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
[2019-08-17T18:50:55,787][DEBUG][o.e.a.s.TransportSearchAction] [D_HnZg] All shards failed for phase: [query]
Please help
can someone please help ?
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.