Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 743E5200C44 for ; Mon, 27 Mar 2017 19:47:05 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 71480160B85; Mon, 27 Mar 2017 17:47:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 68093160B7B for ; Mon, 27 Mar 2017 19:47:04 +0200 (CEST) Received: (qmail 48687 invoked by uid 500); 27 Mar 2017 17:47:02 -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 48676 invoked by uid 99); 27 Mar 2017 17:47:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Mar 2017 17:47:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2EF03180993 for ; Mon, 27 Mar 2017 17:47:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, KAM_NUMSUBJECT=0.5, RCVD_IN_MSPIKE_H4=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=winguzone.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id ePZEKQGUmAuy for ; Mon, 27 Mar 2017 17:47:00 +0000 (UTC) Received: from sender-of-o52.zoho.com (sender-of-o52.zoho.com [135.84.80.217]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id B19585FACC for ; Mon, 27 Mar 2017 17:46:59 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1490636808; s=zoho; d=winguzone.com; i=vladyu@winguzone.com; h=Date:From:To:Message-Id:In-Reply-To:References:Subject:MIME-Version:Content-Type; l=14561; bh=5WNvsooFVueVjKyKJsKP/MZ8pZDBo+N0hhW7VNkyWhw=; b=Iysyx/e2CnUyt0qAzWTyjz2Ykowp4hrFo9OCfw4p/ULWWs14PcxyKsGGROO0ccud m2D0BGi2KgdQ/TqfR38mLAAKVFDVxxx728VannoITuyoRFxoIOWQYYRvNnsZ2m58ztj 9lw5cRDXp/siaUAlDnTiyinYTZEYn/eLlnfUgTac= Received: from mail.zoho.com by mx.zohomail.com with SMTP id 1490636808379272.95575500051154; Mon, 27 Mar 2017 10:46:48 -0700 (PDT) Date: Mon, 27 Mar 2017 13:46:48 -0400 From: Vladimir Yudovin To: "user" Message-Id: <15b10e0a0a8.10c63c786269669.245283493098114916@winguzone.com> In-Reply-To: References: <297422883.3856282.1490444219661@mail.yahoo.com> Subject: Re: Weird error: InvalidQueryException: unconfigured table table2 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_852963_1934067966.1490636808376" X-Priority: Medium User-Agent: Zoho Mail X-Mailer: Zoho Mail archived-at: Mon, 27 Mar 2017 17:47:05 -0000 ------=_Part_852963_1934067966.1490636808376 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit >Just wish that an error like: "Table x not found in keyspace y" You are welcome to open JIRA with type Improvement. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting ---- On Sun, 26 Mar 2017 13:31:33 -0400 S G <sg.online.email@gmail.com> wrote ---- Thanks, got it working now :) Just wish that an error like: "Table x not found in keyspace y" would have been much better than: "Table x not configured". On Sat, Mar 25, 2017 at 6:13 AM, Arvydas Jonusonis <arvydas.jonusonis@gmail.com> wrote: Make sure to prefix the table with the keyspace. On Sat, Mar 25, 2017 at 13:28 Anuj Wadehra <anujw_2003@yahoo.co.in> wrote: Ensure that all the nodes are on same schema version such that table2 schema is replicated properly on all the nodes. Thanks Anuj Sent from Yahoo Mail on Android On Sat, Mar 25, 2017 at 3:19 AM, S G <sg.online.email@gmail.com> wrote: Hi, I have a keyspace with two tables. I run a different query for each table: Table 1: Select * from table1 where id = ? Table 2: Select * from table2 where id1 = ? and id = ? My code using datastax fires above two queries one after the other. While it never fails for table 1, it never succeeds for table 2 And gives an error: com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table table2 at com.datastax.driver.core.Responses$Error.asException(Responses.java:136) at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:179) at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:177) at com.datastax.driver.core.RequestHandler.access$2500(RequestHandler.java:46) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:799) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:633) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:1070) at com.datastax.driver.core.Connection$Dispatcher.channelRead0(Connection.java:993) at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:266) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:293) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:267) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1280) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:890) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:564) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:505) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:419) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:391) Any idea what might be wrong? I have confirmed that all table-names and columns names are lowercase. Datastax java version tried : 3.1.2 and 3.1.4 Cassandra version: 3.10 Thanks SG ------=_Part_852963_1934067966.1490636808376 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable =
>Just wish that an error like:   "Table x n= ot found in keyspace y"
You are welcome to open JIRA w= ith type Improvement.


<= div>Best regards, Vladimir Yudovin,
Winguzone - Cloud Cassandra = Hosting


---- On Sun, 26 Mar 2017 13:31:33 -0400 S G <sg.online.email@gmail.com> wrote ----
<= br>
Thanks, got it working n= ow :)

