From user-return-24494-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Mar 1 17:45:59 2012 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 44E4599D8 for ; Thu, 1 Mar 2012 17:45:59 +0000 (UTC) Received: (qmail 87342 invoked by uid 500); 1 Mar 2012 17:45:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 87311 invoked by uid 500); 1 Mar 2012 17:45:56 -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 87301 invoked by uid 99); 1 Mar 2012 17:45:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2012 17:45:56 +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-a47.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2012 17:45:51 +0000 Received: from homiemail-a47.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a47.g.dreamhost.com (Postfix) with ESMTP id 29E6628406E for ; Thu, 1 Mar 2012 09:45:30 -0800 (PST) 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=bojZAYJSSc z1OK8RBQo5xXVoYyKXe9qa2fs8OR2wGEtN91LfOCtAGEkyCeIfy5oDXFD55/pBtK WTuxuX0+NjKOGsW0PEvYzKmSfXhfzMyLArfZtMMvm+etcdjT8XM8kG/oqaJBlVpW jdFTVEA8uEB/hCyGFEXhPeEfnhSzR3rIM= 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=KLRAYNZ/vJGOdmGI eqfQFLVIla4=; b=nRyTQJj57yvD4CZN/RDIlFuTkuZv4OfzUB3lon9fGS/xgAty pAqVAI1JQ2YqAOkMAMuQOcvWWNzaICbqhpmHGtgCgW0BqZqeuaoV33sEsnXQW22F 3eHKIiX3xfv0WoH/F7oYKIHXASVl0TnAGJ2KNWwNpORZetCazCNWdLe/sZM= Received: from [172.16.1.3] (125-236-193-159.adsl.xtra.co.nz [125.236.193.159]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a47.g.dreamhost.com (Postfix) with ESMTPSA id 6F830284065 for ; Thu, 1 Mar 2012 09:45:29 -0800 (PST) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1257) Content-Type: multipart/alternative; boundary="Apple-Mail=_C6FA91A0-CB96-4C75-B90F-204DA06D786D" Subject: Re: Schema change causes exception when adding data Date: Fri, 2 Mar 2012 06:45:26 +1300 In-Reply-To: To: user@cassandra.apache.org References: <05CEA178DD88EE4FA89EED77C245F84916414DAF@msex85.morningstar.com> Message-Id: <49BABB83-0D56-4FFD-9903-FD96C8DFA145@thelastpickle.com> X-Mailer: Apple Mail (2.1257) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_C6FA91A0-CB96-4C75-B90F-204DA06D786D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 use describe cluster in the CLI to see how many schema versions there = are.=20 Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2/03/2012, at 12:25 AM, Tharindu Mathew wrote: >=20 >=20 > On Thu, Mar 1, 2012 at 11:47 AM, Tharindu Mathew = wrote: > Jeremiah, >=20 > Thanks for the reply. >=20 > This is what we have been doing, but it's not reliable as we don't = know a definite time that the schema would get replicated. Is there any = way I can know for sure that changes have propagated? > [Edit: corrected to a question]=20 >=20 > Then I can block the insertion of data until then. >=20 >=20 > On Thu, Mar 1, 2012 at 4:33 AM, Jeremiah Jordan = wrote: > The error is that the specified colum family doesn=92t exist. If you = connect with the CLI and describe the keyspace does it show up? Also, = after adding a new column family programmatically you can=92t use it = immediately, you have to wait for it to propagate. You can use calls to = describe schema to do so, keep calling it until every node is on the = same schema. >=20 > =20 >=20 > -Jeremiah >=20 > =20 >=20 > From: Tharindu Mathew [mailto:mccloud35@gmail.com]=20 > Sent: Wednesday, February 29, 2012 8:27 AM > To: user > Subject: Schema change causes exception when adding data >=20 > =20 >=20 > Hi, >=20 > I have a 3 node cluster and I'm dynamically updating a keyspace with a = new column family. Then, when I try to write records to it I get the = following exception shown at [1]. >=20 > How do I avoid this. I'm using Hector and the default consistency = level of QUORUM is used. Cassandra version 0.7.8. Replication Factor is = 1. >=20 > How can I solve my problem? >=20 > [1] - > me.prettyprint.hector.api.exceptions.HInvalidRequestException: = InvalidRequestException(why:unconfigured columnfamily proxySummary) >=20 > at = me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(Except= ionsTranslatorImpl.java:42) >=20 > at = me.prettyprint.cassandra.service.KeyspaceServiceImpl$10.execute(KeyspaceSe= rviceImpl.java:397) >=20 > at = me.prettyprint.cassandra.service.KeyspaceServiceImpl$10.execute(KeyspaceSe= rviceImpl.java:383) >=20 > at = me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.j= ava:101) >=20 > at = me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover= (HConnectionManager.java:156) >=20 > at = me.prettyprint.cassandra.service.KeyspaceServiceImpl.operateWithFailover(K= eyspaceServiceImpl.java:129) >=20 > at = me.prettyprint.cassandra.service.KeyspaceServiceImpl.multigetSlice(Keyspac= eServiceImpl.java:401) >=20 > at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery$1.doInKeysp= ace(ThriftMultigetSliceQuery.java:67) >=20 > at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery$1.doInKeysp= ace(ThriftMultigetSliceQuery.java:59) >=20 > at = me.prettyprint.cassandra.model.KeyspaceOperationCallback.doInKeyspaceAndMe= asure(KeyspaceOperationCallback.java:20) >=20 > at = me.prettyprint.cassandra.model.ExecutingKeyspace.doExecute(ExecutingKeyspa= ce.java:72) >=20 > at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery.execute(Thr= iftMultigetSliceQuery.java:58) >=20 >=20 >=20 > --=20 > Regards, >=20 > Tharindu >=20 > =20 >=20 > blog: http://mackiemathew.com/ >=20 > =20 >=20 >=20 >=20 >=20 > --=20 > Regards, >=20 > Tharindu >=20 > blog: http://mackiemathew.com/ >=20 >=20 >=20 >=20 > --=20 > Regards, >=20 > Tharindu >=20 > blog: http://mackiemathew.com/ >=20 --Apple-Mail=_C6FA91A0-CB96-4C75-B90F-204DA06D786D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 use = describe cluster in the CLI to see how many schema versions there = are. 

