19. 7. 2018 v 13:46, Filip Goll <biohazardik@gmail.com>:Hi Martin,sure, do you have some FTP access? Log collector downloaded from 3 hosts almost 700 MB :-DAbout the activity, I’d like to import first .OVA virtual machine. (Exactly this one: Download .OVA format ) When I try to import to the Gluster Data domain the domain crashed. With this errorI try all night to solve it, so I reinstall engine, make some engine-cleanup, drop databases, import back from a backup (unsuccessful), so I move back database from a dump…. Etc.And I thing that I can provide you ssh access, if necessary.RegardsFilip19. 7. 2018 v 13:17, Martin Perina <mperina@redhat.com>:Hi Filip,could you please share with us complete engine logs using SOS log collector [1] and, if possible, engine database dump, so we can investigate the issue? Also do you remember any steps you have performed before this issue happened?ThanksMartinFrom: Filip Goll <biohazardik@gmail.com>
Date: Thu, 19 Jul 2018 at 13:19
Subject: ERROR: integer out of range
To: <users-owner@ovirt.org>Dear guru’s,Do you have any idea how to fix it? I can’t list any storage domain = no data storage domain is up, so the datacenter is also down.Thats why I understand this error:On startup any virtual machine this error:
- Action failed due to database connection failure. Please check connectivity to your Database server
Using: Software Version:4.2.4.5-1.el7PSQL:engine=# select * fromstorage_domains_for_search;ERROR: integer out of rangeIn vdsm.log is everything, but on:engine.log:2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-251) [0d583ed2-fcbd-4d2d-b12c- 0f0532a00a85] Query 'SearchQuery' failed: StatementCallback; SQL [SELECT * FROM ((SELECT distinct storage_domains_for_search.* FROM storage_domains_for_search ) ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of range; nested exception is org.postgresql.util. PSQLException: ERROR: integer out of range 2018-07-19 11:36:51,166+02 ERROR [org.ovirt.engine.core.bll.SearchQuery] (default task-251) [0d583ed2-fcbd-4d2d-b12c- 0f0532a00a85] Exception: org.springframework.dao. DataIntegrityViolationExceptio n: StatementCallback; SQL [SELECT * FROM ((SELECT distinct storage_domains_for_search.* FROM storage_domains_for_search ) ORDER BY storage_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; ERROR: integer out of range; nested exception is org.postgresql.util. PSQLException: ERROR: integer out of range at org.springframework.jdbc.support. SQLStateSQLExceptionTranslator .doTranslate( SQLStateSQLExceptionTranslator .java:102) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.support. AbstractFallbackSQLExceptionTr anslator.translate( AbstractFallbackSQLExceptionTr anslator.java:73) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.support. AbstractFallbackSQLExceptionTr anslator.translate( AbstractFallbackSQLExceptionTr anslator.java:81) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.support. AbstractFallbackSQLExceptionTr anslator.translate( AbstractFallbackSQLExceptionTr anslator.java:81) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute( JdbcTemplate.java:419) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query( JdbcTemplate.java:474) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.core.JdbcTemplate.query( JdbcTemplate.java:484) [spring-jdbc.jar:4.3.9. RELEASE] at org.ovirt.engine.core.dao.StorageDomainDaoImpl. getAllWithQuery( StorageDomainDaoImpl.java:115) [dal.jar:] at org.ovirt.engine.core.bll.SearchQuery.genericSearch( SearchQuery.java:344) [bll.jar:] at org.ovirt.engine.core.bll.SearchQuery. searchStorageDomain( SearchQuery.java:393) [bll.jar:] at org.ovirt.engine.core.bll.SearchQuery. executeQueryCommand( SearchQuery.java:204) [bll.jar:] at org.ovirt.engine.core.bll.QueriesCommandBase. executeCommand( QueriesCommandBase.java:106) [bll.jar:] at org.ovirt.engine.core.dal.VdcCommandBase.execute( VdcCommandBase.java:33) [dal.jar:] at org.ovirt.engine.core.bll.executor. DefaultBackendQueryExecutor. execute( DefaultBackendQueryExecutor. java:14) [bll.jar:] at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend. java:538) [bll.jar:] at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java: 507) [bll.jar:] at sun.reflect.GeneratedMethodAccessor82. invoke(Unknown Source) [:1.8.0_171] at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) [rt.jar:1.8.0_171] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171] at org.jboss.as.ee.component.ManagedReferenceMethodIntercep tor.processInvocation( ManagedReferenceMethodIntercep tor.java:52) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.InterceptorContext$Invocation. proceed(InterceptorContext. java:509) at org.jboss.as.weld.ejb.DelegatingInterceptorInvocatio nContext.proceed( DelegatingInterceptorInvocatio nContext.java:92) [wildfly-weld-ejb-11.0.0. Final.jar:11.0.0.Final] at org.jboss.weld.interceptor.proxy.WeldInvocationContext. interceptorChainCompleted( WeldInvocationContext.java:98) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.weld.interceptor.proxy.WeldInvocationContext. proceed(WeldInvocationContext. java:117) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.ovirt.engine.core.common.di.interceptor. LoggingInterceptor.apply( LoggingInterceptor.java:12) [common.jar:] at sun.reflect.GeneratedMethodAccessor66. invoke(Unknown Source) [:1.8.0_171] at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) [rt.jar:1.8.0_171] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171] at org.jboss.weld.interceptor.reader. SimpleInterceptorInvocation$ SimpleMethodInvocation.invoke( SimpleInterceptorInvocation. java:73) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.weld.interceptor.proxy.WeldInvocationContext. invokeNext( WeldInvocationContext.java:83) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.weld.interceptor.proxy.WeldInvocationContext. proceed(WeldInvocationContext. java:115) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.weld.bean.InterceptorImpl.intercept( InterceptorImpl.java:108) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.as.weld.ejb.DelegatingInterceptorInvocatio nContext.proceed( DelegatingInterceptorInvocatio nContext.java:82) [wildfly-weld-ejb-11.0.0. Final.jar:11.0.0.Final] at org.jboss.as.weld.interceptors. EjbComponentInterceptorSupport .delegateInterception( EjbComponentInterceptorSupport .java:60) at org.jboss.as.weld.interceptors. Jsr299BindingsInterceptor. delegateInterception( Jsr299BindingsInterceptor. java:76) at org.jboss.as.weld.interceptors. Jsr299BindingsInterceptor. doMethodInterception( Jsr299BindingsInterceptor. java:88) at org.jboss.as.weld.interceptors. Jsr299BindingsInterceptor. processInvocation( Jsr299BindingsInterceptor. java:101) at org.jboss.as.ee.component.interceptors. UserInterceptorFactory$1. processInvocation( UserInterceptorFactory.java: 63) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.InterceptorContext$Invocation. proceed(InterceptorContext. java:509) at org.ovirt.engine.core.bll.interceptors. CorrelationIdTrackerIntercepto r.aroundInvoke( CorrelationIdTrackerIntercepto r.java:13) [bll.jar:] at sun.reflect.GeneratedMethodAccessor78. invoke(Unknown Source) [:1.8.0_171] at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) [rt.jar:1.8.0_171] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171] at org.jboss.as.ee.component.ManagedReferenceLifecycleMetho dInterceptor. processInvocation( ManagedReferenceLifecycleMetho dInterceptor.java:89) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.invocationmetrics. ExecutionTimeInterceptor. processInvocation( ExecutionTimeInterceptor.java: 43) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor. processInvocation( ConcurrentContextInterceptor. java:45) [wildfly-ee-11.0.0.Final.jar: 11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.InitialInterceptor. processInvocation( InitialInterceptor.java:40) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.ChainedInterceptor. processInvocation( ChainedInterceptor.java:53) at org.jboss.as.ee.component.interceptors. ComponentDispatcherInterceptor .processInvocation( ComponentDispatcherInterceptor .java:52) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.singleton. SingletonComponentInstanceAsso ciationInterceptor. processInvocation( SingletonComponentInstanceAsso ciationInterceptor.java:53) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx( CMTTxInterceptor.java:264) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports( CMTTxInterceptor.java:379) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor. processInvocation( CMTTxInterceptor.java:244) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.InterceptorContext$Invocation. proceed(InterceptorContext. java:509) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivat ionInterceptor.aroundInvoke( AbstractEJBRequestScopeActivat ionInterceptor.java:73) [weld-core-impl-2.4.3.Final. jar:2.4.3.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInter ceptor.processInvocation( EjbRequestScopeActivationInter ceptor.java:89) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.interceptors. CurrentInvocationContextInterc eptor.processInvocation( CurrentInvocationContextInterc eptor.java:41) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.invocationmetrics. WaitTimeInterceptor. processInvocation( WaitTimeInterceptor.java:47) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.security.SecurityContextInterceptor. processInvocation( SecurityContextInterceptor. java:100) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.deployment.processors. StartupAwaitInterceptor. processInvocation( StartupAwaitInterceptor.java: 22) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.interceptors. ShutDownInterceptorFactory$1. processInvocation( ShutDownInterceptorFactory. java:64) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ejb3.component.interceptors. LoggingInterceptor. processInvocation( LoggingInterceptor.java:67) [wildfly-ejb3-11.0.0.Final. jar:11.0.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.as.ee.component.NamespaceContextInterceptor. processInvocation( NamespaceContextInterceptor. java:50) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.ContextClassLoaderInterceptor. processInvocation( ContextClassLoaderInterceptor. java:60) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.InterceptorContext.run( InterceptorContext.java:438) at org.wildfly.security.manager.WildFlySecurityManager. doChecked( WildFlySecurityManager.java: 609) at org.jboss.invocation.AccessCheckingInterceptor. processInvocation( AccessCheckingInterceptor. java:57) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:422) at org.jboss.invocation.ChainedInterceptor. processInvocation( ChainedInterceptor.java:53) 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.as.ee.component.ProxyInvocationHandler.invoke( ProxyInvocationHandler.java: 81) at org.ovirt.engine.core.common.interfaces.BackendLocal$$$ view4.runQuery(Unknown Source) [common.jar:] at org.ovirt.engine.ui.frontend.server.gwt. GenericApiGWTServiceImpl. runQuery( GenericApiGWTServiceImpl.java: 90) at org.ovirt.engine.ui.frontend.server.gwt. GenericApiGWTServiceImpl. runMultipleQueries( GenericApiGWTServiceImpl.java: 121) at sun.reflect.GeneratedMethodAccessor109. invoke(Unknown Source) [:1.8.0_171] at sun.reflect.DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:43) [rt.jar:1.8.0_171] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171] at com.google.gwt.user.server.rpc.RPC. invokeAndEncodeResponse(RPC. java:587) at com.google.gwt.user.server.rpc.RemoteServiceServlet. processCall( RemoteServiceServlet.java:333) at com.google.gwt.user.server.rpc.RemoteServiceServlet. processCall( RemoteServiceServlet.java:303) at com.google.gwt.user.server.rpc.RemoteServiceServlet. processPost( RemoteServiceServlet.java:373) 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: 78) 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.core.utils.servlet.CachingFilter. doFilter(CachingFilter.java: 133) [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.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:65) [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. SecurityContextAssociationHand ler.handleRequest( SecurityContextAssociationHand ler.java:78) at io.undertow.server.handlers.PredicateHandler. handleRequest( PredicateHandler.java:43) at io.undertow.servlet.handlers.security. SSLInformationAssociationHandl er.handleRequest( SSLInformationAssociationHandl er.java:131) at io.undertow.servlet.handlers.security. ServletAuthenticationCallHandl er.handleRequest( ServletAuthenticationCallHandl er.java:57) at io.undertow.server.handlers.PredicateHandler. handleRequest( PredicateHandler.java:43) at io.undertow.security.handlers.AuthenticationConstraintHandle r.handleRequest( AuthenticationConstraintHandle r.java:53) at io.undertow.security.handlers.AbstractConfidentialityHandler .handleRequest( AbstractConfidentialityHandler .java:46) at io.undertow.servlet.handlers.security. ServletConfidentialityConstrai ntHandler.handleRequest( ServletConfidentialityConstrai ntHandler.java:64) at io.undertow.servlet.handlers.security. ServletSecurityConstraintHandl er.handleRequest( ServletSecurityConstraintHandl er.java:59) at io.undertow.security.handlers.AuthenticationMechanismsHandle r.handleRequest( AuthenticationMechanismsHandle r.java:60) at io.undertow.servlet.handlers.security. CachedAuthenticatedSessionHand ler.handleRequest( CachedAuthenticatedSessionHand ler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler. handleRequest( NotificationReceiverHandler. java:50) at io.undertow.security.handlers.AbstractSecurityContextAssocia tionHandler.handleRequest( AbstractSecurityContextAssocia tionHandler.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.ServletRequestContextThreadSet upAction$1.call( ServletRequestContextThreadSet upAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$ 1.call( ContextClassLoaderSetupAction. java:43) at org.wildfly.extension.undertow.security. SecurityContextThreadSetupActi on.lambda$create$0( SecurityContextThreadSetupActi on.java:105) at org.wildfly.extension.undertow.deployment. UndertowDeploymentInfoService$ UndertowThreadSetupAction. lambda$create$0( UndertowDeploymentInfoService. java:1508) at org.wildfly.extension.undertow.deployment. UndertowDeploymentInfoService$ UndertowThreadSetupAction. lambda$create$0( UndertowDeploymentInfoService. java:1508) at org.wildfly.extension.undertow.deployment. UndertowDeploymentInfoService$ UndertowThreadSetupAction. lambda$create$0( UndertowDeploymentInfoService. java:1508) 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:326) at io.undertow.server.HttpServerExchange$1.run( HttpServerExchange.java:812) at java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_171] at java.util.concurrent.ThreadPoolExecutor$Worker.run( ThreadPoolExecutor.java:624) [rt.jar:1.8.0_171] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_171] Caused by: org.postgresql.util.PSQLException: ERROR: integer out of range 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: 403) at org.postgresql.jdbc2.AbstractJdbc2Statement. executeQuery( AbstractJdbc2Statement.java: 283) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery( WrappedStatement.java:397) at org.springframework.jdbc.core.JdbcTemplate$ 1QueryStatementCallback. doInStatement(JdbcTemplate. java:458) [spring-jdbc.jar:4.3.9. RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute( JdbcTemplate.java:408) [spring-jdbc.jar:4.3.9. RELEASE] ... 151 more
--Martin Perina
Associate Manager, Software Engineering
Red Hat Czech s.r.o.