You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tuure Laurinolli (JIRA)" <ji...@apache.org> on 2012/07/30 10:09:35 UTC

[jira] [Created] (CASSANDRA-4471) Unable to drop keyspace

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

        

[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace

Posted by "Svend Hansen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13447602#comment-13447602 ] 

Svend Hansen commented on CASSANDRA-4471:
-----------------------------------------

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

[jira] [Comment Edited] (CASSANDRA-4471) Unable to drop keyspace

Posted by "Svend Hansen (JIRA)" <ji...@apache.org>.
    [ 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

[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace

Posted by "sunjian (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424956#comment-13424956 ] 

sunjian commented on CASSANDRA-4471:
------------------------------------

Here https://issues.apache.org/jira/browse/CASSANDRA-4461
                
> 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

        

[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace

Posted by "Marco Matarazzo (JIRA)" <ji...@apache.org>.
    [ 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

        

[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace

Posted by "sunjian (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424900#comment-13424900 ] 

sunjian commented on CASSANDRA-4471:
------------------------------------

yes, i have got this problem as well . it happened to the keyspace which has been running for some days , but not all the keyspaces . when it happened , we can't add/edit/delete both the keyspace and the column family , with any kind of client : cli/cqlsh/thrift/hector . no error returns , but  no effects took as well . 
                
> 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

        

[jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace

Posted by "Tuure Laurinolli (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-4471?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424754#comment-13424754 ] 

Tuure Laurinolli commented on CASSANDRA-4471:
---------------------------------------------

It seems that I'm also unable to drop column families inside this keyspace.
                
> 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