[jira] [Commented] (CASSANDRA-5762) Lost row marker after TTL expires

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

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

Jeremiah Jordan commented on CASSANDRA-5762:
--------------------------------------------

Could we keep a "something in here has a TTL" flag and do the optimized way unless it is set?  I think we even already keep that kind of data to do the sstable tombstone compaction?  That way if you don't use TTL's, and you have big columns, you don't get the heap penalty (CASSANDRA-6569).

> Lost row marker after TTL expires
> ---------------------------------
>
>                 Key: CASSANDRA-5762
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5762
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>         Environment: Ubuntu 12.04
>            Reporter: Taner Catakli
>            Assignee: Sylvain Lebresne
>            Priority: Critical
>             Fix For: 1.2.7
>
>         Attachments: 0001-Always-do-slice-queries-for-CQL3-tables.txt
>
>
> I have the following table
> cqlsh:loginproject> DESCRIBE TABLE gameservers;
>  
> CREATE TABLE gameservers (
>   address inet PRIMARY KEY,
>   last_update timestamp,
>   regions blob,
>   server_status boolean
> ) WITH
>   bloom_filter_fp_chance=0.010000 AND
>   caching='KEYS_ONLY' AND
>   comment='' AND
>   dclocal_read_repair_chance=0.000000 AND
>   gc_grace_seconds=864000 AND
>   read_repair_chance=0.100000 AND
>   replicate_on_write='true' AND
>   populate_io_cache_on_flush='false' AND
>   compaction={'class': 'SizeTieredCompactionStrategy'} AND
>   compression={'sstable_compression': 'SnappyCompressor'};
> after inserting a row and executing the following command:
> UPDATE gameservers USING TTL 10 SET server_status = true WHERE address = '192.168.0.100'
> after waiting for the ttl to expire, the row will lose its rowmarker making "select address from gameservers" returning 0 results although there are some.
> in cassandra-cli the table looks like this:
> [default@loginproject] list gameservers;
> Using default limit of 100
> Using default cell limit of 100
> -------------------
> RowKey: 192.168.0.100
> => (name=last_update, value=0000000000000017, timestamp=1373884433543000)
> => (name=regions, value=<truncated>, timestamp=1373883701652000)
> 1 Row Returned.
> Elapsed time: 345 msec(s).
> [default@loginproject]



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)