From user-return-19370-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Tue Aug 2 09:20:49 2011 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 A7B8966D1 for ; Tue, 2 Aug 2011 09:20:49 +0000 (UTC) Received: (qmail 59305 invoked by uid 500); 2 Aug 2011 09:20:44 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 58546 invoked by uid 500); 2 Aug 2011 09:20:24 -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 58538 invoked by uid 99); 2 Aug 2011 09:20:21 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2011 09:20:21 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a46.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Aug 2011 09:20:16 +0000 Received: from homiemail-a46.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a46.g.dreamhost.com (Postfix) with ESMTP id 658493E405B for ; Tue, 2 Aug 2011 02:19:50 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; q=dns; s=thelastpickle.com; b=q/A3X005MS TysJKSlJTVDUsJQwAsT9mXnR/T6QINwrC96h0Cy8hu4y90wsy8iYWFcCd2LWnyUG Uu4de/V9i6lo1U6Wi3rmxqrn9jrx0+ZBROGBqvxSTSu612Y3b942Fmwe1lZFQxA0 bf6zBwRLHojPgDZx82XxlGfVLqwzn1/+0= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; s=thelastpickle.com; bh=hvcXMOyRXX7xV7f5 UWmOEWMNMro=; b=0MBQSHFOL0eut246QWN7JITQUMFEw4z4PJqxQmGP8fZJO0V+ zMuvQUO36WDwLNIzRDRPzm5xc8Qcrvc0bDtFLGDJYQ04zrnD/oZZFvO1I2Tjy2AH 0ihG2ARyHfH1zACD0b6Ppi0DFl0CcXhUcH1PyQuJ8Ool8jaZO5D5ZvfbwjU= Received: from aarons-mbp-2011.lan (122-57-124-115.jetstream.xtra.co.nz [122.57.124.115]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a46.g.dreamhost.com (Postfix) with ESMTPSA id 9981A3E4058 for ; Tue, 2 Aug 2011 02:19:49 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1244.3) Content-Type: multipart/alternative; boundary="Apple-Mail=_ED84B4C7-1BD0-485D-9061-749EB8A41CAF" Subject: Re: Schema Disagreement Date: Tue, 2 Aug 2011 21:19:47 +1200 In-Reply-To: To: user@cassandra.apache.org References: <6F38F03A-5E49-4DE1-A865-15267FD896B1@me.com> Message-Id: X-Mailer: Apple Mail (2.1244.3) --Apple-Mail=_ED84B4C7-1BD0-485D-9061-749EB8A41CAF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 What do you see when you run describe cluster; in the cassandra-cli ? = Whats the exact error you get and is there anything in the server side = logs ? Have you added other CF's before adding this one ? Did the schema agree = before starting this statement? I ran the statement below on the current trunk and it worked.=20 Cheers ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 2 Aug 2011, at 12:08, Dikang Gu wrote: > I thought the schema disagree problem was already solved in 0.8.1... >=20 > On possible solution is to decommission the disagree node and rejoin = it. >=20 >=20 > On Tue, Aug 2, 2011 at 8:01 AM, Yi Yang wrote: > Dear all, >=20 > I'm always meeting mp with schema disagree problems while trying to = create a column family like this, using cassandra-cli: >=20 > create column family sd > with column_type =3D 'Super' > and key_validation_class =3D 'UUIDType' > and comparator =3D 'LongType' > and subcomparator =3D 'UTF8Type' > and column_metadata =3D [ > { > column_name: 'time', > validation_class : 'LongType' > },{ > column_name: 'open', > validation_class : 'FloatType' > },{ > column_name: 'high', > validation_class : 'FloatType' > },{ > column_name: 'low', > validation_class : 'FloatType' > },{ > column_name: 'close', > validation_class : 'FloatType' > },{ > column_name: 'volumn', > validation_class : 'LongType' > },{ > column_name: 'splitopen', > validation_class : 'FloatType' > },{ > column_name: 'splithigh', > validation_class : 'FloatType' > },{ > column_name: 'splitlow', > validation_class : 'FloatType' > },{ > column_name: 'splitclose', > validation_class : 'FloatType' > },{ > column_name: 'splitvolume', > validation_class : 'LongType' > },{ > column_name: 'splitclose', > validation_class : 'FloatType' > } > ] > ; >=20 > I've tried to erase everything and restart Cassandra but this still = happens. But when I clear the column_metadata section this no more = disagreement error. Do you have any idea why this happens? >=20 > Environment: 2 VMs, using the same harddrive, Cassandra 0.8.1, Ubuntu = 10.04 > This is for testing only. We'll move to dedicated servers later. >=20 > Best regards, > Yi >=20 >=20 >=20 > --=20 > Dikang Gu >=20 > 0086 - 18611140205 >=20 --Apple-Mail=_ED84B4C7-1BD0-485D-9061-749EB8A41CAF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 What = do you see when you run describe cluster; in the cassandra-cli ? Whats = the exact error you get and is there anything in the server side logs = ?

Have you added other CF's before adding this one ? = Did the schema agree before starting this = statement?

I ran the statement below on the = current trunk and it = worked. 

Cheers

http://www.thelastpickle.com

On 2 Aug 2011, at 12:08, Dikang Gu wrote:

I thought = the schema disagree problem was already solved in = 0.8.1...

On possible solution is to decommission the = disagree node and rejoin it.


On Tue, Aug 2, 2011 at 8:01 AM, Yi Yang <yyang@me.com> wrote:
Dear all,

I'm always meeting mp with schema disagree problems while trying to = create a column family like this, using cassandra-cli:

create column family sd
   with column_type =3D 'Super'
   and key_validation_class =3D 'UUIDType'
   and comparator =3D 'LongType'
   and subcomparator =3D 'UTF8Type'
   and column_metadata =3D [
       {
       column_name: 'time',
       validation_class : 'LongType'
       },{
       column_name: 'open',
       validation_class : 'FloatType'
       },{
       column_name: 'high',
       validation_class : 'FloatType'
       },{
       column_name: 'low',
       validation_class : 'FloatType'
       },{
       column_name: 'close',
       validation_class : 'FloatType'
       },{
       column_name: 'volumn',
       validation_class : 'LongType'
       },{
       column_name: 'splitopen',
       validation_class : 'FloatType'
       },{
       column_name: 'splithigh',
       validation_class : 'FloatType'
       },{
       column_name: 'splitlow',
       validation_class : 'FloatType'
       },{
       column_name: 'splitclose',
       validation_class : 'FloatType'
       },{
       column_name: 'splitvolume',
       validation_class : 'LongType'
       },{
       column_name: 'splitclose',
       validation_class : 'FloatType'
       }
   ]
;

I've tried to erase everything and restart Cassandra but this still = happens.   But when I clear the column_metadata section this no = more disagreement error.   Do you have any idea why this = happens?

Environment: 2 VMs, using the same harddrive, Cassandra 0.8.1, Ubuntu = 10.04
This is for testing only.   We'll move to dedicated servers = later.

Best regards,
Yi



--
Dikang = Gu

0086 - 18611140205


= --Apple-Mail=_ED84B4C7-1BD0-485D-9061-749EB8A41CAF--