[
https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13431116#comment-13431116
]
Pavel Yaskevich commented on CASSANDRA-4472:
--------------------------------------------
Please check if upgrade to 1.1.3, which has CASSANDRA-4439 included, fixes the
problem.
> 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
