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 > > > > > >
