Re: Query Consistency Issues...

2015-12-15 Thread Steve Robenalt
I agree with Jon. It's almost a statistical certainty that such updates will be processed out of order some of the time because the clock sync between machines will never be perfect. Depending on how your actual code that shows this problem is structured, there are ways to reduce or eliminate such

Re: Query Consistency Issues...

2015-12-15 Thread Jonathan Haddad
High volume updates to a single key in a distributed system that relies on a timestamp for conflict resolution is not a particularly great idea. If you ever do this from multiple clients you'll find unexpected results at least some of the time. On Tue, Dec 15, 2015 at 12:41 PM Paulo Motta wrote:

Re: Query Consistency Issues...

2015-12-15 Thread Paulo Motta
> We are using 2.1.7.1 Then you should be able to use the java driver timestamp generators. > So, we need to look for clock sync issues between nodes in our ring? How close do they need to be? millisecond precision since that is the server precision for timestamps, so probably NTP should do the

Re: Query Consistency Issues...

2015-12-15 Thread James Carman
On Tue, Dec 15, 2015 at 2:57 PM Paulo Motta wrote: > What cassandra and driver versions are you running? > > We are using 2.1.7.1 > It may be that the second update is getting the same timestamp as the > first, or even a lower timestamp if it's being processed by another server > with unsynced

Re: Query Consistency Issues...

2015-12-15 Thread Paulo Motta
What cassandra and driver versions are you running? It may be that the second update is getting the same timestamp as the first, or even a lower timestamp if it's being processed by another server with unsynced clock, so that update may be getting lost. If you have high frequency updates in the s

Query Consistency Issues...

2015-12-15 Thread James Carman
We are encountering a situation in our environment (a 6-node Cassandra ring) where we are trying to insert a row and then immediately update it, using LOCAL_QUORUM consistency (replication factor = 3). I have replicated the issue using the following code: https://gist.github.com/jwcarman/72714e6d