Thanks, Johnny Actually, they were running .. it went through a series of read and writes .. and recovered after the error. Is there any settings I can specify in preparing the Session at java client driver level, here are my current settings -
PoolingOptions poolingOptions = new PoolingOptions() .setConnectionsPerHost(HostDistance.LOCAL, 20, 20) .setMaxRequestsPerConnection(HostDistance.LOCAL, 128) .setNewConnectionThreshold(HostDistance.LOCAL, 100); Cluster.Builder builder = Cluster.builder() .addContactPoints(cp) .withPoolingOptions(poolingOptions) .withProtocolVersion(ProtocolVersion.NEWEST_SUPPORTED) .withPort(port); On Tue, Jul 12, 2016 at 11:47 AM Johnny Miller <johnny.p.mil...@gmail.com> wrote: > Abhinav - your getting that as the driver isn’t finding any hosts up for > your query. You probably need to check if all the nodes in your cluster are > running. > > See: > http://docs.datastax.com/en/drivers/java/3.0/com/datastax/driver/core/exceptions/NoHostAvailableException.html > > > Johnny > > On 12 Jul 2016, at 18:46, Abhinav Solan <abhinav.so...@gmail.com> wrote: > > Hi Everyone, > > I am getting this error on our server, it comes and goes seems the > connection drops a comes back after a while - > > Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All > host(s) tried for query failed (tried: ****************:9042 > (com.datastax.driver.core.exceptions.ConnectionException: [****************] > Pool is CLOSING)) > at > com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:218) > at > com.datastax.driver.core.RequestHandler.access$1000(RequestHandler.java:43) > at > com.datastax.driver.core.RequestHandler$SpeculativeExecution.sendRequest(RequestHandler.java:284) > at > com.datastax.driver.core.RequestHandler.startNewExecution(RequestHandler.java:115) > at > com.datastax.driver.core.RequestHandler.sendRequest(RequestHandler.java:91) > at > com.datastax.driver.core.SessionManager.executeAsync(SessionManager.java:129) > > Can anyone suggest me what can be done to handle this error ? > > > Thanks, > > Abhinav > > >