cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Petrus Gomes <petru...@gmail.com>
Subject Re: Read after Write inconsistent at times
Date Fri, 24 Feb 2017 17:35:30 GMT
Hi,

Check the tombstone count, If is it to high, your query will be impacted.

If tombstone is a problem, you can try to reduce your "gc_grace_seconds" to
reduce tombstone count(Carefully because you use cross data centers).

Tchau,
Petrus Silva



On Fri, Feb 24, 2017 at 12:07 AM, Jan Kesten <j.kesten@enercast.de> wrote:

> Hi,
>
> are your nodes at high load? Are there any dropped messages (nodetool
> tpstats) on any node?
>
> Also have a look at your system clocks. C* needs them in thight sync - via
> ntp for example. Side hint: if you use ntp use the same set of upstreams on
> all of your nodes - ideal your own one. Using pool.ntp.org might lead to
> minimal dirfts in time across your cluster.
>
> Another thing that could help you out is using client side timestamps:
> https://docs.datastax.com/en/developer/java-driver/3.1/manua
> l/query_timestamps/ (of course only when you are using a single client or
> all clients are in sync via ntp).
>
>
>
> Am 24.02.2017 um 07:29 schrieb Charulata Sharma (charshar):
>
>>
>> Hi All,
>>
>> In my application sometimes I cannot read data that just got inserted.
>> This happens very intermittently. Both write and read use LOCAL QUOROM.
>>
>> We have a cluster of 12 nodes which spans across 2 Data Centers and a RF
>> of 3.
>>
>> Has anyone encountered this problem and if yes what steps have you taken
>> to solve it
>>
>> Thanks,
>> Charu
>>
>
> --
> Jan Kesten, mailto:j.kesten@enercast.de
> Tel.: +49 561/4739664-0 FAX: -9 Mobil: +49 160 / 90 98 41 68
> enercast GmbH Universitätsplatz 12 D-34127 Kassel HRB15471
> http://www.enercast.de Online-Prognosen für erneuerbare Energien
> Geschäftsführung: Thomas Landgraf (CEO), Bernd Kratz (CTO), Philipp Rinder
> (CSO)
>
> Diese E-Mail und etwaige Anhänge können vertrauliche und/oder rechtlich
> geschützte Informationen enthalten. Falls Sie nicht der angegebene
> Empfänger sind oder falls diese E-Mail irrtümlich an Sie adressiert wurde,
> benachrichtigen Sie uns bitte sofort durch Antwort-E-Mail und löschen Sie
> diese E-Mail nebst etwaigen Anlagen von Ihrem System. Ebenso dürfen Sie
> diese E-Mail oder ihre Anlagen nicht kopieren oder an Dritte weitergeben.
> Vielen Dank.
>
> This e-mail and any attachment may contain confidential and/or privileged
> information. If you are not the named addressee or if this transmission has
> been addressed to you in error, please notify us immediately by reply
> e-mail and then delete this e-mail and any attachment from your system.
> Please understand that you must not copy this e-mail or any attachment or
> disclose the contents to any other person. Thank you for your cooperation.
>
>

Mime
View raw message