Never mind. After setting up a remote debugger found that table list was coming up null from okhttp client proxy on account of some error from opentsdb. Was my environment issue.
Thanks! Phani On Thu, Jun 21, 2018 at 12:52 PM Phaneendra Kumar Divi < [email protected]> wrote: > 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 < > [email protected]> 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 >> >
