[jira] [Comment Edited] (CASSANDRA-6470) ArrayIndexOutOfBoundsException on range query from client

["Jeremiah Jordan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-6470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13846841#comment-13846841 ] 

Jeremiah Jordan edited comment on CASSANDRA-6470 at 12/12/13 11:34 PM:
-----------------------------------------------------------------------

[~enrico.scalavino] are you using version 2.0.X of C* and the driver?  The limit being a bind parameter isn't supported unless you are. It may be confusing the driver if you are using the 1.0.X version of the driver (not sure what error gets thrown if you do that).


was (Author: jjordan):
[~enrico.scalavino] are you using version 2.0.X of C* and the driver?  The limit being a bind parameter isn't supported unless you are. It be confusing the driver if you are using the 1.0.X version of the driver (not sure what error gets thrown if you do that).

> ArrayIndexOutOfBoundsException on range query from client
> ---------------------------------------------------------
>
>                 Key: CASSANDRA-6470
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6470
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Enrico Scalavino
>            Assignee: Ryan McGuire
>
> schema: 
> CREATE TABLE inboxkeyspace.inboxes(user_id bigint, message_id bigint, thread_id bigint, network_id bigint, read boolean, PRIMARY KEY(user_id, message_id)) WITH CLUSTERING ORDER BY (message_id DESC);
> CREATE INDEX ON inboxkeyspace.inboxes(read);
> query: 
> SELECT thread_id, message_id, network_id FROM inboxkeyspace.inboxes WHERE user_id = ? AND message_id < ? AND read = ? LIMIT ? 
> The query works if run via cqlsh. However, when run through the datastax client, on the client side we get a timeout exception and on the server side, the Cassandra log shows this exception: 
> ERROR [ReadStage:4190] 2013-12-10 13:18:03,579 CassandraDaemon.java (line 187) Exception in thread Thread[ReadStage:4190,5,main]
> java.lang.RuntimeException: java.lang.ArrayIndexOutOfBoundsException: 0
>         at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1940)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:722)
> Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
>         at org.apache.cassandra.db.filter.SliceQueryFilter.start(SliceQueryFilter.java:261)
>         at org.apache.cassandra.db.index.composites.CompositesSearcher.makePrefix(CompositesSearcher.java:66)
>         at org.apache.cassandra.db.index.composites.CompositesSearcher.getIndexedIterator(CompositesSearcher.java:101)
>         at org.apache.cassandra.db.index.composites.CompositesSearcher.search(CompositesSearcher.java:53)
>         at org.apache.cassandra.db.index.SecondaryIndexManager.search(SecondaryIndexManager.java:537)
>         at org.apache.cassandra.db.ColumnFamilyStore.search(ColumnFamilyStore.java:1669)
>         at org.apache.cassandra.db.PagedRangeCommand.executeLocally(PagedRangeCommand.java:109)
>         at org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1423)
>         at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1936)
>         ... 3 more



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)