question

satvantsingh_190085 avatar image
satvantsingh_190085 asked Erick Ramirez answered

Can we ALTER TABLE and disable NodeSync service and run nodetool repair?

[FOLLOW UP QUESTION TO #3879]

Can we alter table and disable nodesync service and run the nodetool repair ? or there some other steps need to follow for this approach ?

repairnodesync
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

smadhavan avatar image
smadhavan answered

@satvantsingh_190085, it is not required to disable NodeSync but, instead you can kick off a manual validation which will place the repair of this particular table priority in the queue. Refer to this answer for a similar question to understand how to perform the same. Documentation reference is here.

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered satvantsingh_190085 commented

@satvantsingh_190085, smadhavan is correct. I've previously answered this question in "Should NodeSync be disabled on a table in order to manually repair it?".

We don't recommend disabling NodeSync on the table. We suggest you run a manual validation which is the equivalent of running a manual repair on the table with this command:

$ nodesync validation submit ks_name.table_name

A manual validation prioritises the repair of the table. When the validation has completed, the NodeSync service will resume syncs of the scheduled segments.

See Manually starting validation for more details. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.