Is SStable loader being run on the same host as the Cassandra node 127.0.0.1 (I see your ring is made up of all loop back IPs).
Rahul Neelakantan 678-451-4545 > On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure <akshay.ballarp...@tcs.com> > wrote: > > Thanks Duncan for quick help.... > now i am trying sstableloader but its not loading data...any suggestion ? > > > [root@CSL-simulation conf]# ps -eaf | grep -i cass > root 20322 1 0 Jul28 ? 00:04:27 > /usr/java/jdk1.7.0_60/bin/java -ea -javaagent:./../lib/jamm-0.2.5.jar > -XX:+CMSClassUnloadingEnabled -XX:+UseThreadPriorities > -XX:ThreadPriorityPolicy=42 -Xms7G -Xmx7G -Xmn1800M > -XX:+HeapDumpOnOutOfMemoryError -Xss256k -XX:StringTableSize=1000003 > -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:+CMSParallelRemarkEnabled > -XX:SurvivorRatio=8 -XX:MaxTenuringThreshold=1 > -XX:CMSInitiatingOccupancyFraction=75 -XX:+UseCMSInitiatingOccupancyOnly > -XX:+UseTLAB -XX:+UseCondCardMark -Djava.net.preferIPv4Stack=true > -Dcom.sun.management.jmxremote.port=7199 > -Dcom.sun.management.jmxremote.rmi.port=7199 > -Dcom.sun.management.jmxremote.ssl=false > -Dcom.sun.management.jmxremote.authenticate=false > -Dlog4j.configuration=log4j-server.properties > -Dlog4j.defaultInitOverride=true -cp > ./../conf:./../build/classes/main:./../build/classes/thrift:./../lib/antlr-3.2.jar:./../lib/apache-cassandra-2.0.8.jar:./../lib/apache-cassandra-clientutil-2.0.8.jar:./../lib/apache-cassandra-thrift-2.0.8.jar:./../lib/commons-cli-1.1.jar:./../lib/commons-codec-1.2.jar:./../lib/commons-lang3-3.1.jar:./../lib/compress-lzf-0.8.4.jar:./../lib/concurrentlinkedhashmap-lru-1.3.jar:./../lib/disruptor-3.0.1.jar:./../lib/guava-15.0.jar:./../lib/high-scale-lib-1.1.2.jar:./../lib/jackson-core-asl-1.9.2.jar:./../lib/jackson-mapper-asl-1.9.2.jar:./../lib/jamm-0.2.5.jar:./../lib/jbcrypt-0.3m.jar:./../lib/jline-1.0.jar:./../lib/json-simple-1.1.jar:./../lib/libthrift-0.9.1.jar:./../lib/log4j-1.2.16.jar:./../lib/lz4-1.2.0.jar:./../lib/metrics-core-2.2.0.jar:./../lib/netty-3.6.6.Final.jar:./../lib/reporter-config-2.1.0.jar:./../lib/servlet-api-2.5-20081211.jar:./../lib/slf4j-api-1.7.2.jar:./../lib/slf4j-log4j12-1.7.2.jar:./../lib/snakeyaml-1.11.jar:./../lib/ > > snappy-java-1.0.5.jar:./../lib/snaptree-0.1.jar:./../lib/super-csv-2.1.0.jar:./../lib/thrift-server-internal-only-0.3.3.jar > org.apache.cassandra.service.CassandraDaemon > root 28246 26448 0 14:24 pts/3 00:00:00 grep -i cass > [root@CSL-simulation conf]# ../bin/sstableloader sample_new/data_new -d > localhost > Established connection to initial hosts > Opening sstables and calculating sections to stream > Streaming relevant part of > sample_new/data_new/sample_new-data_new-jb-1-Data.db to [/127.0.0.1] > Streaming session ID: 05c15ca0-16fe-11e4-bdb8-731053160c4f > progress: [/127.0.0.1 1/1 (100%)] [total: 100% - 0MB/s (avg: 0MB/s)] WARN > 14:25:00,535 [Stream #05c15ca0-16fe-11e4-bdb8-731053160c4f] Stream failed > Streaming to the following hosts failed: > [/127.0.0.1] > java.util.concurrent.ExecutionException: > org.apache.cassandra.streaming.StreamException: Stream failed > [root@CSL-simulation conf]# ../bin/sstableloader sample_new/data_new -d > 127.0.0.1 > Established connection to initial hosts > Opening sstables and calculating sections to stream > Streaming relevant part of > sample_new/data_new/sample_new-data_new-jb-1-Data.db to [/127.0.0.1] > Streaming session ID: 161819e0-16fe-11e4-8377-731053160c4f > progress: [/127.0.0.1 1/1 (100%)] [total: 100% - 0MB/s (avg: 0MB/s)] WARN > 14:25:27,957 [Stream #161819e0-16fe-11e4-8377-731053160c4f] Stream failed > Streaming to the following hosts failed: > [/127.0.0.1] > java.util.concurrent.ExecutionException: > org.apache.cassandra.streaming.StreamException: Stream failed > > Thanks & Regards > Akshay Ghanshyam Ballarpure > Tata Consultancy Services > Cell:- 9985084075 > Mailto: akshay.ballarp...@tcs.com > Website: http://www.tcs.com > ____________________________________________ > Experience certainty. IT Services > Business Solutions > Consulting > ____________________________________________ > > > From: Duncan Sands <duncan.sa...@gmail.com> > To: user@cassandra.apache.org > Date: 07/29/2014 12:58 PM > Subject: Re: unable to load data using sstableloader > > > > > Hi Akshay, > > On 29/07/14 09:14, Akshay Ballarpure wrote: > > Yes, > > I have created keyspaces, but still i am getting error. > > > > cqlsh:sample_new> DESCRIBE KEYSPACES ; > > > > system sample mykeyspace test *sample_new* system_traces > > > > [root@CSL-simulation conf]# ../bin/sstableloader > > /root/Akshay/Cassandra/apache-cassandra-2.0.8/conf/SAMPLE_NEW/DATA_NEW/ -d > > localhost --debug > > Could not retrieve endpoint ranges: > > InvalidRequestException(why:No such keyspace: *SAMPLE_NEW*) > > here SAMPLE_NEW is in upper case, while describe keyspaces showed it lower > case, > sample_new. Try using quote marks: > > CREATE KEYSPACE "SAMPLE_NEW" ... > > Ciao, Duncan. > > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you >