I have a Cassandra cluster of 4 nodes with replication factor of 3, we have about 400M records on table1 and after restarting the cluster I got the following error when selecting from the table
ReadFailure: Error from server: code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}
We tried these queries on cqlsh
select id from table1; ----> Failed
select id from table1 limit 10; -----> Failed
select id from table1 limit 1; ----> Succeed
select id form table1 where id=22; ----> Succeed
select id from othertable; ----> Succeed
And the schema for the table is:
CREATE TABLE ks.table1 (
id int,
name text,
PRIMARY KEY (id))
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.LeveledCompactionStrategy' }
AND compression = { 'chunk_length_in_kb' : 64, 'class' : 'org.apache.cassandra.io.compress.LZ4Compressor' }
AND default_time_to_live = 0
AND speculative_retry = '99PERCENTILE'
AND min_index_interval = 128
AND max_index_interval = 2048
AND crc_check_chance = 1.0;
How can I trace the error and specify the problem?
We are using Cassandra 3.0.8.1293