如何修复cassandra服务器中未配置的表systemlog？

g6ll5ycj  于 2021-06-13  发布在  ElasticSearch
关注(0)|答案(1)|浏览(338)

我在cassandra和elastic search上有一个janusgraph集群。我使用spring（如果它很重要的话）和cassandra驱动程序版本3.6.0。但是我不能用数据填充服务器。有一个错误：

Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: cassandra.xxx.xxxx.xx/xx.x.xx.xxx:9042 (com.datastax.driver.core.exceptions.DriverException: Error preparing query, got ERROR INVALID: unconfigured table systemlog))
    at com.datastax.driver.core.RequestHandler.reportNoMoreHosts(RequestHandler.java:265) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.RequestHandler.access$1200(RequestHandler.java:62) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution.findNextHostAndQuery(RequestHandler.java:357) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution.retry(RequestHandler.java:539) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution.access$2300(RequestHandler.java:307) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.RequestHandler$SpeculativeExecution$2.onSet(RequestHandler.java:863) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1233) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1151) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287) ~[netty-handler-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) ~[netty-codec-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:328) ~[netty-codec-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:302) ~[netty-codec-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:93) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at com.datastax.driver.core.InboundTrafficMeter.channelRead(InboundTrafficMeter.java:38) ~[cassandra-driver-core-3.6.0.jar!/:na]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:352) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1421) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:374) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:360) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:930) ~[netty-transport-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:794) ~[netty-all-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:424) ~[netty-all-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:326) ~[netty-all-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:918) ~[netty-common-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[netty-common-4.1.39.Final.jar!/:4.1.39.Final]
    at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) ~[netty-common-4.1.39.Final.jar!/:4.1.39.Final]
    ... 1 common frames omitted

我在cassandra中手动安装了keyspace和table。但错误并没有消失。如何修复此错误？

JavaspringcassandraelasticsearchJanusGraph

1条答案

按热度按时间
qcbq4gxm

qcbq4gxm1#

这个错误的重要一点是 NoHostAvailableException :

Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: \
  All host(s) tried for query failed ( \
    tried: cassandra.xxx.xxxx.xx/xx.x.xx.xxx:9042 ( \
      com.datastax.driver.core.exceptions.DriverException: \
      Error preparing query, got ERROR INVALID: unconfigured table systemlog \
    ) \
  )

司机抛出一个 NoHostAvailableException 在它尝试了查询计划中的每一个主机并用完了要尝试的主机之后。这可能是您得到“未配置表”的原因的线索。
当一个查询被发送到一个没有收到模式更改的节点时，该节点返回 unconfigured table <table_name . 最可能的原因是您有一个需要首先解决的模式分歧。
如果节点在进行架构更改时没有响应，那么这些节点将不会收到架构更改，因此它们的架构版本将与集群的其他节点不同。解决这个问题的最简单方法是在有问题的节点上重新启动cassandra。干杯！

赞(0）分享  回复(0）举报  2021-06-14
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com