Since you have only one node, sstableloader is unnecessary. Copy/move the the data directory back to the right place and restart Cassandra or run 'nodetool refresh' is sufficient. Do not restore the 'system' keyspace, but do restore the other system keyspaces, such as 'system_auth' and 'system_schema'.

In fact, it comes to my mind that the following is much quicker, simpler and should do the trick anyway:

   1. shutdown Cassandra

   2. backup /var/lib/cassandra (just in case...)

   3. run 'rm -rf
   /var/lib/cassandra/data/system/local-7ad54392bcdd35a684174e047860b377'

   4. change num_tokens

   5. start Cassandra


On 30/07/2021 17:00, Maxim Parkachov wrote:
Thanks for quick answer.

    Do you ever intend to add nodes to this single node cluster? If
    not, I don't see the number of tokens matter at all.

I understand that, I would like to have all environments with the same settings.

    However, if you really want to change it and don't mind downtime,
    you can do this:

        1. make a backup of the data

        2. completely destroy the node with all data in it

        3. create a new node on the same server with the desired
        num_tokens

        4. restore the backup

With 'restore the backup' you mean SSTableLoader ?

Regards,
Maxim.

Reply via email to