Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-30591

LIMIT Pushdown: Internal error if limit and offset have same value

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 6.0.0
    • 6.0.0
    • analytics
    • Enterprise Edition 6.0.0 build 1355
    • Untriaged
    • Centos 64-bit
    • Yes
    • CX Sprint 112

    Description

      I have below documents ingested in CBAS from KV.

      id-0{"name":"dave","gender":"Male","salary":50,"married":false,"age":19,"employed":""}
      id-1{"name":"evan","gender":"Female","salary":100.15,"married":true,"age":25}
      id-2{"name":"john","gender":"Male","salary":150.55,"married":null,"age":44}
      id-3{"name":"sara","gender":"Female","salary":200.34,"married":false,"age":20}
      id-4{"name":"tom","gender":"Male","salary":250.99,"married":true,"age":31}
      

      If limit and offset have same value we are getting "Internal error" on Analytics workbench

      select * from default limit 1 offset 1

       Exception in logs

      2018-07-23T11:54:29.560Z WARN CBAS.apache.asterix [Executor-5:ClusterController] Variable $$12 could not be found in any input schema.
      org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Variable $$12 could not be found in any input schema.
      at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createVariableEvaluatorFactory(QueryLogicalExpressionJobGen.java:133) ~[asterix-algebra.jar:6.0.0-1355]
      at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createEvaluatorFactory(QueryLogicalExpressionJobGen.java:105) ~[asterix-algebra.jar:6.0.0-1355]
      at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.codegenArguments(QueryLogicalExpressionJobGen.java:161) ~[asterix-algebra.jar:6.0.0-1355]
      at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createScalarFunctionEvaluatorFactory(QueryLogicalExpressionJobGen.java:139) ~[asterix-algebra.jar:6.0.0-1355]
      at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createEvaluatorFactory(QueryLogicalExpressionJobGen.java:114) ~[asterix-algebra.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.algebra.expressions.ExpressionRuntimeProvider.createEvaluatorFactory(ExpressionRuntimeProvider.java:41) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.algebra.operators.physical.StreamLimitPOperator.contributeRuntimeOperator(StreamLimitPOperator.java:93) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:169) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:110) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlanImpl(PlanCompiler.java:70) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlan(PlanCompiler.java:53) ~[algebricks-core.jar:6.0.0-1355]
      at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.createJob(HeuristicCompilerFactoryBuilder.java:107) ~[algebricks-compiler.jar:6.0.0-1355]
      at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:291) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1976) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$2(QueryTranslator.java:2483) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2608) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2527) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2496) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:393) ~[asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:136) [asterix-app.jar:6.0.0-1355]
      at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.0-1355]
      at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) [hyracks-control-cc.jar:6.0.0-1355]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162]
      at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162]
      

      Attachments

        For Gerrit Dashboard: MB-30591
        # Subject Branch Project Status CR V

        Activity

          People

            tanzeem.ahmed Tanzeem Ahmed (Inactive)
            tanzeem.ahmed Tanzeem Ahmed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty