cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Matarazzo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4461) Schema no longer modifiable
Date Tue, 24 Jul 2012 14:57:34 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13421462#comment-13421462
] 

Marco Matarazzo commented on CASSANDRA-4461:
--------------------------------------------

It seems that updating the schema from a second node (and maybe the millions of nodetool repair/cleanup/everything)
"unlocked" everything. 

As soon as the problem happens again (and I expect it soon), I will more than happily try
to apply the patch and see if it solves the problem.
                
> 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
>            Assignee: Pavel Yaskevich
>             Fix For: 1.1.3
>
>         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

        

Mime
View raw message