cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Häck (JIRA) <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4397) Schema changes not working
Date Wed, 04 Jul 2012 05:06:34 GMT

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

Stefan Häck commented on CASSANDRA-4397:
----------------------------------------

Update to 1.1.2 increased the problem. All indexes were gone. Rebuild didn't work. 
After a cluster wide reset (deleting data-/commit-/cache-folders), cassandra seems to work
again normally.
                
> Schema changes not working 
> ---------------------------
>
>                 Key: CASSANDRA-4397
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.1
>         Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol
19.32.0]
>            Reporter: Stefan Häck
>         Attachments: output.txt, system.txt
>
>
> No schema change is possible in several keyspaces. 
> No error message appears, everything seems to be o.k., but the schema change isn't adopted.

> I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_index.
> Both nodes are connected to a local ntp-server. 
> Here's the cqlsh output:
> {code:none}
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
>   KEY text PRIMARY KEY,
>   css text,
>   description text,
>   language text,
>   html text,
>   company_id varint,
>   title text
> ) WITH
>   comment='Different cover pages for each company.' AND
>   comparator=text AND
>   read_repair_chance=1.000000 AND
>   gc_grace_seconds=864000 AND
>   default_validation=text 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';
> CREATE INDEX rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
>   KEY text PRIMARY KEY,
>   css text,
>   description text,
>   language text,
>   html text,
>   company_id varint,
>   title text
> ) WITH
>   comment='Different cover pages for each company.' AND
>   comparator=text AND
>   read_repair_chance=1.000000 AND
>   gc_grace_seconds=864000 AND
>   default_validation=text 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';
> CREATE INDEX rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> 
> {code}
> In the attachments are the system.log and the output.log.
> The CassandraCli is also not working.

--
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