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

IllegalStateException when parameters are used with HAVING

    XMLWordPrintable

Details

    • Untriaged
    • Unknown
    • CX Sprint 111

    Description

      Encountered the java.lang.IllegalStateException when parameters are used with having clause

      http://10.142.180.103:8095/analytics/service?statement=select callsign from ds1 group by callsign having count(callsign) > $1 &args=[1]
      		 
       
      		 
      {
      		 
      "requestID": "3c8a6344-3e7a-4c09-a39e-82da9b8bad25",
      		 
      "errors": [
      		 
      {
      		 
      "code": 25000,
      		 
      "msg": "Internal error"
      		 
      }
      		 
      ],
      		 
      "status": "fatal",
      		 
      "metrics": {
      		 
      "elapsedTime": "16.579324ms",
      		 
      "executionTime": "9.710514ms",
      		 
      "resultCount": 0,
      		 
      "resultSize": 0,
      		 
      "processedObjects": 0,
      		 
      "errorCount": 1
      		 
      }
      		 
      }

      Result from N1ql

      select callsign from `travel-sample` group by callsign having count(callsign) > $1
      		 
       
      		 
      [
      		 
      {
      		 
      "callsign": "OA"
      		 
      },
      		 
      {
      		 
      "callsign": "KESTREL"
      		 
      },
      		 
      {
      		 
      "callsign": "Rainbow Air"
      		 
      }
      		 
      ]

      Exception in analytics log

      2018-07-11T08:04:49.011Z INFO CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-1] handleRequest: {"host":"10.142.180.103:8095","path":"/analytics/service","statement":"select callsign from ds1 group by callsign having count(callsign) > $1 ","pretty":false,"mode":null,"clientContextID":null,"format":null,"timeout":null,"maxResultReads":null,"planFormat":null,"expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":false,"job":false,"signature":false,"$1":1}
      		 
      2018-07-11T08:04:49.017Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: ApplicationMessage: nodeID: ac38a33abe0e7625ff4bc0ae731a20e7
      		 
      2018-07-11T08:04:49.017Z INFO CBAS.messaging.CCMessageBroker [Executor-11:ClusterController] Received message: ExecuteStatementRequestMessage(id=81, from=ac38a33abe0e7625ff4bc0ae731a20e7): select callsign from ds1 group by callsign having count(callsign) > $1 ;
      		 
      2018-07-11T08:04:49.019Z INFO CBAS.translator.QueryTranslator [QueryTranslator] []:[?1]
      		 
      java.lang.IllegalStateException: []:[?1]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:189) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:93) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:57) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:195) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:309) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppSimpleExpressionVisitor.visit(AbstractSqlppSimpleExpressionVisitor.java:359) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:215) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.common.statement.Query.accept(Query.java:94) ~[asterix-lang-common.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewriteGroupByAggregationSugar(SqlppQueryRewriter.java:151) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewrite(SqlppQueryRewriter.java:122) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.api.common.APIFramework.reWriteQuery(APIFramework.java:186) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1967) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$2(QueryTranslator.java:2478) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2602) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2522) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2491) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:388) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:134) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) [hyracks-control-cc.jar:6.0.0-1303]
      		 
      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]
      		 
      2018-07-11T08:04:49.019Z ERRO CBAS.apache.asterix [Executor-11:ClusterController] Unexpected exception
      		 
      java.lang.IllegalStateException: []:[?1]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:189) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:93) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:57) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:195) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:309) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppSimpleExpressionVisitor.visit(AbstractSqlppSimpleExpressionVisitor.java:359) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:215) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.common.statement.Query.accept(Query.java:94) ~[asterix-lang-common.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewriteGroupByAggregationSugar(SqlppQueryRewriter.java:151) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewrite(SqlppQueryRewriter.java:122) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.api.common.APIFramework.reWriteQuery(APIFramework.java:186) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1967) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$2(QueryTranslator.java:2478) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2602) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2522) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2491) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:388) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:134) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) [hyracks-control-cc.jar:6.0.0-1303]
      		 
      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]
      		 
      2018-07-11T08:04:49.024Z INFO CBAS.work.WorkQueue [Worker:ac38a33abe0e7625ff4bc0ae731a20e7] Executing: ApplicationMessage: nodeId: ac38a33abe0e7625ff4bc0ae731a20e7
      		 
      2018-07-11T08:04:49.024Z INFO CBAS.messaging.NCMessageBroker [Worker:ac38a33abe0e7625ff4bc0ae731a20e7] Received message: ExecuteStatementResponseMessage(id=81): 0 characters
      		 
      2018-07-11T08:04:49.026Z WARN CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-1] handleException: unexpected exception: {"host":"10.142.180.103:8095","path":"/analytics/service","statement":"select callsign from ds1 group by callsign having count(callsign) > $1 ","pretty":false,"mode":null,"clientContextID":"bb6e4311-9bb9-4b8a-9d84-f627aa23fcb6","format":null,"timeout":null,"maxResultReads":null,"planFormat":null,"expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":false,"job":false,"signature":false,"$1":1}
      		 
      java.lang.IllegalStateException: []:[?1]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:189) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:93) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:57) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:195) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:309) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppSimpleExpressionVisitor.visit(AbstractSqlppSimpleExpressionVisitor.java:359) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:215) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:60) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.common.statement.Query.accept(Query.java:94) ~[asterix-lang-common.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewriteGroupByAggregationSugar(SqlppQueryRewriter.java:151) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewrite(SqlppQueryRewriter.java:122) ~[asterix-lang-sqlpp.jar:6.0.0-1303]
      		 
      at org.apache.asterix.api.common.APIFramework.reWriteQuery(APIFramework.java:186) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1967) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$2(QueryTranslator.java:2478) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2602) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2522) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2491) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:388) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:134) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) ~[asterix-app.jar:6.0.0-1303]
      		 
      at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) ~[hyracks-control-cc.jar:6.0.0-1303]
      		 
      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]
      		 
      2018-07-11T08:05:48.510Z INFO CBAS.netty.DcpMessageHandler [nioEventLoopGroup-3-1] Sending back a NoOp response{"class" : "DcpChannel", "inetAddress" : "/10.142.180.101:11210", "bucket" : "travel-sample", "state" : "CONNECTED"}. Current ack counter = 0
      		 
      2018-07-11T08:07:48.598Z INFO CBAS.netty.DcpMessageHandler [nioEventLoopGroup-3-1] Sending back a NoOp response{"class" : "DcpChannel", "inetAddress" : "/10.142.180.101:11210", "bucket" : "travel-sample", "state" : "CONNECTED"}. Current ack counter = 0
      		 
      2018-07-11T08:07:48.995Z INFO CBAS.events.DeadConnectionDetection [FixerThread:cbas:travel-sample:ac38a33abe0e7625ff4bc0ae731a20e7:0] Running dead connection detection

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            vikas.chaudhary Vikas Chaudhary
            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