Hi Carlos Rolo Using LOCAL_QUORUM for both writes & reads. I see there is a time difference of 2 mins among nodes, I think that could be the reason. Anyways thanks for replying Carlos Rolo... Have a nice day... :)
On Wed, Jul 12, 2017 at 12:45 AM, Carlos Rolo <r...@pythian.com> wrote: > What consistency are you using on those queries? > > On 11 Jul 2017 19:09, "techpyaasa ." <techpya...@gmail.com> wrote: > >> Hi, >> >> We have a table with following schema: >> >> CREATE TABLE ks1.cf1 ( pid bigint, cid bigint, resp_json text, status >> int, PRIMARY KEY (pid, cid) ) WITH CLUSTERING ORDER BY (cid ASC) with LCS >> compaction strategy. >> >> We make very frequent updates to this table with query like >> >> UPDATE ks1.cf1 SET status = 0 where pid=1 and cid=1; >> UPDATE ks1.cf1 SET resp_json='' where uid=1 and mid=1; >> >> >> Now we seeing a strange issue like sometimes status column or resp_json >> column value not getting updated when we query using SELECT query. >> >> We are not seeing any exceptions though during UPDATE query executions. >> And also is there any way to make sure that last UPDATE was success?? >> >> We are using c* - 2.1.17 , datastax java driver 2.1.18. >> >> Can someone point out what the issue is or anybody faced such strange >> issue? >> >> Any help is appreciated. >> >> Thanks in advance >> TechPyaasa >> > > -- > > > >