我尝试连接app和aws cassandra,但我有一个异常“没有节点可用来执行查询”。我正在尝试使用java、Spring数据和来自aws的示例。我绝对知道我与这个数据库有联系,但我不知道它是如何工作的,我想指出的是,我已经创建了一个keyspace。什么东西工作不正常?如何检查节点?这有点奇怪。我甚至不知道如何解决这个问题,而且我在这方面的知识也很少。我甚至会问我需要如何检查以及需要检查什么。这是我的配置文件。
@Configuration
public class CassandraConfig {
private final String username = "...";
private final String password = ".";
File driverConfig = new File(System.getProperty("user.dir")+"/application.conf");
@Primary
@Bean
public CqlSession session() throws NoSuchAlgorithmException {
return CqlSession.builder().
withConfigLoader(DriverConfigLoader.fromFile(driverConfig)).
withAuthCredentials(username, password).
withSslContext(SSLContext.getDefault()).
withKeyspace("my_keyspace").
build();
}
}
还有另一个
datastax-java-driver {
basic {
load-balancing-policy {
local-datacenter = us-east-1
}
contact-points = ["cassandra.us-east-2.amazonaws.com:9142"]
request {
page-size = 3500
timeout = 40 seconds
consistency = LOCAL_QUORUM
}
}
advanced {
control-connection {
timeout = 40 seconds
}
connection {
connect-timeout = 40 seconds
init-query-timeout = 40 seconds
}
auth-provider {
class = PlainTextAuthProvider
}
ssl-engine-factory {
class = DefaultSslEngineFactory
}
metadata {
token-map.enabled = false
schema.enabled = true
}
}
}
和异常
CassandraConnectionFailureException: Query; CQL [CREATE TABLE ............ WITH CLUSTERING ORDER BY (created DESC);]; No node was available to execute the query; nested exception is com.datastax.oss.driver.api.core.NoNodeAvailableException: No node was available to execute the query
发布于 2021-12-02 19:59:11
local-datacenter = us-east-1。都是我的错。
https://stackoverflow.com/questions/70205478
复制相似问题