[jira] [Updated] (CASSANDRA-4461) Schema no longer modifiable

["Marco Matarazzo (JIRA)" <ji...@apache.org>]

     [ 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