Took a look back at it the code and the construction of the exception object is actually eating the underlying exception.
If I shared a branch fixing the error message creation could you build/deploy it and try to re-run your query? What version of Drill are you using? I can base the small change on a commit near whatever release you are on. - Jason On Fri, Jan 22, 2016 at 4:19 PM, Kumiko Yada <kumiko.y...@ds-iq.com> wrote: > No, either of these were followed by a "Caused by" section with another > stacktrace. > > -Kumiko > > -----Original Message----- > From: Jason Altekruse [mailto:altekruseja...@gmail.com] > Sent: Friday, January 22, 2016 4:13 PM > To: user <user@drill.apache.org> > Cc: Kevin Verhoeven <kevin.verhoe...@ds-iq.com>; Ki Kang < > ki.k...@ds-iq.com> > Subject: Re: DATA_WRITE ERROR: Failed to drop table > > Looks like this is just another instance of the same stacktrace, but the > error ID is different, so it may have been a different time you ran a query > that resulted in an error. Are either of these followed by a "Caused by" > section with another stacktrace? > > On Fri, Jan 22, 2016 at 4:03 PM, Kumiko Yada <kumiko.y...@ds-iq.com> > wrote: > > > Yes. > > > > org.apache.drill.common.exceptions.UserRemoteException: DATA_WRITE ERROR: > > Failed to drop table > > > > > > [Error Id: 3a099358-537d-47fd-8cc0-5994c6ffca88 on > > blvkydevbfd01.ds-iq.corp:31010] > > at > > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryR > > esultHandler.java:119) > > ~[drill-java-exec-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.jav > > a:113) > > ~[drill-java-exec-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClient > > WithConnection.java:46) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClient > > WithConnection.java:31) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:69) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.RpcBus$RequestEvent.run(RpcBus.java:400) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.common.SerializedExecutor$RunnableProcessor.run(Seria > > lizedExecutor.java:105) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.RpcBus$SameExecutor.execute(RpcBus.java:264) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.common.SerializedExecutor.execute(SerializedExecutor. > > java:142) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:298 > > ) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:269 > > ) > > ~[drill-rpc-1.4.0.jar:1.4.0] > > at > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMe > > ssageDecoder.java:89) ~[netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abstr > > actChannelHandlerContext.java:339) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstrac > > tChannelHandlerContext.java:324) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler > > .java:254) ~[netty-handler-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abstr > > actChannelHandlerContext.java:339) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstrac > > tChannelHandlerContext.java:324) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMe > > ssageDecoder.java:103) ~[netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abstr > > actChannelHandlerContext.java:339) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstrac > > tChannelHandlerContext.java:324) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageD > > ecoder.java:242) ~[netty-codec-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abstr > > actChannelHandlerContext.java:339) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstrac > > tChannelHandlerContext.java:324) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInbou > > ndHandlerAdapter.java:86) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abstr > > actChannelHandlerContext.java:339) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstrac > > tChannelHandlerContext.java:324) > > ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannel > > Pipeline.java:847) ~[netty-transport-4.0.27.Final.jar:4.0.27.Final] > > at > > io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.ep > > ollInReady(AbstractEpollStreamChannel.java:618) > > ~[netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > at > > io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java > > :329) ~[netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > at > > io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) > > ~[netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > at > > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadE > > ventExecutor.java:111) ~[netty-common-4.0.27.Final.jar:4.0.27.Final] > > at java.lang.Thread.run(Thread.java:745) ~[na:1.7.0_71] > > > > -----Original Message----- > > From: Jason Altekruse [mailto:altekruseja...@gmail.com] > > Sent: Friday, January 22, 2016 4:02 PM > > To: user <user@drill.apache.org> > > Cc: Kevin Verhoeven <kevin.verhoe...@ds-iq.com>; Ki Kang < > > ki.k...@ds-iq.com> > > Subject: Re: DATA_WRITE ERROR: Failed to drop table > > > > Is there another stack trace after this line? This stack trace is > > actually very generic in Drill, it's just the codepath taken when a > > client receives a message. I was looking for an error from the > filesystem itself. > > > > On Fri, Jan 22, 2016 at 3:57 PM, Kumiko Yada <kumiko.y...@ds-iq.com> > > wrote: > > > > > Jason, > > > > > > Here is the callstack: > > > > > > [Error Id: 12e9ba22-271f-4b73-897e-186bf320f9d3 on > > > blvkydevbfd01.ds-iq.corp:31010] > > > at > > > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(Quer > > > yR > > > esultHandler.java:119) > > > [drill-java-exec-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.j > > > av > > > a:113) > > > [drill-java-exec-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClie > > > nt > > > WithConnection.java:46) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClie > > > nt > > > WithConnection.java:31) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:69) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.RpcBus$RequestEvent.run(RpcBus.java:400) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.common.SerializedExecutor$RunnableProcessor.run(Ser > > > ia > > > lizedExecutor.java:105) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.RpcBus$SameExecutor.execute(RpcBus.java:26 > > > 4) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.common.SerializedExecutor.execute(SerializedExecutor. > > > java:142) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:2 > > > 98 > > > ) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:2 > > > 69 > > > ) > > > [drill-rpc-1.4.0.jar:1.4.0] > > > at > > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageTo > > > Me > > > ssageDecoder.java:89) [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abs > > > tr > > > actChannelHandlerContext.java:339) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstr > > > ac > > > tChannelHandlerContext.java:324) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandl > > > er > > > .java:254) [netty-handler-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abs > > > tr > > > actChannelHandlerContext.java:339) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstr > > > ac > > > tChannelHandlerContext.java:324) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageTo > > > Me > > > ssageDecoder.java:103) [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abs > > > tr > > > actChannelHandlerContext.java:339) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstr > > > ac > > > tChannelHandlerContext.java:324) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessag > > > eD > > > ecoder.java:242) [netty-codec-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abs > > > tr > > > actChannelHandlerContext.java:339) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstr > > > ac > > > tChannelHandlerContext.java:324) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInb > > > ou > > > ndHandlerAdapter.java:86) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(Abs > > > tr > > > actChannelHandlerContext.java:339) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(Abstr > > > ac > > > tChannelHandlerContext.java:324) > > > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChann > > > el > > > Pipeline.java:847) [netty-transport-4.0.27.Final.jar:4.0.27.Final] > > > at > > > io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe. > > > ep > > > ollInReady(AbstractEpollStreamChannel.java:618) > > > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > > at > > > io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.ja > > > va > > > :329) [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > > at > > > io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) > > > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > > > at > > > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThrea > > > dE > > > ventExecutor.java:111) [netty-common-4.0.27.Final.jar:4.0.27.Final] > > > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_71] > > > 2016-01-22 23:16:45,852 [Client-1] INFO > > > o.a.drill.exec.rpc.user.UserClient - Channel closed > > > /192.168.200.129:57436 <--> /192.168.200.129:31010. > > > 2016-01-22 23:16:45,853 [qtp1683069650-5882] ERROR > > > o.a.d.e.server.rest.QueryResources - Query from Web UI Failed > > > org.apache.drill.common.exceptions.UserRemoteException: DATA_WRITE > ERROR: > > > Failed to drop table > > > > > > -Kumiko > > > -----Original Message----- > > > From: Jason Altekruse [mailto:altekruseja...@gmail.com] > > > Sent: Friday, January 22, 2016 3:52 PM > > > To: user <user@drill.apache.org> > > > Cc: Kevin Verhoeven <kevin.verhoe...@ds-iq.com>; Ki Kang < > > > ki.k...@ds-iq.com> > > > Subject: Re: DATA_WRITE ERROR: Failed to drop table > > > > > > Looking at where this message is produced, there was likely a lower > > > level filesystem error that was not related to permissions. Can you > > > check the logs for more info? > > > > > > The error message you see on the command line should have an error > > > ID you can use to search the logs. > > > > > > - Jason > > > > > > On Fri, Jan 22, 2016 at 3:22 PM, Kumiko Yada <kumiko.y...@ds-iq.com> > > > wrote: > > > > > > > Hello, > > > > > > > > I created the table using CREATE TABLE AS (CTAS) command, then I > > > > tried to DROP this directory with DROP TABLE command, I'm getting > > > > the error "DATA_WRITE ERROR: Failed to drop table". > > > > > > > > I verified that I have a full permission to the directory. Has > > > > anyone seen this? > > > > > > > > Thanks > > > > Kumiko > > > > > > > > > >
