Re: truncate table in C* 3.11.0

2017-09-07 Thread Cogumelos Maravilha
Now it's working but nothing changed! In the first attempt (I've tried more that 6 times) that I've reported all the nodes were up, snapshot is disable, and I didn't check the sstables files. All the nodes are up and working hard, another table with 15M inserts/hour and 12k/h queries plus the

Re: truncate table in C* 3.11.0

2017-09-07 Thread Carlos Rolo
If you waited less than 60s, no warning/error was issued. Do the following: * Check if all nodes are up (truncate fails if not) * Check if you got a snapshot generated (unless you have auto_snapshot disabled) * Check if you have still the sstables in the directories (you shouldn't) If it didn't

truncate table in C* 3.11.0

2017-09-07 Thread Cogumelos Maravilha
Hi list, Using cqlsh: consistency all; select count(*) table1; 219871 truncate table1; select count(*) table1; 219947 There is a consumer reading data from kafka and inserting in C* but the rate is around 50 inserts/minute. Cheers