Copying titan cassandra keyspace between machines

[yuval yaari]

Hi,

We have a Cassandra clustered environment with a titan keyspace which we want to copy and use on a local developers machine.

I know that there is an option to export/import the graph to a json file, however it seems like there is something malformed in the exported json and we cant import it to the local dev env,

We are using Cassandra's 'copy' tool to export and import the titan keyspace from the clustered env to the local dev env.

After copy was successfully completed, we cannot open the graph (using datastax java driver) and are getting the following exception:

com.thinkaurelius.titan.core.TitanException: Could not execute operation due to backend exception

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.execute(BackendOperation.java:44)

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.execute(BackendOperation.java:144)

at com.thinkaurelius.titan.diskstorage.configuration.backend.KCVSConfiguration.get(KCVSConfiguration.java:88)

at com.thinkaurelius.titan.diskstorage.configuration.BasicConfiguration.isFrozen(BasicConfiguration.java:93)

at com.thinkaurelius.titan.graphdb.configuration.GraphDatabaseConfiguration.<init>(GraphDatabaseConfiguration.java:1338)

at com.thinkaurelius.titan.core.TitanFactory.open(TitanFactory.java:94)

at com.thinkaurelius.titan.core.TitanFactory.open(TitanFactory.java:62)

Caused by: com.thinkaurelius.titan.diskstorage.TemporaryBackendException: Could not successfully complete backend operation due to repeated temporary exceptions after PT1M

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.executeDirect(BackendOperation.java:86)

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.execute(BackendOperation.java:42)

... 30 more

Caused by: com.thinkaurelius.titan.diskstorage.TemporaryBackendException: Temporary failure in storage backend

at com.thinkaurelius.titan.diskstorage.cassandra.astyanax.AstyanaxKeyColumnValueStore.getNamesSlice(AstyanaxKeyColumnValueStore.java:114)

at com.thinkaurelius.titan.diskstorage.cassandra.astyanax.AstyanaxKeyColumnValueStore.getNamesSlice(AstyanaxKeyColumnValueStore.java:78)

at com.thinkaurelius.titan.diskstorage.cassandra.astyanax.AstyanaxKeyColumnValueStore.getSlice(AstyanaxKeyColumnValueStore.java:67)

at com.thinkaurelius.titan.diskstorage.configuration.backend.KCVSConfiguration$1.call(KCVSConfiguration.java:91)

at com.thinkaurelius.titan.diskstorage.configuration.backend.KCVSConfiguration$1.call(KCVSConfiguration.java:88)

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.execute(BackendOperation.java:133)

at com.thinkaurelius.titan.diskstorage.util.BackendOperation$1.call(BackendOperation.java:147)

at com.thinkaurelius.titan.diskstorage.util.BackendOperation.executeDirect(BackendOperation.java:56)

... 31 more

Caused by: com.netflix.astyanax.connectionpool.exceptions.NoAvailableHostsException: NoAvailableHostsException: [host=None(0.0.0.0):0, latency=0(0), attempts=0]No hosts to borrow from

at com.netflix.astyanax.connectionpool.impl.RoundRobinExecuteWithFailover.<init>(RoundRobinExecuteWithFailover.java:48)

at com.netflix.astyanax.connectionpool.impl.TokenAwareConnectionPoolImpl.newExecuteWithFailover(TokenAwareConnectionPoolImpl.java:83)

at com.netflix.astyanax.connectionpool.impl.AbstractHostPartitionConnectionPool.executeWithFailover(AbstractHostPartitionConnectionPool.java:352)

at com.netflix.astyanax.thrift.ThriftColumnFamilyQueryImpl$4.execute(ThriftColumnFamilyQueryImpl.java:538)

at com.thinkaurelius.titan.diskstorage.cassandra.astyanax.AstyanaxKeyColumnValueStore.getNamesSlice(AstyanaxKeyColumnValueStore.java:112)

... 38 more

Can anyone shed light on what should be done to fully copy titan's data from the clustered env to the local dev env? Any help will be much appreciated.

Thanks!