Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3118ED52A for ; Mon, 30 Jul 2012 15:03:35 +0000 (UTC) Received: (qmail 12552 invoked by uid 500); 30 Jul 2012 15:03:35 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 12519 invoked by uid 500); 30 Jul 2012 15:03:35 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 12511 invoked by uid 99); 30 Jul 2012 15:03:35 -0000 Received: from issues-vm.apache.org (HELO issues-vm) (140.211.11.160) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jul 2012 15:03:35 +0000 Received: from isssues-vm.apache.org (localhost [127.0.0.1]) by issues-vm (Postfix) with ESMTP id BFF01142839 for ; Mon, 30 Jul 2012 15:03:34 +0000 (UTC) Date: Mon, 30 Jul 2012 15:03:34 +0000 (UTC) From: "sunjian (JIRA)" To: commits@cassandra.apache.org Message-ID: <125077020.116240.1343660614790.JavaMail.jiratomcat@issues-vm> In-Reply-To: <1654111805.115478.1343635775047.JavaMail.jiratomcat@issues-vm> Subject: [jira] [Commented] (CASSANDRA-4471) Unable to drop keyspace MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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