Cassandra在一致性为1的读取查询期间超时

Question

select * from

select count(*) from

select count(*) from

有人知道我做错了什么吗？

CREATE TABLE test.log (
    day text,
    date timestamp,
    ip text,
    iid int,
    request text,
    src text,
    tid int,
    txt text,
    PRIMARY KEY (day, date, ip)
) WITH read_repair_chance = 0.0
   AND dclocal_read_repair_chance = 0.1
   AND gc_grace_seconds = 864000
   AND bloom_filter_fp_chance = 0.01
   AND caching = { 'keys' : 'ALL', 'rows_per_partition' : 'NONE' }
   AND comment = ''
   AND compaction = { 'class' : 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy' }
   AND compression = { 'sstable_compression' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
   AND default_time_to_live = 0
   AND speculative_retry = '99.0PERCENTILE'
   AND min_index_interval = 128
   AND max_index_interval = 2048;

Answer 1

该错误消息表示读操作有问题。很可能是读取超时。您可能需要更新您的cassandra.yaml，使用更大的读取超时时间，如本SO答案所述。

例如200秒：

read_request_timeout_in_ms: 200000

如果更新不起作用，您可能需要调整Cassandra的JVM设置。有关更多信息，请参见DataStax的“优化Java操作”