Anyone experienced backup and restore database actions with cassandra with time set to the past between backup and restore?
I tried this:
- backup a keyspace via nodetool snapshot
- export keyspace schema to file
- drop keyspace from db
- set time to the past, e.g. 2 hours
- import schema from point 2. As a result I get inconsistencies in db: desc keyspace shows the keyspace as being available but running *select * from my_keyspace.my_table * gives error that keyspace does not exist. I know cassandra is sensitive in terms of time change, however I have a k8s cluster with cassandra db pod and my app pod in which it is required to allow the user possibility to change the system time. Thanks