[
https://issues.apache.org/jira/browse/CASSANDRA-7268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14019564#comment-14019564
]
Jeremiah Jordan commented on CASSANDRA-7268:
--------------------------------------------
Simple reproduction:
{noformat}
CREATE KEYSPACE test WITH replication = {'class': 'SimpleStrategy',
'replication_factor': 1};
USE test;
CREATE COLUMNFAMILY cf5 ( a text PRIMARY KEY, b text, c text, d text ) WITH
COMPACT STORAGE;
CREATE INDEX c5idx ON cf5 (c);
INSERT INTO cf5 (a, b, c, d) VALUES ( '3', '2', '3', '4') USING TTL 84960 AND
TIMESTAMP 1402027485644050;
#PAUSE for a sec
INSERT INTO cf5 (a, b, c, d) VALUES ( '3', '2', '3', '4') USING TTL 84960 AND
TIMESTAMP 1402027485644050;
select * from cf5 where c='3';
{noformat}
This seems fixed by something in 2.1, but is broken in 1.2 and 2.0 branches.
> Secondary Index can miss data without an error
> ----------------------------------------------
>
> Key: CASSANDRA-7268
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7268
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Reporter: Jeremiah Jordan
> Assignee: Sam Tunnicliffe
>
> Seeing issues with secondary indexes after upgrading from 1.1->1.2. Using
> the same thrift code from 1.1, every once in a while a row is inserted that
> does not show up in the secondary index on a text column.
> Using sstable2json we can see the row in the regular sstables on every node,
> but not in the secondary index sstables (even after flushing/taking a
> snapshot).
> If we move the snapshot to a test node and rebuild the secondary index, it
> gets populated correctly and returns the data.
> Sanitized create statement:
> {noformat}
> create column family test2i
> with column_type = 'Standard'
> and comparator = 'UTF8Type'
> and default_validation_class = 'UTF8Type'
> and key_validation_class = 'UTF8Type'
> and read_repair_chance = 1.0
> and dclocal_read_repair_chance = 0.0
> and populate_io_cache_on_flush = false
> and gc_grace = 0
> and min_compaction_threshold = 4
> and max_compaction_threshold = 32
> and replicate_on_write = false
> and compaction_strategy =
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'
> and caching = 'KEYS_ONLY'
> and column_metadata = [
> {column_name : 'second',
> validation_class : UTF8Type,
> index_name : 'test2i_second_idx',
> index_type : 0},
> {column_name : 'A',
> validation_class : UTF8Type},
> {column_name : 'B',
> validation_class : UTF8Type},
> {column_name : 'C',
> validation_class : UTF8Type},
> {column_name : 'D',
> validation_class : UTF8Type},
> {column_name : 'E',
> validation_class : UTF8Type},
> {column_name : 'F',
> validation_class : UTF8Type},
> {column_name : 'G',
> validation_class : UTF8Type},
> {column_name : 'H',
> validation_class : UTF8Type},
> {column_name : 'I',
> validation_class : UTF8Type},
> {column_name : 'J',
> validation_class : UTF8Type},
> {column_name : 'K',
> validation_class : UTF8Type},
> {column_name : 'L',
> validation_class : UTF8Type},
> {column_name : 'M',
> validation_class : UTF8Type}]
> and compression_options = {'sstable_compression' :
> 'org.apache.cassandra.io.compress.SnappyCompressor'};
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
