Summary
When running the sstableloader a connection error is seen, due to the cassandra.yaml file not being found
Symptoms
The following error was seen
Streaming session ID: ae993c90-c175-11e4-8b9e-fd87c74bdff7 ERROR 07:19:56,466 [Stream #ae993c90-c175-11e4-8b9e-fd87c74bdff7] Streaming error occurred java.net.ConnectException: Connection refused at sun.nio.ch.Net.connect0(Native Method) at sun.nio.ch.Net.connect(Net.java:465) at sun.nio.ch.Net.connect(Net.java:457) at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:670) at java.nio.channels.SocketChannel.open(SocketChannel.java:184) at org.apache.cassandra.tools.BulkLoadConnectionFactory.createConnection(BulkLoadConnectionFactory.java:62) at org.apache.cassandra.streaming.StreamSession.createConnection(StreamSession.java:235) at org.apache.cassandra.streaming.ConnectionHandler.initiate(ConnectionHandler.java:77) at org.apache.cassandra.streaming.StreamSession$1.run(StreamSession.java:221) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)
Cause
The sstableloader was not picking up the cassandra.yaml file
Solution
Use the -f switch with the sstableloader to point it to the location of the cassandra.yaml file:
sudo sstableloader -v -d 127.0.0.1 -u cassandra -pw cassandra /var/lib/cassandra/data/Keyspace1/Standard1 -f /etc/dse/cassandra/cassandra.yaml