Allan, I'm confused on why removetoken doesn't do anything and would be interested in finding out why, but to answer your question:
You can shutdown down your last node, nuke the system directory (make a backup just in case), restart the node, load the schema (export it first if need be) and be one your way. You should end up with a node that is the only one in the ring. Again, make a backup of the the system directory (actually, might as well just backup the entire data and commitlog directories) before you start nuking stuff. On Thu, Oct 7, 2010 at 7:12 PM, Aaron Morton <aa...@thelastpickle.com>wrote: > Allan, > I'm a bit confused about what you are trying to do here. You have 2 nodes > with RF = ? , you lost one node completely and now you want to... > > Just get a cluster running again, don't worry about the data. > OR > Restore the data from the dead node. > OR > Create a cluster with the data from the remaining node and a new node. > > Aaron > > > On 08 Oct, 2010,at 11:15 AM, Allan Carroll <alla...@gmail.com> wrote: > > I was able to figure out to use the sstable2json tool to get the values out > of the system keyspace. > > Unfortunately, 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. > > Running removetoken on any of the values 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 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? > > -Allan > > On Oct 7, 2010, at 3:22 PM, Allan Carroll wrote: > > > Hey all, > > > > I had a node go down that I'm not able to get a token for from nodetool > ring. > > > > The wiki says: > > > > "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." > > > > But, I can't for the life of me figure out how to get the system keyspace > to give up the secret. All attempts end up in: > > > > ERROR [pool-1-thread-2] 2010-10-07 21:20:44,865 Cassandra.java (line > 1280) Internal error processing get_slice > > java.lang.RuntimeException: No replica strategy configured for system > > > > > > Can someone point me at a good way to get the token? > > > > Thanks > > -Allan > > -- Riptano Software and Support for Apache Cassandra http://www.riptano.com/ mden...@riptano.com m: 512.587.0900 f: 866.583.2068