Hello,

we can not remove old NFS-data storage domains, this 4 are already deactivated and unattached:

engine=> select id,storage_name from storage_domains where storage_name like 'bs09%';
                  id                  | storage_name
--------------------------------------+---------------
 819b419e-638b-43c7-9189-b93c0314d38a | bs09aF2C10kvm
 9a403356-f58a-4e80-9435-026e6f853a9b | bs09bF2C10kvm
 f5efd264-045b-48d5-b35c-661a30461de5 | bs09aF2C9kvm
 a0989c64-fc41-4a8b-8544-914137d7eae8 | bs09bF2C9kvm
(4 rows)


The only images which still resides in DB are OVF_STORE templates:

engine=> select image_guid,storage_name,disk_description from images_storage_domain_view where storage_name like 'bs09%';
              image_guid              | storage_name  | disk_description
--------------------------------------+---------------+------------------
 6b72139d-a4b3-4e22-98e2-e8b1d64e8e50 | bs09bF2C9kvm  | OVF_STORE
 997fe5a6-9647-4d42-b074-27767984b7d2 | bs09bF2C9kvm  | OVF_STORE
 2b1884cb-eb37-475f-9c24-9638400f15af | bs09aF2C10kvm | OVF_STORE
 85383ffe-68ba-4a82-a692-d93e38bf7f4c | bs09aF2C9kvm  | OVF_STORE
 bca14796-aed1-4747-87c9-1b25861fad86 | bs09aF2C9kvm  | OVF_STORE
 797c27bf-7c2d-4363-96f9-565fa58d0a5e | bs09bF2C10kvm | OVF_STORE
 5d092a1b-597c-48a3-8058-cbe40d39c2c9 | bs09bF2C10kvm | OVF_STORE
 dc61f42f-1330-4bfb-986a-d868c736da59 | bs09aF2C10kvm | OVF_STORE
(8 rows)



Current oVirt Engine version: 4.1.8.2-1.el7.centos
Exception logs from engine are in attachment

Do you have any magic sql statement to figure out what is causing this exception and how we can remove those storage domains without disruption ?

Thank you in advance

--
Ladislav Humenik

2018-02-21 09:50:02,484+01 INFO  
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Lock Acquired to object 
'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', 
sharedLocks=''}'
2018-02-21 09:50:02,509+01 INFO  
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Running command: 
RemoveStorageDomainCommand internal: false. Entities affected :  ID: 
f5efd264-045b-48d5-b35c-661a30461de5 Type: StorageAction group 
DELETE_STORAGE_DOMAIN with role type ADMIN
2018-02-21 09:50:02,527+01 INFO  
[org.ovirt.engine.core.utils.transaction.TransactionSupport] (default task-154) 
[8badc63f-80cf-4211-b98f-a37604642251] transaction rolled back
2018-02-21 09:50:02,529+01 ERROR 
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Command 
'org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand' failed: 
CallableStatementCallback; bad SQL grammar [{call 
force_delete_storage_domain(?)}]; nested exception is 
org.postgresql.util.PSQLException: ERROR: relation "storage_domain_map_table" 
does not exist
  Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL 
statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
2018-02-21 09:50:02,530+01 ERROR 
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Exception: 
org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad 
SQL grammar [{call force_delete_storage_domain(?)}]; nested exception is 
org.postgresql.util.PSQLException: ERROR: relation "storage_domain_map_table" 
does not exist
  Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL 
statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
        at 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1094) 
[spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:1130) 
[spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.simple.AbstractJdbcCall.executeCallInternal(AbstractJdbcCall.java:405)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.simple.AbstractJdbcCall.doExecute(AbstractJdbcCall.java:365)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.simple.SimpleJdbcCall.execute(SimpleJdbcCall.java:198)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:135)
 [dal.jar:]
        at 
org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:130)
 [dal.jar:]
        at 
org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeModification(SimpleJdbcCallsHandler.java:76)
 [dal.jar:]
        at 
org.ovirt.engine.core.dao.StorageDomainDaoImpl.remove(StorageDomainDaoImpl.java:132)
 [dal.jar:]
        at 
org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand.lambda$executeCommand$0(RemoveStorageDomainCommand.java:76)
 [bll.jar:]
        at 
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInNewTransaction(TransactionSupport.java:202)
 [utils.jar:]
        at 
org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand.executeCommand(RemoveStorageDomainCommand.java:74)
 [bll.jar:]
        at 
org.ovirt.engine.core.bll.CommandBase.executeWithoutTransaction(CommandBase.java:1251)
 [bll.jar:]
        at 
org.ovirt.engine.core.bll.CommandBase.executeActionInTransactionScope(CommandBase.java:1391)
 [bll.jar:]
        at 
org.ovirt.engine.core.bll.CommandBase.runInTransaction(CommandBase.java:2055) 
[bll.jar:]
        at 
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInSuppressed(TransactionSupport.java:164)
 [utils.jar:]
        at 
