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 844C411BB8 for ; Mon, 8 Sep 2014 15:23:34 +0000 (UTC) Received: (qmail 86959 invoked by uid 500); 8 Sep 2014 15:23:31 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 86913 invoked by uid 500); 8 Sep 2014 15:23:31 -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 86903 invoked by uid 99); 8 Sep 2014 15:23:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Sep 2014 15:23:31 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of matmsh@yahoo.com designates 98.139.212.126 as permitted sender) Received: from [98.139.212.126] (HELO nm22-vm0.bullet.mail.bf1.yahoo.com) (98.139.212.126) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Sep 2014 15:23:01 +0000 Received: from [98.139.212.150] by nm22.bullet.mail.bf1.yahoo.com with NNFMP; 08 Sep 2014 15:22:59 -0000 Received: from [98.139.212.245] by tm7.bullet.mail.bf1.yahoo.com with NNFMP; 08 Sep 2014 15:22:59 -0000 Received: from [127.0.0.1] by omp1054.mail.bf1.yahoo.com with NNFMP; 08 Sep 2014 15:22:59 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 678990.90322.bm@omp1054.mail.bf1.yahoo.com Received: (qmail 80035 invoked by uid 60001); 8 Sep 2014 15:22:59 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1410189779; bh=eToxOqIWlQVYnL8TCNnkBDjiwMyEN2B/ZeZmEY2uwyA=; h=Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=FA4yA6Bw9NsUo9v/hO9h26J62OOSksRkzrze3j90h349hB22dUScNxXLkEKD1J4J/d9GVhKjrYNrGY0RTNucgcea9wmVZNYvWW0SW3hfB0MjKJFAi7+0iG3YbVRWzX1zR4pUJ5EUUEzAI3IuwqAfScxCmET2M5Rf6wiBD98m9/I= X-YMail-OSG: SDtvWokVM1lx72EiYKxEh0eBu7YcPLFXQQB.BaAtZou4iDa _maPpGeYwCMae_zl88A5MmKIt4OjVKLjY5Kg4r59sKxEVoNvOqW4_KGF0Ojw mOVUPqjmN77WYdRA.Yr1MwAk.tedpHOcq.KwjLCcyjRhbROZteyL_DIdMh9s qMssgDRjcZdjkxT8K3P_rP8CKoGkPgW6baZ91I8bGz.t1xdG0wuk0QPnHx9l Dar9zumLB1ooOEWqpkXWWaadJ7VPOLby8Mp50iILw3uN64Ot_tKqzqwSIqMm 8mSyIiU_xxuXL38IaZ47OiEj8vR0KAQJ3jLkP100f.JvuANXGuWnqNpmIyyb QE2kZ2gtGGStZlwgY2yzn0VgBm0NNEd0pu..KgWbSLBfQtCTWoZaj5sNuHWn dje2YJ.ucpkJNJ_FP97Rc1uzJ9H29_my3hDLa8_8WYzyuJ2Y2gqlWYRnddbP LsFeIX8gdtDiwkp57wLTPcBlL5p_Bdq3QcL56N7B0Izcs3MDzDLufYpAvLS4 031I93KwrpCWwWQ7HyvVkqSK9vl_yq3hM6kF8xIwL_dyvxzg- Received: from [77.107.87.15] by web160606.mail.bf1.yahoo.com via HTTP; Mon, 08 Sep 2014 08:22:59 PDT X-Rocket-MIMEInfo: 002.001,SGksCiAgIEkgYW0gcnVubmluZyBDYXNzYW5kcmEgMi4wLjUgb24gbXkgUEMgKHdpdGgganVzdCBvbmUgbm9kZSBhbmQgdGhlIGRlZmF1bHQgY2Fzc2FuZHJhLnlhbWwpLiAKCkkgaGF2ZSBpbnNlcnRlZCAgb25lIG1pbGxpb24gcm93cyBpbnRvIGEgY29sdW1uIGZhbWlseSAoZWFjaCByb3cgaGFzIGEgaW50IGtleSwgdHdvICBzbWFsbCBzZXQ8c3RyaW5nPiBjb2x1bW5zLikgCgpJbiBjcWxzaCwgIHdoZW4gSSBkaWQgYSBzZWxlY3QgY291bnQKCiBjcWxzaDp0ZXN0a3M.IHNlbGVjdCBjb3VudCgqKSBmcm9tIGkBMAEBAQE- X-Mailer: YahooMailWebService/0.8.203.696 Message-ID: <1410189779.68591.YahooMailNeo@web160606.mail.bf1.yahoo.com> Date: Mon, 8 Sep 2014 08:22:59 -0700 From: Shing Hing Man Reply-To: Shing Hing Man Subject: Cassandra 2.0.5 : *-jb-27-Data.db (No such file or directory) To: "user@cassandra.apache.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1874956439-443275220-1410189779=:68591" X-Virus-Checked: Checked by ClamAV on apache.org --1874956439-443275220-1410189779=:68591 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi,=0A I am running Cassandra 2.0.5 on my PC (with just one node and the = default cassandra.yaml). =0A=0AI have inserted one million rows into a col= umn family (each row has a int key, two small set columns.) =0A=0A= In cqlsh, when I did a select count=0A=0A cqlsh:testks> select count(*) fr= om ips_table limit 2000000;=0A=0AI got the following exception :=0A =0A= ERROR 16:04:05,657 Exception in thread Thread[ReadStage:66,5,main]=0Ajava.l= ang.RuntimeException: java.lang.RuntimeException: java.io.FileNotFoundExcep= tion: /home/shing/installed/cassandras/filelogs/data/testks/ips_table/testk= s-ips_table-jb-27-Data.db (No such file or directory)=0Aat org.apache.cassa= ndra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1935)=0Aa= t java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java= :1145)=0Aat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolEx= ecutor.java:615)=0Aat java.lang.Thread.run(Thread.java:724)=0ACaused by: ja= va.lang.RuntimeException: java.io.FileNotFoundException: /home/shing/instal= led/cassandras/filelogs/data/testks/ips_table/testks-ips_table-jb-27-Data.d= b (No such file or directory)=0Aat org.apache.cassandra.io.compress.Compres= sedRandomAccessReader.open(CompressedRandomAccessReader.java:59)=0Aat org.a= pache.cassandra.io.sstable.SSTableReader.openDataReader(SSTableReader.java:= 1362)=0Aat org.apache.cassandra.io.sstable.SSTableScanner.(SSTableSca= nner.java:67)=0Aat org.apache.cassandra.io.sstable.SSTableReader.getScanner= (SSTableReader.java:1147)=0Aat org.apache.cassandra.db.RowIteratorFactory.g= etIterator(RowIteratorFactory.java:69)=0Aat org.apache.cassandra.db.ColumnF= amilyStore.getSequentialIterator(ColumnFamilyStore.java:1599)=0Aat org.apac= he.cassandra.db.ColumnFamilyStore.getRangeSlice(ColumnFamilyStore.java:1718= )=0Aat org.apache.cassandra.db.PagedRangeCommand.executeLocally(PagedRangeC= ommand.java:111)=0Aat org.apache.cassandra.service.StorageProxy$LocalRangeS= liceRunnable.runMayThrow(StorageProxy.java:1418)=0Aat org.apache.cassandra.= service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1931)=0A... 3 = more=0A=0A=0AAre there some Cassandra parameters I could set to get ride o= f the above exception ?=0A=0AThanks in advance for any assistance !=0A=0ASh= ing --1874956439-443275220-1410189779=:68591 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi,
   I am running Cassandra 2.0.5 on my PC (with just one node an= d the default cassandra.yaml).
