[jira] [Comment Edited] (CASSANDRA-15366) Backup and Restore

["Kamal (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-15366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16956709#comment-16956709 ] 

Kamal edited comment on CASSANDRA-15366 at 10/22/19 5:55 AM:
-------------------------------------------------------------

Hello, [~maxwellguo] ,

Thanks for your prompt reply!

I am using 2 nodes cassandra cluster with version= 3.11.4 and cqlsh version = 5.0.1. 
 I have followed below steps:
 - Created a keyspace by name abc on Node1 and table in it named t1 with below command:
 CREATE KEYSPACE abc WITH replication = \{'class': 'NetworkTopologyStrategy', 'datacenter1': '3'} ;
 create table abc.t1 (id int primary key); 
 insert into abc.t1 (id) values (1);
 insert into abc.t1 (id) values (2);

 - Then executed command "nodetool snapshot abc" on both nodes.
 - After that on Node 1, I truncated table, t1, and copied "snapshot" directory from Node 2.
 - now, i refreshed the keyspace by command = nodetool refresh abc t1
 - and the data restored completely. But while following the same steps second time with adding the values, result is given below:

VALUE ADDITION in second phase:
 insert into abc.t1 (id) values (3);
 insert into abc.t1 (id) values (4);
 insert into abc.t1 (id) values (5);
 insert into abc.t1 (id) values (6);
 insert into abc.t1 (id) values (7);

cassandra@cqlsh> select * from abc.t1;

id
----
5
 4
 7
 6
 3


was (Author: kamalkl):
Hello, [~maxwellguo] ,


Thanks for your prompt reply!


I am using 2 nodes cassandra cluster with version= 3.11.4 and cqlsh version = 5.0.1. 
I have followes below steps:
- Created a keyspace by name abc on Node1 and table in it named t1 with below command:
 CREATE KEYSPACE abc WITH replication = \{'class': 'NetworkTopologyStrategy', 'datacenter1': '3'} ;
 create table abc.t1 (id int primary key); 
 insert into abc.t1 (id) values (1);
 insert into abc.t1 (id) values (2);

- Then executed command "nodetool snapshot abc" on both nodes.
- After that on Node 1, I truncated table, t1, and copied "snapshot" directory from Node 2.
- now, i refershed the keyspace by command = nodetool refresh abc t1
- and the data restored completely. But while following the same steps second time with adding the values, result is given below:

VALUE ADDITION in second phase:
 insert into abc.t1 (id) values (3);
 insert into abc.t1 (id) values (4);
 insert into abc.t1 (id) values (5);
 insert into abc.t1 (id) values (6);
 insert into abc.t1 (id) values (7);

cassandra@cqlsh> select * from abc.t1;

id
----
 5
 4
 7
 6
 3

> Backup and Restore
> ------------------
>
>                 Key: CASSANDRA-15366
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15366
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Kamal
>            Priority: Normal
>
> Hi Team,
> We are testing the backup and restore of CASSANDRA  in a cluster and found that while restoring the backup from the second node to the new node (or previous node) then complete data is not restored.
> Please enlight us on it.
>  
> Regards,
> Kamal



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org