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 Wed, 30 Jul 2014 04:58:53 GMT
Yes Rahul, i didn't created any ring. just a stand alone setup (single 
node cluster)
Issue got resolved after creating sstable file properly...i mean, 
Keyspace/ColumnFamily folder manually and keeping sstable file in it.

Somehow java api is not creating column family folder under keyspace, did 
you or any one saw such problem before  ?


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:
Rahul Neelakantan <rahul@rahul.be>
To:
"user@cassandra.apache.org" <user@cassandra.apache.org>
Date:
07/29/2014 05:02 PM
Subject:
Re: unable to load data using sstableloader



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.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