Bug 1301951

Summary:	[scale] - getstorage_domain_by_type_storagepoolid_and_status hit the engine start up
Product:	[oVirt] ovirt-engine	Reporter:	Eldad Marciano <emarcian>
Component:	Backend.Core	Assignee:	Martin Perina <mperina>
Status:	CLOSED INSUFFICIENT_DATA	QA Contact:	eberman
Severity:	low	Docs Contact:
Priority:	unspecified
Version:	3.6.2	CC:	bugs, eberman, emesika, oourfali, ykaul
Target Milestone:	ovirt-4.2.0	Keywords:	Performance
Target Release:	4.2.0	Flags:	rule-engine: ovirt-4.2+ rule-engine: planning_ack+ rule-engine: devel_ack+ eberman: testing_ack+
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-10-26 08:45:11 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Infra	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Eldad Marciano 2016-01-26 12:39:30 UTC

Description of problem:
this has been called many time, while the engine rising.
the query hit the performance since his avg time to execute is ~20 sec.

required steps
- query optimization. 
- reduce the # of calls (caching or something similar).


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

How reproducible:
100%

Steps to Reproduce:
1. start the engine

Actual results:
long execution time, lots # of calls

Expected results:
fewer # of calls, optimized query with fast response time.

Additional info:

Comment 2 Red Hat Bugzilla Rules Engine 2016-02-29 12:29:21 UTC

Bug tickets must have version flags set prior to targeting them to a release. Please ask maintainer to set the correct version flags and only then set the target milestone.

Comment 3 Sandro Bonazzola 2016-05-02 10:05:36 UTC

Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA.

Comment 4 Yaniv Lavi 2016-05-23 13:20:08 UTC

oVirt 4.0 beta has been released, moving to RC milestone.

Comment 5 Yaniv Lavi 2016-05-23 13:23:41 UTC

oVirt 4.0 beta has been released, moving to RC milestone.

Comment 7 Yaniv Kaul 2017-09-04 14:07:28 UTC

Please re-test in 4.2 with PG 9.5

Comment 8 eberman 2017-10-25 12:31:19 UTC

(In reply to Yaniv Kaul from comment #7)
> Please re-test in 4.2 with PG 9.5

what exactly are we looking for ?
whats "lots # of calls"
what query should i compare and what is efficient improvement ?

Comment 9 Yaniv Kaul 2017-10-25 13:05:36 UTC

(In reply to eberman from comment #8)
> (In reply to Yaniv Kaul from comment #7)
> > Please re-test in 4.2 with PG 9.5
> 
> what exactly are we looking for ?
> whats "lots # of calls"
> what query should i compare and what is efficient improvement ?

I don't know - you guys opened the bug... We want to get base numbers in 4.2 (compared to the initial report in comment 1 )