[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

restoring with commitlogs in C* 3.11

Hello everyone,

I am testing the procedure of restoring a table using the commitlogs without success.

I am following this doc (even if this is for DSE  )
I am probably missing something. Is there anyone who is using the commitlog to make point in time restoring ?
Is there a procedure to make it works ?

This is my procedure.

1- Add this line to JVM_OPTS="$JVM_OPTS -Dcassandra.replayList=pns_nonreg_bench.cf1"

2- I edit the file /etc/cassandra/ like this

archive_command=/bin/ln %path /disk2/cassandra/commit_log_backup/%name
restore_command=cp -f %from %to

3- I restart all the nodes

4- I made a delete on cassandra and the modify the restore_point_in_time to set it before the delete
restore_point_in_time=2018:07:30 09:54:00 # before the delete

5- then I restart cassandra and I just see in the logs this

INFO  [main] 2018-07-30 10:40:43,652 - Replaying /var/opt/hosting/db/cassandra/commitlog/CommitLog-6-1532697162576.log
INFO  [main] 2018-07-30 10:40:43,705 - Log replay complete, 0 replayed mutations

I did not get the data back, (re write it ).

For infor I made the procedure using snapshots and the replaying the commitlogs without success

Thank you very much

Jean Carlo

"The best way to predict the future is to invent it" Alan Kay

( ! ) Warning: include(msgfooter.php): failed to open stream: No such file or directory in /var/www/git/apache-cassandra-users/msg06617.html on line 70
Call Stack
10.0008358384{main}( ).../msg06617.html:0

( ! ) Warning: include(): Failed opening 'msgfooter.php' for inclusion (include_path='.:/var/www/git') in /var/www/git/apache-cassandra-users/msg06617.html on line 70
Call Stack
10.0008358384{main}( ).../msg06617.html:0