You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Stefan Häck (JIRA)" <ji...@apache.org> on 2012/06/30 16:31:42 UTC
[jira] [Created] (CASSANDRA-4397) Schema changes not working
Stefan Häck created CASSANDRA-4397:
--------------------------------------
Summary: Schema changes not working
Key: CASSANDRA-4397
URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
Project: Cassandra
Issue Type: Bug
Affects Versions: 1.1.1
Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
Reporter: Stefan Häck
Attachments: output.txt, system.txt
No schema change is possible in several keyspaces.
No error message appears, everything seems to be o.k., but the schema change isn't adopted.
I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_index.
Both nodes are connected to a local ntp-server.
Here's the cqlsh output:
{code:none}
cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
CREATE TABLE rm_cover_pages (
KEY text PRIMARY KEY,
css text,
description text,
language text,
html text,
company_id varint,
title text
) WITH
comment='Different cover pages for each company.' AND
comparator=text AND
read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
CREATE TABLE rm_cover_pages (
KEY text PRIMARY KEY,
css text,
description text,
language text,
html text,
company_id varint,
title text
) WITH
comment='Different cover pages for each company.' AND
comparator=text AND
read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
cqlsh:bite_personalmanager>
{code}
In the attachments are the system.log and the output.log.
The CassandraCli is also not working.
--
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
[jira] [Commented] (CASSANDRA-4397) Schema changes not working
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4397?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13406279#comment-13406279 ]
Stefan Häck commented on CASSANDRA-4397:
----------------------------------------
Update to 1.1.2 increased the problem. All indexes were gone. Rebuild didn't work.
After a cluster wide reset (deleting data-/commit-/cache-folders), cassandra seems to work again normally.
> Schema changes not working
> ---------------------------
>
> Key: CASSANDRA-4397
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.1
> Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
> Reporter: Stefan Häck
> Attachments: output.txt, system.txt
>
>
> No schema change is possible in several keyspaces.
> No error message appears, everything seems to be o.k., but the schema change isn't adopted.
> I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_index.
> Both nodes are connected to a local ntp-server.
> Here's the cqlsh output:
> {code:none}
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager>
> {code}
> In the attachments are the system.log and the output.log.
> The CassandraCli is also not working.
--
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
[jira] [Resolved] (CASSANDRA-4397) Schema changes not working
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck resolved CASSANDRA-4397.
------------------------------------
Resolution: Unresolved
> Schema changes not working
> ---------------------------
>
> Key: CASSANDRA-4397
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.1
> Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
> Reporter: Stefan Häck
> Attachments: output.txt, system.txt
>
>
> No schema change is possible in several keyspaces.
> No error message appears, everything seems to be o.k., but the schema change isn't adopted.
> I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_index.
> Both nodes are connected to a local ntp-server.
> Here's the cqlsh output:
> {code:none}
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager>
> {code}
> In the attachments are the system.log and the output.log.
> The CassandraCli is also not working.
--
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
[jira] [Updated] (CASSANDRA-4397) Schema changes not working
Posted by "Stefan Häck (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Häck updated CASSANDRA-4397:
-----------------------------------
Attachment: output.txt
system.txt
> Schema changes not working
> ---------------------------
>
> Key: CASSANDRA-4397
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.1
> Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
> Reporter: Stefan Häck
> Attachments: output.txt, system.txt
>
>
> No schema change is possible in several keyspaces.
> No error message appears, everything seems to be o.k., but the schema change isn't adopted.
> I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_index.
> Both nodes are connected to a local ntp-server.
> Here's the cqlsh output:
> {code:none}
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
> KEY text PRIMARY KEY,
> css text,
> description text,
> language text,
> html text,
> company_id varint,
> title text
> ) WITH
> comment='Different cover pages for each company.' AND
> comparator=text AND
> read_repair_chance=1.000000 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 rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager>
> {code}
> In the attachments are the system.log and the output.log.
> The CassandraCli is also not working.
--
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