Cassandra中的RPC超时 [英] RPC Timeout in Cassandra

问题描述

我收到以下错误：

  cqlsh：dev> SELECT DISTINCT id FROM raw_data; 
请求未在rpc_timeout内完成。 
  

这是一个特殊的查询，我永远不会再做，我不在乎多长时间（我不再更改我的模式）。

我如何增加 rpc_timeout for this one query？

我已尝试添加 LIMIT 9999 和 ALLOW FILTERING ，这没有帮助。我期望在结果中少于1000行。

编辑：结果是，这个特定的命令成功后，我运行 nodetool compact ，但是对于一个查询暂时增加 rpc_timeout 的一般情况，我更感兴趣。

解决方案

增加cassandra.yaml文件/ cassandra / conf下的读取请求时间

  read_request_timeout_in_ms：30000 
  

更改此重新启动服务器并执行您的查询，可能是您的问题已解决。

I get the following error:

cqlsh:dev> SELECT DISTINCT id FROM raw_data;
Request did not complete within rpc_timeout.

This is a special query that I'll never make again, I don't care how long it takes, and I don't want to change my schema (since I'll never make the query again...).

How can I increase rpc_timeout for this one query?

I have tried adding LIMIT 9999 and ALLOW FILTERING, and it doesn't help. I expect less than 1000 rows in the result. The query works on another Cassandra cluster with half as much data.

Edit: as it turns out, this particular command succeeded after I ran nodetool compact, but what I'm more interested in the general case of temporarily increasing rpc_timeout for one query.

解决方案

increase the read request time in cassandra.yaml file under /cassandra/conf

read_request_timeout_in_ms: 30000

change this restart server and execute your query, might be your problem get resolved.

这篇关于Cassandra中的RPC超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！