[
https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13421332#comment-13421332
]
Marco Matarazzo commented on CASSANDRA-4461:
--------------------------------------------
Update: on the 3-nodes cluster, executing the same DROP on a second node, does
the magic. It works with CREATE and ALTER too.
It can be useful to know that the keyspace has a replication factor of 3.
> Schema no longer modifiable
> ---------------------------
>
> Key: CASSANDRA-4461
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4461
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.2
> Environment: Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33)
> Reporter: Marco Matarazzo
> Attachments: system.log
>
>
> It seems that after a while, our keyspaces can't be modified. They accept
> data, read and write works, truncate works, just keyspace and every column
> family inside it can't be dropped, created or altered.
> This happens both on our 3 nodes test cluster and on our single-node dev
> cluster.
> With 1.1.1, a rolling restart of the cluster seemed to solve the issue. This
> no longer happens with 1.1.2 .
> user@server:~$ cqlsh -3 -k goh_master cassandra1
> Connected to GOH Cluster at cassandra1:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh:goh_master> drop columnfamily agents_blueprints;
> cqlsh:goh_master>
> user@server:~$ cqlsh -3 -k goh_master cassandra1
> Connected to GOH Cluster at cassandra1:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.2 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh:goh_master> DESCRIBE COLUMNFAMILY agents_blueprints
> CREATE TABLE agents_blueprints (
> agent_id ascii,
> archetype ascii,
> proto_id ascii,
> PRIMARY KEY (agent_id, archetype)
> ) WITH COMPACT STORAGE AND
> comment='' AND
> caching='KEYS_ONLY' AND
> read_repair_chance=0.100000 AND
> gc_grace_seconds=864000 AND
> min_compaction_threshold=4 AND
> max_compaction_threshold=32 AND
> replicate_on_write='true' AND
> compaction_strategy_class='SizeTieredCompactionStrategy' AND
> compression_parameters:sstable_compression='SnappyCompressor';
> cqlsh:goh_master>
--
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
