Yes …it is with LOCAL_SERIAL. Should I be using SERIAL ? Thanks, Charu
From: DuyHai Doan <doanduy...@gmail.com> Reply-To: "user@cassandra.apache.org" <user@cassandra.apache.org> Date: Friday, September 8, 2017 at 12:30 PM To: "user@cassandra.apache.org" <user@cassandra.apache.org> Subject: Re: Lightweight transaction in Multi DC Are you using CAS with SERIAL consistency level for your multi-DC setup ? On Fri, Sep 8, 2017 at 9:27 PM, Charulata Sharma (charshar) <chars...@cisco.com<mailto:chars...@cisco.com>> wrote: Hi, We are facing a serious issue with CAS in a multi DC setup and I wanted to get some input on it from the forum. We have a Column family which stores counts for the number of events our application receives. When the counts reach a certain threshold, there is another process which kicks in. The issue that is happening is, sometimes when concurrent events come in 2 Data Centers, both the events read the same count and increment it to the same value which causes the next process to not kick in. When concurrent events come in the same DC, this does not happen, because in this case, the CAS explicitly fails for one of them. However, in case of Multiple DCs this is not happening. Has anyone faced a similar issue and is there any resolution to this?? I was unable to find any open Jira on this. Thanks, Charu
