Known issue deleting and recreating a CF with the same name, fixed in 2.1 
(manifests in lots of ways)

https://issues.apache.org/jira/browse/CASSANDRA-5202

On Jul 16, 2014, at 8:53 PM, Kevin Burton <bur...@spinn3r.com> wrote:

> looks like a restart of cassandra and a "nodetool compact" fixed this… 
> 
> 
> On Wed, Jul 16, 2014 at 6:45 PM, Kevin Burton <bur...@spinn3r.com> wrote:
> this is really troubling…
> 
> I have a "ghost" table.  I dropped it.. but it's not going away.  
> 
> (Cassandra 2.0.8 btw)
> 
> I ran a 'drop table' on it.. then a 'describe tables' shows that it's not 
> there.  
> 
> However, when I recreated it, with a new schema, all operations on it failed.
> 
> Looking at why… it seems that cassandra had some old SSTables that I imagine 
> are no longer being used but are now in an inconsistent state?
> 
> This is popping up in the system.log:
> 
> Caused by: java.lang.RuntimeException: java.io.FileNotFoundException: 
> /d0/cassandra/data/blogindex/content_idx_source_hashcode/blogindex-content_idx_source_hashcode-jb-1447-Data.db
>  (No such file or directory)
> 
> so I think what happened… is that the original drop table, failed, and then 
> left things in an inconsistent state.
> 
> I tried a nodetool repair and a nodetool compact… those fail on the same 
> java.io.FileNotFoundException … I moved the directories out of the way, same 
> failure issue.
> 
> … any advice on resolving this?
> 
> -- 
> 
> Founder/CEO Spinn3r.com
> Location: San Francisco, CA
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> 
> 
> 
> 
> 
> -- 
> 
> Founder/CEO Spinn3r.com
> Location: San Francisco, CA
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> 
> 

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to