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

Internal error while executing copy to statement

    XMLWordPrintable

Details

    Description

      Steps to reproduce - 

      1. Create an on-prem cluster with serverless mode.
      2. Setup the compute storage seperation.
      3. Now load travel-sample bucket on KV
      4. create a dataset on travel-sample.
      5. Now execute copy to statement.
        1.  

          COPY x TO copytotest AT l1 PATH("test1");Following error is observed on analytics workbench -[
            {
              "code": 25000,
              "msg": "Internal error",
              "query_from_user": "COPY x TO copytotest AT l1 PATH(\"test1\");"
            }
          ]

      Below is the error seen in analytics_info.log

      2023-11-02T13:58:33.116+05:30 ERRO CBAS.apache.asterix [Executor-20:ClusterController] Unexpected exception
      java.lang.NullPointerException: Cannot invoke "org.apache.asterix.common.metadata.Namespace.getDataverseName()" because the return value of "org.apache.asterix.lang.common.statement.CopyToStatement.getNamespace()" is null
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.setQuery(SqlppCopyToRewriteVisitor.java:53) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.visit(SqlppCopyToRewriteVisitor.java:47) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.visit(SqlppCopyToRewriteVisitor.java:41) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.common.statement.CopyToStatement.accept(CopyToStatement.java:80) ~[asterix-lang-common-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.SqlppStatementRewriter.rewrite(SqlppStatementRewriter.java:50) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.translator.QueryTranslator.rewriteStatement(QueryTranslator.java:5462) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:371) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:180) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:68) ~[hyracks-control-cc-8.0.0-1453.jar:8.0.0-1453]
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
      	at java.base/java.lang.Thread.run(Thread.java:840) [?:?]
      2023-11-02T13:58:33.119+05:30 INFO CBAS.messaging.NCMessageBroker [Worker:b955d8a17a1c16c7dbca58bd13db32e9] Received message: ExecuteStatementResponseMessage(id=167): 0 characters
      2023-11-02T13:58:33.120+05:30 WARN CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-9] handleException: unexpected exception: <ud>{"host":"172.23.105.171:8091","path":"/query/service","statement":"COPY x TO copytotest AT l1 PATH(\\\"test1\\\");","pretty":false,"mode":"immediate","clientContextID":"4dfd11f8-fc16-4382-966c-0751aacc1a86","clientType":"ASTERIX","dataverse":null,"format":"CLEAN_JSON","timeout":9223372036854775807,"maxResultReads":1,"planFormat":"JSON","expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":true,"job":false,"profile":"counts","signature":true,"multiStatement":false,"parseOnly":false,"readOnly":false,"maxWarnings":10,"sqlCompat":false,"scanConsistency":"not_bounded","scanWait":null}</ud>
      java.lang.NullPointerException: null
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.setQuery(SqlppCopyToRewriteVisitor.java:53) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.visit(SqlppCopyToRewriteVisitor.java:47) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppCopyToRewriteVisitor.visit(SqlppCopyToRewriteVisitor.java:41) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.common.statement.CopyToStatement.accept(CopyToStatement.java:80) ~[asterix-lang-common-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.lang.sqlpp.rewrites.SqlppStatementRewriter.rewrite(SqlppStatementRewriter.java:50) ~[asterix-lang-sqlpp-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.translator.QueryTranslator.rewriteStatement(QueryTranslator.java:5462) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:371) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:180) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app-8.0.0-1453.jar:8.0.0-1453]
      	at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:68) ~[hyracks-control-cc-8.0.0-1453.jar:8.0.0-1453]
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
      	at java.base/java.lang.Thread.run(Thread.java:840) [?:?] 

       

       

      Attachments

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

        Activity

          People

            wail.alkowaileet Wail Alkowaileet
            umang.agrawal Umang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty