Hello:<br /><br />I&#39;am trying to remove a host from Ovirt Engine (I prviously migrated all the vm&#39;s and put the host in maitenance) and it fails with this error:<div><div><br />Failed to remove Host ov-nodo2 (User: ovirtadmin).<br /><br />Searching in the engine.log I found that it is related to a value in the database. The logs are attached below. How can I force the host removal?<br /><br />My setup: oVirt Engine Version: 3.4.0-1.el6 (Centos 6.5)<br />Ovirt Host (to remove): Centos 6.5, vdsm-4.14.6-0.el6<br /><br />Thanks<br /><br />Federico<br /><br /><br />engine.log:</div></div><br />2014-07-02 15:52:48,924 INFO&nbsp; [org.ovirt.engine.core.bll.RemoveVdsCommand] (ajp--127.0.0.1-8702-4) [5f53d780] Lock Acquired to object EngineLock [exclusiveLocks= key: c212c0a9-a784-4958-bad1-eb3a95b8c9da value: VDS<br />, sharedLocks= ]<br />2014-07-02 15:52:48,979 INFO&nbsp; [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-6-thread-36) [5f53d780] Running comm
 and: RemoveVdsCommand internal: false. Entities affected :&nbsp; ID: c212c0a9-a784-4958-bad1-eb3a95b8c9da Type: VDS<br />2014-07-02 15:52:49,016 INFO&nbsp; [org.ovirt.engine.core.utils.transaction.TransactionSupport] (org.ovirt.thread.pool-6-thread-36) [5f53d780] transaction rolled back<br />2014-07-02 15:52:49,021 ERROR [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-6-thread-36) [5f53d780] Command org.ovirt.engine.core.bll.RemoveVdsCommand throw exception: org.springframework.dao.DataIntegrityViolationException: CallableStatementCallback; SQL [{call deletevdsstatic(?)}]; ERROR: update o delete en &laquo;vds_static&raquo; viola la llave for&aacute;nea &laquo;vds_static_vm_dynamic_m&raquo; en la tabla &laquo;vm_dynamic&raquo;<br />&nbsp; Detail: La llave (vds_id)=(c212c0a9-a784-4958-bad1-eb3a95b8c9da) todav&iacute;a es referida desde la tabla &laquo;vm_dynamic&raquo;.<br />&nbsp; Where: sentencia SQL: &laquo;DELETE FROM vds_static WHERE vds_id =&nbsp; $1 
 &raquo;<br />PL/pgSQL function &quot;deletevdsstatic&quot; line 11 at sentencia SQL; nested exception is org.postgresql.util.PSQLException: ERROR: update o delete en &laquo;vds_static&raquo; viola la llave for&aacute;nea &laquo;vds_static_vm_dynamic_m&raquo; en la tabla &laquo;vm_dynamic&raquo;<br />&nbsp; Detail: La llave (vds_id)=(c212c0a9-a784-4958-bad1-eb3a95b8c9da) todav&iacute;a es referida desde la tabla &laquo;vm_dynamic&raquo;.<br />&nbsp; Where: sentencia SQL: &laquo;DELETE FROM vds_static WHERE vds_id =&nbsp; $1 &raquo;<br />PL/pgSQL function &quot;deletevdsstatic&quot; line 11 at sentencia SQL<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]<br 
 />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:137) [dal.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java
 :74) [dal.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.dao.VdsStaticDAODbFacadeImpl.remove(VdsStaticDAODbFacadeImpl.java:110) [dal.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.dao.VdsStaticDAODbFacadeImpl.remove(VdsStaticDAODbFacadeImpl.java:20) [dal.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.RemoveVdsCommand.RemoveVdsStaticFromDb(RemoveVdsCommand.java:147) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.RemoveVdsCommand.access$200(RemoveVdsCommand.java:36) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.RemoveVdsCommand$1.runInTransaction(RemoveVdsCommand.java:75) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.RemoveVdsCommand$1.runInTransaction(RemoveVdsCommand.java:69) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210) [utils.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.RemoveV
 dsCommand.executeCommand(RemoveVdsCommand.java:69) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1123) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1208) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1884) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:174) [utils.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:116) [utils.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1228) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:351) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.c
 ore.bll.MultipleActionsRunner.executeValidatedCommand(MultipleActionsRunner.java:189) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.MultipleActionsRunner.runCommands(MultipleActionsRunner.java:156) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.bll.MultipleActionsRunner$2.run(MultipleActionsRunner.java:165) [bll.jar:]<br />&nbsp;&nbsp; &nbsp;at org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:97) [utils.jar:]<br />&nbsp;&nbsp; &nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_51]<br />&nbsp;&nbsp; &nbsp;at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51]<br />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]<br />&nbsp;&nbsp; &nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]<br />&nbsp;&nbsp; &nbsp
 ;at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]<br />Caused by: org.postgresql.util.PSQLException: ERROR: update o delete en &laquo;vds_static&raquo; viola la llave for&aacute;nea &laquo;vds_static_vm_dynamic_m&raquo; en la tabla &laquo;vm_dynamic&raquo;<br />&nbsp; Detail: La llave (vds_id)=(c212c0a9-a784-4958-bad1-eb3a95b8c9da) todav&iacute;a es referida desde la tabla &laquo;vm_dynamic&raquo;.<br />&nbsp; Where: sentencia SQL: &laquo;DELETE FROM vds_static WHERE vds_id =&nbsp; $1 &raquo;<br />PL/pgSQL function &quot;deletevdsstatic&quot; line 11 at sentencia SQL<br />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)<br />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)<br />&nbsp;&nbsp; &nbsp;at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.
 execute(AbstractJdbc2Statement.java:512)<br />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<br />&nbsp;&nbsp; &nbsp;at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)<br />&nbsp;&nbsp; &nbsp;at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)<br />&nbsp;&nbsp; &nbsp;at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1066) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014) [spring-jdbc.jar:3.1.1.RELEASE]<br />&nbsp;&nbsp; &nbsp;... 30 more<br /
 ><br />2014-07-02 15:52:49,388 INFO&nbsp; [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (org.ovirt.thread.pool-6-thread-36) [5f53d780] Correlation ID: 5f53d780, Call Stack: null, Custom Event ID: -1, Message: Failed to remove Host ov-nodo2 (User: ovirtadmin).<br />2014-07-02 15:52:49,404 INFO&nbsp; [org.ovirt.engine.core.bll.RemoveVdsCommand] (org.ovirt.thread.pool-6-thread-36) [5f53d780] Lock freed to object EngineLock [exclusiveLocks= key: c212c0a9-a784-4958-bad1-eb3a95b8c9da value: VDS<br />, sharedLocks= ]