Transaction failed because of timeout, retry failed because of the first try actually succeeded.

Hi everyone, I recently encountered a problem wrt light weight transaction. My query is to insert a row to a table if the row doesn't exist. It goes like this: Insert Into mytable (key, col1, col2) Value("key1", 1, 2) If Not Exist My case is the driver somehow gets time out from waiting for coor

Re: Too many keyspaces causes cql connection to time out ?

ed by the big > STW pauses you're observing in Cassandra's logs. > > On Tue, May 24, 2016 at 11:04 AM Justin Lin > wrote: > >> We are exploring cassandra's limit by creating a lot of keyspaces with >> moderate number of column families (roughly 40 - 50) pe

Too many keyspaces causes cql connection to time out ?

We are exploring cassandra's limit by creating a lot of keyspaces with moderate number of column families (roughly 40 - 50) per keyspace and we have a problem after we reach certain amount of keyspaces, that cqlsh starts to time out when connecting to cassandra. This is our cassandra setup. We hav