Cassandra connection exception

Question

I have this code:

private final String CONTACT_POINT = "127.0.0.1";
private SynchronizationTableManager()
{
     cluster = Cluster.builder().addContactPoint(CONTACT_POINT).build();;
     session = cluster.connect(KEYSPACE);
    createTableIfNotExists();
}

I get the following exception:

All host(s) tried for query failed (tried: /127.0.0.1:9042 (com.datastax.driver.core.TransportException: [/127.0.0.1:9042] Cannot connect)) with stack trace: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.1:9042 (com.datastax.driver.core.TransportException: [/127.0.0.1:9042] Cannot connect))

This happens on the line calling cluster.connect(KEYSPACE). Any idea how to fix this?

nastra nastra · Accepted Answer · 2015-10-02T11:07:22

This is most likely a problem with cassandra.yaml settings. Please check the settings of listen_address, rpc_address, and broadcast_rpc_address.

Please also check the connection requirements for the Java driver: https://github.com/datastax/java-driver/wiki/Connection-requirements

Also what does nodetool ring tell you about your C* node? Can you connect to your node over cqlsh?

Cassandra connection exception

2 Answers