Cassandra: Cannot truncate table

cassandra cassandra-2.0 cqlsh
Vinod Patel picture Vinod Patel · Jul 29, 2015 · Viewed 7.1k times · Source

I have a table named buddyme.chatarch.

When trying to truncate the table.

cqlsh:buddyme> TRUNCATE chatarch;

I am getting this error.

TruncateError: <ErrorMessage code=1003 [Error during truncate] message="Error during truncate: Cannot achieve consistency level ALL">

What can be the possible reason? I am new to Cassandra.

Thanks

Answer

user5122182 picture user5122182 · Jul 30, 2015

Even I was facing the same issue. One of the nodes in my cluster was down. Fixed the issue by starting all nodes.

Related questions

Executing CQL through Shell Script?

I am trying to execute the CQL commands from shell script. I am able to connect to the cqlsh (CQL version i'm using is 1.1.18) but unable to send the queries to cql. Any ideas or suggestion how to proceed on …

Read More
How to list column families in keyspace?

How can I get list of all column families in keyspace in Cassandra using CQL 3?

Read More
Trying to login to cassandra's console (cqlsh) and it rejects me

I was trying to set up the user authentication for cassandra when I had the following problem. First I have updated the cassandra.yaml with: authenticator: PasswordAuthenticator then created the system_auth keyspace with a replication_factor of 3 as: CREATE …

Read More