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 976A911F87 for ; Thu, 3 Jul 2014 17:30:58 +0000 (UTC) Received: (qmail 49396 invoked by uid 500); 3 Jul 2014 17:30:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 49361 invoked by uid 500); 3 Jul 2014 17:30:56 -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 49351 invoked by uid 99); 3 Jul 2014 17:30:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jul 2014 17:30:56 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of savio.teles@cuia.com.br designates 209.85.220.169 as permitted sender) Received: from [209.85.220.169] (HELO mail-vc0-f169.google.com) (209.85.220.169) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jul 2014 17:30:51 +0000 Received: by mail-vc0-f169.google.com with SMTP id la4so559615vcb.0 for ; Thu, 03 Jul 2014 10:30:27 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=OuaoYvfsjI0n77qI9Zutd5A52Ym/yS2teJaRn3kdGwY=; b=GZXZ8e8QW8wS0fbTfh1Nzqp0t3dwyL4cmkn0HtA9F5R6JnaDyVNlGTgfHmqQBaAZB3 B46LLymeqsTUpwvTp5F26h3MRLERWx878hQPCk/LEi8gDykR0VLlOtvdLG7A1lsXGJM6 PnNfbWPV1bgtT58qc1YBYd2RMl6MAbDZb/qgCNZF0fTuapCkWXfPPcm5vRtIujlWkadn gY3IjmluHcS5nXSJb3+KJNFiYeBqRdtsTHJU5BK1yDCDGGWyjDr/orRKdYtEFQcDmk5Y V2EJp4P9TKwNIMDbF2UZi31iCbF5fbJumrvwQLomEb3l4PiZAMO5uLtPe2FvPpYJd7x1 ADOw== X-Gm-Message-State: ALoCoQld8lzh1bsIZO2JBPK2lNvtx/exbvuupwM1s7NO4NeweWcyt4DV2BmzTUYUcgf6nu/14M8y MIME-Version: 1.0 X-Received: by 10.221.9.72 with SMTP id ov8mr5086672vcb.27.1404408627054; Thu, 03 Jul 2014 10:30:27 -0700 (PDT) Received: by 10.221.11.14 with HTTP; Thu, 3 Jul 2014 10:30:26 -0700 (PDT) X-Originating-IP: [177.17.167.135] In-Reply-To: References: <92942188-C478-4336-AC8A-2919CAF65300@vast.com> Date: Thu, 3 Jul 2014 14:30:26 -0300 Message-ID: Subject: Re: Write Inconsistency to update a row From: =?UTF-8?Q?S=C3=A1vio_S=2E_Teles_de_Oliveira?= To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=089e0117772155deba04fd4d5dfa X-Virus-Checked: Checked by ClamAV on apache.org --089e0117772155deba04fd4d5dfa Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable > > Are you sure all the nodes are working at that time? Yes. They are working. I would suggest increasing the replication factor (for example 3) and use > CL=3DALL or QUORUM to find out what is going wrong. I did! I still have the same problem. 2014-07-03 13:40 GMT-03:00 Panagiotis Garefalakis : > This seems like a hinted handoff issue but since you use CL =3D ONE it > should happen. > Are you sure all the nodes are working at that time? You could use > nodetool status to check that. > I would suggest increasing the replication factor (for example 3) and use > CL=3DALL or QUORUM to find out what is going wrong. > > Regards, > Panagiotis > > > On Thu, Jul 3, 2014 at 5:11 PM, S=C3=A1vio S. Teles de Oliveira < > savio.teles@cuia.com.br> wrote: > >> replication_factor=3D1 >> CL=3DONE >> >> Does the data show up eventually? >> >> Yes. >> >> Can be the clocks? >> >> >> 2014-07-03 10:47 GMT-03:00 graham sanderson : >> >> What is your keyspace replication_factor? >>> >>> What consistency level are you reading/writing with? >>> >>> Does the data show up eventually? >>> >>> I=E2=80=99m assuming you don=E2=80=99t have any errors (timeouts etc) o= n the write site >>> >>> >>> On Jul 3, 2014, at 7:55 AM, S=C3=A1vio S. Teles de Oliveira < >>> savio.teles@cuia.com.br> wrote: >>> >>> I have two Cassandra 2.0.5 servers running with some datas inserted, >>> where each row have one empty column. When the client send a lot of upd= ate >>> commands to fill this column in each row, some lines update their conte= nt, >>> but some lines remain with the empty column. >>> >>> Using one server, this never happens! >>> >>> Any suggestions? >>> >>> Tks. >>> -- >>> Atenciosamente, >>> S=C3=A1vio S. Teles de Oliveira >>> voice: +55 62 9136 6996 >>> http://br.linkedin.com/in/savioteles >>> Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG >>> Arquiteto de Software >>> CUIA Internet Brasil >>> >>> >>> >> >> >> -- >> Atenciosamente, >> S=C3=A1vio S. Teles de Oliveira >> voice: +55 62 9136 6996 >> http://br.linkedin.com/in/savioteles >> Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG >> Arquiteto de Software >> CUIA Internet Brasil >> > > --=20 Atenciosamente, S=C3=A1vio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG Arquiteto de Software CUIA Internet Brasil --089e0117772155deba04fd4d5dfa Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Are you sure all the nodes are working a= t that time?=C2=A0

