Re: table repair question

[Javier Canillas]

I'm doing it on a daily basis. If the repaired percentage drops from 80%,
then I do a repair over that keyspace-table. Seems working fine for the
last months without problems and avoids huge merkle tree building. No data
loss so far.

I'm running 3.11.0 btw.

2017-10-04 17:44 GMT-03:00 Blake Eggleston :

> Incremental repairs should also update the percentage, although I'd
> recommend not using incremental repair before 4.0. Just want to point out
> that running repairs based on repaired % isn't necessarily a bad thing, but
> it should be a secondary consideration. The important thing is to repair
> data more frequently than your gc grace period.
>
>
> On October 4, 2017 at 1:33:57 PM, Javier Canillas (
> javier.canil...@gmail.com) wrote:
>
> That percentage will only be updated if you do a full repair. If you do
> repairs on local dc or with -pr, that percentage will not be updated.
>
> I scripted a regular repair on each node based on if this percentage is
> below some threshold. It has been running fine since several months ago.
>
> 2017-10-04 12:46 GMT-03:00 Blake Eggleston :
>
>> Not really no. There's a repaired % in nodetool tablestats if you're
>> using incremental repair (and you probably shouldn't be before 4.0 comes
>> out), but I wouldn't make any decisions based off it's value.
>>
>>
>> On October 4, 2017 at 8:05:44 AM, ZAIDI, ASAD A (az1...@att.com) wrote:
>>
>> Hello folk,
>>
>>
>>
>> I’m wondering if there is way to find out list of table(s) which need
>> repair OR if there Is way to find out what %age of data would need to be
>> repaired on a table?  Is such information available from Cassandra  db
>> engine through some other means?
>>
>>
>>
>> TIA~ Asad
>>
>>
>>
>>
>>
>>
>>
>>
>

Re: table repair question

[Blake Eggleston]

Incremental repairs should also update the percentage, although I'd recommend 
not using incremental repair before 4.0. Just want to point out that running 
repairs based on repaired % isn't necessarily a bad thing, but it should be a 
secondary consideration. The important thing is to repair data more frequently 
than your gc grace period.


On October 4, 2017 at 1:33:57 PM, Javier Canillas (javier.canil...@gmail.com) 
wrote:

That percentage will only be updated if you do a full repair. If you do repairs 
on local dc or with -pr, that percentage will not be updated.

I scripted a regular repair on each node based on if this percentage is below 
some threshold. It has been running fine since several months ago.

2017-10-04 12:46 GMT-03:00 Blake Eggleston :
Not really no. There's a repaired % in nodetool tablestats if you're using 
incremental repair (and you probably shouldn't be before 4.0 comes out), but I 
wouldn't make any decisions based off it's value.


On October 4, 2017 at 8:05:44 AM, ZAIDI, ASAD A (az1...@att.com) wrote:

Hello folk,

 

I’m wondering if there is way to find out list of table(s) which need repair OR 
if there Is way to find out what %age of data would need to be repaired on a 
table?  Is such information available from Cassandra  db engine through some 
other means?

 

TIA~ Asad

 

 

 

Re: table repair question

[Javier Canillas]

That percentage will only be updated if you do a full repair. If you do
repairs on local dc or with -pr, that percentage will not be updated.

I scripted a regular repair on each node based on if this percentage is
below some threshold. It has been running fine since several months ago.

2017-10-04 12:46 GMT-03:00 Blake Eggleston :

> Not really no. There's a repaired % in nodetool tablestats if you're using
> incremental repair (and you probably shouldn't be before 4.0 comes out),
> but I wouldn't make any decisions based off it's value.
>
>
> On October 4, 2017 at 8:05:44 AM, ZAIDI, ASAD A (az1...@att.com) wrote:
>
> Hello folk,
>
>
>
> I’m wondering if there is way to find out list of table(s) which need
> repair OR if there Is way to find out what %age of data would need to be
> repaired on a table?  Is such information available from Cassandra  db
> engine through some other means?
>
>
>
> TIA~ Asad
>
>
>
>
>
>
>
>

Re: table repair question

[Blake Eggleston]

Not really no. There's a repaired % in nodetool tablestats if you're using 
incremental repair (and you probably shouldn't be before 4.0 comes out), but I 
wouldn't make any decisions based off it's value.


On October 4, 2017 at 8:05:44 AM, ZAIDI, ASAD A (az1...@att.com) wrote:

Hello folk,

 

I’m wondering if there is way to find out list of table(s) which need repair OR 
if there Is way to find out what %age of data would need to be repaired on a 
table?  Is such information available from Cassandra  db engine through some 
other means?

 

TIA~ Asad