Support Forums : DataStax

DataStax Support Forums » OpsCenter

keyspace deletion error under data-modelling on Opscenter

(5 posts) (2 voices)

Started 1 year ago by
Latest reply from
This topic is resolved

Tags:

Keyspace deletion error

Anonymous
Unregistered

Hi Experts,

I am facing a pop up error while trying to delete a keyspace in cassandra which says:
Error while deleting keyspace: SchemaDisagreementException()

Tried to delete through cql which says:

Attempt #1: Schema versions disagree, (try again later).
Attempt #2: Schema versions disagree, (try again later).
Attempt #3: Schema versions disagree, (try again later).
Attempt #4: Schema versions disagree, (try again later).

schema is simple. I have used Simple strategy with replication factor of 3 in cluster of 8 nodes.

Is there Any specific reason for this to happen? Any help?

Thanks,
Nish

Posted 1 year ago #
nickmbailey
Key Master

This FAQ entry on the cassandra wiki explains what causes schema disagreements and how to resolve them:

http://wiki.apache.org/cassandra/FAQ#schema_disagreement

Posted 1 year ago #
Anonymous
Unregistered

Awesome, thanks Nick! you are quick & very helpful. Much appreciated.

I have one more question:
How can I get the total number of records in column family/table under a given keyspace?

I tried this in cql
SELECT count(*) FROM abc_dimension;

but the value is not correct.

[Nodetool -h localhost cfstats] did not help me neither. Any better ideas?

As a feature request, could you include this feature in the data modelling section of the Opscenter?

Thanks again,
Nish

Posted 1 year ago #
nickmbailey
Key Master

I will make a note of a feature request for row counts in OpsCenter. I've responded to the original question here:

http://www.datastax.com/support-forums/topic/how-to-read-the-total-count-of-records-in-column-family

Posted 1 year ago #
Anonymous
Unregistered

Thanks Nick, Hopefully all our feature requests will be heard.

Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.