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
