[
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: [email protected]
For additional commands, e-mail: [email protected]
