[jira] [Updated] (CASSANDRA-8356) Slice query on a super column family with counters doesn't get all the data
[
https://issues.apache.org/jira/browse/CASSANDRA-8356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
T Jake Luciani updated CASSANDRA-8356:
--
Fix Version/s: (was: 2.0.12)
2.0.13
Slice query on a super column family with counters doesn't get all the data
---
Key: CASSANDRA-8356
URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
Project: Cassandra
Issue Type: Bug
Reporter: Nicolas Lalevée
Assignee: Aleksey Yeschenko
Fix For: 2.0.13
We've finally been able to upgrade our cluster to 2.0.11, after
CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return
all the expected data. We first though because of all the trouble we had that
we lost data, but there a way to actually get the data, so nothing is lost;
it just that cassandra seems to incorrectly skip it.
See the following CQL log:
{noformat}
cqlsh:Theme desc table theme_view;
CREATE TABLE theme_view (
key bigint,
column1 varint,
column2 text,
value counter,
PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
cqlsh:Theme select * from theme_view where key = 99421 limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2011-03-26 | 5
99421 | -12 | 2011-03-27 | 2
99421 | -12 | 2011-03-28 |40
99421 | -12 | 2011-03-29 |14
99421 | -12 | 2011-03-30 |17
99421 | -12 | 2011-03-31 | 5
99421 | -12 | 2011-04-01 |37
99421 | -12 | 2011-04-02 | 7
99421 | -12 | 2011-04-03 | 4
(10 rows)
cqlsh:Theme select * from theme_view where key = 99421 and column1 = -12
limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2014-05-06 |15
99421 | -12 | 2014-06-06 | 7
99421 | -12 | 2014-06-10 |22
99421 | -12 | 2014-06-11 |34
99421 | -12 | 2014-06-12 |35
99421 | -12 | 2014-06-13 |26
99421 | -12 | 2014-06-14 |16
99421 | -12 | 2014-06-15 |24
99421 | -12 | 2014-06-16 |25
(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not.
Via thrift, we have the exact same bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-8356) Slice query on a super column family with counters doesn't get all the data
[
https://issues.apache.org/jira/browse/CASSANDRA-8356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-8356:
---
Tester: Philip Thompson
Slice query on a super column family with counters doesn't get all the data
---
Key: CASSANDRA-8356
URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
Project: Cassandra
Issue Type: Bug
Reporter: Nicolas Lalevée
Assignee: Aleksey Yeschenko
Fix For: 2.0.12
We've finally been able to upgrade our cluster to 2.0.11, after
CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return
all the expected data. We first though because of all the trouble we had that
we lost data, but there a way to actually get the data, so nothing is lost;
it just that cassandra seems to incorrectly skip it.
See the following CQL log:
{noformat}
cqlsh:Theme desc table theme_view;
CREATE TABLE theme_view (
key bigint,
column1 varint,
column2 text,
value counter,
PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
cqlsh:Theme select * from theme_view where key = 99421 limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2011-03-26 | 5
99421 | -12 | 2011-03-27 | 2
99421 | -12 | 2011-03-28 |40
99421 | -12 | 2011-03-29 |14
99421 | -12 | 2011-03-30 |17
99421 | -12 | 2011-03-31 | 5
99421 | -12 | 2011-04-01 |37
99421 | -12 | 2011-04-02 | 7
99421 | -12 | 2011-04-03 | 4
(10 rows)
cqlsh:Theme select * from theme_view where key = 99421 and column1 = -12
limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2014-05-06 |15
99421 | -12 | 2014-06-06 | 7
99421 | -12 | 2014-06-10 |22
99421 | -12 | 2014-06-11 |34
99421 | -12 | 2014-06-12 |35
99421 | -12 | 2014-06-13 |26
99421 | -12 | 2014-06-14 |16
99421 | -12 | 2014-06-15 |24
99421 | -12 | 2014-06-16 |25
(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not.
Via thrift, we have the exact same bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-8356) Slice query on a super column family with counters doesn't get all the data
[
https://issues.apache.org/jira/browse/CASSANDRA-8356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nicolas Lalevée updated CASSANDRA-8356:
---
Summary: Slice query on a super column family with counters doesn't get all
the data (was: Slice query on a super column family with counters don't get
all the data)
Slice query on a super column family with counters doesn't get all the data
---
Key: CASSANDRA-8356
URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
Project: Cassandra
Issue Type: Bug
Reporter: Nicolas Lalevée
We've finally been able to upgrade our cluster to 2.0.11, after
CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return
all the expected data. We first though because of all the trouble we had that
we lost data, but there a way to actually get the data, so nothing is lost;
it just that cassandra seems to incorrectly skip it.
See the following CQL log:
{noformat}
cqlsh:Theme desc table theme_view;
CREATE TABLE theme_view (
key bigint,
column1 varint,
column2 text,
value counter,
PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
cqlsh:Theme select * from theme_view where key = 99421 limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2011-03-26 | 5
99421 | -12 | 2011-03-27 | 2
99421 | -12 | 2011-03-28 |40
99421 | -12 | 2011-03-29 |14
99421 | -12 | 2011-03-30 |17
99421 | -12 | 2011-03-31 | 5
99421 | -12 | 2011-04-01 |37
99421 | -12 | 2011-04-02 | 7
99421 | -12 | 2011-04-03 | 4
(10 rows)
cqlsh:Theme select * from theme_view where key = 99421 and column1 = -12
limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2014-05-06 |15
99421 | -12 | 2014-06-06 | 7
99421 | -12 | 2014-06-10 |22
99421 | -12 | 2014-06-11 |34
99421 | -12 | 2014-06-12 |35
99421 | -12 | 2014-06-13 |26
99421 | -12 | 2014-06-14 |16
99421 | -12 | 2014-06-15 |24
99421 | -12 | 2014-06-16 |25
(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not.
Via thrift, we have the exact same bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-8356) Slice query on a super column family with counters doesn't get all the data
[
https://issues.apache.org/jira/browse/CASSANDRA-8356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-8356:
---
Assignee: Aleksey Yeschenko
Slice query on a super column family with counters doesn't get all the data
---
Key: CASSANDRA-8356
URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
Project: Cassandra
Issue Type: Bug
Reporter: Nicolas Lalevée
Assignee: Aleksey Yeschenko
Fix For: 2.0.12
We've finally been able to upgrade our cluster to 2.0.11, after
CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return
all the expected data. We first though because of all the trouble we had that
we lost data, but there a way to actually get the data, so nothing is lost;
it just that cassandra seems to incorrectly skip it.
See the following CQL log:
{noformat}
cqlsh:Theme desc table theme_view;
CREATE TABLE theme_view (
key bigint,
column1 varint,
column2 text,
value counter,
PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
cqlsh:Theme select * from theme_view where key = 99421 limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2011-03-26 | 5
99421 | -12 | 2011-03-27 | 2
99421 | -12 | 2011-03-28 |40
99421 | -12 | 2011-03-29 |14
99421 | -12 | 2011-03-30 |17
99421 | -12 | 2011-03-31 | 5
99421 | -12 | 2011-04-01 |37
99421 | -12 | 2011-04-02 | 7
99421 | -12 | 2011-04-03 | 4
(10 rows)
cqlsh:Theme select * from theme_view where key = 99421 and column1 = -12
limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2014-05-06 |15
99421 | -12 | 2014-06-06 | 7
99421 | -12 | 2014-06-10 |22
99421 | -12 | 2014-06-11 |34
99421 | -12 | 2014-06-12 |35
99421 | -12 | 2014-06-13 |26
99421 | -12 | 2014-06-14 |16
99421 | -12 | 2014-06-15 |24
99421 | -12 | 2014-06-16 |25
(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not.
Via thrift, we have the exact same bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (CASSANDRA-8356) Slice query on a super column family with counters doesn't get all the data
[
https://issues.apache.org/jira/browse/CASSANDRA-8356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Philip Thompson updated CASSANDRA-8356:
---
Fix Version/s: 2.0.12
Slice query on a super column family with counters doesn't get all the data
---
Key: CASSANDRA-8356
URL: https://issues.apache.org/jira/browse/CASSANDRA-8356
Project: Cassandra
Issue Type: Bug
Reporter: Nicolas Lalevée
Assignee: Aleksey Yeschenko
Fix For: 2.0.12
We've finally been able to upgrade our cluster to 2.0.11, after
CASSANDRA-7188 being fixed.
But now slice queries on a super column family with counters doesn't return
all the expected data. We first though because of all the trouble we had that
we lost data, but there a way to actually get the data, so nothing is lost;
it just that cassandra seems to incorrectly skip it.
See the following CQL log:
{noformat}
cqlsh:Theme desc table theme_view;
CREATE TABLE theme_view (
key bigint,
column1 varint,
column2 text,
value counter,
PRIMARY KEY ((key), column1, column2)
) WITH COMPACT STORAGE AND
bloom_filter_fp_chance=0.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={'class': 'SizeTieredCompactionStrategy'} AND
compression={'sstable_compression': 'SnappyCompressor'};
cqlsh:Theme select * from theme_view where key = 99421 limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2011-03-26 | 5
99421 | -12 | 2011-03-27 | 2
99421 | -12 | 2011-03-28 |40
99421 | -12 | 2011-03-29 |14
99421 | -12 | 2011-03-30 |17
99421 | -12 | 2011-03-31 | 5
99421 | -12 | 2011-04-01 |37
99421 | -12 | 2011-04-02 | 7
99421 | -12 | 2011-04-03 | 4
(10 rows)
cqlsh:Theme select * from theme_view where key = 99421 and column1 = -12
limit 10;
key | column1 | column2| value
---+-++---
99421 | -12 | 2011-03-25 |59
99421 | -12 | 2014-05-06 |15
99421 | -12 | 2014-06-06 | 7
99421 | -12 | 2014-06-10 |22
99421 | -12 | 2014-06-11 |34
99421 | -12 | 2014-06-12 |35
99421 | -12 | 2014-06-13 |26
99421 | -12 | 2014-06-14 |16
99421 | -12 | 2014-06-15 |24
99421 | -12 | 2014-06-16 |25
(10 rows)
{noformat}
As you can see the second query should return data from 2012, but it is not.
Via thrift, we have the exact same bug.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
