7 Replies Latest reply on Apr 12, 2010 10:04 AM by Patrick Conway

    uninventory fails in all cases

    Patrick Conway Newbie

      For any attempt, uninventory fails, on any kind of resource

      With the following error

       

      RHQ3.0.0 B03

       

      postgres 8.4.3

       

      Failed to uninventory selected resources Cause:  javax.ejb.EJBException:javax.persistence.PersistenceException:  org.hibernate.exception.GenericJDBCException: could not execute update  query ->  javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException:  could not execute update query ->  org.hibernate.exception.GenericJDBCException:could not execute update  query -> org.postgresql.util.PSQLException:ERROR: canceling statement  due to statement timeout[SQLException=ERROR: canceling statement due to  statement timeout]

        • 2. Re: uninventory fails in all cases
          Patrick Conway Newbie

          Hi Ian,

           

          I tried the recommended settings but found some of them invalid

           

           

          work_mem I set to 2MB instead of 2048

           

          and max_fsm_pages through an error as invalid setting

           

          The rest I have set

           

          see attached

          • 3. Re: uninventory fails in all cases
            Patrick Conway Newbie

            I restarted RHQ and postgres

             

            now I'm not seeing the error in the browser

             

            but

             

            this is in the logs

             

             

             

            2010-04-12 14:17:57,374 ERROR [org.rhq.enterprise.communications.command.client.ClientCommandSenderTask] {ClientCommandSenderTask.send-failed}Failed to send command [Command: type=[remotepojo]; cmd-in-response=[false]; config=[{rhq.send-throttle=true}]; p
            arams=[{invocation=NameBasedInvocation[removeResource], targetInterfaceName=org.rhq.core.clientapi.agent.discovery.DiscoveryAgentService}]]. Cause: java.util.concurrent.TimeoutException:null. Cause: java.util.concurrent.TimeoutException
            2010-04-12 14:17:57,374 WARN  [org.rhq.enterprise.server.resource.ResourceManagerBean]  Unable to inform agent of inventory removal for resource [11916]
            java.lang.reflect.UndeclaredThrowableException
                    at $Proxy1722.removeResource(Unknown Source)
                    at org.rhq.enterprise.server.resource.ResourceManagerBean.deleteResource(ResourceManagerBean.java:302)
                    at org.rhq.enterprise.server.resource.ResourceManagerBean.deleteResources(ResourceManagerBean.java:231)
                    at org.rhq.enterprise.server.resource.ResourceManagerBean.uninventoryResources(ResourceManagerBean.java:2071)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                    at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                    at org.rhq.enterprise.server.common.TransactionInterruptInterceptor.addCheckedActionToTransactionManager(TransactionInterruptInterceptor.java:77)
                    at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
                    at org.rhq.enterprise.server.authz.RequiredPermissionsInterceptor.checkRequiredPermissions(RequiredPermissionsInterceptor.java:153)
                    at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
                    at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
                    at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                    at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                    at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                    at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
                    at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
                    at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
                    at $Proxy328.uninventoryResources(Unknown Source)
                    at org.rhq.enterprise.gui.inventory.browse.BrowseResourcesUIBean.uninventorySelectedResources(BrowseResourcesUIBean.java:112)
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    at java.lang.reflect.Method.invoke(Method.java:597)
                    at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
                    at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
                    at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
                    at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
                    at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
            • 4. Re: uninventory fails in all cases
              Ian Springer Master

              This means the Server is timing out while trying to connect to the Agent managing the Resource you are trying to uninventory. Make sure that Agent is running and is reachable over the network from the Server.

              • 5. Re: uninventory fails in all cases
                Patrick Conway Newbie

                ah....

                 

                this agent has been removed/renamed

                 

                The platform was originally given the unfortunate name of "hotstuff"

                 

                but the agent has been reconfigured with a more suitable name & hostname,

                 

                 

                Is it possible to uninventory the resources in the case where the agent no-longer exists?

                 

                 

                 

                 

                 

                .

                .

                .

                 

                I just restarted RHQ again, and "hotstuff" and all her subsidiaries are now gone from the resource list

                 

                 

                Thanks for you help

                • 6. Re: uninventory fails in all cases
                  mazz Master

                  Uninventory the platform itself. I believe in the latest code, not only will that uninventory the platform and all its child servers/services, but it will also remove the agent record as well.

                  • 7. Re: uninventory fails in all cases
                    Patrick Conway Newbie

                    It was timing out when uninventoring the platform.....

                     

                    But its working fine now....

                     

                    not sure what exactly the issue was but its resolved after restart

                     

                    thanks