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

[IPV6] Advisor not returning session advise with cluster using IPV6 address

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 7.0.2
    • Neo, 7.0.2
    • query
    • 7.0.2-6883
    • Untriaged
    • 1
    • No

    Description

      To repro:

      • setup single node using ipv6 address
      • load travel-sample
      • connect via cbq and run following:
        • SELECT ADVISOR({'action':'start', 'duration':'40m'})
        • SELECT airportname FROM `travel-sample` WHERE type = "airport" AND lower(city) = "lyon" AND country = "France";
        • SELECT airportname FROM `travel-sample` WHERE type = "airport" AND lower(city) = "grenoble" AND country = "France";
        • select advisor({'action':'list'});
        • select advisor({'action':'stop', 'session':'18a0a2d5-9750-4245-8415-447bff9c1322'}); – replace with your session-id
        • select advisor({'action':'list'}) or select advisor({'action':'get', 'session':'18a0a2d5-9750-4245-8415-447bff9c1322'});

      Advise is empty:

      cbq> SELECT ADVISOR({'action':'start', 'duration':'40m'});
      {
          "requestID": "aff6c04f-e145-4f98-b154-a6726ac9fc86",
          "signature": {
              "$1": "object"
          },
          "results": [
          {
              "$1": {
                  "session": "18a0a2d5-9750-4245-8415-447bff9c1322"
              }
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "4.227506ms",
              "executionTime": "4.04726ms",
              "resultCount": 1,
              "resultSize": 95,
              "serviceLoad": 6
          }
      }
      cbq> SELECT airportname FROM `travel-sample` WHERE type = "airport" AND lower(city) = "lyon" AND country = "France";
      {
          "requestID": "913a0ace-bd10-49b0-ba47-fb0980848529",
          "signature": {
              "airportname": "json"
          },
          "results": [
          {
              "airportname": "Bron"
          },
          {
              "airportname": "Lyon Part-Dieu Railway"
          },
          {
              "airportname": "Saint Exupery"
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "156.141559ms",
              "executionTime": "155.886014ms",
              "resultCount": 3,
              "resultSize": 138,
              "serviceLoad": 6
          }
      }
      cbq> SELECT airportname FROM `travel-sample` WHERE type = "airport" AND lower(city) = "grenoble" AND country = "France";
      {
          "requestID": "1b34c6aa-2c71-4fb9-a4ce-caf0e7a1e14f",
          "signature": {
              "airportname": "json"
          },
          "results": [
          {
              "airportname": "Saint Geoirs"
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "153.643882ms",
              "executionTime": "153.451189ms",
              "resultCount": 1,
              "resultSize": 45,
              "serviceLoad": 6
          }
      }
      cbq> select advisor({'action':'list'});
      {
          "requestID": "0d71eb7f-6f2a-4327-b5a5-d360859a3b49",
          "signature": {
              "$1": "object"
          },
          "results": [
          {
              "$1": [
                  {
                      "tasks_cache": {
                          "class": "advisor",
                          "delay": "40m0s",
                          "id": "6cf01d10-e690-5074-943c-eda1342aea5b",
                          "name": "18a0a2d5-9750-4245-8415-447bff9c1322",
                          "node": "fd63:6f75:6368:2078:b4fb:edff:fe2c:9451:8091",
                          "state": "scheduled",
                          "subClass": "analyze",
                          "submitTime": "2021-09-22 12:40:15.162733883 -0700 PDT m=+973.007142208"
                      }
                  },
                  {
                      "tasks_cache": {
                          "class": "advisor",
                          "delay": "40m0s",
                          "id": "6cf01d10-e690-5074-943c-eda1342aea5b",
                          "name": "18a0a2d5-9750-4245-8415-447bff9c1322",
                          "node": "[fd63:6f75:6368:2078:b4fb:edff:fe2c:9451]:8091",
                          "state": "scheduled",
                          "subClass": "analyze",
                          "submitTime": "2021-09-22 12:40:15.162733883 -0700 PDT m=+973.007142208"
                      }
                  }
              ]
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "8.306142ms",
              "executionTime": "8.11363ms",
              "resultCount": 1,
              "resultSize": 1126,
              "serviceLoad": 6
          }
      }
      cbq> select advisor({'action':'stop', 'session':'18a0a2d5-9750-4245-8415-447bff9c1322'});
      {
          "requestID": "de362223-ce2e-47ba-8fd6-e6c71484a7d2",
          "signature": {
              "$1": "object"
          },
          "results": [
          {
              "$1": []
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "2.063466559s",
              "executionTime": "2.063197491s",
              "resultCount": 1,
              "resultSize": 24,
              "serviceLoad": 6
          }
      }
      cbq> select advisor({'action':'list'});
      {
          "requestID": "8a070f82-9bbc-4c35-a09b-3aa9ccb2f737",
          "signature": {
              "$1": "object"
          },
          "results": [
          {
              "$1": []
          }
          ],
          "status": "success",
          "metrics": {
              "elapsedTime": "6.310308ms",
              "executionTime": "6.079502ms",
              "resultCount": 1,
              "resultSize": 24,
              "serviceLoad": 6
          }
      }
       

      Note that when i setup cluster with hostname and use ipv6-only settings it works as expected.

      Seems like we had this issue on 7.0 as well http://cb-logs-qe.s3-website-us-west-2.amazonaws.com/7.0.0-5302/jenkins_logs/test_suite_executor/362320/consoleText.txt

       

      Attachments

        Issue Links

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

          Activity

            There are no commits yet on this issue.

            People

              pierre.regazzoni Pierre Regazzoni
              pierre.regazzoni Pierre Regazzoni
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty