Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

dnguyen_175352 avatar image
dnguyen_175352 asked ·

Cassandra timeout during SIMPLE write query at consistency ONE

Hi everyone,

I'm using DataStax Studio to learn about CQL. Everything works fine until I start writing data to the table.

It show an error:

An error occurred on line 3: 
Cassandra timeout during SIMPLE write query at consistency ONE (1 replica were required but only 0 acknowledged the write)
(Hint: Ctrl-L to toggle line numbers.)


Not sure what happened. Any idea? Thanks,

cqldatastax community
1562332325504.png (290.8 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

csplinter avatar image
csplinter answered ·

Timeouts in general could occur for a number of reasons but here are some things to check.


1. Make sure that the DSE server instance is up and running.

2. Make sure that the videodb keyspace replication is correct ( this can be done by using "DESCRIBE keyspace videodb" in a Studio cell ). If you used the existing cell in that notebook for keyspace creation this shouldn't be a problem because it uses SimpleStrategy. But if you changed the replication to NetworkTopologyStrategy, make sure your datacenter name is correct there.

3. Look at the system.log ( in /var/log/cassandra by default ) for DSE and there should be more information there on other issues that may be causing the timeout.

4 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Thanks @csplinter,

This is from the debug.log. Looks like Spark Master not ready.

I follow this instruction in order to start with Cassandra and Docker. Something is not right.

logs.txt

0 Likes 0 · ·
logs.txt (2.5 KiB)

@dnguyen_175352 thanks for being on DataStax Community. A friendly note that this post is not an answer so please change it to a comment to csplinter's answer. This is so other users don't mistake it for an answer in the future. Cheers!

0 Likes 0 · ·

Hi @Erick Ramirez, when I convert it to a comment, there is a limit. How can I bypass it? Thanks,

0 Likes 0 · ·
1563539873738.png (7.4 KiB)
Show more comments