Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

Shannu avatar image
Shannu asked Erick Ramirez edited

Cannot recreate keyspace after dropping it

For some reasons we had to drop a keyspace and create it again. After dropping when we are trying to create it again, we are facing an issue that keyspace already exits.

I checked in the schema and tables columnfamilies as well, it is not there. Still it is not allowing us create the new one

schema
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

aploetz avatar image
aploetz answered Erick Ramirez edited

Can you try running

nodetool describecluster

on a few of the nodes?

If you see multiple schema versions, then the DROP didn't fully take. To resolve, run a rolling bounce of the cluster or just the nodes which see multiple schema versions.

1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Thanks @aploetz @divyanshu.imsec_154140 for your answers. This is resolved by rolling bounce followed by full repairs on system keyspaces

1 Like 1 ·
divyanshu.imsec_154140 avatar image
divyanshu.imsec_154140 answered

sometime gossiping takes time to scatter any metadata across all cluster nodes . Hold-on for 10 - 15 min . keep lag (10 min - 20 min ) between two structural change statements .
If issue not resolved , rolling restart is the guided path .



Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.