Bug 535090 (RHQ-1821)

Summary:	postgres plugin config metadata bad?
Product:	[Other] RHQ Project	Reporter:	John Mazzitelli <mazz>
Component:	Plugins	Assignee:	RHQ Project Maintainer <rhq-maint>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Rajan Timaniya <rtimaniy>
Severity:	medium	Docs Contact:
Priority:	low
Version:	unspecified	CC:	cwelton, rtimaniy
Target Milestone:	---	Keywords:	SubBug
Target Release:	---
Hardware:	All
OS:	All
URL:	http://jira.rhq-project.org/browse/RHQ-1821
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-08-25 09:08:07 UTC	Type:	---
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:
Bug Blocks:	565628

Description John Mazzitelli 2009-03-19 20:01:00 UTC

I created a compatible group of two postgres servers. Each agent was up. Went to the config tab for a user in that group and got this in the logs:

15:59:09,625 WARN  [ConfigurationManagerBean] Could not get live configuration f
or resource [Resource[id=500167, type=User, key=postgres, name=postgres User, pa
rent=Postgres [postgres]]]org.rhq.core.clientapi.agent.PluginContainerException:
Cannot load Resource configuration for [500167] -> org.rhq.core.util.exception.W
rappedRemotingException:The column name rolcreaterol was not found in this Resul
tSet.

UI says this:

Failed to load group Resource configuration. Cause: javax.ejb.EJBException:java.lang.RuntimeException: Failed to retrieve live Resource configurations. -> java.lang.RuntimeException:Failed to retrieve live Resource configurations. -> java.util.concurrent.ExecutionException:java.lang.Exception: Failed to obtain live Resource configuration for Resource[id=500167, type=User, key=postgres, name=postgres User, parent=Postgres [postgres]]. -> java.lang.Exception:Failed to obtain live Resource configuration for Resource[id=500167, type=User, key=postgres, name=postgres User, parent=Postgres [postgres]].

Comment 1 Ian Springer 2009-03-20 03:35:56 UTC

I've also noticed "The column name rolcreaterol was not found in this ResultSet." errors periodically in the Agent log.

Comment 2 Red Hat Bugzilla 2009-11-10 20:47:23 UTC

This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1821

Comment 3 wes hayutin 2010-02-16 16:55:55 UTC

Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs.

keyword:
new = Tracking + FutureFeature + SubBug

Comment 4 wes hayutin 2010-02-16 17:01:02 UTC

making sure we're not missing any bugs in rhq_triage

Comment 5 Corey Welton 2010-08-20 15:47:52 UTC

QA: see if this still occurs.  If it does, assign to Heiko for examination.  Otherwise, close.

Comment 6 Rajan Timaniya 2010-08-25 09:08:07 UTC

Verified on JON 2.4 GA

Steps:
1) Install JON 2.4 GA with 2 agents (each agent has postgres)
2) Log-in to JON
3) Create a compatible group of two postgres servers. (Each agent should up)
4) Went to the config tab for a user in that group and observed server and agent logs

Observation:
There isn't any error/exception found in UI or server/agents log.