drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phaneendra Kumar Divi <phaneendra.d...@agilx.ai>
Subject Re: Drill NPE on show tables for openTSDB schema
Date Thu, 21 Jun 2018 11:05:53 GMT
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 <
phaneendra.divi@agilx.ai> 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 <
> 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
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message