N Sujit Kumar created CASSANDRA-15346:
-----------------------------------------
Summary: ReadTimeout: Error from server: code=1200 [Coordinator
node timed out waiting for replica nodes' responses]
Key: CASSANDRA-15346
URL: https://issues.apache.org/jira/browse/CASSANDRA-15346
Project: Cassandra
Issue Type: Bug
Components: CQL/Semantics, CQL/Syntax
Reporter: N Sujit Kumar
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));
{color:#de350b}this table contains nearly billions of records.(huge record
count) {color}
and tried to query like below,
select * from test_table where col_1='value' and col_2='value'; -->
{color:#00875a}getting results{color}
but when we tried like below,
select * from test_table where col_1='value' and col_3='value' allow filtering;
-->{color:#de350b} not getting{color} results
select * from test_table where col_1='value' and col_4='value' allow filtering;
--> {color:#de350b}not getting{color} 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.
{color:#de350b}then result came, but taking very long time with 50 minutes of
execution time.{color}
Can anyone suggest me to solve the "ReadTimeout:" issue without extending the
configuration?
Thanks,
Sujit
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
