cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Yaskevich (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4472) Can't add secondary index
Date Wed, 08 Aug 2012 09:50:12 GMT

    [ 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

        

Mime
View raw message