You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Erik Forsberg (JIRA)" <ji...@apache.org> on 2015/05/21 13:20:00 UTC
[jira] [Created] (CASSANDRA-9450) Added column does not sort as the last column

Erik Forsberg created CASSANDRA-9450:
----------------------------------------

             Summary: Added column does not sort as the last column
                 Key: CASSANDRA-9450
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9450
             Project: Cassandra
          Issue Type: Bug
            Reporter: Erik Forsberg


Getting an AssertionError:

{noformat}
ERROR [ReadStage:977] 2015-05-21 10:52:33,283 CassandraDaemon.java (line 199) Exception in thread Thread[ReadStage:977,5,main]
java.lang.AssertionError: Added column does not sort as the last column
        at org.apache.cassandra.db.ArrayBackedSortedColumns.addColumn(ArrayBackedSortedColumns.java:116)
        at org.apache.cassandra.db.ColumnFamily.addColumn(ColumnFamily.java:121)
        at org.apache.cassandra.db.ColumnFamily.addIfRelevant(ColumnFamily.java:115)
        at org.apache.cassandra.db.filter.SliceQueryFilter.collectReducedColumns(SliceQueryFilter.java:211)
        at org.apache.cassandra.db.filter.QueryFilter.collateColumns(QueryFilter.java:122)
        at org.apache.cassandra.db.filter.QueryFilter.collateOnDiskAtom(QueryFilter.java:80)
        at org.apache.cassandra.db.filter.QueryFilter.collateOnDiskAtom(QueryFilter.java:72)
        at org.apache.cassandra.db.CollationController.collectAllData(CollationController.java:297)
        at org.apache.cassandra.db.CollationController.getTopLevelColumns(CollationController.java:53)
        at org.apache.cassandra.db.ColumnFamilyStore.getTopLevelColumns(ColumnFamilyStore.java:1567)
        at org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1386)
        at org.apache.cassandra.db.Keyspace.getRow(Keyspace.java:330)
        at org.apache.cassandra.db.SliceFromReadCommand.getRow(SliceFromReadCommand.java:65)
        at org.apache.cassandra.db.ReadVerbHandler.doVerb(ReadVerbHandler.java:47)
        at org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:62)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        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:745)
{noformat}

This happens if I run the following query:

{noformat}
select * from "Histograms_daily" where key = 'mykey' limit 90;
{noformat}

Running this however works:

{noformat}
select * from "Histograms_daily" where key = 'mykey' limit 89;
{noformat}

Table definitions is:

{noformat}
CREATE TABLE "Histograms_daily" (
  key text,
  bucket_size bigint,
  value bigint,
  PRIMARY KEY ((key), bucket_size)
) WITH COMPACT STORAGE AND
  bloom_filter_fp_chance=0.100000 AND
  caching='KEYS_ONLY' AND
  comment='' AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  index_interval=512 AND
  read_repair_chance=0.050000 AND
  replicate_on_write='true' AND
  populate_io_cache_on_flush='false' AND
  default_time_to_live=0 AND
  speculative_retry='99.0PERCENTILE' AND
  memtable_flush_period_in_ms=0 AND
  compaction={'sstable_size_in_mb': '256', 'class': 'LeveledCompactionStrategy'} AND
  compression={'sstable_compression': 'DeflateCompressor'};
{noformat}

Enabled TRACE on org.apache.cassandra.db. This gave me:

{noformat}
TRACE [ReadStage:1074] 2015-05-21 10:59:58,994 SliceQueryFilter.java (line 195) collecting 0 of 90: 0:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,994 SliceQueryFilter.java (line 195) collecting 1 of 90: 1:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,994 SliceQueryFilter.java (line 195) collecting 2 of 90: 2:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 3 of 90: 3:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 4 of 90: 4:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 5 of 90: 5:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 6 of 90: 6:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 7 of 90: 7:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 8 of 90: 8:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,995 SliceQueryFilter.java (line 195) collecting 9 of 90: 9:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 10 of 90: 10:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 11 of 90: 11:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 12 of 90: 12:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 13 of 90: 13:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 14 of 90: 14:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,996 SliceQueryFilter.java (line 195) collecting 15 of 90: 15:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 16 of 90: 16:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 17 of 90: 17:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 18 of 90: 18:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 19 of 90: 19:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 20 of 90: 20:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 21 of 90: 21:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,997 SliceQueryFilter.java (line 195) collecting 22 of 90: 22:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 23 of 90: 23:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 24 of 90: 24:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 25 of 90: 25:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 26 of 90: 26:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 27 of 90: 27:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,998 SliceQueryFilter.java (line 195) collecting 28 of 90: 28:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 29 of 90: 29:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 30 of 90: 30:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 31 of 90: 31:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 32 of 90: 32:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 33 of 90: 33:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 34 of 90: 34:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:58,999 SliceQueryFilter.java (line 195) collecting 35 of 90: 35:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 36 of 90: 36:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 37 of 90: 37:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 38 of 90: 38:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 39 of 90: 39:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 40 of 90: 40:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,000 SliceQueryFilter.java (line 195) collecting 41 of 90: 41:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 42 of 90: 42:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 43 of 90: 43:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 44 of 90: 44:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 45 of 90: 45:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 46 of 90: 46:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 47 of 90: 47:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,001 SliceQueryFilter.java (line 195) collecting 48 of 90: 48:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 49 of 90: 49:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 50 of 90: 50:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 51 of 90: 51:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 52 of 90: 52:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 53 of 90: 53:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 54 of 90: 54:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 55 of 90: 55:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 56 of 90: 56:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,002 SliceQueryFilter.java (line 195) collecting 57 of 90: 57:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 58 of 90: 58:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 59 of 90: 59:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 60 of 90: 60:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 61 of 90: 61:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 62 of 90: 62:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 63 of 90: 63:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 64 of 90: 64:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 65 of 90: 65:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 66 of 90: 66:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,003 SliceQueryFilter.java (line 195) collecting 67 of 90: 67:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 68 of 90: 68:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 69 of 90: 69:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 70 of 90: 70:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 71 of 90: 71:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 72 of 90: 72:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 73 of 90: 73:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 74 of 90: 74:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 75 of 90: 75:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 76 of 90: 76:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,004 SliceQueryFilter.java (line 195) collecting 77 of 90: 77:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 78 of 90: 79:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 79 of 90: 80:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 80 of 90: 82:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 81 of 90: 83:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 82 of 90: 84:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 83 of 90: 86:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 84 of 90: 87:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 85 of 90: 88:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,005 SliceQueryFilter.java (line 195) collecting 86 of 90: 89:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,006 SliceQueryFilter.java (line 195) collecting 87 of 90: 94:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,006 SliceQueryFilter.java (line 195) collecting 88 of 90: 95:false:8@1432181173176000!15450827
TRACE [ReadStage:1074] 2015-05-21 10:59:59,006 SliceQueryFilter.java (line 195) collecting 89 of 90: -1501:false:8@1432181173176000!15450827
{noformat}

Traceback is different than CASSANDRA-7867.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)