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

[System Test] Exception org.apache.asterix.common.exceptions.CompilationException: ASX1050: Cannot find dataset seen

    XMLWordPrintable

Details

    • 0
    • Yes
    • Analytics Sprint 42

    Description

      During the system test run with 1.0.0-2045 build, there was an exception seen -

      Seen on node svc-da-node-002.ppio8gahlzrhfijl.sandbox.nonprod-project-avengers.com

      2024-05-09T13:02:08.889+00:00 INFO CBAS.bootstrap.AnalyticsNCApplication [main] Starting Couchbase Analytics driver, version: {"build.date":"Mon Apr 29 12:39:42 PDT 2024","build.number":"2045","build.version":"7.6.100"}
      2024-05-09T13:02:40.441+00:00 INFO CBAS.bootstrap.AnalyticsNCApplication [main] Starting Couchbase Analytics driver, version: {"build.date":"Mon Apr 29 12:39:42 PDT 2024","build.number":"2045","build.version":"7.6.100"}
      2024-05-09T17:08:52.419+00:00 ERRO CBAS.translator.QueryTranslator [QueryTranslator:ef079172-d3c5-4c8d-9a6e-45225e91947f] failed to drop dataset; executing compensating operations
      org.apache.asterix.common.exceptions.CompilationException: ASX1050: Cannot find dataset with name tsvExternalDatasetCEnDSKgkmD in dataverse Default.Default (in line 1, at column 1)
      	at org.apache.asterix.app.translator.QueryTranslator.doDropDataset(QueryTranslator.java:2386) ~[asterix-app.jar:1.0.0-2045]
      	at com.couchbase.analytics.lang.CBStatementExecutor.doDropDataset(CBStatementExecutor.java:1557) ~[columnar-connector.jar:1.0.0-2045]
      	at org.apache.asterix.app.translator.QueryTranslator.handleDatasetDropStatement(QueryTranslator.java:2343) ~[asterix-app.jar:1.0.0-2045]
      	at com.couchbase.analytics.lang.CBStatementExecutor.handleDatasetDropStatement(CBStatementExecutor.java:1537) ~[columnar-connector.jar:1.0.0-2045]
      	at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:415) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:181) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:74) ~[hyracks-control-cc.jar:1.0.0-2045]
      	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) [?:?]
      2024-05-09T17:08:53.600+00:00 ERRO CBAS.translator.QueryTranslator [QueryTranslator:91347de5-6907-476c-a332-0eb0200eb9b4] failed to drop dataset; executing compensating operations
      org.apache.asterix.common.exceptions.CompilationException: ASX1050: Cannot find dataset with name tsvExternalDatasetCEnDSKgkmD in dataverse Default.Default (in line 1, at column 1)
      	at org.apache.asterix.app.translator.QueryTranslator.doDropDataset(QueryTranslator.java:2386) ~[asterix-app.jar:1.0.0-2045]
      	at com.couchbase.analytics.lang.CBStatementExecutor.doDropDataset(CBStatementExecutor.java:1557) ~[columnar-connector.jar:1.0.0-2045]
      	at org.apache.asterix.app.translator.QueryTranslator.handleDatasetDropStatement(QueryTranslator.java:2343) ~[asterix-app.jar:1.0.0-2045]
      	at com.couchbase.analytics.lang.CBStatementExecutor.handleDatasetDropStatement(CBStatementExecutor.java:1537) ~[columnar-connector.jar:1.0.0-2045]
      	at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:415) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:181) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app.jar:1.0.0-2045]
      	at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:74) ~[hyracks-control-cc.jar:1.0.0-2045]
      	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) [?:?]
      

      The test log does indicate that the dataset creation was successful -

      2024-05-09T13:06:28.218Z	debug	api call success	{"env": "other", "method": "POST", "url": "https://api.qe-8.sandbox.nonprod-project-avengers.com/v2/organizations/c76eef43-5196-4675-b869-a536258f9d68/projects/21e370da-34b2-426c-a608-dc6efb28c651/instance/fb9291b1-e817-4b27-95f5-8320cda9e6d6/proxy/query/service", "timeoutSec": 600, "status": 200, "requestId": "994890f1-7365-48bc-ae02-91bfee175187"}
      2024-05-09T13:06:28.218Z	info	Created external dataset tsvExternalDatasetCEnDSKgkmD using link : tsvExternalLinkWuBeEgNZXv	{"env": "other", "action": "Create External Link", "ExternalLinkName": "", "ExternalDatasetName": "", "AWSBucketName": "columnar-functional-sanity-test-data", "AWSBucketPath": "", "AWSFileFormat": "tsv", "IncludeRegex": "*.tsv", "ExcludeRegex": "", "ExternalLinkRegion": "us-west-1", "ProjectID": "21e370da-34b2-426c-a608-dc6efb28c651", "TypeDefinition": "id int,product_name string,product_link string, product_features string,product_specs string, product_image_links string,product_reviews string, product_category string, price double,avg_rating double, num_sold int,upload_date string,weight double,quantity int, seller_name string, seller_location string,seller_verified boolean,template_name string,mutated int, padding string", "Header": true, "InstanceID": "fb9291b1-e817-4b27-95f5-8320cda9e6d6", "ExternalLinkType": "S3", "NumberOfLinks": 1, "NumberOfDatasets": 2, "KeyspaceName": "", "KeyspaceSelectionStrategy": "random"}
      

      The test attempted to drop the datatset and failed with an error. This was about 4 hours after the dataset creation -

      2024-05-09T17:08:53.648Z	warn	api call failed	{"env": "other", "method": "POST", "url": "https://api.qe-8.sandbox.nonprod-project-avengers.com/v2/organizations/c76eef43-5196-4675-b869-a536258f9d68/projects/21e370da-34b2-426c-a608-dc6efb28c651/instance/fb9291b1-e817-4b27-95f5-8320cda9e6d6/proxy/query/service", "timeoutSec": 600, "attempt": 3, "method": "POST", "address": "https://api.qe-8.sandbox.nonprod-project-avengers.com/v2/organizations/c76eef43-5196-4675-b869-a536258f9d68/projects/21e370da-34b2-426c-a608-dc6efb28c651/instance/fb9291b1-e817-4b27-95f5-8320cda9e6d6/proxy/query/service", "error": "unexpected status code 400", "status_code": 400, "body": "{\n\t\"requestID\": \"91347de5-6907-476c-a332-0eb0200eb9b4\",\n\t\"errors\": [{ \n\t\t\"code\": 24025,\t\t\"msg\": \"Cannot find analytics collection with name tsvExternalDatasetCEnDSKgkmD in analytics scope Default.Default (in line 1, at column 1)\"\t} \n\t],\n\t\"status\": \"fatal\",\n\t\"metrics\": {\n\t\t\"elapsedTime\": \"3.524107ms\",\n\t\t\"executionTime\": \"2.853056ms\",\n\t\t\"compileTime\": \"0ns\",\n\t\t\"queueWaitTime\": \"0ns\",\n\t\t\"resultCount\": 0,\n\t\t\"resultSize\": 0,\n\t\t\"processedObjects\": 0,\n\t\t\"bufferCacheHitRatio\": \"0.00%\",\n\t\t\"bufferCachePageReadCount\": 0,\n\t\t\"errorCount\": 1\n\t}\n}\n", "requestId": "35172ddc-d60d-4599-82b8-01310b27a2ab"}
      github.com/couchbasecloud/couchbase-cloud/internal/test/tdk2.mustCallAPI.func3
      

      cbcollect ->

      https://cb-engineering.s3.amazonaws.com/SysTestColumnar/collectinfo-2024-05-09T174258-ns_1%40svc-da-node-001.ppio8gahlzrhfijl.sandbox.nonprod-project-avengers.com.zip
      https://cb-engineering.s3.amazonaws.com/SysTestColumnar/collectinfo-2024-05-09T174258-ns_1%40svc-da-node-002.ppio8gahlzrhfijl.sandbox.nonprod-project-avengers.com.zip
      https://cb-engineering.s3.amazonaws.com/SysTestColumnar/collectinfo-2024-05-09T174258-ns_1%40svc-da-node-003.ppio8gahlzrhfijl.sandbox.nonprod-project-avengers.com.zip
      https://cb-engineering.s3.amazonaws.com/SysTestColumnar/collectinfo-2024-05-09T174258-ns_1%40svc-da-node-004.ppio8gahlzrhfijl.sandbox.nonprod-project-avengers.com.zip

      cc Ritam Sharma

      Attachments

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

        Activity

          People

            pavan.pb Pavan PB
            pavan.pb Pavan PB
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty