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 32622EC2A for ; Wed, 20 Feb 2013 09:53:46 +0000 (UTC) Received: (qmail 17313 invoked by uid 500); 20 Feb 2013 09:53:43 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 17210 invoked by uid 500); 20 Feb 2013 09:53:42 -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 17191 invoked by uid 99); 20 Feb 2013 09:53:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Feb 2013 09:53:42 +0000 X-ASF-Spam-Status: No, hits=2.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of abhijit.chanda0@gmail.com designates 74.125.82.176 as permitted sender) Received: from [74.125.82.176] (HELO mail-we0-f176.google.com) (74.125.82.176) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Feb 2013 09:53:35 +0000 Received: by mail-we0-f176.google.com with SMTP id s43so6308602wey.7 for ; Wed, 20 Feb 2013 01:53:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:x-received:in-reply-to:references:date:message-id :subject:from:to:content-type; bh=seTWDKc6YTMZmC2GHR0PIq2cA2PQJds/C9cNGrkf/BY=; b=k3Z/p5PxLzEfu2nNejmL+mTHJVVcOeRv6CgcVKr6ysyV/sqzVsqSw+c8LrwBiTzCql SpupNQRd7N7C/7KTF5ZU8uMh6xpY0/7Bd9phQUINeDKBxMkMUORSxRqqyuOB8nRRZnSb g8+ftiQHt+ceR61B3ZKSE6fnixFfrG2aoi0FJwszgM4YR977DfG2/FhnVLTCTo5ufj5g ixqPS727pBYGZ8zH9p9WNKaHQIoP58UBYzRdzMMuBbEHm36PQ+jBAEgsv1fslVyqM1sS KZNCxN2okE2w4vE5r4AbUX1FIpqu7Zx9FgN31Vb7AMZsCctAkuOVMQygRdwLme2RmEZO vV/w== MIME-Version: 1.0 X-Received: by 10.180.75.177 with SMTP id d17mr31379183wiw.16.1361353995368; Wed, 20 Feb 2013 01:53:15 -0800 (PST) Received: by 10.180.104.34 with HTTP; Wed, 20 Feb 2013 01:53:15 -0800 (PST) In-Reply-To: References: Date: Wed, 20 Feb 2013 15:23:15 +0530 Message-ID: Subject: Re: UnavailableException() for keyspace From: Abhijit Chanda To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f46d043c811e4eb7a704d624eda0 X-Virus-Checked: Checked by ClamAV on apache.org --f46d043c811e4eb7a704d624eda0 Content-Type: text/plain; charset=ISO-8859-1 It looks like some keyspace creation issue. Can you paste the keyspace creation schema? On Wed, Feb 20, 2013 at 9:09 AM, Marcelo Elias Del Valle wrote: > Hello, > > I have a cluster with 3 nodes, all of them configured as seeds and > with correct listen_addess. If I run nodetool ring on any of the nodes, it > seems ok: > *$ nodetool ring* > *Address DC Rack Status State Load > Effective-Ownership Token * > * > 113427455640312821154458202477256070485 * > *10.84.65.108 us-east 1b Up Normal 69.46 KB > 0.00% 0 * > *10.76.82.94 us-east 1b Up Normal 61.39 KB > 0.00% 56713727820156410577229101238628035242 * > *10.242.139.188 us-east 1b Up Normal 65.71 KB > 0.00% 113427455640312821154458202477256070485 * > > However, in any of the nodes, if I connect to cassandra-cli and try to > list a CF, I get unavailableException: > > *[default@unknown] use dmp_input; > * > *[default@dmp_input] list user;* > *Using default limit of 100* > *Using default column limit of 100* > *null* > *UnavailableException()* > * at > org.apache.cassandra.thrift.Cassandra$get_range_slices_result.read(Cassandra.java:12441) > * > * at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)* > * at > org.apache.cassandra.thrift.Cassandra$Client.recv_get_range_slices(Cassandra.java:696) > * > * at > org.apache.cassandra.thrift.Cassandra$Client.get_range_slices(Cassandra.java:680) > * > * at org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1425)* > * at > org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:273) > * > * at > org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:219) > * > * at org.apache.cassandra.cli.CliMain.main(CliMain.java:346)* > > Any hint what I could be doing wrong and what to look for? > > I created the keyspace with NetworkTopologyStrategy and I am using > Ec2Snitch. > > Thanks in advance. > > Best regards, > -- > Marcelo Elias Del Valle > http://mvalle.com - @mvallebr > -- Abhijit Chanda +91-9748888395 --f46d043c811e4eb7a704d624eda0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
It looks like some keyspace creation issue. Can you paste = the keyspace creation schema?


