在consistency LOCAL_QUORUM上写入查询时Cassandra失败

Question

当我将xml文件写入到Cassandra表列中时，我面对的是exception.Its，一个3节点的集群，所有节点都是up的。

com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed)
    at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80)
    at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
    at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245)
    at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:55)
    at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39)
    at DBConnection.oracle2Cassandra(DBConnection.java:267)
    at DBConnection.main(DBConnection.java:292)
Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed)
    at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91)
    at com.datastax.driver.core.Responses$Error.asException(Responses.java:119)
    at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180)
    at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186)
    at com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44)
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754)
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576)

如果有人能帮我摆脱这种情况，那就太好了。谢谢

Answer 1

然而，我不知道真正的解决方案。

其中一个群集节点var/log/cassandra/system.log文件。我发现一个表的sstable被破坏了。该表在其抛出异常的代码中使用。

对表进行备份。已从节点中删除损坏的数据库文件。Drop表。重新创建表格。

这是我的工作。