CODEWITHSUNDEEP
cassandrasnapshot
Rogelio Triviño
Rogelio Triviño

Reputation: 6559

restoring table data from cassandra snapshot don't gossip to other nodes in cluster

I'm restoring to a deleted table data from a cassandra snapshot. This is what I'm doing: Logging to first node. Taking all files from snapshot and copying them to the table data directory. Executing 

nodetool refresh <keyspace> <table>

and data is showed ok on that node, but not transmitted to others in cluster. I'm aware the reason may be related to timestamps on records, so using advice I try deleting data on tables, executing 

TRUNCATE <table>

on node previously to this process, but with the same results.

Upvotes: 0

Views: 106

Answers (2)

Paul Chandler
Paul Chandler

Reputation: 31

Have you tried a nodetool repair -full on the other nodes?

You will need to do the same refresh process on all the nodes, so the table should appear on all the nodes after that.

Upvotes: 1

Rogelio Trivi&#241;o
Rogelio Trivi&#241;o

Reputation: 6559

I know is a quick and dirty solution, but when I face this problem my solution was:

COPY Usuario (id , usuarioId, organizacionId, descripcion, estado , ultimoCambio, json , sesion) TO 'Usuario.csv';
COPY Usuario (id , usuarioId, organizacionId, descripcion, estado , ultimoCambio, json , sesion) FROM 'Usuario.csv';

And I prefer backup these csv than snapshots. Doing this process, rows are recreated and correctly copied to every node in cluster.

Upvotes: 0

Related Questions