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

[CX] Invalid queries sent by analytics workbench

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • CBAS DP
    • CBAS DP
    • analytics
    • None
    • CBAS build 283
    • Untriaged
    • Unknown
    • CX Sprint 28

    Description

      The analytics workbench sends queries that cannot be evaluated by the CBAS server. These queries are done in the background and are not the result of specific user actions, so users would not be aware of these unless they look at the logs.

      2016-10-16T15:30:42.289-07:00 ERRO CBAS.apache.asterix [qtp636782475-32] Syntax error: In line 1 >>select DatasetName from Metadata.Dataset<< Encountered "Dataset" at column 34. 
      org.apache.asterix.common.exceptions.AsterixException: Syntax error: In line 1 >>select DatasetName from Metadata.Dataset<< Encountered "Dataset" at column 34. 
      	at com.couchbase.analytics.lang.parser.CBSQLPPParser.parse(CBSQLPPParser.java:270) ~[cbas-connector-1.0.0-SNAPSHOT.jar:1.0.0-SNAPSHOT]
      		 
      	at org.apache.asterix.api.http.servlet.QueryServiceServlet.handleRequest(QueryServiceServlet.java:495) [asterix-app-0.8.9-SNAPSHOT.jar:0.8.9-SNAPSHOT]
      		 
      	at org.apache.asterix.api.http.servlet.QueryServiceServlet.doPost(QueryServiceServlet.java:412) [asterix-app-0.8.9-SNAPSHOT.jar:0.8.9-SNAPSHOT]
      		 
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [javax.servlet-api-3.1.0.jar:3.1.0]
      		 
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet-api-3.1.0.jar:3.1.0]
      		 
      	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845) [jetty-servlet-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583) [jetty-servlet-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511) [jetty-servlet-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.Server.handle(Server.java:524) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253) [jetty-server-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273) [jetty-io-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95) [jetty-io-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) [jetty-io-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) [jetty-util-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) [jetty-util-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) [jetty-util-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) [jetty-util-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) [jetty-util-9.3.11.v20160721.jar:9.3.11.v20160721]
      		 
      	at java.lang.Thread.run(Thread.java:745) [?:1.8.0_77]

      It does not seem to inhibit the functionality of the workbench.

      Attachments

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

        Activity

          People

            yingyi Yingyi Bu (Inactive)
            till Till Westmann
            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