'tags machines' takes 30+ seconds to respond with list of 9 nodes
Bug #1715634 reported by
Jason Hobbs
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MAAS |
Fix Released
|
Critical
|
Blake Rouse | ||
2.2 |
Fix Released
|
Critical
|
Blake Rouse |
Bug Description
I am issuing 'maas <profile> tag machines <tag>' calls to my maas server; it is taking 30+ seconds to respond, even when mostly idle otherwise.
I turned on slow query logging at 100 ms and I see that there are event log queries happening for each node, which are taking a long time to complete:
http://
This is with 2.3.0~alpha2-
Related branches
~blake-rouse/maas:query-count-tags-2.2
- Blake Rouse (community): Approve
-
Diff: 308 lines (+217/-4)2 files modifiedsrc/maasserver/api/tags.py (+17/-4)
src/maasserver/api/tests/test_tag.py (+200/-0)
~blake-rouse/maas:query-count-tags
Merged
into
maas:master
- Mike Pontillo (community): Approve
-
Diff: 308 lines (+217/-4)2 files modifiedsrc/maasserver/api/tags.py (+17/-4)
src/maasserver/api/tests/test_tag.py (+200/-0)
Changed in maas: | |
status: | New → Triaged |
status: | Triaged → In Progress |
importance: | Undecided → Critical |
assignee: | nobody → Blake Rouse (blake-rouse) |
milestone: | none → 2.3.0 |
Changed in maas: | |
status: | In Progress → Fix Committed |
Changed in maas: | |
milestone: | 2.3.0 → 2.3.0alpha3 |
Changed in maas: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
The problem with the event query is that it's sorting by 'created', which there is no index for: http:// paste.ubuntu. com/25483923/
It shouldn't need to sort by created time, since sorting by id will give the same results.