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 E9307C2F8 for ; Mon, 11 Jun 2012 09:34:10 +0000 (UTC) Received: (qmail 76235 invoked by uid 500); 11 Jun 2012 09:34:08 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 76092 invoked by uid 500); 11 Jun 2012 09:34:08 -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 76078 invoked by uid 99); 11 Jun 2012 09:34:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2012 09:34:08 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a43.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2012 09:34:01 +0000 Received: from homiemail-a43.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTP id DAFE08C058 for ; Mon, 11 Jun 2012 02:33:39 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; q=dns; s=thelastpickle.com; b=2FGR5fMPsP EMKWAqKSuiu1BM/DbAFEKrleRJwOWjh2zAfiy/S76pXP3qNO8B4eEOoxij1vJmGt sSW2LaSlf7g7ITzjhVO6zpbIJXQ4zItXOeFgbRUxdRneekgcTUG+H2lv6eGPchnS YFjtxHmtnj978THvZZkq2E6YohBqMqnXs= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; s=thelastpickle.com; bh=qwm/LGBH+OBulUFu UTi8nPueFaA=; b=wf9sf6ll8h9MqJmaLOD8ik+4ouEzNdVNznkd42cdWJdUdlcO 31XxfzUzEUlSHUxCsODvn0NhbU6Vjh+cOVgKixUwnYlpLURgEqgdkbguGQXBSVxU BhPV8Vu6W9s3wj40CLdYMauTMhA5/qYIQG6lum0fbUswU0o640RoySTP+M8= Received: from [172.16.1.4] (unknown [203.86.207.101]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTPSA id 225308C057 for ; Mon, 11 Jun 2012 02:33:38 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1278) Content-Type: multipart/alternative; boundary="Apple-Mail=_BF76E026-AFB5-4EE2-9E0F-3AB430CFB6A9" Subject: Re: Effective ownership on both nodes 0 % Date: Mon, 11 Jun 2012 21:33:36 +1200 In-Reply-To: <7073291669E5764EB68B5914AC4204744E0514272C@AUSP01VMBX11.collaborationhost.net> To: user@cassandra.apache.org References: <7073291669E5764EB68B5914AC4204744E0514272C@AUSP01VMBX11.collaborationhost.net> Message-Id: <8CBDAB4B-89DC-479A-82F9-E99711C920A3@thelastpickle.com> X-Mailer: Apple Mail (2.1278) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_BF76E026-AFB5-4EE2-9E0F-3AB430CFB6A9 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 > Also when I run the command > ./nodetool =96h ip_address ring > I found that both nodes ownership is 0 %. Please tell me how should I = fix that. It would be a lot easier to answer you question if you showed the output = from nodetool ring.=20 > UPDATE KEYSPACE demo WITH strategy_options =3D {DC1:2,DC2:2}; on both = the nodes This would only make sense if you had 2 data centres, with at least 2 = nodes in each.=20 You probably just want {DC1:2} > I get the following error: Unavailable Exception This means there are not enough available nodes to perform the request = at the Consistency Level you code has requests. Probably due to the = strategy_options set above. =20 Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/06/2012, at 6:20 PM, Prakrati Agrawal wrote: > Dear all > =20 > I have a Cassandra cluster with 2 nodes. > I was trying to increase the replication factor of keyspace in = Cassandra to 2. I did the following steps: > UPDATE KEYSPACE demo WITH strategy_options =3D {DC1:2,DC2:2}; on both = the nodes > Then I ran the nodetool repair on both the nodes > Then I ran my Hector code to count the number of rows and columns in = the database. > I get the following error: Unavailable Exception > Also when I run the command > ./nodetool =96h ip_address ring > I found that both nodes ownership is 0 %. Please tell me how should I = fix that. > =20 > Thanks and Regards > Prakrati > =20 > =20 > =20 >=20 > This email message may contain proprietary, private and confidential = information. The information transmitted is intended only for the = person(s) or entities to which it is addressed. Any review, = retransmission, dissemination or other use of, or taking of any action = in reliance upon, this information by persons or entities other than the = intended recipient is prohibited and may be illegal. If you received = this in error, please contact the sender and delete the message from = your system. >=20 > Mu Sigma takes all reasonable steps to ensure that its electronic = communications are free from viruses. However, given Internet = accessibility, the Company cannot accept liability for any virus = introduced by this e-mail or any attachment and you are advised to use = up-to-date virus checking software. --Apple-Mail=_BF76E026-AFB5-4EE2-9E0F-3AB430CFB6A9 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252
Also when I run = the command
./nodetool = =96h ip_address ring
I found that both nodes ownership is 0 = %. Please tell me how should I fix = that.
It would be a lot = easier to answer you question if you showed the output from nodetool = ring. 

UPDATE KEYSPACE = demo WITH strategy_options =3D {DC1:2,DC2:2}; on both the = nodes
This would only = make sense if you had 2 data centres, with at least 2 nodes in = each. 
You probably just = want = {DC1:2}

I get the = following error: Unavailable = Exception
This means there = are not enough available nodes to perform the request at the Consistency = Level you code has requests. Probably due to the strategy_options set = above.  

Cheers

http://www.thelastpickle.com

On 11/06/2012, at 6:20 PM, Prakrati Agrawal = wrote:

Dear all
 
I have a Cassandra cluster = with 2 nodes.
I was trying to increase the = replication factor of keyspace in Cassandra to 2. I did the following = steps:
UPDATE KEYSPACE demo WITH = strategy_options =3D {DC1:2,DC2:2}; on both the = nodes
Then I ran = the nodetool repair on both the nodes
Then I ran my Hector code to count the = number of rows and columns in the database.
I get the following error: Unavailable = Exception
Also when I = run the command
./nodetool = =96h ip_address ring
<= div style=3D"margin-top: 0in; margin-right: 0in; margin-left: 0in; = margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, = sans-serif; ">I found that both nodes ownership is 0 = %. Please tell me how should I fix that.
 
Thanks and = Regards
Prakrati
 
 
 


This email message may contain proprietary, = private and confidential information. The information transmitted is = intended only for the person(s) or entities to which it is addressed. = Any review, retransmission, dissemination or other use of, or taking of = any action in reliance upon, this information by persons or entities = other than the intended recipient is prohibited and may be illegal. If = you received this in error, please contact the sender and delete the = message from your system.

Mu Sigma takes all reasonable steps to = ensure that its electronic communications are free from viruses. = However, given Internet accessibility, the Company cannot accept = liability for any virus introduced by this e-mail or any attachment and = you are advised to use up-to-date virus checking = software.

= --Apple-Mail=_BF76E026-AFB5-4EE2-9E0F-3AB430CFB6A9--