You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jeff Williams (JIRA)" <ji...@apache.org> on 2012/05/04 09:30:50 UTC
[jira] [Created] (CASSANDRA-4219) Problem with creating keyspace
after drop
Jeff Williams created CASSANDRA-4219:
----------------------------------------
Summary: 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
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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273114#comment-13273114 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
Hi Pavel,
Have you been able to reproduce this? I am wanting to use these servers for production traffic and am wondering if this issue is a general bug, or due to a corruption in my cluster.
Regards,
Jeff
> 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, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13270509#comment-13270509 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
Ok, I can now reproduce this on my cluster.
If I start with all three servers running. And on one of the servers I create a keyspace, create a column family and test, it all works fine. If I then drop the keyspace and re-create it, everything continues to work. However, as soon as one of the nodes is restarted, the keyspace disappears on that node. If I restart every node in the cluster, then the keyspace cannot be seen anyhwere, however, I can still no longer create a keyspace with that name.
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273163#comment-13273163 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
Hi Jeff, unfortunately I wasn't able to reproduce the situation you are seeing using the following steps:
1. run ccm cluster with 3 nodes
2. create keyspace/cf and added some data
3. stopped node 2
4. dropped keyspace (using CLI from node 1)
5. re-created keyspace and column family (using CLI from node 3 and on the other try from node 1)
6. added some data to the keyspace
7. started node 2
I have seen some of ('Couldn't find cfId=X) but this is unavoidable since we use sequential numbering of CFs and you have re-created one with the same name, we have an issue to switch to UUID ids too (CASSANDRA-3794).
Can you try to run 'resetlocalschema' nodetool command on the failing node? It would truncate all of the schema system tables and try to request it again and re-apply, this was designed specially to resolve such weird situations.
> 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, 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Williams updated CASSANDRA-4219:
-------------------------------------
Attachment: system-startup-debug.log.gz
Debug log for node startup
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273697#comment-13273697 ]
Jonathan Ellis commented on CASSANDRA-4219:
-------------------------------------------
+1
> 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Williams updated CASSANDRA-4219:
-------------------------------------
Attachment: system-91.223.192.26.log.gz
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Douglas Muth (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273686#comment-13273686 ]
Jonathan Ellis commented on CASSANDRA-4219:
-------------------------------------------
bq. Don't think that we should worry about removeDeleted because isMarkedForDelete + isEmpty gives us sufficient information
To clarify: what I'm concerned about is, if there is a row-level tombstone against a previously existing CF definition, then row.isEmpty will be false. so (markedForDelete && isEmpty) will also be false...
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13268231#comment-13268231 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
I have attached the entire system.log from yesterday for the server I was running cqlsh on (10.20.20.25). The cluster is:
oot@meta01:~# nodetool -h meta01 ring PlayLog3
Address DC Rack Status State Load Effective-Owership Token
113427455640312821154458202477256070485
10.20.20.25 CPH R1 Up Normal 27.88 MB 66.67% 0
10.20.20.26 CPH R1 Up Normal 17.5 MB 66.67% 56713727820156410577229101238628035242
10.20.20.24 CPH R1 Up Normal 72.44 MB 66.67% 113427455640312821154458202477256070485
However, I have switched from SimpleSnitch to PropertyFileSnitch this morning.
I'm not sure about the times I run the commands and where that corresponds to in the log, but I'm guessing you may know.
I was testing fail-over and was shutting down the server 10.20.20.26 during writes as a testing. However, it looks like I took it down at 2012-05-03 16:07:13 and that it was down when I did the drop and create, which could be the cause. I see the first error soon after it came back up. Also, I remember that these 'Couldn't find cfId=1013' errors occurred in the system.log on the other servers at the same time (I can send these if you want).
I'm currently running from the Debian packages. I'll try to apply the patch there and reinstall the packages.
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273542#comment-13273542 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
Just did a quick test and it is looking good. The keyspace doesn't disappear! I'll do some more checks to mak sure that all of the data works before and after.
> 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Yaskevich updated CASSANDRA-4219:
---------------------------------------
Attachment: CASSANDRA-4219.patch
The problem was that when KS/CF is deleted row in the system table is marked for delete and all of it's columns are moved, so when it's re-created columns are added but row stays marked for delete, we need to check if given KS/CF doesn't have attributes in it's system table and if it's marked for delete all together, when we do schema version re-generate or load.
> 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
[jira] [Assigned] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis reassigned CASSANDRA-4219:
-----------------------------------------
Assignee: Pavel Yaskevich
> 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, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273683#comment-13273683 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
No, we only check for row.cf.isEmpty when row was marked for delete which could be that KS/CF was actually deleted (empty but row is still there) or re-created. Don't think that we should worry about removeDeleted because isMarkedForDelete + isEmpty gives us sufficient information.
> 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
[jira] [Issue Comment Edited] (CASSANDRA-4219) Problem with
creating keyspace after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273542#comment-13273542 ]
Jeff Williams edited comment on CASSANDRA-4219 at 5/11/12 7:38 PM:
-------------------------------------------------------------------
Just did a quick test and it is looking good. The keyspace doesn't disappear! I'll do some more checks to make sure that all of the data inserts works before and after.
was (Author: jeffwilliams):
Just did a quick test and it is looking good. The keyspace doesn't disappear! I'll do some more checks to mak sure that all of the data works before and after.
> 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne updated CASSANDRA-4219:
----------------------------------------
Attachment: 0001-Add-debug-logs.txt
Would that be possible for you to try applying the attached patch (0001-Add-debug-logs.txt) on one of the machine, switch the log to DEBUG, try recreating said keyspace and send us the resulting log. This should give us more info on what's going on.
Also, do you still have the log of when you first got the 'TSocket read 0 bytes' during a select? Is there any corresponding errors?
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt
>
>
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273165#comment-13273165 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
Pavel,
I am able to recreate this with a freshly installed cluster using the debian 1.1 packages. The steps are:
1. Setup the cluster (I only had 2 nodes in my test)
2. create keyspace on node1 (confirm created on node2)
3. drop keyspace on node1 (confirm dropped on node2)
4. re-created keyspace on node1 (confirm re-created on node2)
5. restart node2
6. keyspace no longer exists on node2
Regards,
Jeff
> 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, 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne updated CASSANDRA-4219:
----------------------------------------
Fix Version/s: 1.1.1
> 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
> Fix For: 1.1.1
>
>
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13268316#comment-13268316 ]
Sylvain Lebresne commented on CASSANDRA-4219:
---------------------------------------------
The weird part here is that this DEBUG log seems to say that the keyspace should exist before you even do the create keyspace (but if it was correctly loaded, you should get a different error, so something is wrong). Could you try restarting the node with DEBUG log and attach that (just wait for the node to be up and running). I want to try to see what's going on with the loading of that keyspace.
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, system-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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Williams updated CASSANDRA-4219:
-------------------------------------
Attachment: system-debug.log.gz
Log for adding Keyspace with debug patch applied and log mode DEBUG.
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, system-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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jonathan Ellis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273674#comment-13273674 ]
Jonathan Ellis commented on CASSANDRA-4219:
-------------------------------------------
do we need to test for row.cf.isEmpty when there was no deletion involved?
do we need a removeDeleted call in there so the row tombstone can supress obsolete columns pre-compaction?
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273493#comment-13273493 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
Jeff, I have done both scenarios you mentioned to check if everything now working as expected, can you please also confirm (just to double-check) if it works on your side too?...
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273170#comment-13273170 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
Yeah, I can reproduce this one - that happens because when you re-create keyspace it wouldn't change the UUID version from the original so when migration is send to the node2 originally it wouldn't correctly merge it into the system table. I will try to fix this one asap.
> 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, 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
[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Williams updated CASSANDRA-4219:
-------------------------------------
Attachment: system.log.gz
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Jeff Williams (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13270458#comment-13270458 ]
Jeff Williams commented on CASSANDRA-4219:
------------------------------------------
Anything useful in that log?
I seems to have replicated the issue somehow. Firstly, I moved the servers onto public IP's, though the last octet is the same:
nodetool -h meta01 ring
Address DC Rack Status State Load Owns Token
113427455640312821154458202477256070485
91.223.192.25 CPH R1 Up Normal 11.2 MB 33.33% 0
91.223.192.26 CPH R1 Up Normal 15.16 MB 33.33% 56713727820156410577229101238628035242
91.223.192.24 CPH R1 Up Normal 20.11 MB 33.33% 113427455640312821154458202477256070485
I created a new keyspace PlayLog2 (PlayLog still does not work), and a column family playlog.
This was available on all nodes. I then ran a few test inserts which worked fine. Then, to test fail-over, I shutdown the node 91.223.192.26 during inserts. The inserts completed fine and a while later I restarted the node 91.223.192.26. Then, when I went to re-run my tests, I see (Hector client):
5710 [Thread-1] DEBUG me.prettyprint.cassandra.connection.client.HThriftClient - Creating a new thrift connection to meta02.cph.aspiro.com(91.223.192.26):9160
5711 [Thread-0] DEBUG me.prettyprint.cassandra.connection.client.HThriftClient - keyspace reseting from null to PlayLog2
Exception in thread "Thread-1" me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:Keyspace PlayLog2 does not exist)
Sure enough, from command line client on 91.223.192.26, I see no PlayLog2 keyspace, yet it exists on 91.223.192.24 and 91.223.192.25. I have attached the system.log from 91.223.192.26 in the hope that it is useful.
> 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
> Fix For: 1.1.1
>
> Attachments: 0001-Add-debug-logs.txt, 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13281154#comment-13281154 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
Hi Doug, I think that the best option would be to simply apply patch from this issue and re-compile Cassandra.
> 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
[jira] [Commented] (CASSANDRA-4219) Problem with creating keyspace
after drop
Posted by "Pavel Yaskevich (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13273695#comment-13273695 ]
Pavel Yaskevich commented on CASSANDRA-4219:
--------------------------------------------
Ok, I understand your worries, we use CFS.getRangeSlice to fetch data which calls removeDeleted in the process of request processing.
> 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