[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2017-12-25 Thread Mhanna Abu Tareef (JIRA)

 [ 
https://issues.apache.org/jira/browse/CASSANDRA-4219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mhanna Abu Tareef updated CASSANDRA-4219:
-
Attachment: k2fabric.log.98
k2fabric.log.99
k2fabric.log.100
k2fabric.log.101
k2fabric.log.102
k2fabric.log.103
no_keyspace.png
no-keyspace-ondisk.png
schema_after_ks_creation.png
schema_before_ks_creation.png

I think i have the same issue in C* 3.11.1

i have a multi-dc cluster
6 nodes
2 DCs

DC1
98
99 - seed
100

DC2
101
102
103 - seed

via cqlsh from 102
1. using a fresh cluster
2. create keyspace k2view_functionslu
3. create table
Works!

from node 93
via cqlsh drop keyspace - succeded

now from node 102
via cqlsh from 102
1. using a fresh cluster
2. create keyspace k2view_functionslu
3. create table => Keyspace k2view_functionslu doesn't exist


- attacged logs from all nodes
- attached schema version from all nodes
- attached "desc keyspaces" 

> 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, 
> k2fabric.log.100, k2fabric.log.101, k2fabric.log.102, k2fabric.log.103, 
> k2fabric.log.98, k2fabric.log.99, no-keyspace-ondisk.png, no_keyspace.png, 
> schema_after_ks_creation.png, schema_before_ks_creation.png, 
> 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.co

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-11 Thread Pavel Yaskevich (JIRA)

 [ 
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(Unkno

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-08 Thread Jeff Williams (JIRA)

 [ 
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, bu

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-05 Thread Jeff Williams (JIRA)

 [ 
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 ke

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-04 Thread Jeff Williams (JIRA)

 [ 
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 oth

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-04 Thread Jeff Williams (JIRA)

 [ 
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

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-04 Thread Sylvain Lebresne (JIRA)

 [ 
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.runT

[jira] [Updated] (CASSANDRA-4219) Problem with creating keyspace after drop

2012-05-04 Thread Sylvain Lebresne (JIRA)

 [ 
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 thi