cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-5762) Lost row marker after TTL expires
Date Wed, 15 Jan 2014 12:12:21 GMT

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

Sylvain Lebresne commented on CASSANDRA-5762:
---------------------------------------------

Actually, CASSANDRA-6588 is probably a better idea than my "disable ttl option" above.

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

Mime
View raw message