How can I check for this secondary index read fails? Is it in the system.log or over the nodetool?
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: aaron morton [mailto:aa...@thelastpickle.com] Sent: Dienstag, 29. Jänner 2013 08:04 To: user@cassandra.apache.org Subject: Re: data not shown up after some time 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<mailto: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<mailto:matthias.zeilin...@bwinparty.com> bwin.party services (Austria) GmbH Marxergasse 1B A-1030 Vienna www.bwinparty.com<http://www.bwinparty.com> From: Viktor Jevdokimov [mailto:viktor.jevdoki...@adform.com<http://adform.com>] Sent: Montag, 28. Jänner 2013 15:25 To: user@cassandra.apache.org<mailto: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<mailto: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<http://twitter.com/#!/adforminsider> Take a ride with Adform's Rich Media Suite<http://vimeo.com/adform/richmedia> <image001.png><http://www.adform.com> <image002.png><http://www.adform.com/site/blog/adform/adform-takes-top-spot-in-best-employer-survey/> 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<http://bwinparty.com>] Sent: Monday, January 28, 2013 15:57 To: user@cassandra.apache.org<mailto: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<mailto:matthias.zeilin...@bwinparty.com> bwin.party services (Austria) GmbH Marxergasse 1B A-1030 Vienna www.bwinparty.com<http://www.bwinparty.com>
