Marco Matarazzo created CASSANDRA-4472:
------------------------------------------
Summary: 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
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>
--
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
