cassandra 查询表时显示“ NoHostAvailable:”

最新推荐文章于 2023-05-23 23:14:25 发布

梁坤红 Bill

最新推荐文章于 2023-05-23 23:14:25 发布

阅读量339

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_43436153/article/details/130552175

版权

一、故障表象

故障1：
应用程序向cassandra数据库的platform_log keyspace插入数据时，报如下错误：
Cannot achieve consistency level QUORUM

故障2：
cqlsh 10.47.100.2 9042 登录数据库后执行
use platform_log;
select * from httprequestloginfo;
**报错为：**NoHostAvailable:

二、故障原因

1.通过以下命令查询
[root@occ_rediskafka-02 conf]# /usr/local/apache-cassandra-3.11.3/bin/nodetool status

结果为：
Datacenter: dc1
##===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
– Address Load Tokens Owns Host ID Rack
UN 10.47.100.10 66.38 MiB 256 ? f5f0bf7c-dc01-4a84-a6ca-33ac55f93f4a rack1
UN 10.47.100.9 53.26 MiB 256 ? e8f0ee29-a878-43c5-8465-82f1c0cb2822 rack1
UN 10.47.100.8 66.28 MiB 256 ? 92b4181d-8520-4445-90a5-958cb8be527c rack1
UN 10.47.100.7 3.82 MiB 256 ? 08057bd1-da44-4af3-8c35-b272dc14ce20 rack1
UN 10.47.100.3 4.27 MiB 256 ? 6522b1e5-6683-4855-b1ba-2326cc05685b rack1
UN 10.47.100.2 10.23 MiB 256 ? 8968477d-d6e2-483e-96ea-636985ad294c rack1

Note: Non-system keyspaces don’t have the same replication settings, effective ownership information is meaningless

desc platform_log;

结果为：
CREATE KEYSPACE platform_log WITH replication = {‘class’: ‘NetworkTopologyStrategy’, ‘datacenter1’: ‘3’} AND durable_writes = true;

显示platform_log 采用NetworkTopologyStrategy。DC名为datacenter1。

2.查询配置
cassandra-topology.properties 配置如下：
注：没有配置对应节点的IP。
在这里插入图片描述

三、处理措施

1.修改cassandra-topology.properties配置文件
*# Cassandra Node IP=Data Center:Rack
10.47.100.2=dc1:rack1
10.47.100.3=dc1:rack1
10.47.100.7=dc1:rack1
10.47.100.8=dc1:rack1
10.47.100.9=dc1:rack1
10.47.100.10=dc1:rack1

*# default for unknown nodes
default=dc1:rack1

2.修改platform_log keyspace配置
ALTER KEYSPACE platform_log WITH replication = {‘class’: ‘NetworkTopologyStrategy’, ‘dc1’: ‘3’} AND durable_writes = true;