[3.2.2.0-31]OpServerUtils.get_query_result not returning the result
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Juniper Openstack | Status tracked in Trunk | |||||
R3.0 |
New
|
High
|
Sandip Dey | |||
R3.0.3.x |
New
|
High
|
Sandip Dey | |||
R3.1 |
New
|
High
|
Sandip Dey | |||
R3.2 |
Fix Committed
|
High
|
Sandip Dey | |||
R4.0 |
Fix Committed
|
High
|
Sandip Dey | |||
R4.1 |
Fix Committed
|
High
|
Sandip Dey | |||
Trunk |
Fix Committed
|
High
|
Sandip Dey |
Bug Description
AnalyticsTestSa
due to this issue.
Failing in the following :
[Build "Ubuntu 14.04.4 LTS" 3.0.3.3-21~kilo] Multi-Interface HA Sanity[mgmt, ctrl=data] Report
[Build "Ubuntu 14.04.4 LTS" 3.0.3.3-21~kilo] Multi-Interface HA Sanity[mgmt, ctrl=data] Report
[Build "Ubuntu 14.04.5 LTS" 3.2.2.0-31~kilo] Multi-Node Virtual Testbed Sanity[mgmt, ctrl=data] Report
[Build "Ubuntu 14.04.5 LTS" 3.2.2.0-31~mitaka] Multi-Node Virtual Testbed Contrail Networking Package Sanity Report
OpServerUtils.
In the following code, OpServerUtils.
The following was the query:
http://
and the query did not return anything as opposed to the script expectation.
Looks like an issue with the where clause when async query is done.
In this case, src vn and dst were specified as shown below.. When
Query:
(Pdb) query_dict
{'table': 'FlowRecordTable', 'start_time': 1490024059000000, 'where': [[{'value2': None, 'name': 'sourcevn', 'value': 'default-
Logs:
> /root/contrail-
-> flows_url = OpServerUtils.
flows_url
'http://
-> query_dict = OpServerUtils.
(Pdb) query_dict
{'table': 'FlowRecordTable', 'start_time': 1490024059000000, 'where': [[{'value2': None, 'name': 'sourcevn', 'value': 'default-
-> resp = OpServerUtils.
resp
u'{"href": "/analytics/
-> qid = resp['href'
> /root/contrail-
-> result = OpServerUtils.
-> print resp.__dict__
{'cookies': <<class 'requests.
> /root/contrail-
-> for chunk in status['chunks']:
status['chunks']
[{u'count': 0, u'start_time': u'1490024059000
http://
{
value: [ ]
}
root/contrail-
-> self.logger.
(Pdb) n
2017-03-20 10:31:00,726 - INFO - Query output: []
Discussed with Nikhil.
Changed in juniperopenstack: | |
importance: | Undecided → High |
Changed in juniperopenstack: | |
milestone: | r3.2.2.0 → none |
description: | updated |
tags: | removed: sanity |
tags: |
added: automation removed: analytics |
start_time and end_time are passed from different timezones. One is IST and other one is UTC. Because of this, delta time is 1 microsecond and query engine does not find anything.