Re: LWT and non-LWT mixed

2017-10-10 Thread Anuj Wadehra
Hi Daniel, What is the RF and CL for Delete?Are you using asynchronous writes?Are you firing both statements from same node sequentially?Are you firing these queries in a loop such that more than one delete and LWT is fired for same partition? I think if you have the same client executing both

Re: LWT and non-LWT mixed

2017-10-10 Thread Javier Canillas
Daniel, Cassandra is "eventually consistent". This means that the DELETE can go to a different coordinator than the INSERT... IF NOT EXISTS. Being so, each coordinator enters a race condition than can make the INSERT...IF NOT EXISTS failed reading data that the DELETE will destroy. Even on the

LWT and non-LWT mixed

2017-10-10 Thread Daniel Woo
The document explains you cannot mix them http://docs.datastax.com/en/archived/cassandra/2.2/cassandra/dml/dmlLtwtTransactions.html But what happens under the hood if I do? e.g, DELETE INSERT ... IF NOT EXISTS The coordinator has 4 steps to do the second statement (INSERT) 1.