DataStax Support Forums » Topic: CQL/Solr queries result in rpc

DataStax Support Forums » Topic: CQL/Solr queries result in rpc_timeout http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout Software, Support, and Training for Apache Cassandra en-US Sun, 19 May 2013 15:36:45 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1620 Fri, 13 Apr 2012 20:53:35 +0000 Anonymous 1620@http://www.datastax.com/support-forums/ Can I ask as side questions. How to limit number of rows returned from solr_query? It should be rows=?. looks like limit N didn't work. Thanks, Charlie | DBA thepaul on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1538 Thu, 05 Apr 2012 20:29:17 +0000 thepaul 1538@http://www.datastax.com/support-forums/ The traceback from that Cassandra node's log would help narrow down the problem, if you can find the error in there. You can probably find it by searching for "Internal error processing execute_cql_query" in system.log, or at least searching for "ERROR". Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1536 Thu, 05 Apr 2012 18:25:12 +0000 Anonymous 1536@http://www.datastax.com/support-forums/ 1) Testing from a Cassandra node: [cqlsh 2.0.0 | Cassandra 1.0.8 | CQL spec 2.0.0 | Thrift protocol 19.20.0] Use HELP for help. cqlsh> use wiki; cqlsh:wiki> select title from solr using consistency local_quorum where solr_query='title:natio*' limit 3; Internal application error cqlsh:wiki> select title from solr using consistency local_quorum where solr_query='title:natio*'; Internal application error cqlsh:wiki> select title from solr where solr_query='title:natio*'; title -------------------------------------------------------------------------- Bolivia national football team 1999 Bolivia national football team 2002 List of French born footballers who have played for other national teams Kenya national under-20 football team Bolivia national football team 2000 Israel men's national inline hockey team Bolivia national football team 2001 cqlsh:wiki> select title from solr where solr_query='title:natio*' limit 3; Request did not complete within rpc_timeout. Testing from a Solr node: [cqlsh 2.0.0 | Cassandra 1.0.8 | CQL spec 2.0.0 | Thrift protocol 19.20.0] Use HELP for help. cqlsh> use wiki; cqlsh:wiki> select title from solr using consistency local_quorum where solr_query='title:natio*'; title -------------------------------------------------------------------------- Bolivia national football team 2002 List of French born footballers who have played for other national teams Bolivia national football team 1999 Bolivia national football team 2002 List of French born footballers who have played for other national teams Bolivia national football team 2001 Bolivia national football team 2000 Israel men's national inline hockey team Kenya national under-20 football team Bolivia national football team 2000 Israel men's national inline hockey team Bolivia national football team 2001 cqlsh:wiki> select title from solr using consistency local_quorum where solr_query='title:natio*' limit 3; Request did not complete within rpc_timeout. 2) RF is {Solr:1}. hamilton.tran on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1535 Thu, 05 Apr 2012 18:10:53 +0000 hamilton.tran 1535@http://www.datastax.com/support-forums/ Hi there, I was unable to reproduce your issue. Could you provide us with a little more detail? Specifically: 1)Which node (analytics/cassandra/search) where you connected to with cqlsh? 2)What was your RF set to? {Solr:1}? Thanks, Ham Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1534 Thu, 05 Apr 2012 16:33:59 +0000 Anonymous 1534@http://www.datastax.com/support-forums/ cqlsh:wiki> select title from solr where solr_query='title:natio*'; title -------------------------------------------------------------------------- Bolivia national football team 1999 Bolivia national football team 2002 List of French born footballers who have played for other national teams Kenya national under-20 football team Bolivia national football team 2000 Israel men's national inline hockey team Bolivia national football team 2001 cqlsh:wiki> select title from solr using consistency local_quorum where solr_query='title:natio*' limit 3; Request did not complete within rpc_timeout. Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1533 Thu, 05 Apr 2012 16:16:43 +0000 Anonymous 1533@http://www.datastax.com/support-forums/ From the CQL help: Consistency level specifications are made up of keyword USING, followed by a consistency level identifier. Valid consistency level identifiers are as follows: * ANY * ONE (default) * QUORUM * ALL * LOCAL_QUORUM * EACH_QUORUM cqlsh:test> select * from events using LOCAL_QUORUM where solr_query='active:true'; Bad Request: line 1:26 missing K_CONSISTENCY at 'LOCAL_QUORUM' cqlsh:test> select * from events using CONSISTENCY LOCAL_QUORUM where solr_query='active:true'; Internal application error tjake on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1532 Thu, 05 Apr 2012 15:22:08 +0000 tjake 1532@http://www.datastax.com/support-forums/ Ah ok then specify the query with LOCAL_QUORUM consistency. This is mentioned in the docs too. tjake on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1531 Thu, 05 Apr 2012 15:22:04 +0000 tjake 1531@http://www.datastax.com/support-forums/ Ah ok then specify the query with LOCAL_QUORUM consistency. This is mentioned in the docs too. Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1530 Thu, 05 Apr 2012 15:21:02 +0000 Anonymous 1530@http://www.datastax.com/support-forums/ No. I have 2 Cassandra, 2 Solr, and 2 Hadoop nodes. Address DC Rack Status State Load Owns Token 85070591730234615865843651857942052874 10.3.24.12 Cassandra rack1 Up Normal 24.98 MB 50.00% 0 10.3.24.14 Analytics rack1 Up Normal 23.86 MB 0.00% 10 10.3.24.16 Solr rack1 Up Normal 33.26 MB 0.00% 20 10.3.24.17 Solr rack1 Up Normal 23.84 MB 0.10% 170141183000000000000000000000000000 10.3.24.13 Cassandra rack1 Up Normal 28.25 MB 49.90% 85070591730234615865843651857942052864 10.3.24.15 Analytics rack1 Up Normal 27.02 MB 0.00% 85070591730234615865843651857942052874 tjake on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1529 Thu, 05 Apr 2012 15:09:04 +0000 tjake 1529@http://www.datastax.com/support-forums/ Is the entire cluster made up of solr nodes? Anonymous on "CQL/Solr queries result in rpc_timeout" http://www.datastax.com/support-forums/topic/cqlsolr-queries-result-in-rpc_timeout#post-1524 Wed, 04 Apr 2012 19:49:54 +0000 Anonymous 1524@http://www.datastax.com/support-forums/ The following query returns 2,765 rows: cqlsh:test> select * from events where solr_query='active:true'; Adding a limit to the above query results in an rpc_timeout: cqlsh:test> select * from events where solr_query='active:true' limit 10; Request did not complete within rpc_timeout. cqlsh:test> I get the same results using the JDBC driver. The events column family contains over 10,000 rows. The following query also fails: cqlsh:test> select * from events where solr_query='active:false'; Request did not complete within rpc_timeout. I don't see any log messages related to the queries in the cassandra logs.