incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: IndexSliceQuery issue - ReadStage piling up (looks like deadlock/infinite loop or similar)
Date Wed, 10 Aug 2011 21:47:46 GMT
Are you still having a problem ? I'm a bit confused about what you saying. 

Cheers

-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com

On 10 Aug 2011, at 03:33, Roland Gude wrote:

> Hi,
>  
> I experience issues when doing a indexslicequery with multiple expressions if one of
the expressions is about a non index column
>  
> I did the equivalent of this example (but with my data) from
> http://www.datastax.com/dev/blog/whats-new-cassandra-07-secondary-indexes
>  
> Secondary indexes automate this. Let’s add some state data:
> 
> [default@demo] set users[bsanderson][state] = 'UT';
> [default@demo] set users[prothfuss][state] = 'WI';
> [default@demo] set users[htayler][state] = 'UT';
> 
> Note that even though state is not indexed yet, we can include the new state data in
a query as long as another column in the query is indexed:
> 
> [default@demo] get users where state = 'UT';
> No indexed columns present in index clause with operator EQ
> [default@demo] get users where state = 'UT' and birth_date > 1970;
> No indexed columns present in index clause with operator EQ
> [default@demo]get users where birth_date = 1968 and state = 'UT';
> -------------------
> RowKey: htayler
> => (column=birth_date, value=1968, timestamp=1291334765649000)
> => (column=full_name, value=Howard Tayler, timestamp=1291334749160000)
> => (column=state, value=5554, timestamp=1291334890708000)
> 
>  
> On On 0.7.8 (with CASSANDRA-2964 applied)
> This example will not return any data, but return “0 rows”. I repeated the query
multiple times with different variations for the values which should all have returned data,
but eventually I ended up with the cluster having 80000 reads pending on some of the nodes
>  
> On 0.7.5 the query will result in a NullPointerException being thrown and “null”
returned in the cli
>  
> ERROR [ReadStage:258] 2011-08-09 16:03:27,153 AbstractCassandraDaemon.java (line 113)
Fatal exception in thread Thread[ReadStage:258,5,main]
> java.lang.RuntimeException: java.lang.NullPointerException
>         at org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:51)
>         at org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> Caused by: java.lang.NullPointerException
>         at org.apache.cassandra.db.ColumnFamily.addAll(ColumnFamily.java:131)
>         at org.apache.cassandra.db.ColumnFamilyStore.scan(ColumnFamilyStore.java:1615)
>         at org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:42)
>         ... 4 more
> ERROR [ReadStage:258] 2011-08-09 16:03:27,153 AbstractCassandraDaemon.java (line 113)
Fatal exception in thread Thread[ReadStage:258,5,main]
> java.lang.RuntimeException: java.lang.NullPointerException
>         at org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:51)
>         at org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:619)
> Caused by: java.lang.NullPointerException
>         at org.apache.cassandra.db.ColumnFamily.addAll(ColumnFamily.java:131)
>         at org.apache.cassandra.db.ColumnFamilyStore.scan(ColumnFamilyStore.java:1615)
>         at org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:42)
>         ... 4 more
>  
>  
>  
> Can anybody reproduce this?
>  
> Greetings,
> Roland
>  
> --
> YOOCHOOSE GmbH
>  
> Roland Gude
> Software Engineer
>  
> Im Mediapark 8, 50670 Köln
>  
> +49 221 4544151 (Tel)
> +49 221 4544159 (Fax)
> +49 171 7894057 (Mobil)
>  
>  
> Email: roland.gude@yoochoose.com
> WWW: www.yoochoose.com
>  
> YOOCHOOSE GmbH
> Geschäftsführer: Dr. Uwe Alkemper, Michael Friedmann
> Handelsregister: Amtsgericht Köln HRB 65275
> Ust-Ident-Nr: DE 264 773 520
> Sitz der Gesellschaft: Köln
>  


Mime
View raw message