Re: Assassinate or decommission?

2019-07-30 Thread Rhys Campbell
assassinate. Have > you seen any issues like gossip information stayed for longer time using > decommission for removing DC? > > On Tue, Jul 30, 2019, 5:43 AM Rhys Campbell > wrote: > >> The advice is to only use assassinate when all else fails. Decommission >>

Re: Assassinate or decommission?

2019-07-30 Thread Rhys Campbell
The advice is to only use assassinate when all else fails. Decommission will make sure any data that needs to be streamed elsewhere will be. Generally decommission > removenode > assassinate is the recommended attempt order https://thelastpickle.com/blog/2018/09/18/assassinate.html Rahul Reddy

Re: Breaking up major compacted Sstable with TWCS

2019-07-12 Thread Rhys Campbell
https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/tools/toolsSStables/toolsSSTableSplit.html Leon Zaruvinsky schrieb am Fr., 12. Juli 2019, 00:06: > Hi, > > We are switching a table to run using TWCS. However, after running the > alter statement, we ran a major compaction withou

Re: Need help on dealing with Cassandra robustness and zombie data

2019-07-01 Thread Rhys Campbell
#1 Set the cassandra service to not auto-start. #2 Longer gc_grace time would help #3 Rebootstrap? If the node doesn't come back within gc_grace,_seconds, remove the node, wipe it, and bootstrap it again. https://docs.datastax.com/en/archived/cassandra/2.0/cassandra/dml/dml_about_deletes_c.html

Re: Restore from EBS onto different cluster

2019-06-27 Thread Rhys Campbell
Sstableloader is probably your best option Ayub M schrieb am Fr., 28. Juni 2019, 08:37: > Hello, I have a cluster with 3 nodes - say cluster1 on AWS EC2 instances. > The cluster is up and running, took snapshot of the keyspaces volume. > > Now I want to restore few tables/keyspaces from the snap

Re: Cluster schema version choosing

2019-05-21 Thread Rhys Campbell
I'd hazzard a guess that the uuid contains a datetime component Aleksey Korolkov schrieb am Di., 21. Mai 2019, 09:36: > Thanks for the feedback. > I also think that node choose like "last wins" but I could not find any > timestamp of schema creation in system tables. > Hope this is not the order

Re: nodetool repair failing with "Validation failed in /X.X.X.X

2019-05-06 Thread Rhys Campbell
is helps! > > > > On Sat, May 4, 2019 at 3:58 PM Rhys Campbell > wrote: > >> >> > Hello, >> > >> > I’m having issues running repair on an Apache Cassandra Cluster. I’m >> getting "Failed creating a merkle tree“ errors on the replication p

nodetool repair failing with "Validation failed in /X.X.X.X

2019-05-04 Thread Rhys Campbell
> Hello, > > I’m having issues running repair on an Apache Cassandra Cluster. I’m getting > "Failed creating a merkle tree“ errors on the replication partner nodes. > Anyone have any experience of this? I am running 2.2.13. > > Further details here… > https://issues.apache.org/jira/projects/