I have inserted  one milli= on rows into a column family (each row has a int key, two  small set&l= t;string> columns.) 

In cqlsh,  when I did a select count
 cqlsh:te= stks> select count(*) from ips_table limit 2000000;

I got the following excep= tion :
  &= nbsp;  =0A
ERROR 16:04:05,657 Exception in thread Thread[ReadStage= :66,5,main]
=0A
java.lang.RuntimeException: java.lang.RuntimeException: java.io.FileNot= FoundException: /home/shing/installed/cassandras/filelogs/data/testks/ips_t= able/testks-ips_table-jb-27-Data.db (No such file or directory)
=0A at org.apac= he.cassandra.service.StorageProxy$DroppableRunnable.run(StorageProxy.java:1= 935)=0A
= at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecuto= r.java:1145)
=0A
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPo= olExecutor.java:615)
=0A
at java.lang.Thread.run(Thread.java:724)
=0A
Caused by: java.lang.= RuntimeException: java.io.FileNotFoundException: /home/shing/installed/cass= andras/filelogs/data/testks/ips_table/testks-ips_table-jb-27-Data.db (No su= ch file or directory)
=0A
at org.apache.cassandra.io.compress.CompressedRandomA= ccessReader.open(CompressedRandomAccessReader.java:59)
=0A
at org.apache.cass= andra.io.sstable.SSTableReader.openDataReader(SSTableReader.java:1362)=0A
at o= rg.apache.cassandra.io.sstable.SSTableScanner.<init>(SSTableScanner.j= ava:67)
=0A
= at org.apache.cassandra.io.sstable.SSTableReader.getScanner(SSTable= Reader.java:1147)
=0A
at org.apache.cassandra.db.RowIteratorFactory.getIterator= (RowIteratorFactory.java:69)
=0A
at org.apache.cassandra.db.ColumnFamilyStore.g= etSequentialIterator(ColumnFamilyStore.java:1599)
=0A
at org.apache.cassandra.d= b.ColumnFamilyStore.getRangeSlice(ColumnFamilyStore.java:1718)
=0A at org.apach= e.cassandra.db.PagedRangeCommand.executeLocally(PagedRangeCommand.java:111)=
=0A
= at org.apache.cassandra.service.StorageProxy$LocalRangeSliceRunnable.runMa= yThrow(StorageProxy.java:1418)
=0A
at org.apache.cassandra.service.StorageProxy= $DroppableRunnable.run(StorageProxy.java:1931)
=0A
... 3 more
=0A
=
=0A

Are there s= ome Cassandra parameters I could set to get ride of the above exception ?

Thanks in advance for any assistance !

Shing<= br>



--1874956439-443275220-1410189779=:68591--