Coordinator node timed out waiting for replica nodes in Cassandra Datastax while insert data

cassandra cql datastax-enterprise
karthi picture karthi · Jun 1, 2015 · Viewed 15.5k times · Source

When I try to Insert data in Cassandra using the below query I am getting the below mentioned error 

cqlsh:assign> insert into tblFiles1(rec_no,clientid,contenttype,datafiles,filename) values(1,2,'gd','dgfsdg','aww');

WriteTimeout: code=1100 [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'}

My Version of Cassandra and DSE: [cqlsh 5.0.1 | Cassandra 2.1.5.469 | DSE 4.7.0 | CQL spec 3.2.0 | Native protoco l v3]

Answer

Rajesh picture Rajesh · Jun 5, 2015

Increase the write_request_timeout_in_ms Timeout in the Cassandra Config file (cassandra.yaml) as

write_request_timeout_in_ms: 20000

and restart your Server

Related questions

Results pagination in Cassandra (CQL)

I am wondering how can I achieve pagination using Cassandra. Let us say that I have a blog. The blog lists max 10 posts per page. To access next posts a user must click on pagination menu to access page 2 (posts 11…

Read More
Get current date in cassandra cql select

In SQL, I am able to do: select getdate(), getdate() - 7 Which returns the current date as well as current date - 7 days. I want to achieve the same in Cassandra CQL. I tried: select dateof(now()) But that does …

Read More
Cassandra Allow filtering

I have a table as below CREATE TABLE test ( day int, id varchar, start int, action varchar, PRIMARY KEY((day),start,id) ); I want to run this query Select * from test where day=1 and start > 1475485412 and start < 1485785654 and …

Read More