[jira] [Resolved] (SOLR-11961) group.query and sort with function getting error in solrcloud
[
https://issues.apache.org/jira/browse/SOLR-11961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Munendra S N resolved SOLR-11961.
-
Resolution: Duplicate
Keeping SOLR-6203 and closing this as duplicate
> group.query and sort with function getting error in solrcloud
> -
>
> Key: SOLR-11961
> URL: https://issues.apache.org/jira/browse/SOLR-11961
> Project: Solr
> Issue Type: Bug
> Components: search, SolrCloud
>Affects Versions: 6.4, 6.4.2
>Reporter: adeppa
>Priority: Major
> Attachments: Screen Shot 2018-02-13 at 11.41.45 AM.png
>
>
> 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}))= im_field_deliverable_type:(12941)=
>
> im_field_deliverable_type:(12941)=true=on=*:*=sm_field_sku:(manpq7416
>
> OR TTPMUS0005A OR TTPXSI1015US OR TTPMUS0004B OR
> TTPDPRUS0215)=product(if(exists(query(\{!v="${sku}"})),1,0),2)
> desc=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
>
>
>
[jira] [Resolved] (SOLR-11961) group.query and sort with function getting error in solrcloud
[
https://issues.apache.org/jira/browse/SOLR-11961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Erick Erickson resolved SOLR-11961.
---
Resolution: Invalid
Well, then please nudge people on the user's list. The JIRA system is reserved
for known bugs, and this does not (yet) qualify.
bq: if tun same query in sudo node will working ,please help me on this
Then it's highly likely this is a permissions issue where you installed Solr
either as, say, root or at least as a user who has permissions to some
directory and are running Solr as some user who does not have those permissions.
> group.query and sort with function getting error in solrcloud
> -
>
> Key: SOLR-11961
> URL: https://issues.apache.org/jira/browse/SOLR-11961
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: search, SolrCloud
>Affects Versions: 6.4, 6.4.2
>Reporter: adeppa
>Priority: Major
> Attachments: Screen Shot 2018-02-13 at 11.41.45 AM.png
>
>
> 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}))= im_field_deliverable_type:(12941)=
>
> im_field_deliverable_type:(12941)=true=on=*:*=sm_field_sku:(manpq7416
>
> OR TTPMUS0005A OR TTPXSI1015US OR TTPMUS0004B OR
> TTPDPRUS0215)=product(if(exists(query(\{!v="${sku}"})),1,0),2)
> desc=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
>
>
>
[jira] [Resolved] (SOLR-11961) group.query and sort with function getting error in solrcloud
[
https://issues.apache.org/jira/browse/SOLR-11961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Erick Erickson resolved SOLR-11961.
---
Resolution: Not A Problem
Please raise this question on the user's list at solr-u...@lucene.apache.org,
see: (http://lucene.apache.org/solr/community.html#mailing-lists-irc) there are
a _lot_ more people watching that list who may be able to help.
If it's determined that this really is a code issue in Solr and not a
configuration/usage problem, we can raise a new JIRA or reopen this one.
Offhand, the "no live servers" message would indicate that not all your nodes
are up and running. If all your nodes _are_ green and you _still_ get the
message then there's something bogus at least. If you could boil down your
example to the essentials that would help a lot.
> group.query and sort with function getting error in solrcloud
> -
>
> Key: SOLR-11961
> URL: https://issues.apache.org/jira/browse/SOLR-11961
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: search
>Affects Versions: 6.4, 6.4.2
>Reporter: adeppa
>Priority: Major
>
> 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}))= im_field_deliverable_type:(12941)=
>
> im_field_deliverable_type:(12941)=true=on=*:*=sm_field_sku:(manpq7416
>
> OR TTPMUS0005A OR TTPXSI1015US OR TTPMUS0004B OR
> TTPDPRUS0215)=product(if(exists(query(\{!v="${sku}"})),1,0),2)
> desc=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
>
>
>
