From user-return-64068-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Thu Jun 20 04:52:12 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 961B418060F for ; Thu, 20 Jun 2019 06:52:12 +0200 (CEST) Received: (qmail 64910 invoked by uid 500); 20 Jun 2019 04:52:08 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 64900 invoked by uid 99); 20 Jun 2019 04:52:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Jun 2019 04:52:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 0844718106E for ; Thu, 20 Jun 2019 04:52:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.801 X-Spam-Level: * X-Spam-Status: No, score=1.801 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=mailjet.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 9j7RzV7zxGfp for ; Thu, 20 Jun 2019 04:52:05 +0000 (UTC) Received: from mail-io1-f47.google.com (mail-io1-f47.google.com [209.85.166.47]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 9002C5F4EB for ; Thu, 20 Jun 2019 04:52:04 +0000 (UTC) Received: by mail-io1-f47.google.com with SMTP id h6so322385ioh.3 for ; Wed, 19 Jun 2019 21:52:04 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=4eqW9tU1TppUcqeZCXNrP94Pt5ZTj0UDjw61YNbDC3M=; b=dSoEjuLAf6l7yIDWyqqh1LKPeLC80Y04hSix2iuQLuGi5eubwyKwEagzDITtzIDwbo +UCUC2BkUQBmYUorHoKCbFhJA0oMOchi2OEzDT6U1Y1sa7y7mZd7FpDtkTJRCO2Obb3i 1H3tkVBploRqK5ML1upyjZf79dYfE4D5FCYLmW0I4eT4xkHs6DoH/jFQAjeFQWDBV8YR 2UbnklYs+cik21DQKNQrSXL50N4q53qPU7fdTjqhwD9ilgsFOo/ZgUQI5CZl5rmO8422 4DrGfR0EqMfhVsX0h/0BSGpcBDwLjR+s0wZt1VVOf6xIpPQaOFa2O1gahMbX0R3itxcv JtuQ== X-Gm-Message-State: APjAAAW0VsdeWeRnOK9Nn8dQDNl5LST478W+NcIcdCHNsEEtSl7XfEKY yH5QVQXNMehyyxW7EYzBDwpqxXHeAEMDnsx9JWret21Pat4= X-Google-Smtp-Source: APXvYqwhpOxOJzQLVUcjxwSZVeQRU1ds7UzPJz+7rW5GFbw+AB+rJhjv3JP1uYYS/EfMoIMP44kPLKgqK4DisUUPYsg= X-Received: by 2002:a02:554a:: with SMTP id e71mr35348042jab.144.1561006323248; Wed, 19 Jun 2019 21:52:03 -0700 (PDT) MIME-Version: 1.0 From: =?UTF-8?Q?L=C3=A9o_FERLIN_SUTTON?= Date: Thu, 20 Jun 2019 06:51:52 +0200 Message-ID: Subject: Tombstones not getting purged To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary="00000000000063d64a058bba1b8c" --00000000000063d64a058bba1b8c Content-Type: text/plain; charset="UTF-8" I have used the following command to check if I had droppable tombstones : `/usr/bin/sstablemetadata --gc_grace_seconds 259200 /var/lib/cassandra/data/stats/tablename/md-sstablename-big-Data.db` I checked every sstable in a loop and had 4 sstables with droppable tombstones : ``` Estimated droppable tombstones: 0.1558453651124074 Estimated droppable tombstones: 0.20980847354256815 Estimated droppable tombstones: 0.30826566640798975 Estimated droppable tombstones: 0.45150604672159905 ``` I changed my compaction configuration this morning (via JMX) to force a tombstone compaction. These are my settings on this node : ``` { "max_threshold":"32", "min_threshold":"4", "unchecked_tombstone_compaction":"true", "tombstone_threshold":"0.1", "class":"org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy" } ``` The threshold is lowed than the amount of tombstones in these sstables and I expected the setting `unchecked_tombstone_compaction=True` would force cassandra to run a "Tombstone Compaction", yet about 24h later all the tombstones are still there. ## About the cluster : The compaction backlog is clear and here are our cassandra settings : Cassandra 3.0.18 concurrent_compactors: 4 compaction_throughput_mb_per_sec: 150 sstable_preemptive_open_interval_in_mb: 50 memtable_flush_writers: 4 Any idea what I might be missing ? Regards, Leo --00000000000063d64a058bba1b8c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have used the following command to check if I had droppa= ble tombstones :
`/usr/bin/sstablemetadata --gc_grace_seconds 259200 /va= r/lib/cassandra/data/stats/tablename/md-sstablename-big-Data.db`

I c= hecked every sstable in a loop and had 4 sstables with droppable tombstones= :

```
Estimated droppable tombstones: 0.1558453651124074
Est= imated droppable tombstones: 0.20980847354256815
Estimated droppable tom= bstones: 0.30826566640798975
Estimated droppable tombstones: 0.451506046= 72159905
```

I changed my compaction configuration this morning (= via JMX) to force a tombstone compaction. These are my settings on this nod= e :

```
{
"max_threshold":"32",
"= ;min_threshold":"4",
"unchecked_tombstone_compactio= n":"true",
"tombstone_threshold":"0.1&quo= t;,
"class":"org.apache.cassandra.db.compaction.SizeTier= edCompactionStrategy"
}
```
The threshold is lowed than the a= mount of tombstones in these sstables and I expected the setting `unchecked= _tombstone_compaction=3DTrue` would force cassandra to run a "Tombston= e Compaction", yet about 24h later all the tombstones are still there.=

## About the cluster :=C2=A0

The compaction backlog is clea= r and here are our cassandra settings :

Cassandra 3.0.18
concurr= ent_compactors: 4
compaction_throughput_mb_per_sec: 150
sstable_preem= ptive_open_interval_in_mb: 50
memtable_flush_writers: 4

Any idea what I might be missing ?
Regards,

Leo
--00000000000063d64a058bba1b8c--