<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Dec 20, 2015 at 12:28 PM, Eli Mesika <span dir="ltr">&lt;<a href="mailto:emesika@redhat.com" target="_blank">emesika@redhat.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""><br>
<br>
----- Original Message -----<br>
&gt; From: &quot;Aleksey Chudov&quot; &lt;<a href="mailto:aleksey.chudov@gmail.com">aleksey.chudov@gmail.com</a>&gt;<br>
&gt; To: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
&gt; Sent: Friday, December 18, 2015 11:38:21 AM<br>
&gt; Subject: [ovirt-users] ERROR: update or delete on table &quot;luns&quot; violates       foreign key constraint...<br>
&gt;<br>
&gt; Hi,<br>
&gt;<br>
&gt; I have two-node self hosted engine cluster with iscsi shared storage. Every<br>
&gt; ovirt-engine restart produces the following error in<br>
&gt; /var/log/ovirt-engine/engine.log. After that engine works without any<br>
&gt; problems.<br>
&gt;<br>
&gt; How to fix it?<br>
<br></span></blockquote><div><br></div><div>Aleksey what&#39;s the engine version?<br> <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
</span>CCing Allon M<br>
<br>
This seems as a bug<br>
<br>
disk_lun_map FK is created without ON DELETE/UPDATE CASCADE<br>
This makes the FK failing in deleting from the luns table (by calling DeleteLun) while the deleted lun in the parent table has references in disk_lun_map<br>
<br>
Allon, please advice<br>
<div><div class="h5"><br>
&gt;<br>
&gt; 2015-12-18 11:33:00,053 ERROR<br>
&gt; [org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand]<br>
&gt; (org.ovirt.thread.pool-8-thread-11) [674068d8] Command<br>
&gt; &#39;org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand&#39;<br>
&gt; failed: CallableStatementCallback; SQL [{call deletelun(?)}]; ERROR: update<br>
&gt; or delete on table &quot;luns&quot; violates foreign key constraint<br>
&gt; &quot;disk_lun_to_lun_fk&quot; on table &quot;disk_lun_map&quot;<br>
&gt; Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced<br>
&gt; from table &quot;disk_lun_map&quot;.<br>
&gt; Where: SQL statement &quot;DELETE FROM LUNs<br>
&gt; WHERE LUN_id = v_LUN_id&quot;<br>
&gt; PL/pgSQL function deletelun(character varying) line 10 at SQL statement;<br>
&gt; nested exception is org.postgresql.util.PSQLException: ERROR: update or<br>
&gt; delete on table &quot;luns&quot; violates foreign key constraint &quot;disk_lun_to_lun_fk&quot;<br>
&gt; on table &quot;disk_lun_map&quot;<br>
&gt; Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced<br>
&gt; from table &quot;disk_lun_map&quot;.<br>
&gt; Where: SQL statement &quot;DELETE FROM LUNs<br>
&gt; WHERE LUN_id = v_LUN_id&quot;<br>
&gt; PL/pgSQL function deletelun(character varying) line 10 at SQL statement<br>
&gt; 2015-12-18 11:33:00,053 ERROR<br>
&gt; [org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand]<br>
&gt; (org.ovirt.thread.pool-8-thread-11) [674068d8] Exception:<br>
&gt; org.springframework.dao.DataIntegrityViolationException:<br>
&gt; CallableStatementCallback; SQL [{call deletelun(?)}]; ERROR: update or<br>
&gt; delete on table &quot;luns&quot; violates foreign key constraint &quot;disk_lun_to_lun_fk&quot;<br>
&gt; on table &quot;disk_lun_map&quot;<br>
&gt; Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced<br>
&gt; from table &quot;disk_lun_map&quot;.<br>
&gt; Where: SQL statement &quot;DELETE FROM LUNs<br>
&gt; WHERE LUN_id = v_LUN_id&quot;<br>
&gt; PL/pgSQL function deletelun(character varying) line 10 at SQL statement;<br>
&gt; nested exception is org.postgresql.util.PSQLException: ERROR: update or<br>
&gt; delete on table &quot;luns&quot; violates foreign key constraint &quot;disk_lun_to_lun_fk&quot;<br>
&gt; on table &quot;disk_lun_map&quot;<br>
&gt; Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced<br>
&gt; from table &quot;disk_lun_map&quot;.<br>
&gt; Where: SQL statement &quot;DELETE FROM LUNs<br>
&gt; WHERE LUN_id = v_LUN_id&quot;<br>
&gt; PL/pgSQL function deletelun(character varying) line 10 at SQL statement<br>
&gt; at<br>
&gt; org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1030)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1064)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:388)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:351)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:181)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:147)<br>
&gt; [dal.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:142)<br>
&gt; [dal.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:80)<br>
&gt; [dal.jar:]<br>
&gt; at org.ovirt.engine.core.dao.LunDaoImpl.remove(LunDaoImpl.java:127)<br>
&gt; [dal.jar:]<br>
&gt; at org.ovirt.engine.core.dao.LunDaoImpl.remove(LunDaoImpl.java:18) [dal.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand.refreshLunsInfo(SyncLunsInfoForBlockStorageDomainCommand.java:94)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand$1.runInTransaction(SyncLunsInfoForBlockStorageDomainCommand.java:51)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand$1.runInTransaction(SyncLunsInfoForBlockStorageDomainCommand.java:48)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:210)<br>
&gt; [utils.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.storage.SyncLunsInfoForBlockStorageDomainCommand.executeCommand(SyncLunsInfoForBlockStorageDomainCommand.java:48)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1215)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1359)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:1983)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:174)<br>
&gt; [utils.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:116)<br>
&gt; [utils.jar:]<br>
&gt; at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1396)<br>
&gt; [bll.jar:]<br>
&gt; at org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:378)<br>
&gt; [bll.jar:]<br>
&gt; at org.ovirt.engine.core.bll.Backend.runAction(Backend.java:475) [bll.jar:]<br>
&gt; at org.ovirt.engine.core.bll.Backend.runActionImpl(Backend.java:457)<br>
&gt; [bll.jar:]<br>
&gt; at org.ovirt.engine.core.bll.Backend.runInternalAction(Backend.java:404)<br>
&gt; [bll.jar:]<br>
&gt; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)<br>
&gt; at<br>
&gt; org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70)<br>
&gt; [wildfly-weld-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:80)<br>
&gt; [wildfly-weld-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)<br>
&gt; [wildfly-weld-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)<br>
&gt; at<br>
&gt; org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:55)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)<br>
&gt; [wildfly-weld-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)<br>
&gt; [wildfly-ee-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:52)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:260)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:399)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:243)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)<br>
&gt; [wildfly-ejb3-8.2.1.Final.jar:8.2.1.Final]<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)<br>
&gt; at<br>
&gt; org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)<br>
&gt; at<br>
&gt; org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)<br>
&gt; at<br>
&gt; org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
&gt; at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)<br>
&gt; at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)<br>
&gt; at<br>
&gt; org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
&gt; at<br>
&gt; org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.interfaces.BackendInternal$$$view2.runInternalAction(Unknown<br>
&gt; Source) [bll.jar:]<br>
&gt; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:414)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:65)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)<br>
&gt; [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.BackendCommandObjectsHandler$BackendInternal$BackendLocal$2049259618$Proxy$_$$_Weld$EnterpriseProxy$.runInternalAction(Unknown<br>
&gt; Source) [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.bll.VdsEventListener$3.run(VdsEventListener.java:255)<br>
&gt; [bll.jar:]<br>
&gt; at<br>
&gt; org.ovirt.engine.core.utils.threadpool.ThreadPoolUtil$InternalWrapperRunnable.run(ThreadPoolUtil.java:92)<br>
&gt; [utils.jar:]<br>
&gt; at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at<br>
&gt; java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)<br>
&gt; [rt.jar:1.8.0_65]<br>
&gt; at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_65]<br>
&gt; Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on<br>
&gt; table &quot;luns&quot; violates foreign key constraint &quot;disk_lun_to_lun_fk&quot; on table<br>
&gt; &quot;disk_lun_map&quot;<br>
&gt; Detail: Key (lun_id)=(36001405821da830526f48d0a961767c8) is still referenced<br>
&gt; from table &quot;disk_lun_map&quot;.<br>
&gt; Where: SQL statement &quot;DELETE FROM LUNs<br>
&gt; WHERE LUN_id = v_LUN_id&quot;<br>
&gt; PL/pgSQL function deletelun(character varying) line 10 at SQL statement<br>
&gt; at<br>
&gt; org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)<br>
&gt; at<br>
&gt; org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)<br>
&gt; at<br>
&gt; org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br>
&gt; at<br>
&gt; org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)<br>
&gt; at<br>
&gt; org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)<br>
&gt; at<br>
&gt; org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)<br>
&gt; at<br>
&gt; org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:301)<br>
&gt; at<br>
&gt; org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)<br>
&gt; at<br>
&gt; org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1066)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at<br>
&gt; org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1014)<br>
&gt; [spring-jdbc.jar:3.1.1.RELEASE]<br>
&gt; ... 106 more<br>
&gt;<br>
&gt;<br>
&gt; Aleksey<br>
&gt;<br>
</div></div>&gt; _______________________________________________<br>
&gt; Users mailing list<br>
&gt; <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
&gt; <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
&gt;<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div><br></div></div>