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]].
I've also noticed "The column name rolcreaterol was not found in this ResultSet." errors periodically in the Agent log.
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-1821
Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs. keyword: new = Tracking + FutureFeature + SubBug
making sure we're not missing any bugs in rhq_triage
QA: see if this still occurs. If it does, assign to Heiko for examination. Otherwise, close.
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.