From user-return-9390-apmail-drill-user-archive=drill.apache.org@drill.apache.org Thu Jun 21 07:23:08 2018 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-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 9040B18B17 for ; Thu, 21 Jun 2018 07:23:08 +0000 (UTC) Received: (qmail 5436 invoked by uid 500); 21 Jun 2018 07:23:08 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 5357 invoked by uid 500); 21 Jun 2018 07:23:08 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 5345 invoked by uid 99); 21 Jun 2018 07:23:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jun 2018 07:23:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 1F4BC1A1C8C for ; Thu, 21 Jun 2018 07:23:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=agilx.ai Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id SIuK-B-iAnot for ; Thu, 21 Jun 2018 07:23:02 +0000 (UTC) Received: from mail-wm0-f53.google.com (mail-wm0-f53.google.com [74.125.82.53]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 332415F4E5 for ; Thu, 21 Jun 2018 07:23:02 +0000 (UTC) Received: by mail-wm0-f53.google.com with SMTP id n5-v6so3855841wmc.5 for ; Thu, 21 Jun 2018 00:23:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=agilx.ai; s=googledkim; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=G/AsQUh2CcKPTlw2vrGxsvqLFQv2bnTcqJDXDd56WX8=; b=GwG0kSadjfJdVw4EnDfTwZ0xGfGXdCRyNfDg3wK+jRdwk7JoZbFzoU4WpoPQaml++l n58Uct6Jq//a20t8ffgMRJlelkXUueE8QMtsFZ2d+yQP7An3Wh5j4npUZyk1HIXUZaal RSNGKzoiutZjSpxQTImfUGeKI0bhmIfq7pWXLoXbbIotHKt+GDXUUgyeXZZrcPTbcCjy XjzTrWO+xtkg2cOGQ4PR46gxWByKjJbdBGmouoF8eiBtevxOSfF6tcdBIKeufFAlj9vp uD7YojixJs4P1CqHCQ2tJXs50nOu84SJaw/5DGuAi34Z5JiJUtct/ezW/CcdZzzZJDQ4 ltYA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=G/AsQUh2CcKPTlw2vrGxsvqLFQv2bnTcqJDXDd56WX8=; b=TGUJarfkty5dba6nWGhbYcPJpXl0bqNMuMbtD7CpDqahIDrTMPJ7DeoDSe92uck1H7 EEy9jB4BFVH3ICgNcvTrTX231ZFruil72AJd1T0n/gyp3s3fuHvEpHtbS3br/cL49mCi RRUWtYiXl1Qypzda7n+d0SSn5dIsbkLwFlDXoBmqy4C5aKwfhbNGgGfIyUQTiU7/Q69x iSfkAL07cYF5W3vKjQMgwzB4FThxZxpAOXSfig0lY1+EbhALEivwGRf8G3sZdxzzlWLE vQYWPn9fUI3nFgmi9uuoF7YF785JT6RdJjqiN15f9ostZX513eV6epocoh/XFHRdP+ll JWog== X-Gm-Message-State: APt69E1WejjSySmB352ckqo81W5k3PpUn4TrviPRPFZYhpernmucmrEZ rUHgl5YcYEgufWKsHfLNzw4OgfqNg4mKz24g60jUIq5XR3Q= X-Google-Smtp-Source: ADUXVKLDrnTNgm8utFDkfemH+QwxC0xpZvc49ydqXFMS8DTvTfq2tVfBaFrRCyVwg4dBdlkzVWFhEtfqpfyRLfHJs30= X-Received: by 2002:a50:868d:: with SMTP id r13-v6mr20900978eda.64.1529565775865; Thu, 21 Jun 2018 00:22:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Phaneendra Kumar Divi Date: Thu, 21 Jun 2018 12:52:44 +0530 Message-ID: Subject: Re: Drill NPE on show tables for openTSDB schema To: user@drill.apache.org Content-Type: multipart/alternative; boundary="000000000000bb3980056f21c851" --000000000000bb3980056f21c851 Content-Type: text/plain; charset="UTF-8" In addition, I see the below stack trace in drillbit.log... 2018-06-21 10:45:00,120 [24d4cbab-9cda-9c63-9018-ce18b23a0003:frag:0:0] ERROR o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: NullPointerException Fragment 0:0 [Error Id: f7961474-3436-4f6d-9d37-34f819142077 on phani:31010] org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: NullPointerException Fragment 0:0 [Error Id: f7961474-3436-4f6d-9d37-34f819142077 on phani:31010] at org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633) ~[drill-common-1.13.0.jar:1.13.0] at org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:300) [drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:160) [drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:266) [drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) [drill-common-1.13.0.jar:1.13.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_171] at java.lang.Thread.run(Thread.java:748) [na:1.8.0_171] Caused by: java.lang.NullPointerException: null at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:210) ~[guava-18.0.jar:na] at com.google.common.collect.Lists.newArrayList(Lists.java:142) ~[guava-18.0.jar:na] at org.apache.drill.exec.store.AbstractSchema.getTableNamesAndTypes(AbstractSchema.java:252) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator$Tables.visitTables(InfoSchemaRecordGenerator.java:301) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema(InfoSchemaRecordGenerator.java:216) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema(InfoSchemaRecordGenerator.java:209) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaRecordGenerator.scanSchema(InfoSchemaRecordGenerator.java:196) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaTableType.getRecordReader(InfoSchemaTableType.java:58) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:34) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch(InfoSchemaBatchCreator.java:30) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch(ImplCreator.java:159) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:182) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getRecordBatch(ImplCreator.java:137) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getChildren(ImplCreator.java:182) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getRootExec(ImplCreator.java:110) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.physical.impl.ImplCreator.getExec(ImplCreator.java:87) ~[drill-java-exec-1.13.0.jar:1.13.0] at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:206) [drill-java-exec-1.13.0.jar:1.13.0] ... 4 common frames omitted Any help would be much appreciated. Thanks! Phani On Thu, Jun 21, 2018 at 12:20 PM Phaneendra Kumar Divi < phaneendra.divi@agilx.ai> wrote: > Hi There, > > I have just installed drill 1.13.0 and configured openTSDB storage plugin > when I try "show tables;" command on the sqline prompt I see the following > error in logs. Can you please help point out what is wrong here? My > openTSDB is running on localhost:4242 itself. > > 2018-06-21 10:45:00,128 [Client-1] INFO > o.a.d.j.i.DrillCursor$ResultsListener - [#7] Query failed: > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > NullPointerException > > Fragment 0:0 > > [Error Id: f7961474-3436-4f6d-9d37-34f819142077 on phani:31010] > at > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) > [drill-java-exec-1.13.0.jar:1.13.0] > at > org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422) > [drill-java-exec-1.13.0.jar:1.13.0] > at > org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96) > [drill-java-exec-1.13.0.jar:1.13.0] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) > [drill-rpc-1.13.0.jar:1.13.0] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244) > [drill-rpc-1.13.0.jar:1.13.0] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88) > [netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287) > [netty-handler-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) > [netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312) > [netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286) > [netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) > [netty-common-4.0.48.Final.jar:4.0.48.Final] > at java.lang.Thread.run(Thread.java:748) [na:1.8.0_171] > > Thanks in advance for your help. > > Regards, > Phani > --000000000000bb3980056f21c851--