Tuure Laurinolli created CASSANDRA-4471:
-------------------------------------------
Summary: 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:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
