Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0999C18A06 for ; Wed, 12 Aug 2015 20:22:08 +0000 (UTC) Received: (qmail 92851 invoked by uid 500); 12 Aug 2015 20:21:46 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 92768 invoked by uid 500); 12 Aug 2015 20:21:45 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 92728 invoked by uid 99); 12 Aug 2015 20:21:45 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Aug 2015 20:21:45 +0000 Date: Wed, 12 Aug 2015 20:21:45 +0000 (UTC) From: "Vince Gonzalez (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-3090) sqlline : save SQL to script file and replay from script, results in error MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-3090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14694112#comment-14694112 ] Vince Gonzalez commented on DRILL-3090: --------------------------------------- Also saw what appears to be the same error intermittently running the same query above in a loop with sqlline -f: {code} 1/1 select count(1) from cp.`employee.json`; Error: SYSTEM ERROR: SocketException: Broken pipe [Error Id: 81702de3-1538-41ea-aa6c-1af382ebb0c7 on ip-172-16-2-95:31010] (state=,code=0) java.sql.SQLException: SYSTEM ERROR: SocketException: Broken pipe [Error Id: 81702de3-1538-41ea-aa6c-1af382ebb0c7 on ip-172-16-2-95:31010] at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:214) at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema(DrillCursor.java:257) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:1362) at org.apache.drill.jdbc.impl.DrillResultSetImpl.execute(DrillResultSetImpl.java:72) at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404) at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:351) at net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:338) at net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69) at org.apache.drill.jdbc.impl.DrillStatementImpl.execute(DrillStatementImpl.java:85) at sqlline.Commands.execute(Commands.java:841) at sqlline.Commands.sql(Commands.java:751) at sqlline.SqlLine.dispatch(SqlLine.java:738) at sqlline.SqlLine.runCommands(SqlLine.java:1641) at sqlline.Commands.run(Commands.java:1304) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) at sqlline.SqlLine.dispatch(SqlLine.java:734) at sqlline.SqlLine.initArgs(SqlLine.java:544) at sqlline.SqlLine.begin(SqlLine.java:587) at sqlline.SqlLine.start(SqlLine.java:366) at sqlline.SqlLine.main(SqlLine.java:259) Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: SocketException: Broken pipe [Error Id: 81702de3-1538-41ea-aa6c-1af382ebb0c7 on ip-172-16-2-95:31010] at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:118) at org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:111) at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:47) at org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:32) at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) at io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618) at io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329) at io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) at java.lang.Thread.run(Thread.java:745) Aborting command set because "force" is false and command failed: "select count(1) from cp.`employee.json`;" Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl {code} > sqlline : save SQL to script file and replay from script, results in error > -------------------------------------------------------------------------- > > Key: DRILL-3090 > URL: https://issues.apache.org/jira/browse/DRILL-3090 > Project: Apache Drill > Issue Type: Bug > Components: Client - CLI > Affects Versions: 1.0.0 > Environment: ffbb9c7adc6360744bee186e1f69d47dc743f73e > Reporter: Khurram Faraaz > Assignee: Daniel Barclay (Drill) > Priority: Minor > Fix For: 1.4.0 > > > Save a SQL query to a script file and replay the SQL from the script file using !run, on sqlline prompt throws error. We should not see the error when we replay the SQL from the script file. > {code} > 0: jdbc:drill:schema=dfs.tmp> !script file3 > Saving command script to "/opt/mapr/drill/drill-1.0.0/bin/file3". Enter "script" with no arguments to stop it. > 0: jdbc:drill:schema=dfs.tmp> select * from sys.drillbits; > +------------+------------+--------------+------------+------------+ > | hostname | user_port | control_port | data_port | current | > +------------+------------+--------------+------------+------------+ > | centos-04.qa.lab | 31010 | 31011 | 31012 | false | > | centos-02.qa.lab | 31010 | 31011 | 31012 | false | > | centos-01.qa.lab | 31010 | 31011 | 31012 | false | > | centos-03.qa.lab | 31010 | 31011 | 31012 | true | > +------------+------------+--------------+------------+------------+ > 4 rows selected (0.176 seconds) > 0: jdbc:drill:schema=dfs.tmp> !script > Script closed. Enter "run /opt/mapr/drill/drill-1.0.0/bin/file3" to replay it. > 0: jdbc:drill:schema=dfs.tmp> !run /opt/mapr/drill/drill-1.0.0/bin/file3 > 1/2 select * from sys.drillbits; > +------------+------------+--------------+------------+------------+ > | hostname | user_port | control_port | data_port | current | > +------------+------------+--------------+------------+------------+ > | centos-04 | 31010 | 31011 | 31012 | false | > | centos-02 | 31010 | 31011 | 31012 | false | > | centos-01 | 31010 | 31011 | 31012 | false | > | centos-03 | 31010 | 31011 | 31012 | true | > +------------+------------+--------------+------------+------------+ > 4 rows selected (0.178 seconds) > 2/2 !script > Usage: script > Aborting command set because "force" is false and command failed: "!script" > {code} > I looked at the contents of file3 under /opt/mapr/drill/drill-1.0.0/bin > There seems to be an additional/extra "!script" in the file. > {code} > [root@centos-01 bin]# cat file3 > select * from sys.drillbits; > !script > [root@centos-01 bin]# > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)