I went with deleting the extra rows created in schema_columns and I’ve now successfully bootstrapped three nodes back on 1.2.10.
No sour side effects to report yet.
Thanks for your help
From: Robert Coli [mailto:email@example.com]
Sent: 02 October 2013 01:00
Subject: Re: Rollback question regarding system metadata change
On Tue, Oct 1, 2013 at 3:45 PM, Chris Wirt <firstname.lastname@example.org> wrote:
Yep they still work. They dont acutally have any of the new system CF
created for 2.0, paxos, etc.. but they do have new rows in the
schema_columns table preventing startup and bootstrapping of new
It *may* be least risky to manually remove these rows and then restart DC3. But unfortunately without really diving into the code, I can't make any statement about what effects it might have.
But anyway, actions to do this would be:
- drop schema (wont actually delete data?)
What actually happens is that you automatically create a snapshot in the snapshots dir when you drop, so you would have to move (or (better) hard link) those files back into place.
- create schema (will create all the metadata and leave my data
- on each node run nodetool refresh (will load my existing data?)
Right. Refresh will rename all SSTables while opening them.
As an alternative to refresh, you can restart the node; Cassandra loads whatever files it finds in the data dir at startup.