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
