Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BD740106F3 for ; Wed, 19 Mar 2014 15:45:26 +0000 (UTC) Received: (qmail 19565 invoked by uid 500); 19 Mar 2014 15:45:24 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 18749 invoked by uid 500); 19 Mar 2014 15:45:15 -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 18735 invoked by uid 99); 19 Mar 2014 15:45:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Mar 2014 15:45:12 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of olek.stasiak@gmail.com designates 209.85.220.172 as permitted sender) Received: from [209.85.220.172] (HELO mail-vc0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Mar 2014 15:45:07 +0000 Received: by mail-vc0-f172.google.com with SMTP id la4so9372885vcb.31 for ; Wed, 19 Mar 2014 08:44:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=Ea4XsjQ+SoPL6HOTzGLX7tYuajr5sO/o5gWB9AhZn+Q=; b=xnJ2Jh7eYg/gMliFrK7S+HSoGjDe3uAYDwzB/wv8TEJXZ796r1f70PNxW4ez6/YUxG wzFrHrI/6hadCputj/hvKRas9iGm5LiFsCkbMrUgds3NqsSNemr1J67QrRbOFJYntkf/ HMDTH2QW0AMc4lX47PbsmLUm4PDIhHi6OPpt5/IAuKD8j2r0nlawl+XVHf0/rTwMiw7B X3joi6JfsaescDHtFhh5AJzBCannO1F7YKXyuIyGE22J6hzdJTOibW/UWAZvzvm2S7ej rmUFprl4ghvGC5WxpexbRTX0AlcijWuUjDQXaCAv35VBcLVjbZLbnpGxdFS33RhUTT5j 8b1A== MIME-Version: 1.0 X-Received: by 10.58.229.167 with SMTP id sr7mr29626395vec.7.1395243886455; Wed, 19 Mar 2014 08:44:46 -0700 (PDT) Received: by 10.220.203.133 with HTTP; Wed, 19 Mar 2014 08:44:46 -0700 (PDT) In-Reply-To: References: <531F0457.4020701@gmail.com> <531F0C47.4040003@gmail.com> Date: Wed, 19 Mar 2014 16:44:46 +0100 Message-ID: Subject: Re: Problems with adding datacenter and schema version disagreement From: "olek.stasiak@gmail.com" To: Emaillist for cass users Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Bump, could anyone comment this behaviour, is it correct, or should I create Jira task for this problems? regards Olek 2014-03-18 16:49 GMT+01:00 olek.stasiak@gmail.com : > Oh, one more question: what should be configuration for storing > system_traces keyspace? Should it be replicated or stored locally? > Regards > Olek > > 2014-03-18 16:47 GMT+01:00 olek.stasiak@gmail.com : >> Ok, i've dropped all system keyspaces, rebuild cluster and recover >> schema, now everything looks ok. >> But main goal of operations was to add new datacenter to cluster. >> After starting node in new cluster two schema versions appear, one >> version is held by 6 nodes of first datacenter, second one is in newly >> added node in new datacenter. Sth like this: >> nodetool status >> Datacenter: datacenter1 >> =3D=3D=3D=3D=3D=3D=3D=3D=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 Host ID >> Rack >> UN 192.168.1.1 50.19 GB 1 0,5% >> c9323f38-d9c4-4a69-96e3-76cd4e1a204e rack1 >> UN 192.168.1.2 54.83 GB 1 0,3% >> ad1de2a9-2149-4f4a-aec6-5087d9d3acbb rack1 >> UN 192.168.1.3 51.14 GB 1 0,6% >> 0ceef523-93fe-4684-ba4b-4383106fe3d1 rack1 >> UN 192.168.1.4 54.31 GB 1 0,7% >> 39d15471-456d-44da-bdc8-221f3c212c78 rack1 >> UN 192.168.1.5 53.36 GB 1 0,3% >> 7fed25a5-e018-43df-b234-47c2f118879b rack1 >> UN 192.168.1.6 39.89 GB 1 0,1% >> 9f54fad6-949a-4fa9-80da-87efd62f3260 rack1 >> 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 Host ID >> Rack >> UN 192.168.1.7 100.77 KB 256 97,4% >> ddb1f913-d075-4840-9665-3ba64eda0558 RAC1 >> >> describe cluster; >> Cluster Information: >> Name: Metadata Cluster >> Snitch: org.apache.cassandra.locator.GossipingPropertyFileSnitch >> Partitioner: org.apache.cassandra.dht.RandomPartitioner >> Schema versions: >> 8fe34841-4f2a-3c05-97f2-15dd413d71dc: [192.168.1.7] >> >> 4ad381b6-df5a-3cbc-ba5a-0234b74d2383: [192.168.1.1, 192.168.1.2, >> 192.168.1.3, 192.168.1.4, 192.168.1.5, 192.168.1.6] >> >> All keyspaces are now configured to keep data in datacenter1. >> I assume, that It's not correct behaviour, is it true? >> Could you help me, how can I safely add new DC to the cluster? >> >> Regards >> Aleksander >> >> >> 2014-03-14 18:28 GMT+01:00 olek.stasiak@gmail.com : >>> Ok, I'll do this during the weekend, I'll give you a feedback on Monday= . >>> Regards >>> Aleksander >>> >>> 14 mar 2014 18:15 "Robert Coli" napisa=B3(a): >>> >>>> On Fri, Mar 14, 2014 at 12:40 AM, olek.stasiak@gmail.com >>>> wrote: >>>>> >>>>> OK, I see, so the data files stay in place, i have to just stop >>>>> cassandra on whole cluster, remove system schema and then start >>>>> cluster and recreate all keyspaces with all column families? Data wil= l >>>>> be than loaded automatically from existing ssstables, right? >>>> >>>> >>>> Right. If you have clients reading while loading the schema, they may = get >>>> exceptions. >>>> >>>>> >>>>> So one more question: what about KS system_traces? should it be >>>>> removed and recreted? What data it's holding? >>>> >>>> >>>> It's holding data about tracing, a profiling feature. It's safe to nuk= e. >>>> >>>> =3DRob >>>>