[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 

[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(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at 

[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, 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-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 keyspaces, but still can't create a keyspace called 
 PlayLog even though it is not listed 

[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 think it was sent incorrectly, please contact your JIRA administrators: 

[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.runTask(Unknown 
 Source)
at 

[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

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, 

[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 other keyspaces, but still can't create a keyspace called 
 PlayLog even though it is not listed