cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cogumelos Maravilha <cogumelosmaravi...@sapo.pt>
Subject Re: truncate table in C* 3.11.0
Date Thu, 07 Sep 2017 13:29:16 GMT
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 normal maintenances tasks.

Thanks

On 07-09-2017 11:16, Carlos Rolo wrote:
> 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 happen, open a ticket.
>
> Tested right now on a 3 nodes 3.11.0 cluster and it worked fine. So if
> you can trace the query to provide additional detail, it would help.
>
>
>
>
> Regards,
>
> Carlos Juzarte Rolo
> Cassandra Consultant / Datastax Certified Architect / Cassandra MVP
>  
> Pythian - Love your data
>
> rolo@pythian | Twitter: @cjrolo | Skype: cjr2k3 | Linkedin:
> _linkedin.com/in/carlosjuzarterolo
> <http://linkedin.com/in/carlosjuzarterolo>_
> Mobile: +351 918 918 100
> www.pythian.com <http://www.pythian.com/>
>
> On Thu, Sep 7, 2017 at 10:07 AM, Cogumelos Maravilha
> <cogumelosmaravilha@sapo.pt <mailto:cogumelosmaravilha@sapo.pt>> wrote:
>
>     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
>
>
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
>     <mailto:user-unsubscribe@cassandra.apache.org>
>     For additional commands, e-mail: user-help@cassandra.apache.org
>     <mailto:user-help@cassandra.apache.org>
>
>
>
> --
>
>
>


Mime
View raw message