Bug 1198086
| Summary: | Error loading global condition cache: ORA-01427: single-row subquery returns more than one row | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Operations Network | Reporter: | bkramer <bkramer> |
| Component: | Monitoring - Alerts | Assignee: | Michael Burman <miburman> |
| Status: | CLOSED ERRATA | QA Contact: | Mike Foley <mfoley> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | JON 3.3.0 | CC: | fbrychta, loleary, lzoubek, miburman, mmahoney |
| Target Milestone: | ER01 | Keywords: | Triaged |
| Target Release: | JON 3.3.2 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-04-30 16:11:02 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: | |
| Embargoed: | |||
| Bug Depends On: | 1045659 | ||
| Bug Blocks: | |||
|
Description
bkramer
2015-03-03 11:38:08 UTC
Prevent the error by modifying the query in master (not the window where this might happen):
commit 47e27a677fdfd230896afac74dc78c0241bdd66c
Author: Michael Burman <yak>
Date: Mon Mar 30 11:53:12 2015 +0300
[BZ 1045659] Add aggregate function max() to subquery to prevent loading more than one availability_type
branch: release/jon3.3.x link: https://github.com/rhq-project/rhq/commit/91b300366 time: 2015-04-01 19:25:12 +0200 commit: 91b300366c0d5532ff6ecdf36e529c3157306e8a author: Michael Burman - yak message: [BZ 1045659] Add aggregate function max() to subquery to prevent loading more than one availability_type (cherry picked from commit 47e27a677fdfd230896afac74dc78c0241bdd66c) Signed-off-by: Libor Zoubek <lzoubek> Moving to ON_QA for testing with latest cumulative patch build: https://brewweb.devel.redhat.com//buildinfo?buildID=429507 Note: Build maps to JON 3.3.2 ER01 build. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHSA-2015-0920.html |