[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13281148#comment-13281148 ]
Douglas Muth commented on CASSANDRA-4219: ----------------------------------------- Good Afternoon, It turns out that I am having this exact issue, and I found this bug via Google. As previously stated, I dropped a keyspace during testing, but was unable to re-create it. Looking in system.schema_keyspaces still shows an entry for that keyspace, but I cannot drop that keyspcae either. First, is there anything I can do as a workaround, short of deleting all of my data and starting over? Second, this isn't in a cluster, it's a single machine, and a development machine at that. So there's no confidential data involved. If it would be of any help whatsoever, I'd be happy to send copies of the entire /var/lib/cassandra/ directory. Please let me know! Thanks for your time, -- Doug > Problem with creating keyspace after drop > ----------------------------------------- > > Key: CASSANDRA-4219 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4219 > Project: Cassandra > Issue Type: Bug > Affects Versions: 1.1.0 > Environment: Debian 6.0.4 x64 > Reporter: Jeff Williams > Assignee: Pavel Yaskevich > Fix For: 1.1.1 > > Attachments: 0001-Add-debug-logs.txt, CASSANDRA-4219.patch, > system-91.223.192.26.log.gz, system-debug.log.gz, > system-startup-debug.log.gz, system.log.gz > > > Hi, > I'm doing testing and wanted to drop a keyspace (with a column family) to > re-add it with a different strategy. So I ran in cqlsh: > DROP KEYSPACE PlayLog; > CREATE KEYSPACE PlayLog WITH strategy_class = 'SimpleStrategy' > AND strategy_options:replication_factor = 2; > And everything seemed to be fine. I ran some inserts, which also seemed to go > fine, but then selecting them gave me: > cqlsh:PlayLog> select count(*) from playlog; > TSocket read 0 bytes > I wasn't sure what was wrong, so I tried dropping and creating again, and now > when I try to create I get: > cqlsh> CREATE KEYSPACE PlayLog WITH strategy_class = 'SimpleStrategy' > ... AND strategy_options:replication_factor = 2; > TSocket read 0 bytes > And the keyspace doesn't get created. In the log it shows: > ERROR [Thrift:4] 2012-05-03 18:23:05,124 CustomTThreadPoolServer.java (line > 204) Error occurred during processing of message. > java.lang.RuntimeException: java.util.concurrent.ExecutionException: > java.lang.AssertionError > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:372) > at > org.apache.cassandra.service.MigrationManager.announce(MigrationManager.java:191) > at > org.apache.cassandra.service.MigrationManager.announceNewKeyspace(MigrationManager.java:129) > at > org.apache.cassandra.cql.QueryProcessor.processStatement(QueryProcessor.java:701) > at > org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:875) > at > org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1235) > at > org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3458) > at > org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.getResult(Cassandra.java:3446) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:32) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:34) > at > org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:186) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown > Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > Caused by: java.util.concurrent.ExecutionException: java.lang.AssertionError > at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) > at java.util.concurrent.FutureTask.get(Unknown Source) > at > org.apache.cassandra.utils.FBUtilities.waitOnFuture(FBUtilities.java:368) > ... 13 more > Caused by: java.lang.AssertionError > at org.apache.cassandra.db.DefsTable.updateKeyspace(DefsTable.java:441) > at org.apache.cassandra.db.DefsTable.mergeKeyspaces(DefsTable.java:339) > at org.apache.cassandra.db.DefsTable.mergeSchema(DefsTable.java:269) > at > org.apache.cassandra.service.MigrationManager$1.call(MigrationManager.java:214) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > ... 3 more > ERROR [MigrationStage:1] 2012-05-03 18:23:05,124 AbstractCassandraDaemon.java > (line 134) Exception in thread Thread[MigrationStage:1,5,main] > java.lang.AssertionError > at org.apache.cassandra.db.DefsTable.updateKeyspace(DefsTable.java:441) > at org.apache.cassandra.db.DefsTable.mergeKeyspaces(DefsTable.java:339) > at org.apache.cassandra.db.DefsTable.mergeSchema(DefsTable.java:269) > at > org.apache.cassandra.service.MigrationManager$1.call(MigrationManager.java:214) > at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) > at java.util.concurrent.FutureTask.run(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown > Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > at java.lang.Thread.run(Unknown Source) > Any ideas how I can recover from this? > I am running version 1.1.0 and have tried nodetool repair, cleanup, compact. > I can create other keyspaces, but still can't create a keyspace called > PlayLog even though it is not listed anywhere. > Jeff -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira