[ 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