Description
while querying combination of group.query and sort function is not working
getting below error
Environment :
Solr 6.4.2 and solr cloud mode with two shards and replication factor 2
AWS with ubuntu
query :/solr/qa/select?fq=((level:*.RL AND
im_field_destination_category:7845 AND im_field_geography:6937 AND
im_field_legacy_category:(7875 OR 12949 OR 7902 OR 12954) AND
im_field_report_research_type:7854) OR (im_field_destination_category:7845
AND im_field_geography:6937 AND im_field_legacy_category:(7875 OR 12949 OR
7902 OR 12954) AND im_field_report_research_type:7855 AND
${sku}))&group.query= im_field_deliverable_type:(12941)&group.query=
im_field_deliverable_type:(12941)&group=true&indent=on&q=:&sku=sm_field_sku:(manpq7416
OR TTPMUS0005A OR TTPXSI1015US OR TTPMUS0004B OR
TTPDPRUS0215)&sort=product(if(exists(query({!v="${sku}"})),1,0),2)
desc&wt=json
if run same query in sudo node will working ,please help me on this
Error:
{
"responseHeader":{
"zkConnected":true,
"status":500,
"QTime":8,
"params":{
"q":":",
"indent":"on",
"fq":"((level:*.RL AND im_field_destination_category:7845 AND
im_field_geography:6937 AND im_field_legacy_category:(7875 OR 12949 OR 7902
OR 12954) AND im_field_report_research_type:7854) OR
(im_field_destination_category:7845 AND im_field_geography:6937 AND
im_field_legacy_category:(7875 OR 12949 OR 7902 OR 12954) AND
im_field_report_research_type:7855 AND ${sku}))",
"sort":"product(if(exists(query({!v=\"${sku}\"})),1,0),2) desc",
"group.query":[" im_field_deliverable_type:(12941)",
" im_field_deliverable_type:(12941)"],
"sku":"sm_field_sku:(manpq7416 OR TTPMUS0005A OR TTPXSI1015US OR
TTPMUS0004B OR TTPDPRUS0215)",
"wt":"json",
"_":"1518098081571",
"group":"true"}},
"error":{
"metadata":[
"error-class","org.apache.solr.common.SolrException",
"root-error-class","org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException"],
"msg":"org.apache.solr.client.solrj.SolrServerException: No live
SolrServers available to handle this
request:[http://172.22.0.231:8983/solr/qa_shard1_replica2,
http://172.22.0.231:8983/solr/qa_shard2_replica2,
http://172.22.1.249:8983/solr/qa_shard1_replica3]",
"trace":"org.apache.solr.common.SolrException:
org.apache.solr.client.solrj.SolrServerException: No live SolrServers
available to handle this
request:[http://172.22.0.231:8983/solr/qa_shard1_replica2,
http://172.22.0.231:8983/solr/qa_shard2_replica2,
http://172.22.1.249:8983/solr/qa_shard1_replica3]\n\tat
org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:415)\n\tat
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:166)\n\tat
org.apache.solr.core.SolrCore.execute(SolrCore.java:2299)\n\tat
org.apache.solr.servlet.HttpSolrCall.execute(HttpSolrCall.java:658)\n\tat
org.apache.solr.servlet.HttpSolrCall.call(HttpSolrCall.java:464)\n\tat
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:345)\n\tat
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:296)\n\tat
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1691)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:582)\n\tat
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)\n\tat
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)\n\tat
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)\n\tat
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)\n\tat
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)\n\tat
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)\n\tat
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:213)\n\tat
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)\n\tat
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)\n\tat
org.eclipse.jetty.server.Server.handle(Server.java:534)\n\tat
org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)\n\tat
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)\n\tat
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)\n\tat
org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)\n\tat
org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)\n\tat
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)\n\tat
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)\n\tat
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)\n\tat
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)\n\tat
java.lang.Thread.run(Thread.java:748)\nCaused by:
org.apache.solr.client.solrj.SolrServerException: No live SolrServers
available to handle this
request:[http://172.22.0.231:8983/solr/qa_shard1_replica2,
http://172.22.0.231:8983/solr/qa_shard2_replica2,
http://172.22.1.249:8983/solr/qa_shard1_replica3]\n\tat
org.apache.solr.client.solrj.impl.LBHttpSolrClient.request(LBHttpSolrClient.java:414)\n\tat
org.apache.solr.handler.component.HttpShardHandlerFactory.makeLoadBalancedRequest(HttpShardHandlerFactory.java:302)\n\tat
org.apache.solr.handler.component.HttpShardHandler.lambda$submit$0(HttpShardHandler.java:166)\n\tat
java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat
java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat
com.codahale.metrics.InstrumentedExecutorService$InstrumentedRunnable.run(InstrumentedExecutorService.java:176)\n\tat
org.apache.solr.common.util.ExecutorUtil$MDCAwareThreadPoolExecutor.lambda$execute$0(ExecutorUtil.java:229)\n\tat
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\t...
1 more\nCaused by:
org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error
from server at http://172.22.0.231:8983/solr/qa_shard1_replica2:
java.lang.Double cannot be cast to org.apache.lucene.util.BytesRef\n\tat
org.apache.solr.client.solrj.impl.HttpSolrClient.executeMethod(HttpSolrClient.java:610)\n\tat
org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:279)\n\tat
org.apache.solr.client.solrj.impl.HttpSolrClient.request(HttpSolrClient.java:268)\n\tat
org.apache.solr.client.solrj.impl.LBHttpSolrClient.doRequest(LBHttpSolrClient.java:435)\n\tat
org.apache.solr.client.solrj.impl.LBHttpSolrClient.request(LBHttpSolrClient.java:387)\n\t...
10 more\n",
"code":500}}
Attachments
Attachments
Issue Links
- duplicates
-
SOLR-6203 cast exception while searching with sort function and result grouping
- Patch Available