I'm having issues when I'm restoring the snapshot from a tables,
I create a table tab1 with 5 rows on my node 3 Took the snapshot Truncate the table tab1 Stopped cassandra Deleted all commitlogs Deleted the file inside the /data/keyspace/table_name/ Copied the file from the snapshot to /data/keyspace/table_name/ Started cassandra Ran nodetool repair keyspace_name
[cqlsh 6.8.0 | DSE 6.8.0 | CQL spec 3.4.5 | DSE protocol v2] Use HELP for help. cqlsh> CONSISTENCY; Current consistency level is ONE. cqlsh>
nodetool clearsnapshot --all cqlsh 10.*.*.3 -u cassandra -p cassandra -e 'DESC SCHEMA;' > /backups/snapshots/schema_filename.cql nodetool ring > /backups/snapshots/token_range_filename nodetool snapshot -t snapshot_backup_n3_t find /cassandra/ -path */snapshots/snapshot_backup_n3_t/* -type f >> "/backups/snapshots/backup_file_listing" /usr/bin/nice -10 /bin/tar -pzcvf /backups/snapshots/backup_snapshot_node3_$(date +%F).tar --files-from=/backups/snapshots/backup_file_listing
tbs1, before I take the snapshot.
(Some rows were deleted and inserted before the snapshot was taken and the keyspace was repaired, to simulate an usual prod situation)
name | solr_query -------+------------ test7 | null test3 | null test1 | null test9 | null test5 | null
after restore the snapshot
name | solr_query -------+------------ test7 | null test3 | null test1 | null
Sometimes I tried the same process I had all the 5 rows other only 3 rows. What could be the issue?