Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 209.85.214.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAHULbCkUzchyd6-Qp9YGAG7NHfmbAoSMR=5UCop7-K9MyEg=kg@mail.gmail.com>
References: 
 <CAHULbCkUzchyd6-Qp9YGAG7NHfmbAoSMR=5UCop7-K9MyEg=kg@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Sat, 19 May 2012 12:08:10 -0500
Message-ID: 
 <CALdd-zg3kVShJf0zb6+Vb06DvxG=Est8F1hVQSzDLFC9ZJfdGA@mail.gmail.com>
Subject: Re: Exception when truncate
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Sounds like you have a permissions problem.  Cassandra creates a
subdirectory for each snapshot.

On Thu, May 17, 2012 at 4:57 AM, ruslan usifov <ruslan.usifov@gmail.com> wr=
ote:
> 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


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com