If you are seeing failed secondary index reads you may be seeing this https://issues.apache.org/jira/browse/CASSANDRA-5079
Cheers ----------------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 29/01/2013, at 3:31 AM, Matthias Zeilinger <matthias.zeilin...@bwinparty.com> wrote: > Hi, > > 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? > > Br, > Matthias Zeilinger > Production Operation – Shared Services > > P: +43 (0) 50 858-31185 > M: +43 (0) 664 85-34459 > E: matthias.zeilin...@bwinparty.com > > bwin.party services (Austria) GmbH > Marxergasse 1B > A-1030 Vienna > > www.bwinparty.com > > From: Viktor Jevdokimov [mailto:viktor.jevdoki...@adform.com] > Sent: Montag, 28. Jänner 2013 15:25 > To: user@cassandra.apache.org > 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 see. > > Best regards / Pagarbiai > Viktor Jevdokimov > Senior Developer > > Email: viktor.jevdoki...@adform.com > Phone: +370 5 212 3063, Fax +370 5 261 0453 > J. Jasinskio 16C, LT-01112 Vilnius, Lithuania > Follow us on Twitter: @adforminsider > Take a ride with Adform's Rich Media Suite > <image001.png> > <image002.png> > > 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 [mailto:matthias.zeilin...@bwinparty.com] > Sent: Monday, January 28, 2013 15:57 > To: user@cassandra.apache.org > Subject: data not shown up after some time > > Hi, > > 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 > > Br, > Matthias Zeilinger > Production Operation – Shared Services > > P: +43 (0) 50 858-31185 > M: +43 (0) 664 85-34459 > E: matthias.zeilin...@bwinparty.com > > bwin.party services (Austria) GmbH > Marxergasse 1B > A-1030 Vienna > > www.bwinparty.com >