Yes. They are working.=C2=A0

I would suggest increasing the replication factor (for example 3) and use = CL=3DALL or QUORUM to find out what is going wrong.
I did! I still have the same problem.



2014-= 07-03 13:40 GMT-03:00 Panagiotis Garefalakis <pangaref@gmail.com>= :
This seems like a hinted ha= ndoff issue but since you use CL =3D ONE it should happen.
Are you sure= all the nodes are working at that time? You could use nodetool status to c= heck that.
I would suggest increasing the replication factor (for example 3) and = use CL=3DALL or QUORUM to find out what is going wrong.

Regards,
Panagiotis


On Thu, Jul 3, 2014 at 5:11 PM, S=C3=A1vio S. Teles de O= liveira <savio.teles@cuia.com.br> wrote:
replication_factor=3D1
= CL=3DONE

Does the data show up eventually?
Yes.
=

Can be the clocks? =C2=A0


2014-07-03 10:47 GMT-03:00 graham sander= son <graham@vast.com>:

What is your keyspace replication_facto= r?

What consistency level are you reading/writing with?<= div>
Does the data show up eventually?

I=E2=80=99m assuming you don=E2=80=99t have any errors (timeouts etc) = on the write site


On Jul 3, 2014, at 7:55 = AM, S=C3=A1vio S. Teles de Oliveira <savio.teles@cuia.com.br> wrote:

I have two Cassand= ra 2.0.5 servers running with some datas inserted, where each row have one = empty column. When the client send a lot of update commands to fill this co= lumn in each row, some lines update their content, but some lines remain wi= th the empty column.

Using one server, this never happens!

Any suggestions?

Tks.
--
Atenciosamente,
S=C3=A1vio S. Teles de Oliveira
voice: +55 62 9136 6996
http://b= r.linkedin.com/in/savioteles
Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG
Arquiteto de S= oftware
CUIA Internet Brasil




--
Atenciosamente,
S=C3=A1vio S. Teles de Oliveira
voice: +55 62 9136 6996
http://b= r.linkedin.com/in/savioteles
Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG
Arquiteto de S= oftware
CUIA Internet Brasil




--
= Atenciosamente,
S=C3=A1vio S. Teles de Oliveira<= br>
voice: +55 62 9136 6996
http://br.linkedin.com/in/savioteles
Mestrando em Ci=C3=AAncias da Computa=C3=A7=C3=A3o - UFG
Arquiteto de S= oftware
CUIA Internet Brasil
--089e0117772155deba04fd4d5dfa--