Delete inactive host from cloudera manager

[#1]

I can't delete an inactive host from cloudera manager.

The host got no role and no heartbeat.

Version: Cloudera Express 5.2.1 (#109 built by jenkins on 20141125-0809 git: 8b79f749fed7e9cef6c3c9cb0664ac1c28b7f9a4)

javax.persistence.PersistenceException:org.hibernate.exception.ConstraintViolationException: could not execute statement
at AbstractEntityManagerImpl.java line 1387
in org.hibernate.ejb.AbstractEntityManagerImpl convert()
 Empiler les traces:

AbstractEntityManagerImpl.java line 1387
in org.hibernate.ejb.AbstractEntityManagerImpl convert()
AbstractEntityManagerImpl.java line 1310
in org.hibernate.ejb.AbstractEntityManagerImpl convert()
AbstractEntityManagerImpl.java line 1316
in org.hibernate.ejb.AbstractEntityManagerImpl convert()
AbstractEntityManagerImpl.java line 999
in org.hibernate.ejb.AbstractEntityManagerImpl flush()
CmfEntityManager.java line 1039
in com.cloudera.cmf.persist.CmfEntityManager flush()
HardwareController.java line 554
in com.cloudera.server.web.cmf.HardwareController deleteHosts()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$FastClassByCGLIB$$fcce8e79 invoke()
MethodProxy.java line 191
in net.sf.cglib.proxy.MethodProxy invoke()
Cglib2AopProxy.java line 688
in org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation invokeJoinpoint()
ReflectiveMethodInvocation.java line 150
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
MethodSecurityInterceptor.java line 61
in org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor invoke()
ReflectiveMethodInvocation.java line 172
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
Cglib2AopProxy.java line 621
in org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor intercept()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$EnhancerByCGLIB$$44400372 deleteHosts()
NativeMethodAccessorImpl.java line -2
in sun.reflect.NativeMethodAccessorImpl invoke0()
NativeMethodAccessorImpl.java line 57
in sun.reflect.NativeMethodAccessorImpl invoke()
DelegatingMethodAccessorImpl.java line 43
in sun.reflect.DelegatingMethodAccessorImpl invoke()
Method.java line 606
in java.lang.reflect.Method invoke()
HandlerMethodInvoker.java line 176
in org.springframework.web.bind.annotation.support.HandlerMethodInvoker invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 436
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 424
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter handle()
DispatcherServlet.java line 790
in org.springframework.web.servlet.DispatcherServlet doDispatch()
DispatcherServlet.java line 719
in org.springframework.web.servlet.DispatcherServlet doService()
FrameworkServlet.java line 669
in org.springframework.web.servlet.FrameworkServlet processRequest()
FrameworkServlet.java line 585
in org.springframework.web.servlet.FrameworkServlet doPost()
HttpServlet.java line 727
in javax.servlet.http.HttpServlet service()
HttpServlet.java line 820
in javax.servlet.http.HttpServlet service()
ServletHolder.java line 511
in org.mortbay.jetty.servlet.ServletHolder handle()
ServletHandler.java line 1221
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
UserAgentFilter.java line 78
in org.mortbay.servlet.UserAgentFilter doFilter()
GzipFilter.java line 131
in org.mortbay.servlet.GzipFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JAMonServletFilter.java line 48
in com.jamonapi.http.JAMonServletFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JavaMelodyFacade.java line 109
in com.cloudera.enterprise.JavaMelodyFacade$MonitoringFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
FilterChainProxy.java line 311
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterSecurityInterceptor.java line 116
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor invoke()
FilterSecurityInterceptor.java line 83
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ExceptionTranslationFilter.java line 113
in org.springframework.security.web.access.ExceptionTranslationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SessionManagementFilter.java line 101
in org.springframework.security.web.session.SessionManagementFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AnonymousAuthenticationFilter.java line 113
in org.springframework.security.web.authentication.AnonymousAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RememberMeAuthenticationFilter.java line 146
in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextHolderAwareRequestFilter.java line 54
in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RequestCacheAwareFilter.java line 45
in org.springframework.security.web.savedrequest.RequestCacheAwareFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AbstractAuthenticationProcessingFilter.java line 182
in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
LogoutFilter.java line 105
in org.springframework.security.web.authentication.logout.LogoutFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextPersistenceFilter.java line 87
in org.springframework.security.web.context.SecurityContextPersistenceFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ConcurrentSessionFilter.java line 125
in org.springframework.security.web.session.ConcurrentSessionFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterChainProxy.java line 173
in org.springframework.security.web.FilterChainProxy doFilter()
DelegatingFilterProxy.java line 237
in org.springframework.web.filter.DelegatingFilterProxy invokeDelegate()
DelegatingFilterProxy.java line 167
in org.springframework.web.filter.DelegatingFilterProxy doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
CharacterEncodingFilter.java line 88
in org.springframework.web.filter.CharacterEncodingFilter doFilterInternal()
OncePerRequestFilter.java line 76
in org.springframework.web.filter.OncePerRequestFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
ServletHandler.java line 399
in org.mortbay.jetty.servlet.ServletHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
SessionHandler.java line 182
in org.mortbay.jetty.servlet.SessionHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
ContextHandler.java line 767
in org.mortbay.jetty.handler.ContextHandler handle()
WebAppContext.java line 450
in org.mortbay.jetty.webapp.WebAppContext handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
StatisticsHandler.java line 53
in org.mortbay.jetty.handler.StatisticsHandler handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
Server.java line 326
in org.mortbay.jetty.Server handle()
HttpConnection.java line 542
in org.mortbay.jetty.HttpConnection handleRequest()
HttpConnection.java line 945
in org.mortbay.jetty.HttpConnection$RequestHandler content()
HttpParser.java line 756
in org.mortbay.jetty.HttpParser parseNext()
HttpParser.java line 218
in org.mortbay.jetty.HttpParser parseAvailable()
HttpConnection.java line 404
in org.mortbay.jetty.HttpConnection handle()
SelectChannelEndPoint.java line 410
in org.mortbay.io.nio.SelectChannelEndPoint run()
QueuedThreadPool.java line 582
in org.mortbay.thread.QueuedThreadPool$PoolThread run()
Caused by: org.hibernate.exception.ConstraintViolationException:could not execute statement
at SQLStateConversionDelegate.java line 129
in org.hibernate.exception.internal.SQLStateConversionDelegate convert()
 Empiler les traces:

SQLStateConversionDelegate.java line 129
in org.hibernate.exception.internal.SQLStateConversionDelegate convert()
StandardSQLExceptionConverter.java line 49
in org.hibernate.exception.internal.StandardSQLExceptionConverter convert()
SqlExceptionHelper.java line 125
in org.hibernate.engine.jdbc.spi.SqlExceptionHelper convert()
SqlExceptionHelper.java line 110
in org.hibernate.engine.jdbc.spi.SqlExceptionHelper convert()
ResultSetReturnImpl.java line 136
in org.hibernate.engine.jdbc.internal.ResultSetReturnImpl executeUpdate()
AbstractEntityPersister.java line 3346
in org.hibernate.persister.entity.AbstractEntityPersister delete()
AbstractEntityPersister.java line 3546
in org.hibernate.persister.entity.AbstractEntityPersister delete()
EntityDeleteAction.java line 100
in org.hibernate.action.internal.EntityDeleteAction execute()
ActionQueue.java line 377
in org.hibernate.engine.spi.ActionQueue execute()
ActionQueue.java line 369
in org.hibernate.engine.spi.ActionQueue executeActions()
ActionQueue.java line 293
in org.hibernate.engine.spi.ActionQueue executeActions()
AbstractFlushingEventListener.java line 339
in org.hibernate.event.internal.AbstractFlushingEventListener performExecutions()
DefaultFlushEventListener.java line 52
in org.hibernate.event.internal.DefaultFlushEventListener onFlush()
SessionImpl.java line 1234
in org.hibernate.internal.SessionImpl flush()
AbstractEntityManagerImpl.java line 996
in org.hibernate.ejb.AbstractEntityManagerImpl flush()
CmfEntityManager.java line 1039
in com.cloudera.cmf.persist.CmfEntityManager flush()
HardwareController.java line 554
in com.cloudera.server.web.cmf.HardwareController deleteHosts()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$FastClassByCGLIB$$fcce8e79 invoke()
MethodProxy.java line 191
in net.sf.cglib.proxy.MethodProxy invoke()
Cglib2AopProxy.java line 688
in org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation invokeJoinpoint()
ReflectiveMethodInvocation.java line 150
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
MethodSecurityInterceptor.java line 61
in org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor invoke()
ReflectiveMethodInvocation.java line 172
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
Cglib2AopProxy.java line 621
in org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor intercept()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$EnhancerByCGLIB$$44400372 deleteHosts()
NativeMethodAccessorImpl.java line -2
in sun.reflect.NativeMethodAccessorImpl invoke0()
NativeMethodAccessorImpl.java line 57
in sun.reflect.NativeMethodAccessorImpl invoke()
DelegatingMethodAccessorImpl.java line 43
in sun.reflect.DelegatingMethodAccessorImpl invoke()
Method.java line 606
in java.lang.reflect.Method invoke()
HandlerMethodInvoker.java line 176
in org.springframework.web.bind.annotation.support.HandlerMethodInvoker invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 436
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 424
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter handle()
DispatcherServlet.java line 790
in org.springframework.web.servlet.DispatcherServlet doDispatch()
DispatcherServlet.java line 719
in org.springframework.web.servlet.DispatcherServlet doService()
FrameworkServlet.java line 669
in org.springframework.web.servlet.FrameworkServlet processRequest()
FrameworkServlet.java line 585
in org.springframework.web.servlet.FrameworkServlet doPost()
HttpServlet.java line 727
in javax.servlet.http.HttpServlet service()
HttpServlet.java line 820
in javax.servlet.http.HttpServlet service()
ServletHolder.java line 511
in org.mortbay.jetty.servlet.ServletHolder handle()
ServletHandler.java line 1221
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
UserAgentFilter.java line 78
in org.mortbay.servlet.UserAgentFilter doFilter()
GzipFilter.java line 131
in org.mortbay.servlet.GzipFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JAMonServletFilter.java line 48
in com.jamonapi.http.JAMonServletFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JavaMelodyFacade.java line 109
in com.cloudera.enterprise.JavaMelodyFacade$MonitoringFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
FilterChainProxy.java line 311
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterSecurityInterceptor.java line 116
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor invoke()
FilterSecurityInterceptor.java line 83
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ExceptionTranslationFilter.java line 113
in org.springframework.security.web.access.ExceptionTranslationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SessionManagementFilter.java line 101
in org.springframework.security.web.session.SessionManagementFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AnonymousAuthenticationFilter.java line 113
in org.springframework.security.web.authentication.AnonymousAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RememberMeAuthenticationFilter.java line 146
in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextHolderAwareRequestFilter.java line 54
in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RequestCacheAwareFilter.java line 45
in org.springframework.security.web.savedrequest.RequestCacheAwareFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AbstractAuthenticationProcessingFilter.java line 182
in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
LogoutFilter.java line 105
in org.springframework.security.web.authentication.logout.LogoutFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextPersistenceFilter.java line 87
in org.springframework.security.web.context.SecurityContextPersistenceFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ConcurrentSessionFilter.java line 125
in org.springframework.security.web.session.ConcurrentSessionFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterChainProxy.java line 173
in org.springframework.security.web.FilterChainProxy doFilter()
DelegatingFilterProxy.java line 237
in org.springframework.web.filter.DelegatingFilterProxy invokeDelegate()
DelegatingFilterProxy.java line 167
in org.springframework.web.filter.DelegatingFilterProxy doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
CharacterEncodingFilter.java line 88
in org.springframework.web.filter.CharacterEncodingFilter doFilterInternal()
OncePerRequestFilter.java line 76
in org.springframework.web.filter.OncePerRequestFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
ServletHandler.java line 399
in org.mortbay.jetty.servlet.ServletHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
SessionHandler.java line 182
in org.mortbay.jetty.servlet.SessionHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
ContextHandler.java line 767
in org.mortbay.jetty.handler.ContextHandler handle()
WebAppContext.java line 450
in org.mortbay.jetty.webapp.WebAppContext handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
StatisticsHandler.java line 53
in org.mortbay.jetty.handler.StatisticsHandler handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
Server.java line 326
in org.mortbay.jetty.Server handle()
HttpConnection.java line 542
in org.mortbay.jetty.HttpConnection handleRequest()
HttpConnection.java line 945
in org.mortbay.jetty.HttpConnection$RequestHandler content()
HttpParser.java line 756
in org.mortbay.jetty.HttpParser parseNext()
HttpParser.java line 218
in org.mortbay.jetty.HttpParser parseAvailable()
HttpConnection.java line 404
in org.mortbay.jetty.HttpConnection handle()
SelectChannelEndPoint.java line 410
in org.mortbay.io.nio.SelectChannelEndPoint run()
QueuedThreadPool.java line 582
in org.mortbay.thread.QueuedThreadPool$PoolThread run()
Caused by: org.postgresql.util.PSQLException:ERROR: update or delete on table "hosts" violates foreign key constraint "fk_client_config_host" on table "client_configs" Detail: Key (host_id)=(8) is still referenced from table "client_configs".
at QueryExecutorImpl.java line 2102
in org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse()
 Empiler les traces:

QueryExecutorImpl.java line 2102
in org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse()
QueryExecutorImpl.java line 1835
in org.postgresql.core.v3.QueryExecutorImpl processResults()
QueryExecutorImpl.java line 257
in org.postgresql.core.v3.QueryExecutorImpl execute()
AbstractJdbc2Statement.java line 500
in org.postgresql.jdbc2.AbstractJdbc2Statement execute()
AbstractJdbc2Statement.java line 388
in org.postgresql.jdbc2.AbstractJdbc2Statement executeWithFlags()
AbstractJdbc2Statement.java line 334
in org.postgresql.jdbc2.AbstractJdbc2Statement executeUpdate()
NewProxyPreparedStatement.java line 105
in com.mchange.v2.c3p0.impl.NewProxyPreparedStatement executeUpdate()
ResultSetReturnImpl.java line 133
in org.hibernate.engine.jdbc.internal.ResultSetReturnImpl executeUpdate()
AbstractEntityPersister.java line 3346
in org.hibernate.persister.entity.AbstractEntityPersister delete()
AbstractEntityPersister.java line 3546
in org.hibernate.persister.entity.AbstractEntityPersister delete()
EntityDeleteAction.java line 100
in org.hibernate.action.internal.EntityDeleteAction execute()
ActionQueue.java line 377
in org.hibernate.engine.spi.ActionQueue execute()
ActionQueue.java line 369
in org.hibernate.engine.spi.ActionQueue executeActions()
ActionQueue.java line 293
in org.hibernate.engine.spi.ActionQueue executeActions()
AbstractFlushingEventListener.java line 339
in org.hibernate.event.internal.AbstractFlushingEventListener performExecutions()
DefaultFlushEventListener.java line 52
in org.hibernate.event.internal.DefaultFlushEventListener onFlush()
SessionImpl.java line 1234
in org.hibernate.internal.SessionImpl flush()
AbstractEntityManagerImpl.java line 996
in org.hibernate.ejb.AbstractEntityManagerImpl flush()
CmfEntityManager.java line 1039
in com.cloudera.cmf.persist.CmfEntityManager flush()
HardwareController.java line 554
in com.cloudera.server.web.cmf.HardwareController deleteHosts()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$FastClassByCGLIB$$fcce8e79 invoke()
MethodProxy.java line 191
in net.sf.cglib.proxy.MethodProxy invoke()
Cglib2AopProxy.java line 688
in org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation invokeJoinpoint()
ReflectiveMethodInvocation.java line 150
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
MethodSecurityInterceptor.java line 61
in org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor invoke()
ReflectiveMethodInvocation.java line 172
in org.springframework.aop.framework.ReflectiveMethodInvocation proceed()
Cglib2AopProxy.java line 621
in org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor intercept()
<generated> line -1
in com.cloudera.server.web.cmf.HardwareController$$EnhancerByCGLIB$$44400372 deleteHosts()
NativeMethodAccessorImpl.java line -2
in sun.reflect.NativeMethodAccessorImpl invoke0()
NativeMethodAccessorImpl.java line 57
in sun.reflect.NativeMethodAccessorImpl invoke()
DelegatingMethodAccessorImpl.java line 43
in sun.reflect.DelegatingMethodAccessorImpl invoke()
Method.java line 606
in java.lang.reflect.Method invoke()
HandlerMethodInvoker.java line 176
in org.springframework.web.bind.annotation.support.HandlerMethodInvoker invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 436
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter invokeHandlerMethod()
AnnotationMethodHandlerAdapter.java line 424
in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter handle()
DispatcherServlet.java line 790
in org.springframework.web.servlet.DispatcherServlet doDispatch()
DispatcherServlet.java line 719
in org.springframework.web.servlet.DispatcherServlet doService()
FrameworkServlet.java line 669
in org.springframework.web.servlet.FrameworkServlet processRequest()
FrameworkServlet.java line 585
in org.springframework.web.servlet.FrameworkServlet doPost()
HttpServlet.java line 727
in javax.servlet.http.HttpServlet service()
HttpServlet.java line 820
in javax.servlet.http.HttpServlet service()
ServletHolder.java line 511
in org.mortbay.jetty.servlet.ServletHolder handle()
ServletHandler.java line 1221
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
UserAgentFilter.java line 78
in org.mortbay.servlet.UserAgentFilter doFilter()
GzipFilter.java line 131
in org.mortbay.servlet.GzipFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JAMonServletFilter.java line 48
in com.jamonapi.http.JAMonServletFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
JavaMelodyFacade.java line 109
in com.cloudera.enterprise.JavaMelodyFacade$MonitoringFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
FilterChainProxy.java line 311
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterSecurityInterceptor.java line 116
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor invoke()
FilterSecurityInterceptor.java line 83
in org.springframework.security.web.access.intercept.FilterSecurityInterceptor doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ExceptionTranslationFilter.java line 113
in org.springframework.security.web.access.ExceptionTranslationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SessionManagementFilter.java line 101
in org.springframework.security.web.session.SessionManagementFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AnonymousAuthenticationFilter.java line 113
in org.springframework.security.web.authentication.AnonymousAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RememberMeAuthenticationFilter.java line 146
in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextHolderAwareRequestFilter.java line 54
in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
RequestCacheAwareFilter.java line 45
in org.springframework.security.web.savedrequest.RequestCacheAwareFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
AbstractAuthenticationProcessingFilter.java line 182
in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
LogoutFilter.java line 105
in org.springframework.security.web.authentication.logout.LogoutFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
SecurityContextPersistenceFilter.java line 87
in org.springframework.security.web.context.SecurityContextPersistenceFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
ConcurrentSessionFilter.java line 125
in org.springframework.security.web.session.ConcurrentSessionFilter doFilter()
FilterChainProxy.java line 323
in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter()
FilterChainProxy.java line 173
in org.springframework.security.web.FilterChainProxy doFilter()
DelegatingFilterProxy.java line 237
in org.springframework.web.filter.DelegatingFilterProxy invokeDelegate()
DelegatingFilterProxy.java line 167
in org.springframework.web.filter.DelegatingFilterProxy doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
CharacterEncodingFilter.java line 88
in org.springframework.web.filter.CharacterEncodingFilter doFilterInternal()
OncePerRequestFilter.java line 76
in org.springframework.web.filter.OncePerRequestFilter doFilter()
ServletHandler.java line 1212
in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter()
ServletHandler.java line 399
in org.mortbay.jetty.servlet.ServletHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
SessionHandler.java line 182
in org.mortbay.jetty.servlet.SessionHandler handle()
SecurityHandler.java line 216
in org.mortbay.jetty.security.SecurityHandler handle()
ContextHandler.java line 767
in org.mortbay.jetty.handler.ContextHandler handle()
WebAppContext.java line 450
in org.mortbay.jetty.webapp.WebAppContext handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
StatisticsHandler.java line 53
in org.mortbay.jetty.handler.StatisticsHandler handle()
HandlerWrapper.java line 152
in org.mortbay.jetty.handler.HandlerWrapper handle()
Server.java line 326
in org.mortbay.jetty.Server handle()
HttpConnection.java line 542
in org.mortbay.jetty.HttpConnection handleRequest()
HttpConnection.java line 945
in org.mortbay.jetty.HttpConnection$RequestHandler content()
HttpParser.java line 756
in org.mortbay.jetty.HttpParser parseNext()
HttpParser.java line 218
in org.mortbay.jetty.HttpParser parseAvailable()
HttpConnection.java line 404
in org.mortbay.jetty.HttpConnection handle()
SelectChannelEndPoint.java line 410
in org.mortbay.io.nio.SelectChannelEndPoint run()
QueuedThreadPool.java line 582
in org.mortbay.thread.QueuedThreadPool$PoolThread run()

[#2 · Accepted solution]

The key part of the exception is this:

Caused by: org.postgresql.util.PSQLException:ERROR: update or delete on table "hosts" violates foreign key constraint "fk_client_config_host" on table "client_configs" Detail: Key (host_id)=(8) is still referenced from table "client_configs".
at QueryExecutorImpl.java line 2102
in org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse()

 Before trying to delete the host, try removing all roles (including gateways) from the host.

Regards,

Ben

[#3]

The host was only a gateways. I delete this role, then remove the host from the cluster.

I should delete this from Cloudera Manager before...

Now I still got the error even, the host got no role and no heatbeat from cloudera manager.