uninventory fails in all cases

[macchonmhaighe]

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]

[ips]

Have you tuned you Postgres instance as recommended in the RHQ docs?

http://www.rhq-project.org/display/JOPR2/PostgreSQL#PostgreSQL-PostgreSQLPreparation

[macchonmhaighe]

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

[macchonmhaighe]

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)

[ips]

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.

[macchonmhaighe]

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

[mazz]

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.

[macchonmhaighe]

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