我刚刚使用jdk 19升级到Sping Boot 2.7，并决定使用在docker中运行的Cassandra bitnami 3进行测试“Junit-5”，我得到的错误是No node was available to execute the query，而且每次都发生在相同的测试用例中。

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

这是我用来连接的代码

var loader = DriverConfigLoader.programmaticBuilder()
        .withDuration(DefaultDriverOption.REQUEST_TIMEOUT, Duration.ofMinutes(1))
        .withString(DefaultDriverOption.LOAD_BALANCING_POLICY_CLASS,
                DcInferringLoadBalancingPolicy.class.getName())
        .build();

if (session == null || session.isClosed()) {
  var host = System.getenv("CASSANDRA_HOST") == null ? "localhost" : System.getenv("CASSANDRA_HOST");
  var username = "localhost".equals(host)? "": "cassandra";
  var password = "localhost".equals(host)? "": "cassandra";

  LOG.info("Cassandra host '{}'.", host);
  LOG.info("Cassandra username '{}'.", username);
  LOG.info("Cassandra password '{}'.", password);

  var sessionBuilder = new CqlSessionBuilder()
          .addContactPoint(new InetSocketAddress(host, 9042))
          .withLocalDatacenter("datacenter1")
          .withConfigLoader(loader);

  if (!username.isEmpty()) {
    sessionBuilder.withAuthCredentials(username, password);
  }

  session = sessionBuilder.build();

同样重要的是要提到，我有很多170多个测试用例分布在不同的文件中，并且在每次执行文件时，我都尝试使用此代码再次清理和填充DB

session.execute("create keyspace if not exists \"schema_x\" WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 1};");

  for (final String stmt : getCassaandraStatementsFromFile(CASSANDRA_SCHEMA_FILE)) {
    session.execute(stmt);
    LOG.info("Cassandra. Executed statement: '{}'.", stmt.replaceAll("\n", ""));
  }

并且错误恰好发生在创建keyspace行上，我尝试从我这边进行一些调整

• 调整连接加载器并使用节流，但没有任何帮助
• 我还检查了docker本身内部的本地数据中心值，并与我的值相匹配。

最后，完整的错误堆栈跟踪（如果需要）

org.springframework.data.cassandra.CassandraConnectionFailureException: \
  Query; CQL [com.datastax.oss.driver.internal.core.cql.DefaultSimpleStatement@65b70f9e]; \
  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
    at org.springframework.data.cassandra.core.cql.CassandraExceptionTranslator.translate(CassandraExceptionTranslator.java:137)
    at org.springframework.data.cassandra.core.cql.CassandraAccessor.translate(CassandraAccessor.java:422)
    at org.springframework.data.cassandra.core.cql.CqlTemplate.translateException(CqlTemplate.java:764)
    at org.springframework.data.cassandra.core.cql.CqlTemplate.query(CqlTemplate.java:300)
    at org.springframework.data.cassandra.core.cql.CqlTemplate.query(CqlTemplate.java:320)
    at org.springframework.data.cassandra.core.CassandraTemplate.select(CassandraTemplate.java:337)
    at org.springframework.data.cassandra.repository.query.CassandraQueryExecution$CollectionExecution.execute(CassandraQueryExecution.java:136)
    at 
    ...
Caused by: com.datastax.oss.driver.api.core.NoNodeAvailableException: \
No node was available to execute the query
    at com.datastax.oss.driver.api.core.NoNodeAvailableException.copy(NoNodeAvailableException.java:40)
    at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149)
    at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:53)
    at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:30)
    at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230)
    at com.datastax.oss.driver.api.core.cql.SyncCqlSession.execute(SyncCqlSession.java:54)
    at org.springframework.data.cassandra.core.cql.CqlTemplate.query(CqlTemplate.java:298)
    ... 39 common frames omitted

我将感谢您对此的支持，并提前表示感谢