[
https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13430986#comment-13430986
]
Pavel Yaskevich commented on CASSANDRA-4472:
--------------------------------------------
I can't reproduce this behavior on the latest cassandra-1.1 branch, I have
tried creating ks/cf and adding index on username, restart, add index on admin
and create new cf + index, everything worked just fine. Can you please describe
what was going on in the system when you were adding new index (on admin)? Can
you try to give admin index an explicit name e.g. `create index users_admin on
users (admin);' and see if that changes your situation, because i see "Updating
column admin definition for index null" in the logs?... I think that this
problem is related to buggy default names method fixed by CASSANDRA-4439
> 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
