cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthias Zeilinger <>
Subject RE: data not shown up after some time
Date Mon, 28 Jan 2013 14:31:31 GMT

No I have checked the TTL: 7776000

Very interesting is, if I do a simple "list <cf>;" the data is shown, but it I do a
"get <cf> where <index>='<testvalue>';" it returns "0 Row Returned".

How can that be?

Matthias Zeilinger
Production Operation - Shared Services

P: +43 (0) 50 858-31185
M: +43 (0) 664 85-34459
E: services (Austria) GmbH
Marxergasse 1B
A-1030 Vienna

From: Viktor Jevdokimov []
Sent: Montag, 28. Jänner 2013 15:25
Subject: RE: data not shown up after some time

Are you sure your app is setting TTL correctly?
TTL is in seconds. For 90 days it have to be 90*24*60*60=7776000.
What If you set by accident 777600 (10 times less) - that will be 9 days, almost what you

Best regards / Pagarbiai
Viktor Jevdokimov
Senior Developer

Phone: +370 5 212 3063, Fax +370 5 261 0453
J. Jasinskio 16C, LT-01112 Vilnius, Lithuania
Follow us on Twitter: @adforminsider<!/adforminsider>
Take a ride with Adform's Rich Media Suite<>

[Adform News]<>
[Adform awarded the Best Employer 2012]<>

Disclaimer: The information contained in this message and attachments is intended solely for
the attention and use of the named addressee and may be confidential. If you are not the intended
recipient, you are reminded that the information remains the property of the sender. You must
not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this
message in error, please contact the sender immediately and irrevocably delete this message
and any copies.

From: Matthias Zeilinger []
Sent: Monday, January 28, 2013 15:57
Subject: data not shown up after some time


I´m a simple operations guy and new to Cassandra.
I have the problem that one of our application is writing data into Cassandra (but not deleting
them, because we should have a 90 days TTL).
The application operates in 1 KS with 5 CF. my current setup:

3 node cluster and KS has a RF of 3 (I know it´s not the best setup)

I can see now the problem that after 10 days most (nearly all) data are not showing anymore
in the cli and also our application cannot see the data.
I assume that it has something to do with the gc_grace_seconds, it is set to 10 days.

I have read many documentations about tombstones, but our application doesn´t perform deletes.
How can I see in the cli, if I row key has any tombstone or not.

Could it be that there are some ghost tombstones?

Thx for your help

Matthias Zeilinger
Production Operation - Shared Services

P: +43 (0) 50 858-31185
M: +43 (0) 664 85-34459
E:<> services (Austria) GmbH
Marxergasse 1B
A-1030 Vienna<>

View raw message