Cheers

http://www.thelastpickle.com

On 2/03/2012, at 12:25 AM, Tharindu Mathew wrote:



On Thu, Mar 1, 2012 at 11:47 AM, Tharindu Mathew = <mccloud35@gmail.com> = wrote:
Jeremiah,

Thanks for the reply.

This is what we have been = doing, but it's not reliable as we don't know a definite time that the = schema would get replicated. Is there any way I can know for sure that = changes have propagated?
[Edit: corrected to a question]

Then I can block the insertion of data until then.


On = Thu, Mar 1, 2012 at 4:33 AM, Jeremiah Jordan <JEREMIAH.JORDAN@morningstar.com> = wrote:

The error is that the specified colum family = doesn=92t exist.  If you connect with the CLI and describe the keyspace does it show = up?  Also, after adding a new column family programmatically you can=92t use it = immediately, you have to wait for it to propagate.  You can use calls to describe = schema to do so, keep calling it until every node is on the same = schema.

 

-Jeremiah

 

From: Tharindu Mathew [mailto:mccloud35@gmail.com]
Sent: Wednesday, February 29, 2012 8:27 AM
To: user
Subject: Schema change causes exception when adding = data

 

Hi,

I have a 3 node cluster and I'm dynamically updating a keyspace with a = new column family. Then, when I try to write records to it I get the = following exception shown at [1].

How do I avoid this. I'm using Hector and the default consistency level = of QUORUM is used. Cassandra version 0.7.8. Replication Factor is 1.

How can I solve my problem?

[1] -
me.prettyprint.hector.api.exceptions.HInvalidRequestException: InvalidRequestException(why:unconfigured columnfamily = proxySummary)

at = me.prettyprint.cassandra.service.ExceptionsTranslatorImpl.translate(Except= ionsTranslatorImpl.java:42)

at = me.prettyprint.cassandra.service.KeyspaceServiceImpl$10.execute(KeyspaceSe= rviceImpl.java:397)

at = me.prettyprint.cassandra.service.KeyspaceServiceImpl$10.execute(KeyspaceSe= rviceImpl.java:383)

at = me.prettyprint.cassandra.service.Operation.executeAndSetResult(Operation.j= ava:101)

at = me.prettyprint.cassandra.connection.HConnectionManager.operateWithFailover= (HConnectionManager.java:156)

at = me.prettyprint.cassandra.service.KeyspaceServiceImpl.operateWithFailover(K= eyspaceServiceImpl.java:129)

at = me.prettyprint.cassandra.service.KeyspaceServiceImpl.multigetSlice(Keyspac= eServiceImpl.java:401)

at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery$1.doInKeysp= ace(ThriftMultigetSliceQuery.java:67)

at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery$1.doInKeysp= ace(ThriftMultigetSliceQuery.java:59)

at = me.prettyprint.cassandra.model.KeyspaceOperationCallback.doInKeyspaceAndMe= asure(KeyspaceOperationCallback.java:20)

at = me.prettyprint.cassandra.model.ExecutingKeyspace.doExecute(ExecutingKeyspa= ce.java:72)

at = me.prettyprint.cassandra.model.thrift.ThriftMultigetSliceQuery.execute(Thr= iftMultigetSliceQuery.java:58)



--
Regards,

Tharindu

 

 




-- =
Regards,

Tharindu





-- =
Regards,

Tharindu



= --Apple-Mail=_C6FA91A0-CB96-4C75-B90F-204DA06D786D--