cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Svend Hansen (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-4471) Unable to drop keyspace
Date Tue, 04 Sep 2012 13:55:07 GMT

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

Svend Hansen edited comment on CASSANDRA-4471 at 9/5/12 12:53 AM:
------------------------------------------------------------------

We're having the same problem on our build server. Can't drop or alter column families and
can't drop keyspace.
We're running cassandra 1.1.3 on Ubuntu 12.04.1 LTS.
We haven't had the problem on any of our test servers which are running 1.1.2 on "Amazon Linux"
(based on RedHat).
Not sure if the difference is the Cassandra version (you see it on 1.1.2, right?) or the OS
(you all experience this just on Debian?)

Edit: I've installed 1.1.4 on the build server but had to actually delete the data files to
get rid of the CFs. I'll see if it happens again with 1.1.4...
                
      was (Author: svendhhh):
    We're having the same problem on our build server. Can't drop or alter column families
and can't drop keyspace.
We're running cassandra 1.1.3 on Ubuntu 12.04.1 LTS.
We haven't had the problem on any of our test servers which are running 1.1.2 on "Amazon Linux"
(based on RedHat).
Not sure if the difference is the Cassandra version (you see it on 1.1.2, right?) or the OS
(you all experience this just on Debian?)


                  
> 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

Mime
View raw message