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 > -- --