Re: Read after Write inconsistent at times

2017-02-25 Thread Anuj Wadehra
assandra.apache.org> Date: Friday, February 24, 2017 at 9:42 AM To: "user@cassandra.apache.org" <user@cassandra.apache.org> Subject: Re: Read after Write inconsistent at times WRT to NTP, I first encountered this issue on my first cluster.  The problem with ntp isn't just if you're

Re: Read after Write inconsistent at times

2017-02-24 Thread Charulata Sharma (charshar)
a.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Subject: Re: Read after Write inconsistent at times WRT to NTP, I first encountered this issue on my first cluster. The problem with ntp isn't just if you're doin

Re: Read after Write inconsistent at times

2017-02-24 Thread Jonathan Haddad
WRT to NTP, I first encountered this issue on my first cluster. The problem with ntp isn't just if you're doing inserts, it's if you're doing inserts in combination with deletes, and using server timestamps with a greater variance than the period between the delete and the insert. Basically, you

Re: Read after Write inconsistent at times

2017-02-24 Thread Petrus Gomes
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

Re: Read after Write inconsistent at times

2017-02-24 Thread Jan Kesten
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.

Re: Read after Write inconsistent at times

2017-02-23 Thread Ben Slater
Have you checked that NTP is correctly synched across all nodes in your cluster? On Fri, 24 Feb 2017 at 17:29 Charulata Sharma (charshar) wrote: > > Hi All, > > In my application sometimes I cannot read data that just got inserted. > This happens very intermittently. Both

Read after Write inconsistent at times

2017-02-23 Thread 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