Re: Accidentaly removed SSTables of unneeded data

[Simon ELBAZ]

Hi Shalom,

I've runned refresh as Nitan suggested without sstablescrub.

Then i tried drain/restart on the 3 nodes. The repair is now OK.

Thanks for your help

Simon

On 02/05/2019 16:58, shalom sagges wrote:

Hi Simon,

If you haven't did that already, try to drain and restart the node you 
deleted the data from.

Then run the repair again.

Regards,

On Thu, May 2, 2019 at 5:53 PM Simon ELBAZ > wrote:


Hi,

I am running Cassandra v2.1 on a 3 node cluster.

/# yum list installed | grep cassa//
//cassandra21.noarch 2.1.12-1 @datastax //
//cassandra21-tools.noarch 2.1.12-1
@datastax /

Unfortunately, I accidentally removed the SSTables (using rm)
(older than 10 days) of a table on the 3 nodes.

Running 'nodetool repair' on one of the 3 nodes returns error.
Whereas, it does not on another.

I don't need to recover the lost data but I would like 'nodetool
repair' not returning an error.

Thanks for any advice.

Simon

Re: Accidentaly removed SSTables of unneeded data

[Nitan Kainth]

You can run nodetool refresh and then sstablescrub to see if there is any
corruption.

On Thu, May 2, 2019 at 9:53 AM Simon ELBAZ  wrote:

> Hi,
>
> I am running Cassandra v2.1 on a 3 node cluster.
>
> *# yum list installed | grep cassa*
> *cassandra21.noarch2.1.12-1
> @datastax*
> *cassandra21-tools.noarch  2.1.12-1
> @datastax   *
>
> Unfortunately, I accidentally removed the SSTables (using rm) (older than
> 10 days) of a table on the 3 nodes.
>
> Running 'nodetool repair' on one of the 3 nodes returns error. Whereas, it
> does not on another.
>
> I don't need to recover the lost data but I would like 'nodetool repair'
> not returning an error.
>
> Thanks for any advice.
>
> Simon
>

Re: Accidentaly removed SSTables of unneeded data

[shalom sagges]

Hi Simon,

If you haven't did that already, try to drain and restart the node you
deleted the data from.
Then run the repair again.

Regards,

On Thu, May 2, 2019 at 5:53 PM Simon ELBAZ  wrote:

> Hi,
>
> I am running Cassandra v2.1 on a 3 node cluster.
>
> *# yum list installed | grep cassa*
> *cassandra21.noarch2.1.12-1
> @datastax*
> *cassandra21-tools.noarch  2.1.12-1
> @datastax   *
>
> Unfortunately, I accidentally removed the SSTables (using rm) (older than
> 10 days) of a table on the 3 nodes.
>
> Running 'nodetool repair' on one of the 3 nodes returns error. Whereas, it
> does not on another.
>
> I don't need to recover the lost data but I would like 'nodetool repair'
> not returning an error.
>
> Thanks for any advice.
>
> Simon
>

Accidentaly removed SSTables of unneeded data

[Simon ELBAZ]

Hi,

I am running Cassandra v2.1 on a 3 node cluster.

/# yum list installed | grep cassa//
//cassandra21.noarch 2.1.12-1 @datastax //
//cassandra21-tools.noarch 2.1.12-1 @datastax /

Unfortunately, I accidentally removed the SSTables (using rm) (older 
than 10 days) of a table on the 3 nodes.


Running 'nodetool repair' on one of the 3 nodes returns error. Whereas, 
it does not on another.


I don't need to recover the lost data but I would like 'nodetool repair' 
not returning an error.


Thanks for any advice.

Simon