cassandra select query failed with code=1300

Viewed 4464

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

0 Answers
Related