From user-return-9750-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Fri Oct 08 00:13:10 2010 Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 29213 invoked from network); 8 Oct 2010 00:13:10 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 8 Oct 2010 00:13:10 -0000 Received: (qmail 42719 invoked by uid 500); 8 Oct 2010 00:13:08 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 42651 invoked by uid 500); 8 Oct 2010 00:13: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 42643 invoked by uid 99); 8 Oct 2010 00:13:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Oct 2010 00:13:08 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a53.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 08 Oct 2010 00:13:00 +0000 Received: from homiemail-a53.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTP id 7333313807A for ; Thu, 7 Oct 2010 17:12:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=to:from :subject:date:message-id:content-type:mime-version:in-reply-to; q=dns; s=thelastpickle.com; b=kS8viR9kcc3t2z1QNDVlI38RClThv72B/ rnTb2SXcVVRDfykGLADkLAuPLuIvyYitcwAu9+HZVyAIsIXnIf/HiYbN6tNBVGI7 BMFKsjOH3c5HPHV1TeyHarYnq04hSeh5/39/yMmOswqJiTbgBxx1NpqB22ie/qAk VARRwmbqkE= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=to :from:subject:date:message-id:content-type:mime-version: in-reply-to; s=thelastpickle.com; bh=MafWS9IcIsV3KkLS20lzpaBmFKU =; b=yrC8XJDzG5fKqziF3njhyZ0iA+oG7PlZ5K/JQLs2atfSc7tB59j4KoXqmWD Gybt/ABzBr03CziKArMrcqMbSxAQJ03sDAUpxm0hoGVR2ZdlS+StLboqbAe7xIUw CpD7b5W0EohxCBbjwl1WcpK7rGU9ZoSd+fZhbzjKJjpJwsRc= Received: from localhost (webms.mac.com [17.148.16.116]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTPSA id 5B06D138075 for ; Thu, 7 Oct 2010 17:12:37 -0700 (PDT) To: user@cassandra.apache.org From: Aaron Morton Subject: Re: Retrieving dead node's token from system keyspace Date: Fri, 08 Oct 2010 00:12:36 GMT X-Mailer: MobileMe Mail (1C3203) Message-id: <5425ff30-ac5f-68d5-e8c7-9749cba5976f@me.com> Content-Type: multipart/alternative; boundary=Apple-Webmail-42--0fa9fded-e494-658c-c464-bbb0a45666b8 MIME-Version: 1.0 In-Reply-To: <5087D823-CBDD-4126-9D36-CA0486E57D52@gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Webmail-42--0fa9fded-e494-658c-c464-bbb0a45666b8 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=ISO-8859-1; format=flowed Allan,=A0=0AI'm a bit=A0confused=A0about what you are trying to do here. Y= ou have 2 nodes with RF =3D ? , you lost one node=A0completely=A0and now y= ou want to...=0A=0AJust get a cluster running again, don't worry about the= data.=0AOR=0ARestore the data from the dead node.=A0=0AOR=0ACreate a clus= ter with the data from the remaining node and a new node.=0A=0AAaron=0A=0A= =0AOn 08 Oct, 2010,at 11:15 AM, Allan Carroll wrote:=0A= =0AI was able to figure out to use the sstable2json tool to get the values= out of the system keyspace.=0A=0AUnfortunately, the node that went down t= ook all of it's data with it and I only have access to the system keyspace= of the remaining live node. There were only two nodes and the one left sh= ould have a whole DB copy.=0A=0ARunning removetoken on any of the values t= hat appeared to be tokens in the LocationInfo cf hasn't done any good. Per= haps I'm missing which value is the token of the dead node? Or, is there a= way to take down the last node and bring back up a new cluster using the = sstables that I have on the remaining node?=0A=0A-Allan=0A=0AOn Oct 7, 201= 0, at 3:22 PM, Allan Carroll wrote:=0A=0A> Hey all, =0A> =0A> I had a node= go down that I'm not able to get a token for from nodetool ring.=0A> =0A>= The wiki says:=0A> =0A> "You can obtain the dead node's token by running = nodetool ring on any live node, unless there was some kind of outage, and = the others came up but not the down one -- in that case, you can retrieve = the token from the live nodes' system tables."=0A> =0A> But, I can't for t= he life of me figure out how to get the system keyspace to give up the sec= ret. All attempts end up in:=0A> =0A> ERROR [pool-1-thread-2] 2010-10-07 2= 1:20:44,865 Cassandra.java (line 1280) Internal error processing get_slice= =0A> java.lang.RuntimeException: No replica strategy configured for system= =0A> =0A> =0A> Can someone point me at a good way to get the token?=0A> =0A= > Thanks=0A> -Allan=0A=0A --Apple-Webmail-42--0fa9fded-e494-658c-c464-bbb0a45666b8 Content-Type: multipart/related; type="text/html"; boundary=Apple-Webmail-86--0fa9fded-e494-658c-c464-bbb0a45666b8 --Apple-Webmail-86--0fa9fded-e494-658c-c464-bbb0a45666b8 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1;
Allan, 
I'm a bit confused about what you ar= e trying to do here. You have 2 nodes with RF =3D ? , you lost one node&nb= sp;completely and now you want to...

Just ge= t a cluster running again, don't worry about the data.
OR
<= div>Restore the data from the dead node. 
OR
Crea= te a cluster with the data from the remaining node and a new node.

Aaron


On 08 Oct,= 2010,at 11:15 AM, Allan Carroll <allanca@gmail.com> wrote:

<= /div>
I was abl= e to figure out to use the sstable2json tool to get the values out of the = system keyspace.
=0A
=0AUnfortunately, the node that went down took = all of it's data with it and I only have access to the system keyspace of = the remaining live node. There were only two nodes and the one left should= have a whole DB copy.
=0A
=0ARunning removetoken on any of the valu= es that appeared to be tokens in the LocationInfo cf hasn't done any good.= Perhaps I'm missing which value is the token of the dead node? Or, is the= re a way to take down the last node and bring back up a new cluster using = the sstables that I have on the remaining node?
=0A
=0A-Allan
=0A=
=0AOn Oct 7, 2010, at 3:22 PM, Allan Carroll wrote:
=0A
=0A> = Hey all,
=0A>
=0A> I had a node go down that I'm not able to= get a token for from nodetool ring.
=0A>
=0A> The wiki says:=
=0A>
=0A> "You can obtain the dead node's token by running n= odetool ring on any live node, unless there was some kind of outage, and t= he others came up but not the down one -- in that case, you can retrieve t= he token from the live nodes' system tables."
=0A>
=0A> But, = I can't for the life of me figure out how to get the system keyspace to gi= ve up the secret. All attempts end up in:
=0A>
=0A> ERROR [po= ol-1-thread-2] 2010-10-07 21:20:44,865 Cassandra.java (line 1280) Internal= error processing get_slice
=0A> java.lang.RuntimeException: No repl= ica strategy configured for system
=0A>
=0A>
=0A> Can = someone point me at a good way to get the token?
=0A>
=0A> Th= anks
=0A> -Allan
=0A
=0A
--Apple-Webmail-86--0fa9fded-e494-658c-c464-bbb0a45666b8-- --Apple-Webmail-42--0fa9fded-e494-658c-c464-bbb0a45666b8--