[
https://issues.apache.org/jira/browse/DRILL-819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007390#comment-14007390
]
Ramana Inukonda Nagaraj commented on DRILL-819:
-----------------------------------------------
Did some quick analysis.
The inner query passes fine.
I think there is some issue with the outer syntax rather than the private
shared pools error which shows up.
Seeing this across nodes
io.netty.handler.codec.DecoderException:
org.apache.drill.common.exceptions.ExpressionParsingException: Expression has
syntax error! line 1:0:no viable alternative at input 'is'
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:99)
[netty-codec-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
[netty-transport-4.0.7.Final.jar:na]
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
[netty-codec-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
[netty-transport-4.0.7.Final.jar:na]
io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:173)
[netty-codec-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.invokeChannelRead(DefaultChannelHandlerContext.java:334)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelHandlerContext.fireChannelRead(DefaultChannelHandlerContext.java:320)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:785)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:100)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:497)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:465)
[netty-transport-4.0.7.Final.jar:na]
io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:359)
[netty-transport-4.0.7.Final.jar:na]
io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:101)
[netty-common-4.0.7.Final.jar:na]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
Caused by: org.apache.drill.common.exceptions.ExpressionParsingException:
Expression has syntax error! line 1:0:no viable alternative at input 'is'
org.apache.drill.common.expression.parser.ExprParser.displayRecognitionError(ExprParser.java:166)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.antlr.runtime.BaseRecognizer.reportError(BaseRecognizer.java:186)
~[antlr-runtime-3.4.jar:na]
org.apache.drill.common.expression.parser.ExprParser.lookup(ExprParser.java:5068)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.atom(ExprParser.java:4275)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.unaryExpr(ExprParser.java:4157)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.xorExpr(ExprParser.java:3859)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.mulExpr(ExprParser.java:3726)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.addExpr(ExprParser.java:3594)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.relExpr(ExprParser.java:3469)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.equExpr(ExprParser.java:3341)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.andExpr(ExprParser.java:3215)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.orExpr(ExprParser.java:3090)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.condExpr(ExprParser.java:3015)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.expression(ExprParser.java:2946)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.parser.ExprParser.parse(ExprParser.java:203)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.LogicalExpression$De.deserialize(LogicalExpression.java:78)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.common.expression.LogicalExpression$De.deserialize(LogicalExpression.java:55)
~[drill-common-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:449)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:347)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:976)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:276)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:912)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:155)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:123)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:113)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:82)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:106)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:447)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:347)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:976)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:276)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:912)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:155)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:123)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:113)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:82)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:106)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:447)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:347)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:976)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:276)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:912)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:155)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:123)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:113)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:82)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:106)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:447)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:347)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault(BeanDeserializerBase.java:976)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:276)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId(BeanDeserializerBase.java:912)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther(BeanDeserializer.java:155)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:123)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:113)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:82)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:106)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize(TypeWrappedDeserializer.java:36)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReader.java:1216)
~[jackson-databind-2.2.0.jar:2.2.0]
com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:830)
~[jackson-databind-2.2.0.jar:2.2.0]
org.apache.drill.exec.planner.PhysicalPlanReader.readFragmentOperator(PhysicalPlanReader.java:96)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.fragment.NonRootFragmentManager.<init>(NonRootFragmentManager.java:57)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.control.WorkEventBus.getOrCreateFragmentManager(WorkEventBus.java:95)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.data.DataServer$1.getHandshakeResponse(DataServer.java:85)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.data.DataServer$1.getHandshakeResponse(DataServer.java:73)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.BasicServer$ServerHandshakeHandler.consumeHandshake(BasicServer.java:109)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:53)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:29)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
[netty-codec-4.0.7.Final.jar:na]
... 18 more
> Failure while closing accountor encountered
> -------------------------------------------
>
> Key: DRILL-819
> URL: https://issues.apache.org/jira/browse/DRILL-819
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Zhiyong Liu
>
> Datasources: TPCH (10MB), three-way split parquet files
> git.commit.id.abbrev=2fad21d
> git.commit.id=2fad21d5a6ec43bb68fb989e48b6da180f23f73a
> 0: jdbc:drill:schema=dfs.TpcHMulti> select count(*) from (select l.l_orderkey
> as x, c.c_custkey as y
> . . . . . . . . . . . . . . . . . > from lineitem l left outer join
> customer c on l.l_orderkey = c.c_custkey) where y is null;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "48974397-f16f-44a6-80dc-678a81ed9a90"
> endpoint {
> address: "perfnode104.perf.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < IllegalStateException:[ Failure
> while closing accountor. Expected private and shared pools to be set to
> initial values. However, one or more were not. Stats are
> zone init allocated delta
> private 1000000 839520 160480
> shared 9999000000 9999000000 0. ]"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
