question

dnguyen_175352 avatar image
dnguyen_175352 asked Erick Ramirez edited

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,

cql
1562332325504.png (290.8 KiB)
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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 dnguyen_175352 commented

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

dnguyen_175352 avatar image dnguyen_175352 commented ·

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)
Erick Ramirez avatar image Erick Ramirez ♦♦ dnguyen_175352 commented ·

@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 ·
dnguyen_175352 avatar image dnguyen_175352 Erick Ramirez ♦♦ commented ·

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