[ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marco Matarazzo updated CASSANDRA-4461: --------------------------------------- Attachment: system.log > 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