Hinted handoff - which is what provides eventual consistency - can time out and be discarded/lost if the cluster is under heavy load or encounters poor network connectivity or nodes are down for too long, which is what requires running repair. That's why quorum is the recommended cl for both write and read for true consistency.
-- Jack Krupansky On Thu, Jun 25, 2015 at 7:51 AM, Alain RODRIGUEZ <arodr...@gmail.com> wrote: > Excepted if the node failed to take the write and you have no Hinted > Handoff (or for some reason they also failed). > > Have you tried at QUORUM or even ALL, this would force a synchronous read > repair. You can also try to repair directly. > > Hope this will help, > > C*heers, > > Alain > > 2015-06-25 13:34 GMT+02:00 Aditya Shetty <aditya.she...@snapdeal.com>: > >> I am using consistency one for both. However, the writes had happened a >> few days before, so it does not look like an issue of eventual consistency. >> >> On Thu, Jun 25, 2015 at 3:59 PM, Perica Milošević < >> perica.milose...@gmail.com> wrote: >> >>> Which ConsistencyLevel do you use for writing and reading of the data? >>> >>> Cheers, >>> Perica >>> >>> >>> On Thu, Jun 25, 2015 at 12:12 PM, Aditya Shetty < >>> aditya.she...@snapdeal.com> wrote: >>> >>>> Hi >>>> >>>> I have a 3 node cassandra cluster with a replication factor of 2. I >>>> have a basic column family which I am reading by primary key. Here is the >>>> CF structure: >>>> >>>> CREATE TABLE reviews_platform.object_stats ( >>>> >>>> object_owner_id int, >>>> >>>> object_type int, >>>> >>>> object_id text, >>>> num_of_reviews int, PRIMARY KEY ((object_owner_id, object_type), >>>> object_id) >>>> >>>> ); >>>> However, when I query this column family by primary key, I sometimes >>>> get no records, even though the record exists. The same query after some >>>> time gives a proper response. >>>> >>>> >>>> >>>> >>>> >>>> >>>> *Query: select * from reviews_platform.object_stats whereobject_id = >>>> '674813358269'and object_type = 0and object_owner_id = 0;* >>>> Note that I am querying using the java driver. >>>> >>>> -- >>>> >>>> Aditya Shetty >>>> *Lead Engineer* >>>> >>>> *M*: +91 7022423545, *T*: 080 46603000 *EXT*: 4417 >>>> 2nd FLOOR, WEST WING, >>>> >>>> SALARPURIA SUPREME, MARATHAHALLI, BENGALURU >>>> >>>> Download Our App [image: A] >>>> <https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android> >>>> [image: A] >>>> <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios> >>>> [image: W] >>>> <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> >>>> >>> >>> >> >> >> -- >> >> Aditya Shetty >> *Lead Engineer* >> >> *M*: +91 7022423545, *T*: 080 46603000 *EXT*: 4417 >> 2nd FLOOR, WEST WING, >> >> SALARPURIA SUPREME, MARATHAHALLI, BENGALURU >> >> Download Our App [image: A] >> <https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android> >> [image: A] >> <https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios> >> [image: W] >> <http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f> >> > >
