首页 文章

Cassandra:2.2.8:org.apache.cassandra.exceptions.ReadTimeoutException:操作超时 - 仅收到0个响应

提问于
浏览
0

我遇到了节点崩溃,其中system.logfile显示了一堆“ReadTimeoutException”达到500ms .

cassandra.yaml文件的设置为[read_request_timeout_in_ms:10000]

请问大家请分享我如何解决这些超时问题!提前致谢!

错误堆栈:

错误[SharedPool-Worker-241] 2017-02-01 13:18:27,663 Message.java:611 - 请求期间发生意外异常; channel = [id:0x5d8abf33,/ 172.18.30.62:47575 => /216.12.225.9:9042] java.lang.RuntimeException:org.apache.cassandra.exceptions.ReadTimeoutException:操作超时 - 仅收到0个响应 . 在org.apache.cassandra.auth.CassandraRoleManager.getRole(CassandraRoleManager.java:497)〜[apache-cassandra-2.2.8.jar:2.2.8] org.apache.cassandra.auth.CassandraRoleManager.canLogin(CassandraRoleManager . java:306)〜[apache-cassandra-2.2.8.jar:2.2.8]在org.apache.cassandra.service.ClientState.login(ClientState.java:269)〜[apache-cassandra-2.2.8.jar :2.2.8] org.apache.cassandra.transport.messages.AuthResponse.execute(AuthResponse.java:79)〜[apache-cassandra-2.2.8.jar:2.2.8] org.apache.cassandra.transport .Message $ Dispatcher.channelRead0(Message.java:507)[apache-cassandra-2.2.8.jar:2.2.8] at org.apache.cassandra.transport.Message $ Dispatcher.channelRead0(Message.java:401)[ apache-cassandra-2.2.8.jar:2.2.8] at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)[netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)[netty-all-4.0.23.Final.jar:4.0.2 3.Final] at io.netty.channel.AbstractChannelHandlerContext.access $ 700(AbstractChannelHandlerContext.java:32)[netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext $ 8 .run(AbstractChannelHandlerContext.java:324)java.util.concurrent.Executors中的[netty-all-4.0.23.Final.jar:4.0.23.Final] $ RunnableAdapter.call(Executors.java:511)[na: 1.8.0_111] org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService $ FutureTask.run(AbstractLocalAwareExecutorService.java:164)[apache-cassandra-2.2.8.jar:2.2.8] at org.apache.cassandra.concurrent.SEPWorker .run(SEPWorker.java:105)[apache-cassandra-2.2.8.jar:2.2.8] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_111]引起:org .apache.cassandra.exceptions.ReadTimeoutException:操作超时 - 仅收到0个响应 . 在Org.apache.cassandra.service.ReadCallback.get(ReadCallback.java:110)〜[apache-cassandra-2.2.8.jar:2.2.8] org.apache.cassandra.service.AbstractReadExecutor.get(AbstractReadExecutor . 在org.apache.cassandra.service.StorageProxy.fetchRows(StorageProxy.java:1441)〜[apache-cassandra-2.2.8.jar :2.2.8] org.apache.cassandra.service.StorageProxy.readRegular(StorageProxy.java:1365)〜[apache-cassandra-2.2.8.jar:2.2.8] at org.apache.cassandra.service.StorageProxy .read(StorageProxy.java:1282)〜[apache-cassandra-2.2.8.jar:2.2.8]在org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:224)〜[apache- cassandra-2.2.8.jar:2.2.8]在org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:176)〜[apache-cassandra-2.2.8.jar:2.2.8] at at org.apache.cassandra.auth.CassandraRoleManager.getRoleFromTable(CassandraRoleManager.java:505)〜[apache-cassandra-2.2.8.jar:2.2.8] at org.apache.cassandra.auth.CassandraRo leManager.getRole(CassandraRoleManager.java:493)〜[apache-cassandra-2.2.8.jar:2.2.8] ...省略了13个常用帧

INFO [ScheduledTasks:1] 2017-02-01 13:18:27,682 MessagingService.java:946 - 在最后5000毫秒内删除了READ消息:内部超时为149,跨节点超时为0 INFO [服务线程] 2017-02- 01 13:18:27,693 StatusLogger.java:106 - enterprise.t_sf_venue_test 0,0 INFO [ScheduledTasks:1] 2017-02-01 13:18:27,699 MessagingService.java:946 - REQUEST_RESPONSE消息在最后5000毫秒内删除:7内部超时和0表示跨节点超时INFO [服务主题] 2017-02-01 13:18:27,699 StatusLogger.java:106 - enterprise.alestnstats 0,0 INFO [ScheduledTasks:1] 2017-02-01 13:18 :27,699 MessagingService.java:946 - RANGE_SLICE消息在最后5000毫秒内被删除:内部超时为116,跨节点超时为0

1 回答

  • 1

    正如您在日志中看到的那样,实际上失败的查询不是您尝试的查询执行 .

    failing query是cassandra的内部:

    “SELECT * FROM system_auth.roles;”

    这些内部cassandra查询(misc查询)不使用'read_request_timeout_in_ms' . 相反,它使用'request_timeout_in_ms' .

相关问题