resource-list makes SQL calls for every resource which is a nested stack
Bug #1578854 reported by
Steve Baker
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Heat |
Fix Released
|
High
|
Steve Baker |
Bug Description
Rather than doing a single query for resources, doing a resource-list appears to perform extra queries for any resources which are also stacks (note, this isn't even a --show-nested)
Will comment with SQL logs when I have a small test case
Changed in heat: | |
milestone: | newton-1 → newton-2 |
Changed in heat: | |
milestone: | newton-2 → newton-3 |
Changed in heat: | |
milestone: | newton-3 → newton-rc1 |
Changed in heat: | |
milestone: | newton-rc1 → none |
milestone: | none → ocata-1 |
Changed in heat: | |
milestone: | ocata-1 → ocata-2 |
To post a comment you must log in.
Illustration from a real deployment that shows how bad this is:
[stack@ r710-undercloud ~]$ time heat resource-list overcloud -n 5 | grep -i failed | ComputeNodesPos tDeployment | 3ffeec84- 3a25-46b8- b219-4f2bfce141 fe | OS::TripleO: :ComputePostDep loyment | UPDATE_FAILED | 2016-05-06T09:10:08 | overcloud | sDeploy | 189eb75d- ef4e-4efb- 89d1-2c3fa94e55 f7 | OS::Heat: :StructuredDepl oyments | UPDATE_FAILED | 2016-05-06T09:17:06 | overcloud- ComputeNodesPos tDeployment- ws3b7l4bgvh5 |
| ComputeArtifact
real 13m23.083s
user 0m12.094s
sys 0m0.510s