[ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13431000#comment-13431000 ]
Marco Matarazzo commented on CASSANDRA-4472: -------------------------------------------- It's sure we was reading and writing from various CF, maybe even the same we was trying to modify. Surely no one else was modifying the schema. Alas, I don't know more than this. I tried creating the index both with and without specifying the index name, and either way it didn't work. What I did is trying to "snapshot" the problem: I made a .tgz of /var/lib/cassandra directory, and it seems that moving it on a clean cassandra 1.1.2 node does make the problem appear again. I could try to pass you this archive. I didn't have time to try with 1.1.3, tough. Maybe the first thing to do is to see if the problem solves upgrading to 1.1.3. > Can't add secondary index > ------------------------- > > Key: CASSANDRA-4472 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4472 > Project: Cassandra > Issue Type: Bug > Affects Versions: 1.1.2 > Environment: Ubuntu LTS 12.04 > Reporter: Marco Matarazzo > Assignee: Pavel Yaskevich > Fix For: 1.1.4 > > Attachments: system.log > > > It seems connected to CASSANDRA-4461 (and CASSANDRA-4471), but symptoms are > different so I open a separate bug. It may be the same problem, though. > Applying CASSANDRA-4432 seems not to solve the issue. > It seems I can't create secondary indexes on any CF. Reading and wrting data > works, creating and dropping tables works. Adding new indexes, no longer > works, and I get no errors and nothing in logs that (to me) seems an error. > This happens on a single node cassandra installation, on Ubuntu LTS 12.04. > > cqlsh:goh_master> DESCRIBE TABLE users; > CREATE TABLE users ( > corporation_id ascii PRIMARY KEY, > mail_token ascii, > admin ascii, > sysd ascii, > username ascii, > password ascii, > dockd ascii > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 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 users_username ON users (username); > cqlsh:goh_master> create index on users (admin); > cqlsh:goh_master> DESCRIBE TABLE users; > CREATE TABLE users ( > corporation_id ascii PRIMARY KEY, > mail_token ascii, > admin ascii, > sysd ascii, > username ascii, > password ascii, > dockd ascii > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 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 users_username ON users (username); > Interestingly enough, I can create new columnfamilies and add indexes to them: > cqlsh:goh_master> create table test (id ascii, value ascii, PRIMARY KEY(id)); > cqlsh:goh_master> DESCRIBE TABLE test; > CREATE TABLE test ( > id ascii PRIMARY KEY, > value ascii > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 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'; > cqlsh:goh_master> create index test_value ON test (value); > ^[[A^[[Acqlsh:goh_DESCRIBE TABLE test;(value); > CREATE TABLE test ( > id ascii PRIMARY KEY, > value ascii > ) WITH > comment='' AND > comparator=text AND > read_repair_chance=0.100000 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 test_value ON test (value); > 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