not resolved
DKumar
Member
I've started my cassandra in solr mode and pushed my solrconfig and schema file to keyspace which is created and inserted data. If i check the data in cassandra i'm able to find but unable to retrieve the same in solr portal.
Getting the below error.
The request sent by the client was syntactically incorrect (Bad Request)
DKumar
Member
I just opened solr portal and gave *:* as the input. if i click on schema or config i'm able to see that. My URL is like http://ipnumber:8983/solr/keyspacename.cfname/admin/
That should work, if you directly request the search results with a URL like:
http://host:8983/solr/keyspace.cfname/select/?q=*%3A*&version=2.2&start=0&rows=10&indent=on
Do you still get an error response?
Also which version of DSE are you running?
DKumar
Member
Yes Sam. I tried that.
I'm getting the same bad request(HTTP status 400).
HTTP Status 400 - Bad Request Bad Request request:
http://host:8983/solr/kesypspace.cfname~ALL/select
I'm using DSE 2.2 version.
DKumar
Member
Here i've included the log details when i do query from solr admin page for the mentioned issue.
Bad Request
request: http://host:8983/solr/keyspace.cfname~ALL/select
at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:436)
at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:246)
at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:149)
at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:116)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Sorry, this is what I mean by the topology. Are all the nodes in the cluster search nodes? If not, what replication strategy are you using for the keyspace? In a multi-node setup all nodes must be search nodes, or else you need to use a datacenter aware replication strategy and ensure that all the search nodes (and only the search nodes) are in one dc.
DSE search splits solr indexes into shards and distributes them across the available nodes. At search time, it uses solr's distributed search to search across the shards and combines the results before returning them. If search and non-search nodes are mixed in a dc (or non-dc aware cluster) solr queries are sent to non-search nodes, which cannot process them.
DKumar
Member
Thanks again Sam for helping out, please find below - answers for your questions & more details about exception stack trace
-------------
1. What replication strategy are you using for the keyspace?
Ans:
using following commands, while creating KEYSPACE
CREATE KEYSPACE <KeySpaceName> with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and strategy_options = {replication_factor:1};
+
Additional info,
We have 3 VMs setup on same Physical Machine/Rack/DC. 1 VM (ie. 0.0.0.31) is made Seed and other 2 VMs (0.0.0.37 & 0.0.0.39) are peers participating in the ring set up.
In Cassandra.yaml file on all 3 VMs (0.0.0.31, 0.0.0.37, 0.0.0.39), we have the following config, b'cos, 0.0.0.31 is the seed node,
seed_provider:
# Addresses of hosts that are deemed contact points.
# Cassandra nodes use this list of hosts to find each other and learn
# the topology of the ring. You must change this if you are running
# multiple nodes!
- class_name: org.apache.cassandra.locator.SimpleSeedProvider
parameters:
# seeds is actually a comma-delimited list of addresses.
# Ex: "<ip1>,<ip2>,<ip3>"
- seeds: "0.0.0.31"
+
endpoint_snitch: com.datastax.bdp.snitch.DseDelegateSnitch
------------------------------------------------------
2. In a multi-node setup all nodes must be search nodes?
Ans:
All our 3 nodes/VM are used as search nodes only
------------------------------------------------------
3. datacenter aware replication strategy and ensure that all the search nodes (and only the search nodes) are in one dc?
Ans:
We are using 3 VMs running up on same PhysicalMachine/RACK/DC for testing this DSE2.2 set up, so we havn't changed/added config details in "cassandra-topology.properties", we are living with the default config which came with DSE download.
So, do we have to comment any of it? Following are the config details in this file with which, we are running the cluster
# Cassandra Node IP=Data Center:Rack
192.168.1.100=DC1:RAC1
192.168.2.200=DC2:RAC2
10.0.0.10=DC1:RAC1
10.0.0.11=DC1:RAC1
10.0.0.12=DC1:RAC2
10.20.114.10=DC2:RAC1
10.20.114.11=DC2:RAC1
10.21.119.13=DC3:RAC1
10.21.119.10=DC3:RAC1
10.0.0.13=DC1:RAC2
10.21.119.14=DC3:RAC2
10.20.114.15=DC2:RAC2
# default for unknown nodes
default=DC1:r1
# Native IPv6 is supported, however you must escape the colon in the IPv6 Address
# Also be sure to comment out JVM_OPTS="$JVM_OPTS -Djava.net.preferIPv4Stack=true"
# in cassandra-env.sh
fe80\:0\:0\:0\:202\:b3ff\:fe1e\:8329=DC1:RAC3
********************Notes about EXCEPTION************************************
After server start up, when we launch SOLR admin page from seed node (0.0.0.31), it displays the admin page (no issues)
http://0.0.0.31:8983/solr/dnbgovtsearch.dnbdata/admin/
However, when we type a search text & hit search from 31's solr admin page, we are getting following error from 0.0.0.39 (as you said, looks like internally DSE/SOLR does a dist search query which is sent to all nodes in the ring)
*****ERR MSG START*********
HTTP Status 400 - Bad Request Bad Request request: http://0.0.0.39:8983/solr/dnbgovtsearch.dnbdata~ALL/select
--------------------------------------------------------------------------------
type Status report
message Bad Request Bad Request request: http://0.0.0.39:8983/solr/dnbgovtsearch.dnbdata~ALL/select
description The request sent by the client was syntactically incorrect (Bad Request Bad Request request: http://0.0.0.39:8983/solr/dnbgovtsearch.dnbdata~ALL/select).
*****ERR MSG END*********
*****Exception Stack trace is attached below, (to get this trace, I directly launched the URL (http://0.0.0.39:8983/solr/dnbgovtsearch.dnbdata~ALL/select) in the browser)
HTTP Status 500 - java.lang.StackOverflowError org.apache.solr.common.SolrException: java.lang.StackOverflowError at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:284) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1460) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:353) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.execute(CassandraDispatchFilter.java:190) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:248) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.doFilter(CassandraDispatchFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.StackOverflowError at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:237) at org.apache.commons.httpclient.HttpConnection.isStale(HttpConnection.java:505) at org.apache.commons.httpclient.HttpConnection.closeIfStale(HttpConnection.java:430) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.closeIfStale(MultiThreadedHttpConnectionManager.java:1273) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:381) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:428) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:246) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:149) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:116) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) ... 1 more
type Status report
message java.lang.StackOverflowError org.apache.solr.common.SolrException: java.lang.StackOverflowError at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:284) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1460) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:353) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.execute(CassandraDispatchFilter.java:190) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:248) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.doFilter(CassandraDispatchFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.StackOverflowError at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:237) at org.apache.commons.httpclient.HttpConnection.isStale(HttpConnection.java:505) at org.apache.commons.httpclient.HttpConnection.closeIfStale(HttpConnection.java:430) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.closeIfStale(MultiThreadedHttpConnectionManager.java:1273) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:381) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:428) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:246) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:149) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:116) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) ... 1 more
description The server encountered an internal error (java.lang.StackOverflowError org.apache.solr.common.SolrException: java.lang.StackOverflowError at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:284) at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:129) at org.apache.solr.core.SolrCore.execute(SolrCore.java:1460) at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:353) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.execute(CassandraDispatchFilter.java:190) at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:248) at com.datastax.bdp.cassandra.index.solr.CassandraDispatchFilter.doFilter(CassandraDispatchFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: java.lang.StackOverflowError at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read(BufferedInputStream.java:237) at org.apache.commons.httpclient.HttpConnection.isStale(HttpConnection.java:505) at org.apache.commons.httpclient.HttpConnection.closeIfStale(HttpConnection.java:430) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.closeIfStale(MultiThreadedHttpConnectionManager.java:1273) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:381) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:428) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:246) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:149) at org.apache.solr.handler.component.HttpShardHandler$1.call(HttpShardHandler.java:116) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) ... 1 more ) that prevented it from fulfilling this request.
-----------------------------------------------------
You must log in to post.
