Início / dba / Perguntas / 333486
Accepted
Frank Limstrand
Asked: 2023-11-27 21:31:26 +0800 CST

sstableloader falha com NoHostAvailableException, "Todos os hosts tentados para consulta falharam"

  • 772

sstableloader é executado em um host v4.1.3 usando sstablefiles de um host v3.11.6:

sstableloader -v --nodes oneofthehosts --username whatever --password whatever --truststore /etc/cassandra/conf/truststore.jks --truststore-password whatever --keystore /etc/cassandra/conf/keystore.jks --keystore-password whatever /tmp/keyspace/table

A mensagem de erro (ligeiramente cortada):

com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: oneofthehosts/someip:9042 (com.datastax.driver.core.exceptions.OperationTimedOutException: [oneofthehosts/someip:9042] Operation timed out))
java.lang.RuntimeException: Unable to initialise org.apache.cassandra.utils.NativeSSTableLoaderClient
    at org.apache.cassandra.utils.NativeSSTableLoaderClient.init(NativeSSTableLoaderClient.java:102)
    at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:167)
    at org.apache.cassandra.tools.BulkLoader.load(BulkLoader.java:91)
    at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:58)
Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: oneofthehosts/someip:9042 (com.datastax.driver.core.exceptions.OperationTimedOutException: oneofthehosts/someip:9042] Operation timed out))
    at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:270)
    at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:109)
    at com.datastax.driver.core.Cluster$Manager.negotiateProtocolVersionAndConnect(Cluster.java:1813)
    at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1726)
    at com.datastax.driver.core.Cluster.init(Cluster.java:214)
    at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:387)
    at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:366)
    at com.datastax.driver.core.Cluster.connect(Cluster.java:311)
    at org.apache.cassandra.utils.NativeSSTableLoaderClient.init(NativeSSTableLoaderClient.java:70)
    ... 3 more
Exception in thread "main" org.apache.cassandra.tools.BulkLoadException: java.lang.RuntimeException: Unable to initialise org.apache.cassandra.utils.NativeSSTableLoaderClient
    at org.apache.cassandra.tools.BulkLoader.load(BulkLoader.java:104)
    at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:58)

Algumas mensagens selecionadas após definir o nível TRACE em logback-tools.xml:

DEBUG 13:29:19,765 [oneofthehosts/someip:9042] preparing to open 1 new connections, total = 1
DEBUG 13:29:19,915 Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=false] Connection established, initializing transport
TRACE 13:29:19,920 Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=false], stream 0, writing request STARTUP {CQL_VERSION=3.0.0, DRIVER_VERSION=3.11.0, DRIVER_NAME=DataStax Java Driver}
DEBUG 13:29:20,113 [id: 0xef0b330f, L:/someip:44896 - R:oneofthehosts/someip:9042] HANDSHAKEN: TLS_AES_256_GCM_SHA384

waiting for timeout

TRACE 13:29:32,027 Defuncting Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=false]
com.datastax.driver.core.exceptions.OperationTimedOutException: [oneofthehosts/someip:9042] Operation timed out
DEBUG 13:29:32,028 [oneofthehosts/someip:9042] preventing new connections for the next 1000 ms
DEBUG 13:29:32,029 [oneofthehosts/someip:9042] Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=false] failed, remaining = 0
DEBUG 13:29:32,029 Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=true] closing connection
DEBUG 13:29:32,029 Not terminating Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=true]: there are still pending requests
DEBUG 13:29:32,031 Connection[oneofthehosts/someip:9042-1, inFlight=0, closed=true], stream 0, Error writing request STARTUP {CQL_VERSION=3.0.0, DRIVER_VERSION=3.11.0, DRIVER_NAME=DataStax Java Driver}
DEBUG 13:29:32,035 [Control connection] error on oneofthehosts/someip:9042 connection, no more host to try

Isso parece familiar? Poderia estar relacionado ao TLS ou já ultrapassamos a configuração inicial da conexão?

cassandra

1 respostas

  1. Best Answer

    O driver Java incorporado usado por sstableloadernão consegue se conectar ao cluster que leva ao NoHostAvailableException. O subjacente OperationTimedOutExceptionindica que o driver não obteve resposta do servidor.

    Concordo com sua avaliação de que está relacionado ao TLS, por isso recomendo que você valide os detalhes do TLS fornecidos na linha de comando. Certifique-se de usar as credenciais do cluster Cassandra 4.1. Saúde!

    • 0

relate perguntas