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

CREATE DATASET AT dataverse.link does not recognize dataverse

    XMLWordPrintable

    Details

    • Triage:
      Untriaged
    • Story Points:
      1
    • Is this a Regression?:
      Unknown
    • Sprint:
      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

          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 ]
          umang.agrawal Umang made changes -
          Labels approved-for-6.6.0 triaged approved-for-6.6.0 needs-functional-test triaged
          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 ]

            People

            Assignee:
            umang.agrawal Umang
            Reporter:
            simon.dew Simon Dew
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Gerrit Reviews

                There are no open Gerrit changes

                  PagerDuty