On Wed, Feb 20, 2013 at 9:09 AM, Marcelo Elias Del Va= lle <mvallebr@gmail.com> wrote:
Hello,

= =A0 =A0 I have a cluster with 3 nodes, all of them configured as seeds and = with correct listen_addess. If I run nodetool ring on any of the nodes, it = seems ok:
$ nodetool ring<= /i>
Address = =A0 =A0 =A0 =A0 DC =A0 =A0 =A0 =A0 =A0Rack =A0 =A0 =A0 =A0Status State =A0 = Load =A0 =A0 =A0 =A0 =A0 =A0Effective-Ownership Token =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0
=A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0113427455640312821154458202477256070485 =A0 =A0=A0
10.84.6= 5.108 =A0 =A0us-east =A0 =A0 1b =A0 =A0 =A0 =A0 =A0Up =A0 =A0 Normal =A069.= 46 KB =A0 =A0 =A0 =A00.00% =A0 =A0 =A0 =A0 =A0 =A0 =A0 0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0
10.76.82.94 =A0 = =A0 us-east =A0 =A0 1b =A0 =A0 =A0 =A0 =A0Up =A0 =A0 Normal =A061.39 KB =A0= =A0 =A0 =A00.00% =A0 =A0 =A0 =A0 =A0 =A0 =A0 56713727820156410577229101238= 628035242 =A0 =A0 =A0
10.242.139.188 =A0us-east =A0 =A0 1b =A0 =A0 =A0 =A0 = =A0Up =A0 =A0 Normal =A065.71 KB =A0 =A0 =A0 =A00.00% =A0 =A0 =A0 =A0 =A0 = =A0 =A0 113427455640312821154458202477256070485=A0

=A0 =A0 However, in any of the nodes, if I connec= t to cassandra-cli and try to list a CF, I get unavailableException:
<= div>
[default@unknown] = use dmp_input;
[default@dmp_input] list user;
Using default limi= t of 100
Using default column limit of 100
null
UnavailableExcepti= on()
at org.apache.cassandra.thr= ift.Cassandra$get_range_slices_result.read(Cassandra.java:12441)=
at org.apache.thrift.TServiceClient.receiveBase(= TServiceClient.java:78)
at org.a= pache.cassandra.thrift.Cassandra$Client.recv_get_range_slices(Cassandra.jav= a:696)
at org.apache.cassandra.thrift.Cassandra$Client.= get_range_slices(Cassandra.java:680)
at org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1425)=
at org.apache.cassandra.cli.CliClient.executeCLI= Statement(CliClient.java:273)
at= org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:= 219)
at org.apache.cassandra.cli.CliMain.main(CliMain= .java:346)

=A0 =A0 Any hint what I coul= d be doing wrong and what to look for?=A0
=A0 =A0=A0
=A0 =A0 =A0I created the keyspace with=A0NetworkT= opologyStrategy and I am using Ec2Snitch.

Th= anks in advance.

Best regards,
--
Marcelo Elias Del Valle
http://mvalle.com=A0- @= mvallebr



--
Abhijit Chanda
+91-9748888395
--f46d043c811e4eb7a704d624eda0--