ORA-02049 for InstalledPackage, ContentServiceRequest deleteByResources
A lot of these (for many, many minutes:)
23:30:47,125 ERROR [org.jboss.as.ejb3.invocation] (http-/0.0.0.0:7080-192) JBAS014134: EJB Invocation failed on component ConfigurationManagerBean for method public abstract void org.rhq.enterprise.server.configuration.ConfigurationManagerLocal.setResourceConfiguration(int,org.rhq.core.domain.configuration.Configuration): javax.ejb.EJBTransactionRolledbackException: Transaction rolled back ... at org.rhq.enterprise.server.configuration.ConfigurationManagerLocal$$$view54.setResourceConfiguration(Unknown Source) [rhq-server.jar:4.12.0] at org.rhq.enterprise.server.configuration.ConfigurationServerServiceImpl.persistUpdatedResourceConfiguration(ConfigurationServerServiceImpl.java:83) [rhq-server.jar:4.12.0] at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source) [:1.8.0] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0] at org.rhq.enterprise.communications.command.impl.remotepojo.server.RemotePojoInvocationCommandService.execute(RemotePojoInvocationCommandService.java:184) [rhq-enterprise-comm-4.12.0.jar:4.12.0]
Followed by more errors in the log. It looks like a bulk delete was happening, causing the agents to fail:
23:33:24,479 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 2049, SQLState: 42000 23:33:24,479 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) ORA-02049: timeout: distributed transaction waiting for lock 23:33:24,479 ERROR [org.rhq.enterprise.server.resource.ResourceManagerBean] (RHQScheduler_Worker-2) Bulk named query delete error for 'InstalledPackage.deleteByResources' for [56 6859]: org.hibernate.exception.SQLGrammarException: could not execute statement 23:34:24,497 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) SQL Error: 2049, SQLState: 42000 23:34:24,497 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (RHQScheduler_Worker-2) ORA-02049: timeout: distributed transaction waiting for lock 23:34:24,497 ERROR [org.rhq.enterprise.server.resource.ResourceManagerBean] (RHQScheduler_Worker-2) Bulk named query delete error for 'ContentServiceRequest.deleteByResources' fo r [566859]: org.hibernate.exception.SQLGrammarException: could not execute statement
This is RHQ 4.12 and I'm wondering if this is an existing issue or not?