Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-8461

java.lang.AssertionError when running select queries

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: Legacy/CQL
    • Labels:
      None
    • Environment:

      ubuntu 14.04

    • Severity:
      Normal

      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]

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                cdwijayarathna Chamila Dilshan Wijayarathna
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: