Bug 961861

Summary:	Resource configuration not loading due to duplicate times in update history
Product:	[Other] RHQ Project	Reporter:	Steve Bicker <bickersteve>
Component:	Configuration	Assignee:	Nobody <nobody>
Status:	NEW ---	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	4.2	CC:	hrupp
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		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:

Description Steve Bicker 2013-05-10 15:13:23 UTC

Description of problem:
Navigated to the page to display the current configuration for a resource. The content did not load and instead a red error banner displayed with the following information:

Message: Failed to load configuration.
Detail:
java.lang.RuntimeException:[1368198050579] javax.ejb.EJBException:javax.persistence.NonUniqueResultException: result returns 2 elements -> javax.persistence.NonUniqueResultException:result returns 2 elements
--- STACK TRACE FOLLOWS ---
[1368198050579] javax.ejb.EJBException:javax.persistence.NonUniqueResultException: result returns 2 elements -> javax.persistence.NonUniqueResultException:result returns 2 elements


Then discovered that it was being caused by two items in the configuration history having the exact same creation and modified times in the database. Was able to resolve by loading the configuration history page and deleting one of the duplicate entries, but it is unknown as to why they got created like that in the first place. (Also, neither update was directly created by a user; they were automatically generated by RHQ).


Version-Release number of selected component (if applicable):
Version: 4.2.0
Build Number: 6746535


How reproducible:
Have not been able to reproduce.

  
Actual results:
Error banner displays; configuration page does not load.


Expected results:
Configuration page loads without error.


Additional info: