Cassandra：NoHostAvailableException：尝试查询的所有主机均失败 [英] Cassandra :NoHostAvailableException: All host(s) tried for query failed

问题描述

我将数据从SimpleStrategy Cassandra的数据库复制到另一个数据库。它们具有相同的密匙空间结构。但是，当我运行命令sstableloader--nodes时，出现以下错误。有人知道如何解决此错误吗？

卡桑德拉版本：3.11.10

命令行：# sstableloader --nodes 127.0.0.0 /var/lib/cassandra/loadme/keyspace/table01-5eef6110d04111ebb620bd376a9dc9e9/snapshots/dropped-1624306636002-table01

堆栈跟踪错误：

All host(s) tried for query failed (tried: /127.0.0.0:9042 (com.datastax.driver.core.exceptions.TransportException: [/127.0.0.0] Cannot connect))
com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.0:9042 (com.datastax.driver.core.exceptions.TransportException: [/127.0.0.0] Cannot connect))
        at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:233)
        at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:79)
        at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1424)
        at com.datastax.driver.core.Cluster.init(Cluster.java:163)
        at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:334)
        at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:309)
        at com.datastax.driver.core.Cluster.connect(Cluster.java:251)
        at org.apache.cassandra.utils.NativeSSTableLoaderClient.init(NativeSSTableLoaderClient.java:73)
        at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:159)
        at org.apache.cassandra.tools.BulkLoader.load(BulkLoader.java:80)
        at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:48)
Exception in thread "main" org.apache.cassandra.tools.BulkLoadException: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.0:9042 (com.datastax.driver.core.exceptions.TransportException: [/127.0.0.0] Cannot connect))
        at org.apache.cassandra.tools.BulkLoader.load(BulkLoader.java:93)
        at org.apache.cassandra.tools.BulkLoader.main(BulkLoader.java:48)
Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /127.0.0.0:9042 (com.datastax.driver.core.exceptions.TransportException: [/127.0.0.0] Cannot connect))
        at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:233)
        at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:79)
        at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1424)
        at com.datastax.driver.core.Cluster.init(Cluster.java:163)
        at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:334)
        at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:309)
        at com.datastax.driver.core.Cluster.connect(Cluster.java:251)
        at org.apache.cassandra.utils.NativeSSTableLoaderClient.init(NativeSSTableLoaderClient.java:73)
        at org.apache.cassandra.io.sstable.SSTableLoader.stream(SSTableLoader.java:159)
        at org.apache.cassandra.tools.BulkLoader.load(BulkLoader.java:80)
        ... 1 more

推荐答案

您在命令行中传递的是--nodes 127.0.0.0，但在netstat输出端口9042(本地传输)中正在侦听127.0.0.1。尝试将命令行更改为--nodes 127.0.0.1

当您收到错误All host(s) tried for query failed并且nodeTool指示您的群集已启动并运行时，请始终确保将正确的端口绑定到您的IP或本地主机。

这篇关于Cassandra：NoHostAvailableException：尝试查询的所有主机均失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！