Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id A94D1200B61 for ; Tue, 9 Aug 2016 20:58:48 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id A4679160AA5; Tue, 9 Aug 2016 18:58:48 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id E981C160A6B for ; Tue, 9 Aug 2016 20:58:47 +0200 (CEST) Received: (qmail 52424 invoked by uid 500); 9 Aug 2016 18:58:46 -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 52413 invoked by uid 99); 9 Aug 2016 18:58:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Aug 2016 18:58:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id C0C0CC0C8F for ; Tue, 9 Aug 2016 18:58:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id cVqKzoBjBYdH for ; Tue, 9 Aug 2016 18:58:44 +0000 (UTC) Received: from mail-yw0-f182.google.com (mail-yw0-f182.google.com [209.85.161.182]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id B32CA5FBCA for ; Tue, 9 Aug 2016 18:58:44 +0000 (UTC) Received: by mail-yw0-f182.google.com with SMTP id r9so12525226ywg.0 for ; Tue, 09 Aug 2016 11:58:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=SsehxNmyhS7zWN2XCLym7mcGSGGw/BiJPJ+dq3jlCyM=; b=x2w5N0KaKyrrqSueL/dJiKPzk4dBYmEjIi77lHM1u2JBua21CCo8anYQ/5vyYfJfz+ 7ixpEOm2BFjP+mnl86yDb685z5d0VBgC12bOj18vYEBkbCJQzvAlOYvHecB6lyESL4Yx 4kty90AU3hCP3AoLOomxyJfKq2LCJHjsRZMQxtFm0xYtxl/QYZB1KAIhNwaeXVabb5pD GkHVcrVqfkk+IQ2hUzj3GMH4Bt6CsTysGIUpZfjxcp6geRD2h88YHA9vFJM/iyyS5fH8 IDF27wJbpZNwgt80SMwXi8oHZi85IUAEumCwlkGCgLTeHvTVQNEvUkzxLxhKwITQcvyh ts7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=SsehxNmyhS7zWN2XCLym7mcGSGGw/BiJPJ+dq3jlCyM=; b=c1NkW/yKEqw8wZJSCVlrwD/JgxIHN/inx14npHR3ZCIfAL71U4JQVgqzk+bPwZyJrw NwT77dykt/rYQgDn5b40Ls0a/xDfe9hknx2cxJgL7LQYmhe9EKO+Ip+Uh8IVQuJSS0sm RhHNTAA8nFEe6Et9u+sFBl/e+wgR+yZVMyBUfiFB1ITiEQXPcjXwXrIRxHddYZOrn+sh j1e9eeMvzJXTJ0tUxr6YtSsjB28uV3WxT1val7FNGZodshKGbozasVgL16mcLcL/aCtg P3R6CB1NkoBRgVtUDXwCsGdl7ZicvYRgJNnst0BtCYXIY5nIUR3rbibw650urWlSMJ57 AyLA== X-Gm-Message-State: AEkoousHSGGDCc1pb19HgQkS9ElEyD11o4pThR1Oq2MlR2TnltjZhI6RIoBgQ9fGwNetS3Q9T9Jp+7a0r6ua3w== X-Received: by 10.129.145.6 with SMTP id i6mr73095846ywg.35.1470769124282; Tue, 09 Aug 2016 11:58:44 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.118.136 with HTTP; Tue, 9 Aug 2016 11:58:23 -0700 (PDT) In-Reply-To: References: From: Paulo Motta Date: Tue, 9 Aug 2016 15:58:23 -0300 Message-ID: Subject: Re: Incremental repairs leading to unrepaired data To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=94eb2c09248c3352980539a81fd3 archived-at: Tue, 09 Aug 2016 18:58:48 -0000 --94eb2c09248c3352980539a81fd3 Content-Type: text/plain; charset=UTF-8 Anticompaction throttling can be done by setting the usual compaction_throughput_mb_per_sec knob on cassandra.yaml or via nodetool setcompactionthroughput. Did you try lowering that and checking if that improves the dropped mutations? 2016-08-09 13:32 GMT-03:00 Stefano Ortolani : > Hi all, > > I am running incremental repaird on a weekly basis (can't do it every day > as one single run takes 36 hours), and every time, I have at least one node > dropping mutations as part of the process (this almost always during the > anticompaction phase). Ironically this leads to a system where repairing > makes data consistent at the cost of making some other data not consistent. > > Does anybody know why this is happening? > > My feeling is that this might be caused by anticompacting column families > with really wide rows and with many SStables. If that is the case, any way > I can throttle that? > > Thanks! > Stefano > --94eb2c09248c3352980539a81fd3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Anticompaction throttling can be done by setting the usual= compaction_throughput_mb_per_sec knob on cassandra.yaml or via nodetool se= tcompactionthroughput. Did you try lowering that=C2=A0 and checking if that= improves the dropped mutations?

2016-08-09 13:32 GMT-03:00 Stefano Ortolani <ost= efano@gmail.com>:
Hi all,

I am running incremental rep= aird on a weekly basis (can't do it every day as one single run takes 3= 6 hours), and every time, I have at least one node dropping mutations as pa= rt of the process (this almost always during the anticompaction phase). Iro= nically this leads to a system where repairing makes data consistent at the= cost of making some other data not consistent.

Do= es anybody know why this is happening?

My feeling = is that this might be caused by anticompacting column families with really = wide rows and with many SStables. If that is the case, any way I can thrott= le that?

Thanks!
Stefano

--94eb2c09248c3352980539a81fd3--