Just wish that an error like:
<= div>   "Table x not found in keyspace y"
would have= been much better than:
   "Table x not config= ured".


On= Sat, Mar 25, 2017 at 6:13 AM, Arvydas Jonusonis <arvydas.jonusonis@gmail.co= m> wrote:

Make sure to prefix the table = with the keyspace.
On Sat, Mar 25= , 2017 at 13:28 Anuj Wadehra <anujw_2003@yahoo.co.in> wrote:
Ensure that all the nodes are on same schema versi= on such that table2 schema is replicated properly on all the nodes.

Thanks
Anuj


On Sat, Mar 25, 2017 at 3:19 AM, S G

Hi,

I have a key= space with two tables.

I run a different query= for each table:

Table 1:
 = Select * from table1 where id =3D ?

Table 2:<= br>
  Select * from table2 where id1 =3D ? and id =3D ?
<= /div>


My code using datastax fires above = two queries one after the other.
While it never fails for tab= le 1, it never succeeds for table 2
And gives an error:


com.datastax.driver.core.except= ions.InvalidQueryException: unconfigured table table2
at com.datastax.driver.core.Responses$Error.asException(Re= sponses.java:136) 
at com.datast= ax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:179= ) 
at com.datastax.driver.core.R= equestHandler.setFinalResult(RequestHandler.java:177) 
<= span style=3D"">at com.datastax.driver.core.RequestHandler.access$25= 00(RequestHandler.java:46) 
at c= om.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(= RequestHandler.java:799) 
at com= .datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHand= ler.java:633) 
at com.datastax.d= river.core.Connection$Dispatcher.channelRead0(Connection.java:1070) 
at com.datastax.driver.core.Connection= $Dispatcher.channelRead0(Connection.java:993) 
at io.netty.channel.SimpleChannelInboundHandler.channelRead(= SimpleChannelInboundHandler.java:105) 
= at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(= AbstractChannelHandlerContext.java:342) 
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRea= d(AbstractChannelHandlerContext.java:328) 
at io.netty.channel.AbstractChannelHandlerContext.fireChannelR= ead(AbstractChannelHandlerContext.java:321) 
at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleS= tateHandler.java:266) 
at io.net= ty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelH= andlerContext.java:342) 
at io.n= etty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChanne= lHandlerContext.java:328) 
at io= .netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChanne= lHandlerContext.java:321) 
at io= .netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDe= coder.java:102) 
at io.netty.cha= nnel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandler= Context.java:342) 
at io.netty.c= hannel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandl= erContext.java:328) 
at io.netty= .channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandl= erContext.java:321) 
at io.netty= .handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.ja= va:293) 
at io.netty.handler.cod= ec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:267) 
at io.netty.channel.AbstractChannelHand= lerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) <= br>
at io.netty.channel.AbstractChannelHa= ndlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) = ;
at io.netty.channel.AbstractChannel= HandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:321) = ;
at io.netty.channel.DefaultChannelP= ipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1280) 
=
at io.netty.channel.AbstractChannelHandl= erContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) 
at io.netty.channel.AbstractChannelHan= dlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:328) =
at io.netty.channel.DefaultChannelPi= peline.fireChannelRead(DefaultChannelPipeline.java:890) 
at io.netty.channel.nio.AbstractNioByteChannel$Nio= ByteUnsafe.read(AbstractNioByteChannel.java:131) 
at io.netty.channel.nio.NioEventLoop.processSelectedKey(N= ioEventLoop.java:564) 
at io.net= ty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:= 505) 
at io.netty.channel.nio.Ni= oEventLoop.processSelectedKeys(NioEventLoop.java:419) 
<= span style=3D"">at io.netty.channel.nio.NioEventLoop.run(NioEventLoo= p.java:391) 

Any idea what might be= wrong?

I have confirmed that all table-names = and columns names are lowercase.
Datastax java version tried = : 3.1.2  and 3.1.4
Cassandra version: 3.10


Thanks
SG


=

------=_Part_852963_1934067966.1490636808376--