我已经成功地建立了一个有7个节点的cassandra集群。但是,我无法让它用于基本查询。
CREATE TABLE lgrsettings (
siteid bigint,
channel int,
name text,
offset float,
scalefactor float,
units text,
PRIMARY KEY (siteid, channel)
)
insert into lgrsettings (siteid,channel,name,offset,scalefactor,units) values (999,1,'Flow',0.0,1.0,'m');
然后在一个节点上:
select * from lgrsettings;
Request did not complete within rpc_timeout.
另一方面:
select * from lgrsettings;
Bad Request: unconfigured columnfamily lgrsettings
即使键空间和列族显示在所有节点上。
你知道我可以从哪里开始找吗?
亚历克斯
有趣的结果。处理键空间创建和插入的节点显示:
Keyspace: testdata
Read Count: 0
Read Latency: NaN ms.
Write Count: 2
Write Latency: 0.304 ms.
Pending Tasks: 0
Column Family: lgrsettings
SSTable count: 0
Space used (live): 0
Space used (total): 0
Number of Keys (estimate): 0
Memtable Columns Count: 10
Memtable Data Size: 129
Memtable Switch Count: 0
Read Count: 0
Read Latency: NaN ms.
Write Count: 2
Write Latency: NaN ms.
Pending Tasks: 0
Bloom Filter False Positives: 0
Bloom Filter False Ratio: 0.00000
Bloom Filter Space Used: 0
Compacted row minimum size: 0
Compacted row maximum size: 0
Compacted row mean size: 0
Column Family: datapoints
SSTable count: 0
Space used (live): 0
Space used (total): 0
Number of Keys (estimate): 0
Memtable Columns Count: 0
Memtable Data Size: 0
Memtable Switch Count: 0
Read Count: 0
Read Latency: NaN ms.
Write Count: 0
Write Latency: NaN ms.
Pending Tasks: 0
Bloom Filter False Positives: 0
Bloom Filter False Ratio: 0.00000
Bloom Filter Space Used: 0
Compacted row minimum size: 0
Compacted row maximum size: 0
Compacted row mean size: 0
其他节点在cfstats中没有,但是在descripe keyspace testdata中显示了它;在cql3客户端中。。。
2条答案
按热度按时间6tqwzwtp1#
请求未在rpc\u超时内完成
检查您的cassandra日志以确认是否存在任何问题-有时cassandra中的异常会导致客户端超时。
xyhw6mcr2#
op在一篇评论中说,他找到了问题的原因:
我设法解决了这个问题。这是由于节点之间的时间同步,所以我在所有节点上安装了ntpd,等待5分钟,然后再试一次,我有一个工作集群!