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] [Commented] (CASSANDRA-4471) Unable to drop keyspace
Date Mon, 30 Jul 2012 16:19:35 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424962#comment-13424962
] 

Marco Matarazzo commented on CASSANDRA-4471:
--------------------------------------------

Exactly the same problem we got. I had to close the bug as I can't reproduce it (we had to
move forward, zap the db and start over with a dump) but if you can nail it down, it would
be wonderful. 

And I confirm that, when it happens, it's a keyspace-specific problem.
                
> 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

        

Mime
View raw message