cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Neelakantan <ra...@rahul.be>
Subject Re: unable to load data using sstableloader
Date Tue, 29 Jul 2014 11:46:09 GMT
Sstabloader and Cassandra can't use the same network interface, clearly mentioned in the Cassandra
documentation on DataStax. If you are running both Cassandra and SStableloader locally, you
have to take some extra steps. Look at the post.

pushpalankajaya.blogspot.com/2012/06/bulk-loading-data-to-cassandra-using.html?m=1



Rahul Neelakantan

> On Jul 29, 2014, at 4:55 AM, Akshay Ballarpure <akshay.ballarpure@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.ballarpure@tcs.com
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty.        IT Services
>                        Business Solutions
>                        Consulting
> ____________________________________________ 
> 
> 
> From:	Duncan Sands <duncan.sands@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
> 

Mime
View raw message