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 EA5FFCB25 for ; Tue, 12 Aug 2014 09:03:44 +0000 (UTC) Received: (qmail 98570 invoked by uid 500); 12 Aug 2014 09:03:41 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 98532 invoked by uid 500); 12 Aug 2014 09:03:41 -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 98522 invoked by uid 99); 12 Aug 2014 09:03:41 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Aug 2014 09:03:41 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Jonathan.Demeyer@macq.eu designates 109.135.2.61 as permitted sender) Received: from [109.135.2.61] (HELO smtp2.macqel.be) (109.135.2.61) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Aug 2014 09:03:36 +0000 Received: from localhost (localhost [127.0.0.1]) by smtp2.macqel.be (Postfix) with ESMTP id 31C4D130F25 for ; Tue, 12 Aug 2014 11:03:15 +0200 (CEST) X-Virus-Scanned: amavisd-new at macqel.be Received: from smtp2.macqel.be ([127.0.0.1]) by localhost (mail.macqel.be [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lKAvixAmrgoM for ; Tue, 12 Aug 2014 11:03:08 +0200 (CEST) Received: from EXCHANGE01.macqel (mail.macqel.be [10.1.40.246]) by smtp2.macqel.be (Postfix) with ESMTP id E9BAE130D2B for ; Tue, 12 Aug 2014 11:03:07 +0200 (CEST) Received: from EXCHANGE01.macqel ([fe80::e465:169f:884d:d529]) by EXCHANGE01.macqel ([fe80::e465:169f:884d:d529%20]) with mapi id 14.01.0438.000; Tue, 12 Aug 2014 11:03:07 +0200 From: Demeyer Jonathan To: "user@cassandra.apache.org" Subject: Cassandra schema disagreement Thread-Topic: Cassandra schema disagreement Thread-Index: Ac+2DDskhHK9lxrhT5KF2bQlLA4Afw== Date: Tue, 12 Aug 2014 09:03:06 +0000 Message-ID: <58864417ED5920429A5FCEB17B6B883D14E89CEF@EXCHANGE01.macqel> Accept-Language: fr-FR, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.1.41.92] Content-Type: multipart/alternative; boundary="_000_58864417ED5920429A5FCEB17B6B883D14E89CEFEXCHANGE01macqe_" MIME-Version: 1.0 X-Antivirus: avast! (VPS 140812-0, 08/12/2014), Outbound message X-Antivirus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org --_000_58864417ED5920429A5FCEB17B6B883D14E89CEFEXCHANGE01macqe_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, I have a cluster running and I'm trying to change the schema on it. Altough= it succeeds on one cluster (a test one), on another it keeps creating two = separate schema versions (both are 2 DC configuration; the cluster where it= goes wrong end up with a schema version on each DC). I use apache-cassandra11-1.1.12 on CentOS 6.4 I'm trying to start from a fresh cassandra config (doing " rm -rf /var/lib/= cassandra/{commitlog,data}/* " while cassandra is stopped). Each DC are on separate IP segment but there are no firewall between them. Here is the output of the command when the desynchronisation occurs: --- [root@cassandranode00 CDN]# cassandra-cli -f reCreateCassandraStruct.sh Connected to: "TTF Cluster v20131111_1257" on 127.0.0.1/9160 7ef8c681-189a-3088-8598-560437f705d9 Waiting for schema agreement... ... schemas agree across the cluster Authenticated to keyspace: ks1 f179fd8e-f8ca-36cf-bf53-d8341fd6006e Waiting for schema agreement... The schema has not settled in 10 seconds; further migrations are ill-advise= d until it does. Versions are f179fd8e-f8ca-36cf-bf53-d8341fd6006e:[10.69.221.20, 10.69.221.= 21, 10.69.221.22], e9656b30-b671-3fce-9fb4-bdd3e6da36d1:[1 = 0.69.10.14, 10.69.10.13, 10.69.10.11] --- I also try creating a keyspace with a column family using the opscenter (wi= th no good result). I'm out of hint to where to look. Do you have some suggestions ? Is there improvements on this side with cassandra > 1.1.12 ? Thanks, Jonathan DEMEYER Here is the start of reCreateCassandraStruct.sh : CREATE KEYSPACE ks1 WITH placement_strategy =3D 'NetworkTopologyStrategy' A= ND strategy_options=3D{DC1:3,DC2:3}; use ks1; create column family id with comparator =3D 'UTF8Type' and key_validation_class =3D 'UTF8Type' and column_metadata =3D [ { column_name : 'user', validation_class : UTF8Type } ]; CREATE KEYSPACE ks2 WITH placement_strategy =3D 'NetworkTopologyStrategy' A= ND strategy_options=3D{DC1:3,DC2:3}; use ks2; create column family id; --_000_58864417ED5920429A5FCEB17B6B883D14E89CEFEXCHANGE01macqe_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hel= lo,
 
I h= ave a cluster running and I'm trying to change the schema on it. Altough it= succeeds on one cluster (a test one), on another it keeps creating two sep= arate schema versions (both are 2 DC configuration; the cluster where it goes wrong end up with a schema version on each = DC).
 
I u= se apache-cassandra11-1.1.12 on CentOS 6.4
 
I'm= trying to start from a fresh cassandra config (doing " rm -rf /var/lib/cassandra/{commitlog,data}/* " while= cassandra is stopped).
 
Eac= h DC are on separate IP segment but there are no firewall between them.
 
Her= e is the output of the command when the desynchronisation occurs:
---=
[ro= ot@cassandranode00 CDN]# cassandra-cli -f reCreateCassandraStruct.sh
Connected to: "TTF Cluster v20131111_1257" on 127.0.0.1/9160
7ef8c681-189a-3088-8598-560437f705d9
Waiting for schema agreement...
... schemas agree across the cluster
Authenticated to keyspace: ks1
f179fd8e-f8ca-36cf-bf53-d8341fd6006e
Waiting for schema agreement...
The schema has not settled in 10 seconds; further migrations are ill-advise= d until it does.
Versions are f179fd8e-f8ca-36cf-bf53-d8341fd6006e:[10.69.221.20, 10.69.221.= 21, 10.69.221.22], e9656b30-b671-3fce-9fb4-bdd3e6da36d1:[1   = ;            &n= bsp;    0.69.10.14, 10.69.10.13, 10.69.10.11]<= /div>
---=
 
I a= lso try creating a keyspace with a column family using the opscenter (with = no good result).
 
I'm= out of hint to where to look. Do you have some suggestions ?=
 
Is = there improvements on this side with cassandra > 1.1.12 ?<= /div>
 
Tha= nks,

Jonathan DEMEYER

Here is the = start of reCreateCassandraStruct.sh :

CREATE KEYSP= ACE ks1 WITH placement_strategy =3D 'NetworkTopologyStrategy' AND strategy_options=3D{DC1:3,DC2:3};
use ks1;
create column family id
with comparator =3D 'UTF8Type'
and key_validation_class =3D 'UTF8Type'
and column_metadata =3D [
{
column_name : 'user',
validation_class : UTF8Type
}
];
CREATE KEYSPACE ks2 WITH placement_strategy =3D 'NetworkTopologyStrategy' A= ND strategy_options=3D{DC1:3,DC2:3};
use ks2;
create column family id;

--_000_58864417ED5920429A5FCEB17B6B883D14E89CEFEXCHANGE01macqe_--