Bug 1329414

Summary:	over time, horizon's admin -> overview page becomes very slow ....
Product:	[Community] RDO	Reporter:	Kambiz Aghaiepour <kambiz>
Component:	python-django-horizon	Assignee:	Matthias Runge <mrunge>
Status:	CLOSED EOL	QA Contact:	Ido Ovadia <iovadia>
Severity:	medium	Docs Contact:
Priority:	unspecified
Version:	Kilo	CC:	aortega, apevec, athomas, iserrano, jjozwiak, mrunge, srevivo
Target Milestone:	---
Target Release:	Kilo
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-05-19 15:38:03 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Kambiz Aghaiepour 2016-04-21 20:52:55 UTC

Description of problem:

I've noticed that when logging into the admin account after a bunch of activity against the RDO installation, it takes a very long time (many minutes) before horizon loads (I think the issue is the overview admin page which is also the main landing page for logging in).

The list includes overall activity including deleted projects.  If you orchestrate lots of testing against the installation using "rally" you will see lots of projects get created and later deleted.  As such I have an overview page which lists at the bottom:

"Displaying 2035 items"

Is it possible to do something about the Overview page either by displaying only the first 20 items, or changing the type of information being displayed?  Logging into admin is very painful currently.  Non-admin accounts login quickly.


Version-Release number of selected component (if applicable):

Liberty

How reproducible:

Always.

Steps to Reproduce:

Run rally against openstack in an endless loop.  After a few days (or hours depending on what you do and how you do it) you will find horizon getting slower and slower.

Comment 1 Alan Pevec 2016-04-21 22:11:26 UTC

This seems to be generic design issue so it should be reported (and fixed) upstream.

Comment 2 Kambiz Aghaiepour 2016-04-21 22:41:04 UTC

I'm happy to report it upstream.  Once I have it reported I will link the upstream bug here.

Comment 3 Kambiz Aghaiepour 2016-04-21 22:44:44 UTC

https://bugs.launchpad.net/horizon/+bug/1573288

Comment 4 Itxaka 2016-04-22 08:19:39 UTC

This has been reported in here: https://bugzilla.redhat.com/show_bug.cgi?id=1320724

There is also a patch upstream that alleviates this issue: https://review.openstack.org/#/c/238204/


Seems that there is not a simple fix for this:

 - Disable the overview panel completely
 - Redo the whole Overview panel to not take into account deleted instances by default
 - Change the range for the display to one day so the delay in displaying is not that big

Comment 5 Itxaka 2016-04-22 08:21:56 UTC

*** Bug 1320724 has been marked as a duplicate of this bug. ***

Comment 6 Kambiz Aghaiepour 2016-04-22 13:31:58 UTC

I applied the upstream patch and it seems to work out fine.  I also changed the default value of days_range from None to 1 in the first_day method of the BaseUsage class defined in /usr/share/openstack-dashboard/openstack_dashboard/usage/base.py to avoid _needing_ to set the OVERVIEW_DAYS_RANGE setting.

I commented on it upstream as the default behavior of "first of the month until today" seems arbitrary and frankly makes the dashboard unusable in the default view particularly as it gets to be later and later into the current month.

Comment 7 Chandan Kumar 2016-05-19 15:38:03 UTC

This bug is against a Version which has reached End of Life.
If it's still present in supported release (http://releases.openstack.org), please update Version and reopen.