[CASSANDRA-4461] Schema no longer modifiable

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Fix Version/s: 1.1.3

Environment

Ubuntu LTS 12.04, Java Sun Oracle 6 (jre1.6.0_33)

• Severity: Normal
• Assignee: Pavel Yaskevich
• Reporter: Marco Matarazzo

Authors

Pavel Yaskevich

• Created: 24/Jul/12 10:45
• Updated: 16/Apr/19 09:32
• Resolved: 24/Jul/12 15:18

Description

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>