[CASSANDRA-15346] ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses]

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem
• Component/s: CQL/Semantics, CQL/Syntax
• Platform: All
• Assignee: Unassigned
• Reporter: N Sujit Kumar
• Created: 07/Oct/19 12:22
• Updated: 28/Apr/21 19:45
• Resolved: 28/Apr/21 19:45

Description

Hi,

We have created table with below schema:

create table test_table(col_1 text, col_2 text, col_3 text, col_4 text, col_5 text, col_6 text, col_7 text, PRIMARY KEY (col_1, col_2, col_3, col_4, col_5));

this table contains nearly billions of records.(huge record count)  

and tried to query like below,

select * from test_table where col_1='value' and col_2='value'; --> getting results

but when we tried like below,

select * from test_table where col_1='value' and col_3='value' allow filtering; --> not getting results

select * from test_table where col_1='value' and col_4='value' allow filtering; --> not getting results

we are getting below error:

"ReadTimeout: Error from server: code=1200 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'}"

After i got above error, i have extended the timeout parameters from 5 seconds to 60 minutes in cassandra.yaml configuration file. 

then result came, but taking very long time with 50 minutes of execution time.

Can anyone suggest me to solve the "ReadTimeout:" issue without extending the configuration?

Thanks,

Sujit