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 7A2D5200C63 for ; Thu, 11 May 2017 17:13:11 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 78A21160BB2; Thu, 11 May 2017 15:13:11 +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 BF78D160BC7 for ; Thu, 11 May 2017 17:13:10 +0200 (CEST) Received: (qmail 29882 invoked by uid 500); 11 May 2017 15:13:10 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 29871 invoked by uid 99); 11 May 2017 15:13:09 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 May 2017 15:13:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 6E1D31A0155 for ; Thu, 11 May 2017 15:13:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id LflY3hXia4BD for ; Thu, 11 May 2017 15:13:07 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 4897F5FB62 for ; Thu, 11 May 2017 15:13:06 +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 52EADE0D22 for ; Thu, 11 May 2017 15:13:05 +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 4D1B821E11 for ; Thu, 11 May 2017 15:13:04 +0000 (UTC) Date: Thu, 11 May 2017 15:13:04 +0000 (UTC) From: =?utf-8?Q?Julius_=C5=BDaromskis_=28JIRA=29?= To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CASSANDRA-13441) Schema version changes for each upgraded node in a rolling upgrade, causing migration storms MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 11 May 2017 15:13:11 -0000 [ https://issues.apache.org/jira/browse/CASSANDRA-13441?page=3Dcom.atla= ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId= =3D16006613#comment-16006613 ]=20 Julius =C5=BDaromskis commented on CASSANDRA-13441: ---------------------------------------------- Hi, any workaround for this issue? I've hit this after upgrading from 3.0.9= to 3.0.13 and doing sstableupgrade. Noticed weird disk write patterns and = started seeing migration tasks bouncing around. I've only managed to update= first of the 3 nodes. Migrations tasks have stopped after I've rebooted fi= rst node. {noformat} Cluster Information: Name: cloud.zaromskis.lt cluster Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch Partitioner: org.apache.cassandra.dht.Murmur3Partitioner Schema versions: 600b7268-d42a-3b72-8706-093b6c8cfaff: [10.240.0.6] 77a40699-8e9e-35aa-834e-68c32e40a45a: [10.240.0.7, 10.240.0= .8] {noformat} {noformat} Datacenter: dc1 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Status=3DUp/Down |/ State=3DNormal/Leaving/Joining/Moving -- Address Load Tokens Owns (effective) Host ID = Rack UN 10.240.0.6 284.95 GB 256 63.4% d0d83d9d-0dec-45c= d-9ca9-93515fa131f3 rack1 UN 10.240.0.7 288.53 GB 256 64.1% 6d9709a0-0e10-46a= 1-9afa-d106b74ca9e0 rack1 UN 10.240.0.8 326.31 GB 256 72.5% 5c969700-8bd9-49a= 4-9772-1284439f8364 rack1 {noformat} The schema version of first node would not propagate to other nodes. I'm af= raid further upgrades might create new schema versions? I can't afford to l= ose any data. Any advise? > Schema version changes for each upgraded node in a rolling upgrade, causi= ng migration storms > -------------------------------------------------------------------------= ------------------- > > Key: CASSANDRA-13441 > URL: https://issues.apache.org/jira/browse/CASSANDRA-1344= 1 > Project: Cassandra > Issue Type: Bug > Components: Schema > Reporter: Jeff Jirsa > Assignee: Jeff Jirsa > Fix For: 3.0.14, 3.11.0, 4.0 > > > In versions < 3.0, during a rolling upgrade (say 2.0 -> 2.1), the first n= ode to upgrade to 2.1 would add the new tables, setting the new 2.1 version= ID, and subsequently upgraded hosts would settle on that version. > When a 3.0 node upgrades and writes its own new-in-3.0 system tables, it'= ll write the same tables that exist in the schema with brand new timestamps= . As written, this will cause all nodes in the cluster to change schema (to= the version with the newest timestamp). On a sufficiently large cluster wi= th a non-trivial schema, this could cause (literally) millions of migration= tasks to needlessly bounce across the cluster. -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org For additional commands, e-mail: commits-help@cassandra.apache.org