cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akshay Ballarpure <akshay.ballarp...@tcs.com>
Subject Re: unable to load data using sstableloader
Date Tue, 29 Jul 2014 08:55:13 GMT
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/snaptr
 ee-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