Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5F16610254 for ; Fri, 13 Dec 2013 03:12:30 +0000 (UTC) Received: (qmail 64128 invoked by uid 500); 13 Dec 2013 03:11:34 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 64061 invoked by uid 500); 13 Dec 2013 03:11:25 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 63885 invoked by uid 99); 13 Dec 2013 03:11:10 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Dec 2013 03:11:10 +0000 Date: Fri, 13 Dec 2013 03:11:09 +0000 (UTC) From: "Marcos Trama (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CASSANDRA-6470) ArrayIndexOutOfBoundsException on range query from client MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-6470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13847099#comment-13847099 ] Marcos Trama commented on CASSANDRA-6470: ----------------------------------------- I get the same error. I dont know when it has been started. I'm using Cassandra 2.0.2 and Datastax Java Driver 2.0.0-beta2. Query works in cqlsh but fail when running in the client. I tried to re-create (DROP/CREATE) the column family, but the error stills. Query in the cqlsh: cqlsh:pollkan> SELECT observer FROM observed WHERE observed = fa93c210-4bff-11e3-b48f-5714d8c6f3b2 AND observer > 00000000-0000-1000-0000-000000000000 and blocked = false LIMIT 10000; observer -------------------------------------- 43814f60-5bb1-11e3-97c8-ad396a9e8180 (1 rows) Query in the client: 2013-12-13/00:53:03.039/BRST [timeline_1] DEBUG br.com.pollkan.batch.CqlCommands Execute query [SELECT observer FROM observed WHERE observed = ? AND observer > ? and blocked = ? LIMIT 10000;] arguments [[fa93c210-4bff-11e3-b48f-5714d8c6f3b2][00000000-0000-1000-0000-000000000000][false]] Error in cassandra: ERROR [ReadStage:52] 2013-12-13 01:04:56,799 CassandraDaemon.java (line 187) Exception in thread Thread[ReadStage:52,5,main] java.lang.RuntimeException: java.lang.ArrayIndexOutOfBoundsException: 0 at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1931) 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:724) 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:1649) at org.apache.cassandra.db.PagedRangeCommand.executeLocally(PagedRangeCommand.java:109) at org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMayThrow(StorageProxy.java:1414) at org.apache.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1927) ... 3 more Error from driver log: 2013-12-13/01:05:06.798/BRST [timeline_1] ERROR br.com.pollkan.batch.CqlCommands Exception! [Cassandra timeout during read query at consistency ONE (1 responses were required but only 0 replica responded)] com.datastax.driver.core.exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency ONE (1 responses were required but only 0 replica responded) at com.datastax.driver.core.exceptions.ReadTimeoutException.copy(ReadTimeoutException.java:69) at com.datastax.driver.core.ResultSetFuture.extractCauseFromExecutionException(ResultSetFuture.java:271) at com.datastax.driver.core.ResultSetFuture.getUninterruptibly(ResultSetFuture.java:187) at com.datastax.driver.core.Session.execute(Session.java:126) at br.com.pollkan.batch.CqlCommands.executeQuery(CqlCommands.java:149) at br.com.pollkan.batch.BaseBatch.processChild(BaseBatch.java:364) at br.com.pollkan.batch.BaseBatch.run(BaseBatch.java:640) at java.lang.Thread.run(Thread.java:722) If need more information, please let me know. Tks > 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)