org.ovirt.engine.core.utils.transaction.TransactionSupport.executeInScope(TransactionSupport.java:103)
 [utils.jar:]
        at org.ovirt.engine.core.bll.CommandBase.execute(CommandBase.java:1451) 
[bll.jar:]
        at 
org.ovirt.engine.core.bll.CommandBase.executeAction(CommandBase.java:397) 
[bll.jar:]
        at 
org.ovirt.engine.core.bll.executor.DefaultBackendActionExecutor.execute(DefaultBackendActionExecutor.java:13)
 [bll.jar:]
        at org.ovirt.engine.core.bll.Backend.runAction(Backend.java:516) 
[bll.jar:]
        at org.ovirt.engine.core.bll.Backend.runActionImpl(Backend.java:498) 
[bll.jar:]
        at org.ovirt.engine.core.bll.Backend.runAction(Backend.java:451) 
[bll.jar:]
        at sun.reflect.GeneratedMethodAccessor529.invoke(Unknown Source) 
[:1.8.0_161]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [rt.jar:1.8.0_161]
        at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_161]
        at 
org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
        at 
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70)
 [wildfly-weld-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:80)
 [wildfly-weld-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
 [wildfly-weld-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
        at 
org.ovirt.engine.core.bll.interceptors.CorrelationIdTrackerInterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.java:13)
 [bll.jar:]
        at sun.reflect.GeneratedMethodAccessor251.invoke(Unknown Source) 
[:1.8.0_161]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [rt.jar:1.8.0_161]
        at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_161]
        at 
org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:89)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
        at 
org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
 [weld-core-impl-2.3.5.Final.jar:2.3.5.Final]
        at 
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
 [wildfly-weld-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
 [wildfly-ee-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at 
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) 
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) 
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:243)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)
 [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
        at 
org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:636)
        at 
org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
        at 
org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at 
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198)
        at 
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
        at 
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
        at 
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
        at 
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
        at 
org.ovirt.engine.core.common.interfaces.BackendLocal$$$view3.runAction(Unknown 
Source) [common.jar:]
        at 
org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runAction(GenericApiGWTServiceImpl.java:171)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
[rt.jar:1.8.0_161]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
[rt.jar:1.8.0_161]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [rt.jar:1.8.0_161]
        at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_161]
        at 
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
        at 
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
        at 
com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:305)
        at 
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 
[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at 
org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.service(GenericApiGWTServiceImpl.java:77)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 
[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
        at 
io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
        at 
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
        at 
org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94) 
[utils.jar:]
        at 
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
        at 
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
        at 
org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)
        at 
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
        at 
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
        at 
org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:73) 
[branding.jar:]
        at 
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
        at 
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
        at 
org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:66) 
[utils.jar:]
        at 
io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
        at 
io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
        at 
io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
        at 
io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
        at 
io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
        at 
org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
        at 
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at 
io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
        at 
io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
        at 
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at 
io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53)
        at 
io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
        at 
io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
        at 
io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59)
        at 
io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
        at 
io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
        at 
io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
        at 
io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
        at 
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at 
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
        at 
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at 
io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
        at 
io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
        at 
io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
        at 
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
        at 
io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
        at 
io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
        at 
io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
        at 
io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
        at 
io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
        at 
io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
        at 
io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)
        at 
io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
        at 
io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
        at 
io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
        at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202)
        at 
io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:805)
        at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
[rt.jar:1.8.0_161]
        at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
[rt.jar:1.8.0_161]
        at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_161]
Caused by: org.postgresql.util.PSQLException: ERROR: relation 
"storage_domain_map_table" does not exist
  Where: SQL statement "TRUNCATE TABLE STORAGE_DOMAIN_MAP_TABLE"
PL/pgSQL function remove_entities_from_storage_domain(uuid) line 21 at SQL 
statement
SQL statement "SELECT Remove_Entities_From_storage_domain(v_storage_domain_id)"
PL/pgSQL function force_delete_storage_domain(uuid) line 3 at PERFORM
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:410)
        at 
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:303)
        at 
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
        at 
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1133)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.JdbcTemplate$6.doInCallableStatement(JdbcTemplate.java:1130)
 [spring-jdbc.jar:4.2.4.RELEASE]
        at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1078) 
[spring-jdbc.jar:4.2.4.RELEASE]
        ... 153 more

2018-02-21 09:50:02,552+01 ERROR 
[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] EVENT_ID: 
USER_REMOVE_STORAGE_DOMAIN_FAILED(961), Correlation ID: 
8badc63f-80cf-4211-b98f-a37604642251, Job ID: 
38ec4e85-6455-426c-a1b2-67d36bd996e9, Call Stack: null, Custom ID: null, Custom 
Event ID: -1, Message: Failed to remove Storage Domain bs09aF2C9kvm. (User: 
admin@internal)
2018-02-21 09:50:02,561+01 INFO  
[org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default 
task-154) [8badc63f-80cf-4211-b98f-a37604642251] Lock freed to object 
'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', 
sharedLocks=''}'
_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Reply via email to