You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Cogumelos Maravilha <co...@sapo.pt> on 2017/09/07 09:07:19 UTC
truncate table in C* 3.11.0
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
For additional commands, e-mail: user-help@cassandra.apache.org
Re: truncate table in C* 3.11.0
Posted by Cogumelos Maravilha <co...@sapo.pt>.
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 <ma...@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
> <ma...@cassandra.apache.org>
> For additional commands, e-mail: user-help@cassandra.apache.org
> <ma...@cassandra.apache.org>
>
>
>
> --
>
>
>
Re: truncate table in C* 3.11.0
Posted by Carlos Rolo <ro...@pythian.com>.
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
On Thu, Sep 7, 2017 at 10:07 AM, Cogumelos Maravilha <
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
> For additional commands, e-mail: user-help@cassandra.apache.org
>
>
--
--