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

jonasmartinpico_114991 avatar image
jonasmartinpico_114991 asked Erick Ramirez answered

How can we remove tombstones from system_auth.role_permissions?

Hi guys!

We have some app that has generated more than 100000 tombstones in the role_permissions table. WE have checked the gc_grace_seconds of that table, and we were so suprised to see that is 90 days by default. we tried to reduce that gc_grace_seconds to a low number in order to reomve the tombstones, but it seems that is impossible to alter that .. (our superuser has all kind of actions granted).

How could we remove the tombstones on this table? is it possible to reduce the gc_grace_seconds?

Regards!

authorization
10 |1000 characters needed characters left characters exceeded
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

You didn't specify which version you're running but I assume that you are referring submitting lots of Spark apps, it indicates that you're running an older version of DSE.

This is a known issue that was fixed in DSE 6.0.10 and 6.7.5 (DSP-19393). There is a temporary workaround available that involves granting the Spark app user privileges before submitting apps (DSP-19098).

If you log a ticket with DataStax Support, one our engineers will be able to assist you with manually clearing the tombstones in the system_auth.role_permissions table. Cheers!

Share
10 |1000 characters needed characters left characters exceeded
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.