Re: c* updates not getting reflected.

[techpyaasa .]

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

> What consistency are you using on those queries?
>
> On 11 Jul 2017 19:09, "techpyaasa ."  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
>>
>
> --
>
>
>
>

Re: c* updates not getting reflected.

[Carlos Rolo]

What consistency are you using on those queries?

On 11 Jul 2017 19:09, "techpyaasa ."  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
>

-- 


--