Hi Philip, I'm using version 2.1.2.
Following is the error log at system.log. ( https://gist.github.com/cdwijayarathna/2749f52c52f5c7fd807d ) 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] Thank you! On Thu, Dec 11, 2014 at 8:35 PM, Philip Thompson < philip.thomp...@datastax.com> wrote: > The full error should be in that node's system.log file. What version are > you running? > > On Thu, Dec 11, 2014 at 9:42 AM, Chamila Wijayarathna < > cdwijayarat...@gmail.com> wrote: > >> Hi Philip, >> >> I ran my queries on cqlsh terminal and it only shows this. >> >> Thank you! >> >> On Thu, Dec 11, 2014 at 6:43 PM, Philip Thompson < >> philip.thomp...@datastax.com> wrote: >> >>> There is a definitely a problem here, but without the entire stack >>> trace, it is unclear what exactly may be wrong. >>> >>> On Thu, Dec 11, 2014 at 7:37 AM, Chamila Wijayarathna < >>> cdwijayarat...@gmail.com> wrote: >>> >>>> Hello all, >>>> >>>> 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. >>>> >>>> Is this a bug or what is wrong here? >>>> >>>> Thank You! >>>> >>>> -- >>>> *Chamila Dilshan Wijayarathna,* >>>> SMIEEE, SMIESL, >>>> Undergraduate, >>>> Department of Computer Science and Engineering, >>>> University of Moratuwa. >>>> >>> >>> >> >> >> -- >> *Chamila Dilshan Wijayarathna,* >> SMIEEE, SMIESL, >> Undergraduate, >> Department of Computer Science and Engineering, >> University of Moratuwa. >> > > -- *Chamila Dilshan Wijayarathna,* SMIEEE, SMIESL, Undergraduate, Department of Computer Science and Engineering, University of Moratuwa.
