[
https://issues.apache.org/jira/browse/CASSANDRA-10988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15230612#comment-15230612
]
Vadim TSes'ko commented on CASSANDRA-10988:
-------------------------------------------
We managed to reproduce the bug using Cassandra 2.2.5 with the following table
schema (unset parameters use default values):
{code:sql}
CREATE TABLE mytable (
u text,
t timeuuid,
PRIMARY KEY (u, t)
) WITH COMPACT STORAGE
AND CLUSTERING ORDER BY (t DESC)
AND compaction = {'min_threshold': '2', 'class':
'org.apache.cassandra.db.compaction.DateTieredCompactionStrategy',
'base_time_seconds': '1'}
AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}
AND dclocal_read_repair_chance = 0.0
AND default_time_to_live = 10
AND gc_grace_seconds = 0
AND read_repair_chance = 0.0;
{code}
And the following query:
{code:sql}
SELECT COUNT(1) as cnt
FROM mytable
WHERE u = :user AND t > :timestamp
ORDER BY t DESC
LIMIT 110;
{code}
Removing {{COMPACT STORAGE}} definitely helps, so it is somehow connected.
> ClassCastException in SelectStatement
> -------------------------------------
>
> Key: CASSANDRA-10988
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10988
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Reporter: Vassil Hristov
>
> After we've upgraded our cluster to version 2.1.11, we started getting the
> bellow exceptions for some of our queries. Issue seems to be very similar to
> CASSANDRA-7284.
> {code:java}
> java.lang.ClassCastException:
> org.apache.cassandra.db.composites.Composites$EmptyComposite cannot be cast
> to org.apache.cassandra.db.composites.CellName
> at
> org.apache.cassandra.db.composites.AbstractCellNameType.cellFromByteBuffer(AbstractCellNameType.java:188)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.db.composites.AbstractSimpleCellNameType.makeCellName(AbstractSimpleCellNameType.java:125)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.db.composites.AbstractCellNameType.makeCellName(AbstractCellNameType.java:254)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.makeExclusiveSliceBound(SelectStatement.java:1197)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.applySliceRestriction(SelectStatement.java:1205)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.processColumnFamily(SelectStatement.java:1283)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:1250)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:299)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:276)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:224)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:67)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:238)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.cql3.QueryProcessor.processPrepared(QueryProcessor.java:493)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.transport.messages.ExecuteMessage.execute(ExecuteMessage.java:138)
> ~[apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439)
> [apache-cassandra-2.1.11.jar:2.1.11]
> at
> org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335)
> [apache-cassandra-2.1.11.jar:2.1.11]
> at
> io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
> [netty-all-4.0.23.Final.jar:4.0.23.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-all-4.0.23.Final.jar:4.0.23.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32)
> [netty-all-4.0.23.Final.jar:4.0.23.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324)
> [netty-all-4.0.23.Final.jar:4.0.23.Final]
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> [na:1.8.0_66]
> at
> org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164)
> [apache-cassandra-2.1.11.jar:2.1.11]
> at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105)
> [apache-cassandra-2.1.11.jar:2.1.11]
> at java.lang.Thread.run(Thread.java:745) [na:1.8.0_66]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
