cassandra—即使是对集群不起作用的简单查询(“请求未在rpc\u超时内完成”)

xoefb8l8  于 2021-06-14  发布在  Cassandra
关注(0)|答案(2)|浏览(329)

我已经成功地建立了一个有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客户端中。。。

6tqwzwtp

6tqwzwtp1#

请求未在rpc\u超时内完成
检查您的cassandra日志以确认是否存在任何问题-有时cassandra中的异常会导致客户端超时。

xyhw6mcr

xyhw6mcr2#

op在一篇评论中说,他找到了问题的原因:
我设法解决了这个问题。这是由于节点之间的时间同步,所以我在所有节点上安装了ntpd,等待5分钟,然后再试一次,我有一个工作集群!

相关问题