I was able to resolve the issue with a rolling restart of the cluster. From: James Shaw <jxys...@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.si...@gmail.com<mailto:rahul.xavier.si...@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 <dav...@cqg.com<mailto:dav...@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> dav...@cqg.com<mailto:dav...@cqg.com>
