cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Philip Thompson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-9450) Added column does not sort as the last column
Date Thu, 04 Jun 2015 14:04:38 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-9450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14572809#comment-14572809
] 

Philip Thompson commented on CASSANDRA-9450:
--------------------------------------------

This seems like a duplicate of CASSANDRA-8985, which we could not reproduce. Potentially the
additional information will be enough. [~carlyeks], do you want to handle this ticket as well?

> 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
>             Fix For: 2.0.x
>
>
> 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)

Mime
View raw message