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 ashaw@wetafx.co.nz designates
 110.232.144.26 as permitted sender)
Message-ID: <4E3C839D.2090203@wetafx.co.nz>
Date: Sat, 06 Aug 2011 11:58:21 +1200
From: Aurynn Shaw <ashaw@wetafx.co.nz>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:5.0) Gecko/20110705 Thunderbird/5.0
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: Secondary indexes and drop column family
References: <4E3C7B31.7030302@wetafx.co.nz>
In-Reply-To: <4E3C7B31.7030302@wetafx.co.nz>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Answered my own question; a snapshot gets taken when you drop a CF, per:

http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-take-a-snapshot-after-a-column-family-update-td6222772.html

So, I can recover to a known-good working position, and delete my 
indices properly.

Thanks!
~A

On 06/08/11 11:22, Aurynn Shaw wrote:
> Hey all;
>
> So, I've managed to get myself into a position where I'm not sure how 
> to recover.
>
> I have a column family that I was a significant number of secondary 
> indexes on. Some buggy code created a bunch of useless indexes 
> accidentally, and I took what (at the time) seemed the most obvious path:
>
> Drop the column family, recreate it, and reconstruct the indexes from 
> existing data with a known-working script.
>
> However, now that I've done this, I'm getting:
> InvalidRequestException(why='Duplicate index names 
> <CFName>.6d62783a646f635f6964')
>
> when I run the script that generates the secondary indexes.
>
> Since the CF got dropped and recreated, I can't iterate it to delete 
> the indexes, since they're not there anymore.
>
> How do I go about recovering from this? I suspect that ithe name is 
> being held somewhere in the system keyspace, but I'm not sure where to 
> look.
>
> I'm using Cassandra 0.7.4, RF=1.
>
> Thanks,
> Aurynn
>
>