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 5E7A7200CDD for ; Sun, 23 Jul 2017 17:19:04 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 5D163164804; Sun, 23 Jul 2017 15:19:04 +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 B2A28164809 for ; Sun, 23 Jul 2017 17:19:03 +0200 (CEST) Received: (qmail 1203 invoked by uid 500); 23 Jul 2017 15:19:02 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 1015 invoked by uid 99); 23 Jul 2017 15:19:02 -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; Sun, 23 Jul 2017 15:19:02 +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 3B22EC0399 for ; Sun, 23 Jul 2017 15:19:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-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 ZsybPL3wIeA0 for ; Sun, 23 Jul 2017 15:19:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 4E7A65FD4A for ; Sun, 23 Jul 2017 15:19:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id BA167E0DFD for ; Sun, 23 Jul 2017 15:19:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 24DC421EEB for ; Sun, 23 Jul 2017 15:19:00 +0000 (UTC) Date: Sun, 23 Jul 2017 15:19:00 +0000 (UTC) From: "ZhaoYang (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CASSANDRA-13073) Optimize repair behaviour with MVs MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Sun, 23 Jul 2017 15:19:04 -0000 [ https://issues.apache.org/jira/browse/CASSANDRA-13073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ZhaoYang updated CASSANDRA-13073: --------------------------------- Component/s: Materialized Views > Optimize repair behaviour with MVs > ---------------------------------- > > Key: CASSANDRA-13073 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13073 > Project: Cassandra > Issue Type: Bug > Components: Materialized Views > Reporter: Benjamin Roth > > I am referring to a discusson on the dev list about the MV streaming issues discussed in 12888. > It turned out that under some circumstances, repairing MVs can lead to inconsistencies. To remove that inconsistencies, it is necessary, to repair the base table first and then the MV again. These inconsistencies can be created both by read repair or CF/Keyspace repair. > Proposition: > - Exclude MVs from keyspace repairs > - Disable read repairs on MVs or transform them to a read repair of the base table (maybe complicated but possible) > Explanation: > - CF base has PK a and field b > - MV has PK a, b > - 2 nodes n1 + n2, no hints > - Initial state is a=1,b=1 at time t=0 > - Node n2 goes down > - Mutation a=1, b=2 at time t=1 > - Node n2 comes up and node n1 goes down > - Mutation a=1, b=3 at time t=2 > - Node n1.mv contains: a1=1, b=3 + tombstone for a1=1,b=1 > - Node n2.mv contains: a1=1, b=2 + tombstone for a1=1,b=1 > When doing a repair on mv _before_ repairing base, mv would look like: > - Node n1.mv contains: a1=1, b=3 + tombstone for a1=1,b=1 + a1=1, b=2 > - Node n2.mv contains: a1=1, b=2 + tombstone for a1=1,b=1 + a1=1, b=3 > Repairing _only_ the base table would create the correct result: > - Node n1.mv contains: a1=1, b=3 + tombstone for a1=1,b=1 + tombstone for a1=1,b=2 > - Node n2.mv contains: a1=1, b=3 + tombstone for a1=1,b=1 (TS for a1=2,b=2 should not have been created as b=3 was there, which shadows b=2 and should not reach the MV at all) > All this does not apply if CASSANDRA-13066 will be implemented and enabled -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org For additional commands, e-mail: commits-help@cassandra.apache.org