You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (Jira)" <ji...@apache.org> on 2021/05/04 18:52:00 UTC

[jira] [Commented] (ASTERIXDB-2883) SELECT udf(null); hangs forever in optimization

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17339222#comment-17339222 ] 

Dmitry Lychagin commented on ASTERIXDB-2883:
--------------------------------------------

Patch: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/11306

> SELECT udf(null); hangs forever in optimization
> -----------------------------------------------
>
>                 Key: ASTERIXDB-2883
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2883
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: FUN - Functions, SQL - Translator SQL++
>    Affects Versions: 0.9.7
>            Reporter: Luke Ren
>            Assignee: Dmitry Lychagin
>            Priority: Minor
>
> Running an external UDF with a constant null argument seems to get stuck forever in optimization. 
> Stack from optimizer:
> {noformat}
> "QueryTranslator:b5adbd21-1d31-429e-a42d-c8fa80d67902@8514" prio=10 tid=0x8a nid=NA runnable
>   java.lang.Thread.State: RUNNABLE
> 	  at org.apache.hyracks.algebricks.core.algebra.expressions.AbstractFunctionCallExpression.cloneArguments(AbstractFunctionCallExpression.java:91)
> 	  at org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression.cloneExpression(ScalarFunctionCallExpression.java:46)
> 	  at org.apache.hyracks.algebricks.core.algebra.expressions.ScalarFunctionCallExpression.cloneExpression(ScalarFunctionCallExpression.java:29)
> 	  at org.apache.hyracks.algebricks.rewriter.rules.ExtractCommonExpressionsRule.removeCommonExpressions(ExtractCommonExpressionsRule.java:191)
> 	  at org.apache.hyracks.algebricks.rewriter.rules.ExtractCommonExpressionsRule.removeCommonExpressions(ExtractCommonExpressionsRule.java:165)
> 	  at org.apache.hyracks.algebricks.rewriter.rules.ExtractCommonExpressionsRule.rewritePre(ExtractCommonExpressionsRule.java:113)
> 	  at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:78)
> 	  at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:91)
> 	  at org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialFixpointRuleController.rewriteWithRuleCollection(SequentialFixpointRuleController.java:52)
> 	  at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:91)
> 	  at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runLogicalOptimizationSets(HeuristicOptimizer.java:82)
> 	  at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:63)
> 	  at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.optimize(HeuristicCompilerFactoryBuilder.java:94)
> 	  at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:266)
> 	  at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:2917)
> 	  at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$3(QueryTranslator.java:3422)
> 	  at org.apache.asterix.app.translator.QueryTranslator$$Lambda$585.9901947.compile(Unknown Source:-1)
> 	  at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:3555)
> 	  at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:3459)
> 	  at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:3438)
> 	  at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:444)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)