0 Replies Latest reply on Aug 1, 2014 7:59 PM by Elias Ross

    ORA-02049 for InstalledPackage, ContentServiceRequest deleteByResources

    Elias Ross Master

      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?