cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Payne <dav...@cqg.com>
Subject RE: Cassandra 2.2.7 Compaction after Truncate issue
Date Thu, 13 Sep 2018 15:50:13 GMT
I was able to resolve the issue with a rolling restart of the cluster.

From: James Shaw <jxyshaw@gmail.com>
Sent: Thursday, August 23, 2018 7:52 PM
To: user@cassandra.apache.org
Subject: Re: Cassandra 2.2.7 Compaction after Truncate issue

you may go OS level to delete the files.That's what I did before.  Truncate action is frequently
failed on some remote nodes in a heavy transactions env.

Thanks,

James

On Thu, Aug 23, 2018 at 8:54 PM, Rahul Singh <rahul.xavier.singh@gmail.com<mailto:rahul.xavier.singh@gmail.com>>
wrote:
David ,

What CL do you set when running this command?

Rahul Singh
Chief Executive Officer
m 202.905.2818

Anant Corporation
1010 Wisconsin Ave NW, Suite 250<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D1010%2BWisconsin%2BAve%2BNW%2C%2BSuite%2B250%2B%250D%250AWashington%2C%2BD.C.%2B20007%26entry%3Dgmail%26source%3Dg&data=02%7C01%7C%7C7231eb88a6154a6520bf08d60964367b%7C0f96d359c20349d1a42dcbb27249db0d%7C0%7C0%7C636706723366003689&sdata=p0KhN5D2H%2B1bZ%2B2jeOXSV8OSaRCJTqHmH6ffFzwwfNU%3D&reserved=0>
Washington, D.C. 20007

We build and manage digital business technology platforms.
On Aug 14, 2018, 11:49 AM -0500, David Payne <davidp@cqg.com<mailto:davidp@cqg.com>>,
wrote:

Scenario: Cassandra 2.2.7, 3 nodes, RF=3 keyspace.


Truncate a table.

More than 24 hours later… FileCacheService is still reporting cold readers for sstables
of truncated data for node 2 and 3, but not node 1.

The output of nodeool compactionstats shows stuck compaction for the truncated table for node
2 and 3, but not node 1.

This appears to be a defect that was fixed in 2.1.0. https://issues.apache.org/jira/browse/CASSANDRA-7803<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FCASSANDRA-7803&data=02%7C01%7C%7C7231eb88a6154a6520bf08d60964367b%7C0f96d359c20349d1a42dcbb27249db0d%7C0%7C0%7C636706723366003689&sdata=3k9pCBlv5lMMnKVlEq1bVH2K9nSLVc2Nho4TDAboDSM%3D&reserved=0>

Any ideas?

Thanks,
David Payne
    | ̄ ̄|
_☆☆☆_
( ´_⊃`)
c. 303-717-0548<tel:303-717-0548>
davidp@cqg.com<mailto:davidp@cqg.com>


Mime
View raw message