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 29EAC7B93 for ; Tue, 18 Oct 2011 20:35:41 +0000 (UTC) Received: (qmail 96344 invoked by uid 500); 18 Oct 2011 20:35:39 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 96317 invoked by uid 500); 18 Oct 2011 20:35:39 -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 96309 invoked by uid 99); 18 Oct 2011 20:35:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Oct 2011 20:35:39 +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-a42.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Oct 2011 20:35:32 +0000 Received: from homiemail-a42.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a42.g.dreamhost.com (Postfix) with ESMTP id D9EBD68C05D for ; Tue, 18 Oct 2011 13:35:08 -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=cO13ZPpkAh sWC3wmpoW4X1P2bC7q5F31XcPnVbzBhcTwt62VmUK71zLtgjt1qHpS9an9lSiwzx pYXN4iulw8xOk6d8tr7nilxmErlHgiOpYY7Dvq20fQJRmThjeqLNOJZzx58HEEYt hS+CbAsAgIrvSS5AUBw8uOm6SR7APpjt0= 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=NBW6jesSf6LlP9wd jAN/8O5waQA=; b=P50mUtXcPyZ9j9czpRQuIqu+rWN17snPYd0Eyr7gVF4GTfdc +QlmIIeTLQ2LkZmlCW4jt03EH3HYW+D/5y+eW/Cv6jb3E4xJ32H3DXDqpnBRWGQA 23VgPQWPi2Bf/ja2pUv5wYXm1an94WD6xjzLCTxWtVDNr92ya4ZgESMceFQ= Received: from [172.16.1.4] (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-a42.g.dreamhost.com (Postfix) with ESMTPSA id 300B268C058 for ; Tue, 18 Oct 2011 13:35:08 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1251.1) Content-Type: multipart/alternative; boundary="Apple-Mail=_8AF4975D-110B-4575-A738-1B9C526AC07D" Subject: Re: show schema fails Date: Wed, 19 Oct 2011 09:35:04 +1300 In-Reply-To: <4E9D0DF8.7060900@sendmail.cz> To: user@cassandra.apache.org References: <4E9982E5.8040401@sendmail.cz> <4E9D0DF8.7060900@sendmail.cz> Message-Id: X-Mailer: Apple Mail (2.1251.1) --Apple-Mail=_8AF4975D-110B-4575-A738-1B9C526AC07D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-2 Looks like the column meta for the CF specifies a column name that is = not a valid Long. I seem to remember a bug like this something in the = past.=20 You should be able to work around this by running ALTER COLUMN FAMILY = and only specifying valid column meta data.=20 Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/10/2011, at 6:26 PM, Radim Kolar wrote: > Dne 17.10.2011 22:06, aaron morton napsal(a): >> Hi there, >> If you start cassandra-cli with --debug it will output a stack = trace if the error is client side. > A long is exactly 8 bytes: 5 > java.lang.RuntimeException: A long is exactly 8 bytes: 5 > at = org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310)= > at = org.apache.cassandra.cli.CliMain.processStatement(CliMain.java:217) > at org.apache.cassandra.cli.CliMain.main(CliMain.java:345) > Caused by: org.apache.cassandra.db.marshal.MarshalException: A long is = exactly 8 bytes: 5 > at = org.apache.cassandra.db.marshal.LongType.getString(LongType.java:72) > at = org.apache.cassandra.cli.CliClient.showColumnMeta(CliClient.java:1710) > at = org.apache.cassandra.cli.CliClient.showColumnFamily(CliClient.java:1687) > at = org.apache.cassandra.cli.CliClient.showKeyspace(CliClient.java:1637) > at = org.apache.cassandra.cli.CliClient.executeShowSchema(CliClient.java:1598) > at = org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:250)= > ... 2 more >=20 > No error in server log. cli expect long value but in database is = stored something different. it should not be possible to store different = type if column has metadata set. --Apple-Mail=_8AF4975D-110B-4575-A738-1B9C526AC07D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-2 Looks = like the column meta for the CF specifies a column name that is not a = valid Long. I seem to remember a bug like this something in the = past. 

You should be able to work around this by = running  ALTER COLUMN FAMILY and only specifying valid column meta = data. 

Cheers

http://www.thelastpickle.com

On 18/10/2011, at 6:26 PM, Radim Kolar wrote:

Dne = 17.10.2011 22:06, aaron morton napsal(a):
Hi = there,
If you = start cassandra-cli with --debug it will output a stack trace if the = error is client side.
A long is exactly 8 bytes: = 5
java.lang.RuntimeException: A long is exactly 8 bytes: 5
=        at = org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:310)=
       at = org.apache.cassandra.cli.CliMain.processStatement(CliMain.java:217)
=        at = org.apache.cassandra.cli.CliMain.main(CliMain.java:345)
Caused by: = org.apache.cassandra.db.marshal.MarshalException: A long is exactly 8 = bytes: 5
       at = org.apache.cassandra.db.marshal.LongType.getString(LongType.java:72)
=        at = org.apache.cassandra.cli.CliClient.showColumnMeta(CliClient.java:1710)
=        at = org.apache.cassandra.cli.CliClient.showColumnFamily(CliClient.java:1687)        at = org.apache.cassandra.cli.CliClient.showKeyspace(CliClient.java:1637)
=        at = org.apache.cassandra.cli.CliClient.executeShowSchema(CliClient.java:1598)<= br>        at = org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:250)=
       ... 2 more

No = error in server log. cli expect long value but in database is stored = something different. it should not be possible to store different type = if column has metadata = set.

= --Apple-Mail=_8AF4975D-110B-4575-A738-1B9C526AC07D--