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

CREATE DATASET AT dataverse.link does not recognize dataverse

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown
    • CX Sprint 209

    Description

      Assume that the Test dataverse exists.

      Create a remote link in the Test dataverse using the REST API:

      $ curl -v -u Administrator:password -X POST "http://localhost:8095/analytics/link?dataverse=Test&name=myCbLink&type=couchbase&hostname=remote:8091&username=Administrator&password=password&encryption=none"

      On localhost, create a dataset on the remote link:

      CREATE DATASET airports ON `travel-sample` AT Test.myCbLink WHERE `type` = "airport";

      The dataset is not created:

      [
      		 
        {
      		 
          "code": 24006,
      		 
          "msg": "Link Default.myCbLink does not exist",
      		 
          "query_from_user": "CREATE DATASET airports ON `travel-sample` AT Test.myCbLink WHERE `type` = \"airport\";"
      		 
        }
      		 
      ]

      Note that the error message states Default.myCbLink does not exist even though we specified AT Test.myCbLink.

      However, changing the default dataverse with USE works:

      USE Test;
      		 
      CREATE DATASET airports ON `travel-sample` AT Test.myCbLink WHERE `type` = "airport";

      Attachments

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

        Activity

          Ascending order - Click to sort in descending order
          simon.dew Simon Dew created issue -
          till Till Westmann made changes -
          Field Original Value New Value
          Labels triaged
          Hussain.Towaileb Hussain Towaileb made changes -
          Sprint CX Sprint 209 [ 1167 ]
          Hussain.Towaileb Hussain Towaileb made changes -
          Rank Ranked higher
          Hussain.Towaileb Hussain Towaileb made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hussain.Towaileb Hussain Towaileb made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          till Till Westmann made changes -
          Link This issue blocks MB-38724 [ MB-38724 ]
          till Till Westmann made changes -
          Labels triaged approved-for-6.6.0 triaged
          till Till Westmann made changes -
          Due Date 24/Jul/20
          Hussain.Towaileb Hussain Towaileb made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-6.6.0-7895 contains cbas-core commit b3b2a01 with commit message:
          MB-40605: Use the correct dataverse when creating remote links

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.0-7895 contains cbas-core commit b3b2a01 with commit message: MB-40605 : Use the correct dataverse when creating remote links
          umang.agrawal Umang made changes -
          Labels approved-for-6.6.0 triaged approved-for-6.6.0 needs-functional-test triaged
          umang.agrawal Umang added a comment -

          verified with couchbase server build 6.6.0-7897

          umang.agrawal Umang added a comment - verified with couchbase server build 6.6.0-7897
          umang.agrawal Umang made changes -
          VERIFICATION STEPS 1. Create a dataverse "Test".
          2. curl -v -u Administrator:password -X POST "http://localhost:8095/analytics/link?dataverse=Test&name=myCbLink&type=couchbase&hostname=remote:8091&username=Administrator&password=password&encryption=none"
          3. CREATE DATASET airports ON `travel-sample` AT Test.myCbLink WHERE `type` = "airport";
          4. dataset created successfully.
          Assignee Hussain Towaileb [ hussain.towaileb ] Umang [ JIRAUSER24787 ]
          Status Resolved [ 5 ] Closed [ 6 ]
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-7.0.0-2746 contains cbas-core commit b3b2a01 with commit message:
          MB-40605: Use the correct dataverse when creating remote links

          build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.0-2746 contains cbas-core commit b3b2a01 with commit message: MB-40605 : Use the correct dataverse when creating remote links
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-6.6.2-9599 contains cbas-core commit b3b2a01 with commit message:
          MB-40605: Use the correct dataverse when creating remote links

          build-team Couchbase Build Team added a comment - Build couchbase-server-6.6.2-9599 contains cbas-core commit b3b2a01 with commit message: MB-40605 : Use the correct dataverse when creating remote links

          People

            umang.agrawal Umang
            simon.dew Simon Dew
            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