You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sam S (JIRA)" <ji...@apache.org> on 2013/01/10 22:50:13 UTC
[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13550464#comment-13550464 ]
Sam S commented on CASSANDRA-4471:
----------------------------------
I am having this same issue on a single node cluster (replication factor 1) using Cassandra 1.1.2
> Unable to drop keyspace
> -----------------------
>
> Key: CASSANDRA-4471
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4471
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.1.2
> Environment: Debian 6, cassandra.apache.org binary package
> Reporter: Tuure Laurinolli
>
> Drop keyspace command completes without error but the keyspace is not removed. Reproduced both using cassandra-cli and pycassa.
> Drop as observed from command line:
> [default@unknown] show keyspaces;
> Keyspace: system:
> Replication Strategy: org.apache.cassandra.locator.LocalStrategy
> Durable Writes: true
> Options: []
> Column Families:
> ColumnFamily: HintsColumnFamily (Super)
> "hinted handoff data"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.BytesType/org.apache.cassandra.db.marshal.BytesType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: IndexInfo
> "indexes that have been completed"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: LocationInfo
> "persistent metadata for the local node"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.BytesType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Migrations
> "individual schema mutations"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: NodeIdInfo
> "nodeId and their metadata"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Schema
> "current state of the schema"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Versions
> "server version information"
> Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: version
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_columnfamilies
> "ColumnFamily definitions"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType)
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_columns
> "ColumnFamily column attributes"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType)
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_keyspaces
> "Keyspace definitions"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: strategy_options
> Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Column Name: durable_writes
> Validation Class: org.apache.cassandra.db.marshal.BooleanType
> Column Name: name
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Column Name: strategy_class
> Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> Keyspace: testspace:
> Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
> Durable Writes: true
> Options: [replication_factor:3]
> Column Families:
> ColumnFamily: testfamily
> Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 864000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.1
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: name
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Column Name: value
> Validation Class: org.apache.cassandra.db.marshal.LongType
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> Compression Options:
> sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor
> [default@unknown] drop keyspace testspace;
> 2aaee280-efab-37c6-ae0e-7608f16f3a7f
> Waiting for schema agreement...
> ... schemas agree across the cluster
> [default@unknown] show keyspaces;
> Keyspace: system:
> Replication Strategy: org.apache.cassandra.locator.LocalStrategy
> Durable Writes: true
> Options: []
> Column Families:
> ColumnFamily: HintsColumnFamily (Super)
> "hinted handoff data"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.BytesType/org.apache.cassandra.db.marshal.BytesType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: IndexInfo
> "indexes that have been completed"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: LocationInfo
> "persistent metadata for the local node"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.BytesType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Migrations
> "individual schema mutations"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: NodeIdInfo
> "nodeId and their metadata"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.TimeUUIDType
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Schema
> "current state of the schema"
> Key Validation Class: org.apache.cassandra.db.marshal.BytesType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: Versions
> "server version information"
> Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 0
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: version
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_columnfamilies
> "ColumnFamily definitions"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType)
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_columns
> "ColumnFamily column attributes"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType,org.apache.cassandra.db.marshal.AsciiType)
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> ColumnFamily: schema_keyspaces
> "Keyspace definitions"
> Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
> GC grace seconds: 10368000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.0
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: strategy_options
> Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Column Name: durable_writes
> Validation Class: org.apache.cassandra.db.marshal.BooleanType
> Column Name: name
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Column Name: strategy_class
> Validation Class: org.apache.cassandra.db.marshal.AsciiType
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> Keyspace: testspace:
> Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
> Durable Writes: true
> Options: [replication_factor:3]
> Column Families:
> ColumnFamily: testfamily
> Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Default column value validator: org.apache.cassandra.db.marshal.BytesType
> Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
> GC grace seconds: 864000
> Compaction min/max thresholds: 4/32
> Read repair chance: 0.1
> DC Local Read repair chance: 0.0
> Replicate on write: true
> Caching: KEYS_ONLY
> Bloom Filter FP chance: default
> Built indexes: []
> Column Metadata:
> Column Name: name
> Validation Class: org.apache.cassandra.db.marshal.UTF8Type
> Column Name: value
> Validation Class: org.apache.cassandra.db.marshal.LongType
> Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
> Compression Options:
> sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor
> [default@unknown]
> Log output from one node during the drop:
> INFO [MigrationStage:1] 2012-07-30 11:06:59,640 ColumnFamilyStore.java (line 643) Enqueuing flush of Memtable-schema_keyspaces@979188416(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,641 Memtable.java (line 266) Writing Memtable-schema_keyspaces@979188416(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,654 Memtable.java (line 307) Completed flushing /home/tul/cassandra-data/data/system/schema_keyspaces/system-schema_keyspaces-hd-30-Data.db (59 bytes) for commitlog position ReplayPosition(segmentId=34790348724, position=2196)
> INFO [MigrationStage:1] 2012-07-30 11:06:59,655 ColumnFamilyStore.java (line 643) Enqueuing flush of Memtable-schema_columnfamilies@893461718(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,655 Memtable.java (line 266) Writing Memtable-schema_columnfamilies@893461718(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,673 Memtable.java (line 307) Completed flushing /home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-40-Data.db (59 bytes) for commitlog position ReplayPosition(segmentId=34790348724, position=2196)
> INFO [CompactionExecutor:5] 2012-07-30 11:06:59,674 CompactionTask.java (line 109) Compacting [SSTableReader(path='/home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-40-Data.db'), SSTableReader(path='/home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-39-Data.db'), SSTableReader(path='/home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-38-Data.db'), SSTableReader(path='/home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-37-Data.db')]
> INFO [MigrationStage:1] 2012-07-30 11:06:59,676 ColumnFamilyStore.java (line 643) Enqueuing flush of Memtable-schema_columns@640632851(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,677 Memtable.java (line 266) Writing Memtable-schema_columns@640632851(12/15 serialized/live bytes, 1 ops)
> INFO [FlushWriter:5] 2012-07-30 11:06:59,711 Memtable.java (line 307) Completed flushing /home/tul/cassandra-data/data/system/schema_columns/system-schema_columns-hd-35-Data.db (59 bytes) for commitlog position ReplayPosition(segmentId=34790348724, position=2196)
> INFO [CompactionExecutor:5] 2012-07-30 11:06:59,724 CompactionTask.java (line 221) Compacted to [/home/tul/cassandra-data/data/system/schema_columnfamilies/system-schema_columnfamilies-hd-41-Data.db,]. 1,500 to 1,323 (~88% of original) bytes for 1 keys at 0.025749MB/s. Time: 49ms.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira