Bug 1301951 - [scale] - getstorage_domain_by_type_storagepoolid_and_status hit the engine start up
Summary: [scale] - getstorage_domain_by_type_storagepoolid_and_status hit the engine ...
Keywords:
Status: CLOSED INSUFFICIENT_DATA
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Backend.Core
Version: 3.6.2
Hardware: x86_64
OS: Linux
unspecified
low vote
Target Milestone: ovirt-4.2.0
: 4.2.0
Assignee: Martin Perina
QA Contact: eberman
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-01-26 12:39 UTC by Eldad Marciano
Modified: 2017-10-26 08:45 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-10-26 08:45:11 UTC
oVirt Team: Infra
rule-engine: ovirt-4.2+
rule-engine: planning_ack+
rule-engine: devel_ack+
eberman: testing_ack+

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

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 )
Note You need to log in before you can comment on or make changes to this bug.