CQL/Solr queries result in rpc_timeout

(11 posts) (5 voices)

• Started 1 year ago by
• Latest reply from
• This topic is not resolved

Tags:

• dresses for Bridesmaid

1. 

   Anonymous
   Unregistered

   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.

   Posted 1 year ago #
2. 

   tjake
   Moderator

   Is the entire cluster made up of solr nodes?

   Posted 1 year ago #
3. 

   Anonymous
   Unregistered

   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

   Posted 1 year ago #
4. 

   tjake
   Moderator

   Ah ok then specify the query with LOCAL_QUORUM consistency. This is mentioned in the docs too.

   Posted 1 year ago #
5. 

   tjake
   Moderator

   Ah ok then specify the query with LOCAL_QUORUM consistency. This is mentioned in the docs too.

   Posted 1 year ago #
6. 

   Anonymous
   Unregistered

   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

   Posted 1 year ago #
7. 

   Anonymous
   Unregistered

   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.

   Posted 1 year ago #
8. 

   hamilton.tran
   Moderator

   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

   Posted 1 year ago #
9. 

   Anonymous
   Unregistered

   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}.

   Posted 1 year ago #
10. 

    thepaul
    Moderator

    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".

    Posted 1 year ago #
11. 

    Anonymous
    Unregistered

    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

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.