QE ignores filter while querying for stat queries

Bug #1605371 reported by Chinmay Zanpure
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Juniper Openstack
Status tracked in Trunk
R3.1
Fix Committed
High
Nikhil Bansal
Trunk
Fix Committed
High
Nikhil Bansal

Bug Description

Following Query JSON returns 21000 records whereas the limit is only 15:
{
 "table": "StatTable.NodeStatus.process_mem_cpu_usage",
 "start_time": 1469084760000000,
 "end_time": 1469127960000000,
 "select_fields": ["T=60", "COUNT(process_mem_cpu_usage)","process_mem_cpu_usage.module_id","process_mem_cpu_usage.inst_id", "SUM(process_mem_cpu_usage.mem_virt)", "MAX(process_mem_cpu_usage.mem_virt)",
"MIN(process_mem_cpu_usage.mem_virt)", "AVG(process_mem_cpu_usage.mem_virt)", "SUM(process_mem_cpu_usage.cpu_share)", "MAX(process_mem_cpu_usage.cpu_share)", "MIN(process_mem_cpu_usage.cpu_share)", "AVG(process_mem_cpu_usage.cpu_share)", "SUM(process_mem_cpu_usage.mem_res)", "MAX(process_mem_cpu_usage.mem_res)", "MIN(process_mem_cpu_usage.mem_res)", "AVG(process_mem_cpu_usage.mem_res)", "name", "CLASS(T=)"],
 "filter": [
  []
 ],
 "where": [
  [{
   "name": "name",
   "value": "",
   "op": 7
  }]
 ],
 "limit": 15,
 "sort": "asc",
 "dir": 1
}

Tags: analytics
Revision history for this message
Chinmay Zanpure (czanpure) wrote :
Changed in juniperopenstack:
assignee: Raj Reddy (rajreddy) → Nikhil Bansal (nikhilb-u)
Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : [Review update] R3.1

Review in progress for https://review.opencontrail.org/22364
Submitter: Nikhil Bansal (<email address hidden>)

Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : A change has been merged

Reviewed: https://review.opencontrail.org/22364
Committed: http://github.org/Juniper/contrail-controller/commit/8df3c010a91b80135b024639c79e219f5cead71e
Submitter: Zuul
Branch: R3.1

commit 8df3c010a91b80135b024639c79e219f5cead71e
Author: Nikhil B <email address hidden>
Date: Mon Jul 25 11:11:44 2016 +0530

Applying Limit filter on map results

Limit filter was not getting applied on map results because of which stats
query results were not getting filtered
Closes-Bug: 1605371

Change-Id: Idba744c1bb1904d441fc0935d1f4feb75a0fa676

Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : [Review update] master

Review in progress for https://review.opencontrail.org/22793
Submitter: Nikhil Bansal (<email address hidden>)

information type: Proprietary → Public
Revision history for this message
OpenContrail Admin (ci-admin-f) wrote : A change has been merged

Reviewed: https://review.opencontrail.org/22793
Committed: http://github.org/Juniper/contrail-controller/commit/9be037d1296abf60f0322cb89d77ed9d5d976237
Submitter: Zuul
Branch: master

commit 9be037d1296abf60f0322cb89d77ed9d5d976237
Author: Nikhil B <email address hidden>
Date: Wed Aug 3 14:45:33 2016 +0530

Applying Limit filter on map results

Limit filter was not getting applied on map results because of which stats
query results were not getting filtered
Closes-Bug: 1605371

Change-Id: Ieb266731487020cbcf67f60cda04bab3d2b375db

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.