[jira] [Updated] (CASSANDRA-7268) Secondary Index can miss data without an error

["Jeremiah Jordan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-7268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeremiah Jordan updated CASSANDRA-7268:
---------------------------------------

    Reproduced In: 2.0.8, 1.2.15, 1.2.12  (was: 1.2.12)

> 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)