Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-15346

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Triage Needed
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: CQL/Semantics, CQL/Syntax
    • Labels:
      None
    • Platform:
      All
    • Impacts:
      None

      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

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Sujit1988 N Sujit Kumar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: