Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.0.2
-
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
- relates to
-
-
- Closed
-