question

developer37@gmail.com avatar image
developer37@gmail.com asked Erick Ramirez answered

Why can't I change the replication settings for my Astra keyspace?

My enviroment: myastracluster in Datastax Astra

I am getting this error when I am trying to access keyspace spacecraft via spring:

[s0] Error while computing token map for replication settings {class=org.apache.cassandra.locator.NetworkTopologyStrategy, us-east1=3}: could not achieve replication factor 3 for datacenter us-east1 (found only 2 replicas).

I tried to correct by running csql on Astra:

ALTER KEYSPACE spacecraft WITH REPLICATION = {'class': 'NetworkTopologyStrategy', 'us-east1': '2'};

I am getting the following error. Is there any way I can upgrade my permission Or change the replication level in spacecraft ?

Unauthorized: Error from server: code=2100 [Unauthorized] message="User SUser has no ALTER permission on <keyspace spacecraft> or any of its parents"
astra
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

It seems like you created your database using a different Cassandra user and you are now trying to access the spacecraft keyspace using SUser but you haven't granted it the correct permissions.

You need to manage access for additional users with the CQL GRANT command. For more info, see Creating additional users in Astra.

As an alternative if your DB doesn't contain important data, you can terminate it and launch a new DB. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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