Skip to content

Instantly share code, notes, and snippets.

@ojingo
Created June 22, 2015 14:55
Show Gist options
  • Save ojingo/eb7628265902cd3f5597 to your computer and use it in GitHub Desktop.
Save ojingo/eb7628265902cd3f5597 to your computer and use it in GitHub Desktop.
Blocked trying to move data from DSE 4.6.7 to DSE 4.7 = sstableloader issue
i'm trying to transfer data from DSE 4.6.7 to DSE 4.7.0 and having issue with sstableloader:
Could not retrieve endpoint ranges:
java.lang.NullPointerException
java.lang.RuntimeException: Could not retrieve endpoint ranges:
staging-db-02 host is in the same network as target DSE cluster hosts
### first attempt failed because of 'vero' keyspace was not created
root@staging-db-02:/srv/db/data# sstableloader --debug -f /tmp/cassandra.yml -d 192.168.20.10,192.168.20.11 vero/post_comments/
Could not retrieve endpoint ranges:
InvalidRequestException(why:No such keyspace: vero)
java.lang.RuntimeException: Could not retrieve endpoint ranges:
at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:282)
at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149)
at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:94)
Caused by: InvalidRequestException(why:No such keyspace: vero)
at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34055)
at org.apache.cassandra.thrift.Cassandra$describe_ring_result$describe_ring_resultStandardScheme.read(Cassandra.java:34022)
at org.apache.cassandra.thrift.Cassandra$describe_ring_result.read(Cassandra.java:33964)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at org.apache.cassandra.thrift.Cassandra$Client.recv_describe_ring(Cassandra.java:1251)
at org.apache.cassandra.thrift.Cassandra$Client.describe_ring(Cassandra.java:1238)
at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:258)
... 2 more
### second attempt failed because of table was not created
root@staging-db-02:/srv/db/data# sstableloader --debug -f /tmp/cassandra.yml -d 192.168.20.10,192.168.20.11 vero/post_comments/
Established connection to initial hosts
Opening sstables and calculating sections to stream
Skipping file vero-post_comments-jb-29-Data.db: column family vero.post_comments doesn't exist
Skipping file vero-post_comments-jb-30-Data.db: column family vero.post_comments doesn't exist
Streaming session ID: 2b589e30-18ea-11e5-b56b-eb5c6dba7a72
### 'vero.users' was created before running sstableloader
root@staging-db-02:/srv/db/data# sstableloader --debug -f /tmp/cassandra.yml -d 192.168.20.10,192.168.20.11 vero/users/
Could not retrieve endpoint ranges:
java.lang.NullPointerException
java.lang.RuntimeException: Could not retrieve endpoint ranges:
at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:282)
at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:149)
at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:94)
Caused by: java.lang.NullPointerException
at org.apache.cassandra.serializers.BooleanSerializer.deserialize(BooleanSerializer.java:33)
at org.apache.cassandra.serializers.BooleanSerializer.deserialize(BooleanSerializer.java:24)
at org.apache.cassandra.db.marshal.AbstractType.compose(AbstractType.java:142)
at org.apache.cassandra.cql3.UntypedResultSet$Row.getBoolean(UntypedResultSet.java:102)
at org.apache.cassandra.config.CFMetaData.fromSchemaNoColumnsNoTriggers(CFMetaData.java:1701)
at org.apache.cassandra.config.CFMetaData.fromThriftCqlRow(CFMetaData.java:1059)
at org.apache.cassandra.tools.BulkLoader$ExternalClient.init(BulkLoader.java:274)
... 2 more
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment