You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Swathi Vikas <sw...@yahoo.com> on 2012/08/28 00:56:50 UTC

sstableloader error

Hi,
 
I had uploaded data using sstablelaoder to a single node cluster earlier without any problem. Now, while trying to upload to 3 node cluster it is giving me below error: 
 
localhost:~/apache-cassandra-1.0.7/sstableloader_folder # bin/sstableloader DEMO/
Starting client (and waiting 30 seconds for gossip) ...
Streaming revelant part of DEMO/UMD-hc-1-Data.db to [/10.245.28.232, /10.245.28.231, /10.245.28.230]
progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)]
 [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230 0/0 (100)] [total: 0 - 0MB/s (avg: 0MB/s)] WARN 21:41:15,200 Failed attempt 1 to connect to /10.245.28.232 to stream null. Retrying in 20000 ms. (java.net.ConnectException: Connection timed out)
progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230 0/0 (100)] [total: 0 - 0MB/s (avg: 0MB/s)]^Clocalhost:~/apache-cassandra-1.0.7/sstableloader_folder #

I am running cassandra on foreground. So, on all of the cassandra nodes i get the below message:
 INFO 21:40:30,335 Node /192.168.11.11 is now part of the cluster
 INFO 21:40:30,336 InetAddress /192.168.11.11 is now UP
 INFO 21:41:55,320 InetAddress /192.168.11.11 is now dead.
 INFO 21:41:55,321 FatClient /192.168.11.11 has been silent for 30000ms, removing from gossip

I used ByteOrderPartitioner and filled intial token on all nodes.
I have set seeds as "10.245.28.230,10.245.28.231"
I have properly set listen address, rpc_address(0.0.0.0) and ports
 
One thing i noticed is that, when i try to connect to this cluster using client(libQtCassandra) and try to create column family, all the nodes respond and column family got created properly. 
 
Can anyone help me please.
 
Thanks and Regards,
Swat.vikas

Re: sstableloader error

Posted by aaron morton <aa...@thelastpickle.com>.
> WARN 21:41:15,200 Failed attempt 1 to connect to /10.245.28.232 to stream null. Retrying in 20000 ms. (java.net.ConnectException: Connection timed out)
If you let sstable run does it complete ?

> I am running cassandra on foreground. So, on all of the cassandra nodes i get the below message:
>  INFO 21:40:30,335 Node /192.168.11.11 is now part of the cluster
This is the bulk load process joining the ring to send the file around. 

Cheers

-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 28/08/2012, at 10:56 AM, Swathi Vikas <sw...@yahoo.com> wrote:

> Hi,
>  
> I had uploaded data using sstablelaoder to a single node cluster earlier without any problem. Now, while trying to upload to 3 node cluster it is giving me below error:
>  
> localhost:~/apache-cassandra-1.0.7/sstableloader_folder # bin/sstableloader DEMO/
> Starting client (and waiting 30 seconds for gossip) ...
> Streaming revelant part of DEMO/UMD-hc-1-Data.db to [/10.245.28.232, /10.245.28.231, /10.245.28.230]
> progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230 0/0 (100)] [total: 0 - 0MB/s (avg: 0MB/s)] WARN 21:41:15,200 Failed attempt 1 to connect to /10.245.28.232 to stream null. Retrying in 20000 ms. (java.net.ConnectException: Connection timed out)
> progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230progress: [/10.245.28.232 0/0 (100)] [/10.245.28.231 0/1 (0)] [/10.245.28.230 0/0 (100)] [total: 0 - 0MB/s (avg: 0MB/s)]^Clocalhost:~/apache-cassandra-1.0.7/sstableloader_folder #
> I am running cassandra on foreground. So, on all of the cassandra nodes i get the below message:
>  INFO 21:40:30,335 Node /192.168.11.11 is now part of the cluster
>  INFO 21:40:30,336 InetAddress /192.168.11.11 is now UP
>  INFO 21:41:55,320 InetAddress /192.168.11.11 is now dead.
>  INFO 21:41:55,321 FatClient /192.168.11.11 has been silent for 30000ms, removing from gossip
> I used ByteOrderPartitioner and filled intial token on all nodes.
> I have set seeds as "10.245.28.230,10.245.28.231"
> I have properly set listen address, rpc_address(0.0.0.0) and ports
>  
> One thing i noticed is that, when i try to connect to this cluster using client(libQtCassandra) and try to create column family, all the nodes respond and column family got created properly.
>  
> Can anyone help me please.
>  
> Thanks and Regards,
> Swat.vikas
>  
>