[CASSANDRA-8461] java.lang.AssertionError when running select queries

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Component/s: Legacy/CQL

Environment

ubuntu 14.04

• Severity: Normal
• Assignee: Unassigned
• Reporter: Chamila Dilshan Wijayarathna
• Created: 11/Dec/14 18:35
• Updated: 16/Apr/19 09:31
• Resolved: 11/Dec/14 18:52

Description

I have a column family with following schema.

CREATE TABLE corpus.trigram_category_ordered_frequency (
id bigint,
word1 varchar,
word2 varchar,
word3 varchar,
category varchar,
frequency int,
PRIMARY KEY(category,frequency,word1,word2,word3)
);

When I run

select word1,word2,word3 from corpus.trigram_category_ordered_frequency where category IN ('N','A','C','S','G') order by frequency DESC LIMIT 10;

I am getting error saying

<ErrorMessage code=0000 [Server error] message="java.lang.AssertionError">

But when I ran

select * from corpus.trigram_category_ordered_frequency where category IN ('N','A','C','S','G') order by frequency DESC LIMIT 10;

it works without any error.

system log for this error is as follows.

ERROR [SharedPool-Worker-1] 2014-12-11 20:42:20,152 Message.java:538 - Unexpected exception during request; channel = [id: 0xea57d8b6, /127.0.0.1:35624 => /127.0.0.1:9042]
java.lang.AssertionError: null
	at org.apache.cassandra.cql3.ResultSet.addRow(ResultSet.java:63) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.Selection$ResultSetBuilder.newRow(Selection.java:333) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.processColumnFamily(SelectStatement.java:1227) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:1161) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:290) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:267) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:215) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:64) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:226) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:248) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:119) ~[apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:439) [apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:335) [apache-cassandra-2.1.2.jar:2.1.2]
	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:471) [na:1.7.0_72]
	at org.apache.cassandra.concurrent.AbstractTracingAwareExecutorService$FutureTask.run(AbstractTracingAwareExecutorService.java:164) [apache-cassandra-2.1.2.jar:2.1.2]
	at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-2.1.2.jar:2.1.2]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_72]

Issue Links

• duplicates: CASSANDRA-8286 Regression in ORDER BY