cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arend-Jan Wijtzes <ajwyt...@wise-guys.nl>
Subject Re: lost keyspace
Date Wed, 08 Aug 2012 15:42:40 GMT
On Wed, Aug 08, 2012 at 05:08:56PM +0200, Mateusz Korniak wrote:
> On Wednesday 08 of August 2012, Arend-Jan Wijtzes wrote:
> > Forgot to mention that the keyspace 'twitter' was created, then droppend
> > and re-created a couple of days ago.
> > 
> > How about if I create a new keyspace with the same definition and then
> > copy the existing tables into the proper place and call nodetool
> > refresh on each node. Would that work or are there references in the
> > tables to the keyspace name?
> 
> Worth to try, should work.  Perhaps use  _copy_ of SStables.
> I did that during schema version desync solving few times on 1.0.x.
> Make sure you have same schema version on all nodes first.

OK that worked. One extra step was required and that was to rename the 
keyspace part in the filenames of the sstables.

Still would like to know why the original keyspace got lost and if there
is a 'proper' way to restore it.

-- 
Arend-Jan Wijtzes -- Wiseguys -- www.wise-guys.nl

Mime
View raw message