Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BAADB174C5 for ; Tue, 31 Mar 2015 22:02:55 +0000 (UTC) Received: (qmail 14653 invoked by uid 500); 31 Mar 2015 22:02:53 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 14609 invoked by uid 500); 31 Mar 2015 22:02:53 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 14595 invoked by uid 99); 31 Mar 2015 22:02:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 22:02:53 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Saurabh_Sethi@symantec.com designates 166.98.1.210 as permitted sender) Received: from [166.98.1.210] (HELO ecl1mtaoutpex02.symantec.com) (166.98.1.210) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Mar 2015 22:02:48 +0000 X-AuditID: a66201d2-f79f16d000007125-da-551b18bc8976 Received: from tus1opsmtapin01.ges.symantec.com (tus1opsmtapin01.ges.symantec.com [192.168.214.43]) by ecl1mtaoutpex02.symantec.com (Symantec Brightmail Gateway out) with SMTP id 52.33.28965.CB81B155; Tue, 31 Mar 2015 21:59:24 +0000 (GMT) Received: from [155.64.220.137] (helo=TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM) by tus1opsmtapin01.ges.symantec.com with esmtp (Exim 4.76) (envelope-from ) id 1Yd4Bw-0007qC-1X for user@cassandra.apache.org; Tue, 31 Mar 2015 21:59:24 +0000 Received: from TUS1XCHEVSPIN32.SYMC.SYMANTEC.COM ([155.64.220.145]) by TUS1XCHHUBPIN01.SYMC.SYMANTEC.COM ([155.64.220.137]) with mapi; Tue, 31 Mar 2015 14:59:23 -0700 From: Saurabh Sethi To: "user@cassandra.apache.org" Date: Tue, 31 Mar 2015 14:59:21 -0700 Subject: Re: Column value not getting updated Thread-Topic: Column value not getting updated Thread-Index: AdBr/fIZKO7TPHz2Rg6CBSjTu6hKGA== Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.4.8.150116 acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_D1406695528Asaurabhsethisymanteccom_" MIME-Version: 1.0 X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFlrFIsWRmVeSWpSXmKPExsVyYMU1bd09EtKhBr9OyVqce/eP2YHR49u1 b+wBjFFcNimpOZllqUX6dglcGdvfv2YuOKVRsa/jGXMD4yblLkZODgkBE4mLP06wQthiEhfu rWfrYuTiEBL4wCjx6Nw6KKebSaKh+wI7hLOKUaLn2SawFjYBA4npvy8yg9giAtYSBxY+YAGx WQRUJe4vW8UIYgsL6EocmHqCHaJGT+Lv1YesMHb3q4lANRwcvAJmEs+vaIKEhQRqJdY07AYb wykQKHFxxgywMYxA130/tYYJxGYWEJe49WQ+E8TVAhJL9pxnhrBFJV4+/gc2XhRo/KFZH1kg ekUl7rSvZ4TojZb4P/0SmM0rIChxcuYTlgmMYrOQjJ2FpGwWkjKIuIHE+3PzmSFsbYllC19D 2foSG7+cZUQWX8DIvopRJjU5xzC3JDG/tKQgtcLASK+4MjcRGH/Jesn5uZsYgTG4LInx0g7G +4d1DzEKcDAq8fAa8UiHCrEmlgFVHmKU4GBWEuHdfkQqVIg3JbGyKrUoP76oNCe1+BCjNAeL kjjvw07RUCGB9MSS1OzU1ILUIpgsEwenVAOjYMOGj4X/rP0ZzoRser6f6VdSeEm9N2vPm4il sbdT5kX2PDXyW5DBeKzygTqbxN5DRQy8zU8vzpdzNJGbz/VkfmRL7H3OcN0E9s4z1Sc++mW9 3HKkOfpS0MVNHw7+Z46xOzRfJWN/bMP5T5VdLGaV6buVTrL53O08cOqk4GnD/Wcnipd46qcr sRRnJBpqMRcVJwIATUbRgb0CAAA= X-Virus-Checked: Checked by ClamAV on apache.org --_000_D1406695528Asaurabhsethisymanteccom_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable That=92s what I found out that the clocks were not in sync. But I have setup NTP on all 3 nodes and would expect the clocks to be in sy= nc. From: Nate McCall > Reply-To: "user@cassandra.apache.org" > Date: Tuesday, March 31, 2015 at 2:50 PM To: Cassandra Users > Subject: Re: Column value not getting updated You would see that if the servers' clocks were out of sync. Make sure the time on the servers is in sync or set the client timestamps e= xplicitly. On Tue, Mar 31, 2015 at 3:23 PM, Saurabh Sethi > wrote: I have written a unit test that creates a column family, inserts a row in t= hat column family and then updates the value of one of the columns. After updating, unit test immediately tries to read the updated value for t= hat column, but Cassandra returns the old value. * I am using QueryBuilder API and not CQL directly. * I am using the consistency level of QUORUM for everything =96 insert, = update and read. * Cassandra is running as a 3 node cluster with replication factor of 3. Anyone has any idea what is going on here? Thanks, Saurabh -- ----------------- Nate McCall Austin, TX @zznate Co-Founder & Sr. Technical Consultant Apache Cassandra Consulting http://www.thelastpickle.com --_000_D1406695528Asaurabhsethisymanteccom_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
That=92s what I found out that t= he clocks were not in sync.

But I have setup NTP o= n all 3 nodes and would expect the clocks to be in sync.

From: Nate McCall <nate@thelastpickle.com>
Reply-To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Tuesday, March 31, 2015 at 2:50 P= M
To: Cassandra Users <user@cassandra.apache.org>Subject: Re: Column value not ge= tting updated

You would see t= hat if the servers' clocks were out of sync. 

Make= sure the time on the servers is in sync or set the client timestamps expli= citly. 

On Tue, Mar 31, 2015 at 3:23 PM, Saurabh Sethi <Saurabh_Sethi@sy= mantec.com> wrote:
I have written a unit test that creates a column famil= y, inserts a row in that column family and then updates the value of one of= the columns.

After updating, unit test immediatel= y tries to read the updated value for that column, but Cassandra returns th= e old value.
  • I am using QueryBuilder API and not CQL directly.=
  • I am using the consistency level of QUORUM for everything =96 inse= rt, update and read.
  • Cassandra is running as a 3 node cluster with = replication factor of 3.

Anyone has any idea w= hat is going on here?

Thanks,
Saurabh



--
-----------------
Nate McCa= ll
Austin, TX
@zznate

Co-Founder & Sr. Technical Consultan= t
Apache Cassandra Consulting
http://www.thelastpickle.com
--_000_D1406695528Asaurabhsethisymanteccom_--