cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marco Matarazzo (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-4472) Can't add secondary index
Date Mon, 30 Jul 2012 16:37:34 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-4472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Marco Matarazzo updated CASSANDRA-4472:
---------------------------------------

    Description: 
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>


  was:
It seems connected to [CASSANDRA-4461|https://issues.apache.org/jira/browse/CASSANDRA-4461]
(and [CASSANDRA-4471|https://issues.apache.org/jira/browse/CASSANDRA-4471]), but symptoms
are different so I open a separate bug. It may be the same problem, though.

Applying [CASSANDRA-4432|https://issues.apache.org/jira/browse/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>


    
> 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
>         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