Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BBC9AC79C for ; Thu, 17 May 2012 10:06:13 +0000 (UTC) Received: (qmail 49672 invoked by uid 500); 17 May 2012 10:06:11 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 49642 invoked by uid 500); 17 May 2012 10:06:11 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 49621 invoked by uid 99); 17 May 2012 10:06:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 10:06:10 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of ruslan.usifov@gmail.com designates 209.85.213.44 as permitted sender) Received: from [209.85.213.44] (HELO mail-yw0-f44.google.com) (209.85.213.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 10:06:04 +0000 Received: by yhq56 with SMTP id 56so1954123yhq.31 for ; Thu, 17 May 2012 03:05:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=KEjU9po6tHwAWepabY+O0M5uwOwHPWa3zCo3HXL7Af0=; b=W47HMXZnJxXayNHGxEzs0GAKmtqW2zqWObhZ65yKISNK/3n8y6dDwwYrXSxM1fiJ9K v+uMzLYUGyO8imwa3is1/2vnqdhpTrC8aY4cI5tRZ8/DDUSm6O5PUsfYLWRSI8nhhjVI voJz+sOznFtHYaayA0GjnyU4/RfMw7W4N/iaiD4SqNUcgqusQZrBEeVeBJg8aB7lsJSf 8fzMT2BAWOrvgCyq0r2R8+6tY+AOa75lUik6l14KVaF8nKB3n79Sdo5q/miXTt2wyHa3 uLOCApOEyDz3yKN6OYVy7GIJVR8YxCwFS7jdKwLWqx33+u1tpSrIsaAkt9EBaX5cMM5o HjSA== MIME-Version: 1.0 Received: by 10.236.76.133 with SMTP id b5mr7591342yhe.3.1337249143563; Thu, 17 May 2012 03:05:43 -0700 (PDT) Received: by 10.236.170.196 with HTTP; Thu, 17 May 2012 03:05:43 -0700 (PDT) In-Reply-To: References: Date: Thu, 17 May 2012 14:05:43 +0400 Message-ID: Subject: Re: Exception when truncate From: ruslan usifov To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Also i miss understand why on empty CF(no any SStable) truncate heavy loads disk?? 2012/5/17 ruslan usifov : > Hello > > I have follow situation on our test server: > > from cassandra-cli i try to use > > truncate purchase_history; > > 3 times i got: > > [default@township_6waves] truncate purchase_history; > null > UnavailableException() > =A0 =A0 =A0 =A0at org.apache.cassandra.thrift.Cassandra$truncate_result.r= ead(Cassandra.java:20212) > =A0 =A0 =A0 =A0at org.apache.cassandra.thrift.Cassandra$Client.recv_trunc= ate(Cassandra.java:1077) > =A0 =A0 =A0 =A0at org.apache.cassandra.thrift.Cassandra$Client.truncate(C= assandra.java:1052) > =A0 =A0 =A0 =A0at org.apache.cassandra.cli.CliClient.executeTruncate(CliC= lient.java:1445) > =A0 =A0 =A0 =A0at org.apache.cassandra.cli.CliClient.executeCLIStatement(= CliClient.java:272) > =A0 =A0 =A0 =A0at org.apache.cassandra.cli.CliMain.processStatementIntera= ctive(CliMain.java:220) > =A0 =A0 =A0 =A0at org.apache.cassandra.cli.CliMain.main(CliMain.java:348) > > > So this looks that truncate goes very slow and too long, than > rpc_timeout_in_ms: 10000 (this can happens because we have very slow > disck on test machine) > > But in in cassandra system log i see follow exception: > > > ERROR [MutationStage:7022] 2012-05-17 12:19:14,356 > AbstractCassandraDaemon.java (line 139) Fatal exception in thread > Thread[MutationStage:7022,5,main] > java.io.IOError: java.io.IOException: unable to mkdirs > /home/cassandra/1.0.0/data/township_6waves/snapshots/1337242754356-purcha= se_history > =A0 =A0 =A0 =A0at org.apache.cassandra.db.ColumnFamilyStore.snapshotWitho= utFlush(ColumnFamilyStore.java:1433) > =A0 =A0 =A0 =A0at org.apache.cassandra.db.ColumnFamilyStore.snapshot(Colu= mnFamilyStore.java:1462) > =A0 =A0 =A0 =A0at org.apache.cassandra.db.ColumnFamilyStore.truncate(Colu= mnFamilyStore.java:1657) > =A0 =A0 =A0 =A0at org.apache.cassandra.db.TruncateVerbHandler.doVerb(Trun= cateVerbHandler.java:50) > =A0 =A0 =A0 =A0at org.apache.cassandra.net.MessageDeliveryTask.run(Messag= eDeliveryTask.java:59) > =A0 =A0 =A0 =A0at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(= ThreadPoolExecutor.java:886) > =A0 =A0 =A0 =A0at java.util.concurrent.ThreadPoolExecutor$Worker.run(Thre= adPoolExecutor.java:908) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:662) > Caused by: java.io.IOException: unable to mkdirs > /home/cassandra/1.0.0/data/township_6waves/snapshots/1337242754356-purcha= se_history > =A0 =A0 =A0 =A0at org.apache.cassandra.io.util.FileUtils.createDirectory(= FileUtils.java:140) > =A0 =A0 =A0 =A0at org.apache.cassandra.io.util.FileUtils.createDirectory(= FileUtils.java:131) > =A0 =A0 =A0 =A0at org.apache.cassandra.db.ColumnFamilyStore.snapshotWitho= utFlush(ColumnFamilyStore.java:1409) > =A0 =A0 =A0 =A0... 7 more > > > Also i see that in snapshort dir already exists > 1337242754356-purchase_history directory, so i think that snapshort > names that generate cassandra not uniquely. > > PS: We use cassandra 1.0.10 on Ubuntu 10.0.4-LTS