Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of ajwytzes@wise-guys.nl
 designates 194.109.125.200 as permitted sender)
Date: Wed, 8 Aug 2012 15:03:52 +0200
From: Arend-Jan Wijtzes <ajwytzes@wise-guys.nl>
To: user@cassandra.apache.org
Subject: lost keyspace
Message-ID: <20120808130352.GC25746@vito.wise-guys.nl>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.21 (2010-09-15)

Hi,

Today we rebooted a node in our cluster for maintenance and after that
one of the keyspaces went missing. This is what we did leading up to
this:

nodetool drain -h localhost
reboot

restart cassandra
There was an error during startup:
ERROR [MutationStage:109] 2012-08-08 14:05:56,443 RowMutationVerbHandler.java (line 61) Error in row mutation org.apache.cassandra.db.UnknownColumnFamilyException: Couldn't find cfId=1014

(then we found keyspace twitter is missing)

The sstables are still there so I tried to re-create the keyspace:
cassandra-cli -h localhost
[default@unknown] create keyspace twitter with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and strategy_options = {replication_factor:3} ; 
b890b65a-40a6-3fc5-838d-34d58368cb64
Waiting for schema agreement...
... schemas agree across the cluster
NotFoundException()

default@unknown] use twitter;
Keyspace 'twitter' not found.

So we can't create the keyspace. The cassandra version is 1.1.0.
What is the proper way to deal with this?

Thanks for your help.

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