Bug 1306325
| Summary: | [scale] - GetStorageConnectionsByStorageTypeAndStatus generate slow query for multiple SD's | |||
|---|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Eldad Marciano <emarcian> | |
| Component: | Database.Core | Assignee: | Allon Mureinik <amureini> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Eldad Marciano <emarcian> | |
| Severity: | medium | Docs Contact: | ||
| Priority: | unspecified | |||
| Version: | 3.6.2 | CC: | amureini, bugs, emarcian, gklein, mperina, oourfali, ylavi | |
| Target Milestone: | ovirt-4.0.0-alpha | Flags: | oourfali:
ovirt-4.0.0?
ylavi: planning_ack+ amureini: devel_ack+ rule-engine: testing_ack? |
|
| Target Release: | 4.0.0 | |||
| Hardware: | x86_64 | |||
| OS: | Linux | |||
| Whiteboard: | ||||
| Fixed In Version: | Doc Type: | Bug Fix | ||
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1337257 (view as bug list) | Environment: | ||
| Last Closed: | 2016-08-11 15:05:17 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | Storage | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Embargoed: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 1337257 | |||
|
Description
Eldad Marciano
2016-02-10 15:07:44 UTC
performance improved when using this patch: https://gerrit.ovirt.org/#/c/52912/ depends on: https://bugzilla.redhat.com/show_bug.cgi?id=1302794 *** Bug 1306324 has been marked as a duplicate of this bug. *** --10 rows \ SD's exe time = 485ms --1 row \ SD exe time = 495ms So, IIUC from comment 1 https://gerrit.ovirt.org/#/c/52912/ solved the issue Please approve Moving from 4.0 alpha to 4.0 beta since 4.0 alpha has been already released and bug is not ON_QA. approve. any chance to back-port? Allon, do you agree backporting https://gerrit.ovirt.org/52912 into 3.6? (In reply to Martin Perina from comment #7) > Allon, do you agree backporting https://gerrit.ovirt.org/52912 into 3.6? The backport is a bit tricky, but it's easy to verify, and once verified it shouldn't be too risky. Taking the BZ, and will handle the BZ for 3.6.7, as to not add additional risk to 3.6.6 Messed up the flags a bit here, sorry. This bug is ON_QA for 4.0 alpha release. I'll clone it to a new one for 3.6.7 since the schemas have diverged quite a bit, and I'd like it to be verified on both branches. This bug was fixed and is slated to be in the upcoming version. As we are focusing our testing at this phase on severe bugs, this bug was closed without going through its verification step. If you think this bug should be verified by QE, please set its severity to high and move it back to ON_QA |