cassandra 读取逾时:来自服务器的错误:code=1200 [协调器节点等待副本节点时超时

pw136qt2  于 2022-11-05  发布在  Cassandra
关注(0)|答案(1)|浏览(144)

我收到以下错误,

ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}

版本详细信息,[cqlsh 5.0.1| cassandra 3.11.4| CQL质量标准3.4.4|本机协议v4]

cqlsh:infinito> select count(id) from list_subscriber;

该表仅包含10条记录,且主键位于“Id”列上,仅具有int类型。
我正在尝试增加一些超时参数(request_timeout_in_ms:),但没有成功
任何帮助都是感激不尽的。

nukf8bse

nukf8bse1#

我最后做了低于期权,使低于期权的价值增加了10倍。
编辑/etc/cassandra/cassandra.yaml文件

sudo nano /etc/cassandra/cassandra.yaml

# How long the coordinator should wait for read operations to complete

read_request_timeout_in_ms: 50000

# How long the coordinator should wait for seq or index scans to complete

range_request_timeout_in_ms: 100000

# How long the coordinator should wait for writes to complete

write_request_timeout_in_ms: 20000

# How long the coordinator should wait for counter writes to complete

counter_write_request_timeout_in_ms: 50000

# How long a coordinator should continue to retry a CAS operation

# that contends with other proposals for the same row

cas_contention_timeout_in_ms: 10000

# How long the coordinator should wait for truncates to complete

# (This can be much longer, because unless auto_snapshot is disabled

# we need to flush first so we can snapshot before removing the data.)

truncate_request_timeout_in_ms: 600000

# The default timeout for other, miscellaneous operations

request_timeout_in_ms: 100000

# How long before a node logs slow queries. Select queries that take longer than

# this timeout to execute, will generate an aggregated log message, so that slow queries

# can be identified. Set this value to zero to disable slow query logging.

slow_query_log_timeout_in_ms: 5000

然后打开终端并执行以下命令

cqlsh --request-timeout=6000

一切看起来都很好。

相关问题