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