2:17 p.m.
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?
Thanks
Martin
[1]
https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
From: Filip Goll <
biohazardik(a)gmail.com>
Date: Thu, 19 Jul 2018 at 13:19
Subject: ERROR: integer out of range
To: <users-owner(a)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.el7
PSQL:
engine=# select * from
storage_domains_for_search;
ERROR: integer out of range
In 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.DataIntegrityViolationException:
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(AbstractFallbackSQLExceptionTranslator.java:73)
[spring-jdbc.jar:4.3.9.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTr
anslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
[spring-jdbc.jar:4.3.9.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTr
anslator.translate(AbstractFallbackSQLExceptionTranslator.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(ManagedReferenceMethodInterceptor.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.DelegatingInterceptorInvocationContext.proceed(
DelegatingInterceptorInvocationContext.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.DelegatingInterceptorInvocationContext.proceed(
DelegatingInterceptorInvocationContext.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(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInterceptor.
processInvocation(ManagedReferenceLifecycleMethodInterceptor.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(SingletonComponentInstanceAssociationInterceptor.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(AbstractEJBRequestScopeActivationInterceptor.java:73)
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInter
ceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
at org.jboss.invocation.InterceptorContext.proceed(
InterceptorContext.java:422)
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterc
eptor.processInvocation(CurrentInvocationContextInterceptor.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(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(
PredicateHandler.java:43)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandl
er.handleRequest(SSLInformationAssociationHandler.java:131)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandl
er.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(
PredicateHandler.java:43)
at io.undertow.security.handlers.AuthenticationConstraintHandle
r.handleRequest(AuthenticationConstraintHandler.java:53)
at io.undertow.security.handlers.AbstractConfidentialityHandler
.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstrai
ntHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandl
er.handleRequest(ServletSecurityConstraintHandler.java:59)
at io.undertow.security.handlers.AuthenticationMechanismsHandle
r.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHand
ler.handleRequest(CachedAuthenticatedSessionHandler.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.ServletRequestContextThreadSetupAction$1.call(
ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(
ContextClassLoaderSetupAction.java:43)
at org.wildfly.extension.undertow.security.SecurityContextThreadSetupActi
on.lambda$create$0(SecurityContextThreadSetupAction.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.
2:47 p.m.
New subject: ERROR: integer out of range
Hi Martin,
sure, do you have some FTP access? Log collector downloaded from 3 hosts almost 700 MB
:-D
About the activity, I’d like to import first .OVA virtual machine. (Exactly this one:
Download .OVA format
<https://bitnami.com/redirect/to/225673/bitnami-redmine-3.4.6-0-linux-debi...
) When I try to import to the Gluster Data domain the domain crashed. With this error
I 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.
Regards
Filip
19. 7. 2018 v 13:17, Martin Perina <mperina(a)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?
Thanks
Martin
[1]
https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
<https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
From: Filip Goll <biohazardik(a)gmail.com <mailto:biohazardik@gmail.com>>
Date: Thu, 19 Jul 2018 at 13:19
Subject: ERROR: integer out of range
To: <users-owner(a)ovirt.org <mailto: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.el7
PSQL:
engine=# select * from storage_domains_for_search;
ERROR: integer out of range
In 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.DataIntegrityViolationException: 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.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
[spring-jdbc.jar:4.3.9.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
[spring-jdbc.jar:4.3.9.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.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.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.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.CorrelationIdTrackerInterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.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.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.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.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.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.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
org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.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.
4:29 p.m.
New subject: ERROR: integer out of range
OK,
I uploaded to some websites hope all logs:
https://mcts.cz/exchange/engine.log <https://mcts.cz/exchange/engine.log>
Other files are in the same folder
- engine.log
- engine_20180719_141441.sql
- sosreport-LogCollector-20180719132830.tar.xz
- sosreport-LogCollector-20180719132830.tar.xz.md5
- vdsm.log
F.
19. 7. 2018 v 13:46, Filip Goll <biohazardik(a)gmail.com>:
Hi Martin,
sure, do you have some FTP access? Log collector downloaded from 3 hosts almost 700 MB
:-D
About the activity, I’d like to import first .OVA virtual machine. (Exactly this one:
Download .OVA format
<https://bitnami.com/redirect/to/225673/bitnami-redmine-3.4.6-0-linux-debi...
) When I try to import to the Gluster Data domain the domain crashed. With this error
I 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.
Regards
Filip
> 19. 7. 2018 v 13:17, Martin Perina <mperina(a)redhat.com
<mailto: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?
>
> Thanks
>
> Martin
>
> [1]
https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
<https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
>
>
> From: Filip Goll <biohazardik(a)gmail.com
<mailto:biohazardik@gmail.com>>
> Date: Thu, 19 Jul 2018 at 13:19
> Subject: ERROR: integer out of range
> To: <users-owner(a)ovirt.org <mailto: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.el7
>
>
> PSQL:
> engine=# select * from storage_domains_for_search;
> ERROR: integer out of range
>
> In 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.DataIntegrityViolationException: 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.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
[spring-jdbc.jar:4.3.9.RELEASE]
> at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
[spring-jdbc.jar:4.3.9.RELEASE]
> at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.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.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.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.CorrelationIdTrackerInterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.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.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.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.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
> at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
> at
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.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.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
org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.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.
5:52 p.m.
New subject: ERROR: integer out of range
Hi
Is there a chance that one of the following Integers passed 2^32 - 1 ???
available_disk_size | integer
confirmed_available_disk_size | integer
used_disk_size | integer
commited_disk_size | integer
actual_images_size | integer
warning_low_space_indicator | integer
critical_space_action_blocker | integer
warning_low_confirmed_space_indicator | integer
external_status | integer
I am suspecting especially all those *size* columns , please check by
extending one by one to BigInt and check if the problem solved
On Thu, Jul 19, 2018 at 2:17 PM, Martin Perina <mperina(a)redhat.com> wrote:
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?
Thanks
Martin
[1] https://www.ovirt.org/documentation/admin-guide/
chap-Utilities/#the-log-collector-tool
From: Filip Goll <
>
> biohazardik(a)gmail.com>
> Date: Thu, 19 Jul 2018 at 13:19
> Subject: ERROR: integer out of range
> To: <users-owner(a)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.el7
>
>
> PSQL:
> engine=# select * from
>
> storage_domains_for_search;
> ERROR: integer out of range
>
> In 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.DataIntegrityViolationException:
> 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.SQLStateSQLExceptionTransla
> tor.doTranslate(SQLStateSQLExceptionTranslator.java:102)
> [spring-jdbc.jar:4.3.9.RELEASE]
> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
> [spring-jdbc.jar:4.3.9.RELEASE]
> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
> [spring-jdbc.jar:4.3.9.RELEASE]
> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.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.getAllWithQue
> ry(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.DefaultBackendQueryExecut
> or.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.ManagedReferenceMethodInterceptor.
> processInvocation(ManagedReferenceMethodInterceptor.java:52)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(
> InterceptorContext.java:509)
> at org.jboss.as.weld.ejb.DelegatingInterceptorInvocationContext
> .proceed(DelegatingInterceptorInvocationContext.java:92)
> [wildfly-weld-ejb-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.inter
> ceptorChainCompleted(WeldInvocationContext.java:98)
> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.proce
> ed(WeldInvocationContext.java:117) [weld-core-impl-2.4.3.Final.ja
> r:2.4.3.Final]
> at org.ovirt.engine.core.common.di.interceptor.LoggingIntercept
> or.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.SimpleInterceptorInvocatio
> n$SimpleMethodInvocation.invoke(SimpleInterceptorInvocation.java:73)
> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.invok
> eNext(WeldInvocationContext.java:83) [weld-core-impl-2.4.3.Final.ja
> r:2.4.3.Final]
> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.proce
> ed(WeldInvocationContext.java:115) [weld-core-impl-2.4.3.Final.ja
> r: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.DelegatingInterceptorInvocationContext
> .proceed(DelegatingInterceptorInvocationContext.java:82)
> [wildfly-weld-ejb-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.as.weld.interceptors.EjbComponentInterceptorSuppor
> t.delegateInterception(EjbComponentInterceptorSupport.java:60)
> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.del
> egateInterception(Jsr299BindingsInterceptor.java:76)
> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doM
> ethodInterception(Jsr299BindingsInterceptor.java:88)
> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.pro
> cessInvocation(Jsr299BindingsInterceptor.java:101)
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactor
> y$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(
> InterceptorContext.java:509)
> at org.ovirt.engine.core.bll.interceptors.CorrelationIdTrackerI
> nterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInt
> erceptor.processInvocation(ManagedReferenceLifecycleMethodIn
> terceptor.java:89)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeI
> nterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.proc
> essInvocation(ConcurrentContextInterceptor.java:45)
> [wildfly-ee-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.InitialInterceptor.processInvocation(In
> itialInterceptor.java:40)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.ChainedInterceptor.processInvocation(Ch
> ainedInterceptor.java:53)
> at org.jboss.as.ee.component.interceptors.ComponentDispatcherIn
> terceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.component.singleton.SingletonComponentInst
> anceAssociationInterceptor.processInvocation(SingletonCompon
> entInstanceAssociationInterceptor.java:53) [wildfly-ejb3-11.0.0.Final.jar
> :11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.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(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(
> InterceptorContext.java:509)
> at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationIntercep
> tor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
> at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.
> processInvocation(EjbRequestScopeActivationInterceptor.java:89)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.component.interceptors.CurrentInvocationCo
> ntextInterceptor.processInvocation(CurrentInvoc
> ationContextInterceptor.java:41) [wildfly-ejb3-11.0.0.Final.jar
> :11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterc
> eptor.processInvocation(WaitTimeInterceptor.java:47)
> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.security.SecurityContextInterceptor.proces
> sInvocation(SecurityContextInterceptor.java:100)
> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.deployment.processors.StartupAwaitIntercep
> tor.processInvocation(StartupAwaitInterceptor.java:22)
> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptor
> Factory$1.processInvocation(ShutDownInterceptorFactory.java:64)
> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.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(InterceptorC
> ontext.java:422)
> at org.jboss.as.ee.component.NamespaceContextInterceptor.proces
> sInvocation(NamespaceContextInterceptor.java:50)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.ContextClassLoaderInterceptor.processIn
> vocation(ContextClassLoaderInterceptor.java:60)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.InterceptorContext.run(InterceptorConte
> xt.java:438)
> at org.wildfly.security.manager.WildFlySecurityManager.doChecke
> d(WildFlySecurityManager.java:609)
> at org.jboss.invocation.AccessCheckingInterceptor.processInvoca
> tion(AccessCheckingInterceptor.java:57)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
> ontext.java:422)
> at org.jboss.invocation.ChainedInterceptor.processInvocation(Ch
> ainedInterceptor.java:53)
> at org.jboss.as.ee.component.ViewService$View.invoke(ViewServic
> e.java:198)
> at org.jboss.as.ee.component.ViewDescription$1.processInvocatio
> n(ViewDescription.java:185)
> at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(Prox
> yInvocationHandler.java:81)
> at org.ovirt.engine.core.common.interfaces.BackendLocal$$$view4.runQuery(Unknown
> Source) [common.jar:]
> at org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTService
> Impl.runQuery(GenericApiGWTServiceImpl.java:90)
> at org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTService
> Impl.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.processC
> all(RemoteServiceServlet.java:333)
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processC
> all(RemoteServiceServlet.java:303)
> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processP
> ost(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.GenericApiGWTService
> Impl.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(Se
> rvletHandler.java:85)
> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
> oFilter(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.d
> oFilter(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.d
> oFilter(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.d
> oFilter(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.d
> oFilter(FilterHandler.java:131)
> at io.undertow.servlet.handlers.FilterHandler.handleRequest(Fil
> terHandler.java:84)
> at io.undertow.servlet.handlers.security.ServletSecurityRoleHan
> dler.handleRequest(ServletSecurityRoleHandler.java:62)
> at io.undertow.servlet.handlers.ServletDispatchingHandler.handl
> eRequest(ServletDispatchingHandler.java:36)
> at org.wildfly.extension.undertow.security.SecurityContextAssoc
> iationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(P
> redicateHandler.java:43)
> at io.undertow.servlet.handlers.security.SSLInformationAssociat
> ionHandler.handleRequest(SSLInformationAssociationHandler.java:131)
> at io.undertow.servlet.handlers.security.ServletAuthenticationC
> allHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(P
> redicateHandler.java:43)
> at io.undertow.security.handlers.AuthenticationConstraintHandle
> r.handleRequest(AuthenticationConstraintHandler.java:53)
> at io.undertow.security.handlers.AbstractConfidentialityHandler
> .handleRequest(AbstractConfidentialityHandler.java:46)
> at io.undertow.servlet.handlers.security.ServletConfidentiality
> ConstraintHandler.handleRequest(ServletConfident
> ialityConstraintHandler.java:64)
> at io.undertow.servlet.handlers.security.ServletSecurityConstra
> intHandler.handleRequest(ServletSecurityConstraintHandler.java:59)
> at io.undertow.security.handlers.AuthenticationMechanismsHandle
> r.handleRequest(AuthenticationMechanismsHandler.java:60)
> at io.undertow.servlet.handlers.security.CachedAuthenticatedSes
> sionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
> at io.undertow.security.handlers.NotificationReceiverHandler.ha
> ndleRequest(NotificationReceiverHandler.java:50)
> at io.undertow.security.handlers.AbstractSecurityContextAssocia
> tionHandler.handleRequest(AbstractSecurityContextAssociation
> Handler.java:43)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(P
> redicateHandler.java:43)
> at org.wildfly.extension.undertow.security.jacc.JACCContextIdHa
> ndler.handleRequest(JACCContextIdHandler.java:61)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(P
> redicateHandler.java:43)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(P
> redicateHandler.java:43)
> at io.undertow.servlet.handlers.ServletInitialHandler.handleFir
> stRequest(ServletInitialHandler.java:292)
> at io.undertow.servlet.handlers.ServletInitialHandler.access$10
> 0(ServletInitialHandler.java:81)
> at io.undertow.servlet.handlers.ServletInitialHandler$2.call(Se
> rvletInitialHandler.java:138)
> at io.undertow.servlet.handlers.ServletInitialHandler$2.call(Se
> rvletInitialHandler.java:135)
> at io.undertow.servlet.core.ServletRequestContextThreadSetupAct
> ion$1.call(ServletRequestContextThreadSetupAction.java:48)
> at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.
> call(ContextClassLoaderSetupAction.java:43)
> at org.wildfly.extension.undertow.security.SecurityContextThrea
> dSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
> at org.wildfly.extension.undertow.deployment.UndertowDeployment
> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
> owDeploymentInfoService.java:1508)
> at org.wildfly.extension.undertow.deployment.UndertowDeployment
> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
> owDeploymentInfoService.java:1508)
> at org.wildfly.extension.undertow.deployment.UndertowDeployment
> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
> owDeploymentInfoService.java:1508)
> at io.undertow.servlet.handlers.ServletInitialHandler.dispatchR
> equest(ServletInitialHandler.java:272)
> at io.undertow.servlet.handlers.ServletInitialHandler.access$00
> 0(ServletInitialHandler.java:81)
> at io.undertow.servlet.handlers.ServletInitialHandler$1.handleR
> equest(ServletInitialHandler.java:104)
> at io.undertow.server.Connectors.executeRootHandler(Connectors.java:326)
> at io.undertow.server.HttpServerExchange$1.run(HttpServerExchan
> ge.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.receiveErrorRespons
> e(QueryExecutorImpl.java:2157)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
> yExecutorImpl.java:1886)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
> orImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract
> Jdbc2Statement.java:555)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
> (AbstractJdbc2Statement.java:403)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs
> tractJdbc2Statement.java:283)
> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(Wr
> appedStatement.java:397)
> at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCa
> llback.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.
6:46 p.m.
New subject: ERROR: integer out of range
19. 7. 2018 v 16:52, Eli Mesika <emesika(a)redhat.com>:
Hi
Is there a chance that one of the following Integers passed 2^32 - 1 ???
available_disk_size | integer
- max int 5533
confirmed_available_disk_size | integer
- <NULL>
used_disk_size | integer
- max int 1851
commited_disk_size | integer
- Which table? I can’t
find it
actual_images_size | integer
- Which table? I can’t find
it
warning_low_space_indicator | integer
- max int 10
critical_space_action_blocker | integer
- max int 5
warning_low_confirmed_space_indicator | integer
- <NULL>
external_status | integer
- max int 0
I am suspecting especially all those *size* columns , please check by extending one by
one to BigInt and check if the problem solved
On Thu, Jul 19, 2018 at 2:17 PM, Martin Perina <mperina(a)redhat.com
<mailto:mperina@redhat.com>> wrote:
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?
Thanks
Martin
[1]
https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
<https://www.ovirt.org/documentation/admin-guide/chap-Utilities/#the-log-c...
From: Filip Goll <biohazardik(a)gmail.com <mailto:biohazardik@gmail.com>>
Date: Thu, 19 Jul 2018 at 13:19
Subject: ERROR: integer out of range
To: <users-owner(a)ovirt.org <mailto: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.el7
PSQL:
engine=# select * from storage_domains_for_search;
ERROR: integer out of range
In 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.DataIntegrityViolationException: 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.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
[spring-jdbc.jar:4.3.9.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
[spring-jdbc.jar:4.3.9.RELEASE]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.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.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.java:92)
[wildfly-weld-ejb-11.0.0.Final.jar:11.0.0.Final]
at org.jboss.weld.interceptor.pro
<http://org.jboss.weld.interceptor.pro/>xy.WeldInvocationContext.interc...
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
at org.jboss.weld.interceptor.pro
<http://org.jboss.weld.interceptor.pro/>xy.WeldInvocationContext.procee...
[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.pro
<http://org.jboss.weld.interceptor.pro/>xy.WeldInvocationContext.invoke...
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
at org.jboss.weld.interceptor.pro
<http://org.jboss.weld.interceptor.pro/>xy.WeldInvocationContext.procee...
[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.DelegatingInterceptorInvocationContext.proceed(DelegatingInterceptorInvocationContext.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.CorrelationIdTrackerInterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:89)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.in
<http://org.jboss.as.ejb3.component.in/>vocationmetrics.ExecutionTimeIn...
[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.si
<http://org.jboss.as.ejb3.component.si/>ngleton.SingletonComponentInsta...
[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.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
[weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
at
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
at org.jboss.as.ejb3.component.in
<http://org.jboss.as.ejb3.component.in/>terceptors.CurrentInvocationCon...
[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.in
<http://org.jboss.as.ejb3.component.in/>vocationmetrics.WaitTimeInterce...
[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.in
<http://org.jboss.as.ejb3.component.in/>terceptors.ShutDownInterceptorF...
[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.in
<http://org.jboss.as.ejb3.component.in/>terceptors.LoggingInterceptor.p...
[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.Name
<http://org.jboss.as.ee.component.name/>spaceContextInterceptor.process...
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.se
<http://org.ovirt.engine.core.utils.se/>rvlet.HeaderFilter.doFilter(Hea...
[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.se
<http://org.ovirt.engine.core.utils.se/>rvlet.CachingFilter.doFilter(Ca...
[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.se
<http://org.ovirt.engine.core.utils.se/>rvlet.LocaleFilter.doFilter(Loc...
[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.Pr
<http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(Pr...
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.Pr
<http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(Pr...
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.Pr
<http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(Pr...
at
org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.Pr
<http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(Pr...
at io.undertow.server.handlers.Pr
<http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(Pr...
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
org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.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.
11:59 a.m.
New subject: ERROR: integer out of range
On Thu, Jul 19, 2018 at 6:42 PM, Filip Goll <biohazardik(a)gmail.com> wrote:
19. 7. 2018 v 16:52, Eli Mesika <emesika(a)redhat.com>:
Hi
Is there a chance that one of the following Integers passed 2^32 - 1 ???
available_disk_size | integer
- max int 5533
confirmed_available_disk_size | integer
- <NULL>
used_disk_size | integer
- max int 1851
commited_disk_size | integer
- Which table? I can’t find it
actual_images_size | integer
- Which table? I can’t find it
Those are taken from the storage_domains_image_sizes view :
SELECT isdm.storage_domain_id,
(COALESCE(sum(
CASE
WHEN i.active = true AND (vfdv.entity_type IS NULL OR
vfdv.entity_type::text <> 'TEMPLATE'::text) THEN i.size
ELSE din.actual_size
END), 0::numeric) *
0.000000000931322574615478515625)::bigint::integer AS commited_disk_size,
(COALESCE(sum(din.actual_size), 0::numeric) *
0.000000000931322574615478515625)::bigint::integer AS actual_images_size
FROM images i
JOIN image_storage_domain_map isdm ON i.image_guid = isdm.image_id
LEFT JOIN disk_image_dynamic din ON i.image_guid = din.image_id
LEFT JOIN vms_for_disk_view vfdv ON i.image_group_id = vfdv.device_id
GROUP BY isdm.storage_domain_id;
I really suspect that one of those two computations leads to the reported
overflow
warning_low_space_indicator | integer
- max int 10
critical_space_action_blocker | integer
- max int 5
warning_low_confirmed_space_indicator | integer
- <NULL>
external_status | integer
- max int 0
I am suspecting especially all those *size* columns , please check by
extending one by one to BigInt and check if the problem solved
On Thu, Jul 19, 2018 at 2:17 PM, Martin Perina <mperina(a)redhat.com> wrote:
> 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?
>
> Thanks
>
> Martin
>
> [1] https://www.ovirt.org/documentation/admin-guide/chap-
> Utilities/#the-log-collector-tool
>
>
> From: Filip Goll <
>>
>> biohazardik(a)gmail.com>
>> Date: Thu, 19 Jul 2018 at 13:19
>> Subject: ERROR: integer out of range
>> To: <users-owner(a)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.el7
>>
>>
>> PSQL:
>> engine=# select * from
>>
>> storage_domains_for_search;
>> ERROR: integer out of range
>>
>> In 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.DataIntegrityViolationException:
>> 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.SQLStateSQLExceptionTransla
>> tor.doTranslate(SQLStateSQLExceptionTranslator.java:102)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>> [spring-jdbc.jar:4.3.9.RELEASE]
>> at org.springframework.jdbc.support.AbstractFallbackSQLExceptio
>> nTranslator.translate(AbstractFallbackSQLExceptionTranslator.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.getAllWithQue
>> ry(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.DefaultBackendQueryExecut
>> or.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.ManagedReferenceMethodInterceptor.
>> processInvocation(ManagedReferenceMethodInterceptor.java:52)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.InterceptorContext$Invocation.proceed(I
>> nterceptorContext.java:509)
>> at org.jboss.as.weld.ejb.DelegatingInterceptorInvocationContext
>> .proceed(DelegatingInterceptorInvocationContext.java:92)
>> [wildfly-weld-ejb-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.inter
>> ceptorChainCompleted(WeldInvocationContext.java:98)
>> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
>> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.proce
>> ed(WeldInvocationContext.java:117) [weld-core-impl-2.4.3.Final.ja
>> r:2.4.3.Final]
>> at org.ovirt.engine.core.common.di.interceptor.LoggingIntercept
>> or.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.SimpleInterceptorInvocatio
>> n$SimpleMethodInvocation.invoke(SimpleInterceptorInvocation.java:73)
>> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
>> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.invok
>> eNext(WeldInvocationContext.java:83) [weld-core-impl-2.4.3.Final.ja
>> r:2.4.3.Final]
>> at org.jboss.weld.interceptor.proxy.WeldInvocationContext.proce
>> ed(WeldInvocationContext.java:115) [weld-core-impl-2.4.3.Final.ja
>> r: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.DelegatingInterceptorInvocationContext
>> .proceed(DelegatingInterceptorInvocationContext.java:82)
>> [wildfly-weld-ejb-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.as.weld.interceptors.EjbComponentInterceptorSuppor
>> t.delegateInterception(EjbComponentInterceptorSupport.java:60)
>> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.del
>> egateInterception(Jsr299BindingsInterceptor.java:76)
>> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.doM
>> ethodInterception(Jsr299BindingsInterceptor.java:88)
>> at org.jboss.as.weld.interceptors.Jsr299BindingsInterceptor.pro
>> cessInvocation(Jsr299BindingsInterceptor.java:101)
>> at org.jboss.as.ee.component.interceptors.UserInterceptorFactor
>> y$1.processInvocation(UserInterceptorFactory.java:63)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.InterceptorContext$Invocation.proceed(I
>> nterceptorContext.java:509)
>> at org.ovirt.engine.core.bll.interceptors.CorrelationIdTrackerI
>> nterceptor.aroundInvoke(CorrelationIdTrackerInterceptor.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.ManagedReferenceLifecycleMethodInt
>> erceptor.processInvocation(ManagedReferenceLifecycleMethodIn
>> terceptor.java:89)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeI
>> nterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.proc
>> essInvocation(ConcurrentContextInterceptor.java:45)
>> [wildfly-ee-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.InitialInterceptor.processInvocation(In
>> itialInterceptor.java:40)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.ChainedInterceptor.processInvocation(Ch
>> ainedInterceptor.java:53)
>> at org.jboss.as.ee.component.interceptors.ComponentDispatcherIn
>> terceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.component.singleton.SingletonComponentInst
>> anceAssociationInterceptor.processInvocation(SingletonCompon
>> entInstanceAssociationInterceptor.java:53)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.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(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.InterceptorContext$Invocation.proceed(I
>> nterceptorContext.java:509)
>> at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationIntercep
>> tor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)
>> [weld-core-impl-2.4.3.Final.jar:2.4.3.Final]
>> at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.p
>> rocessInvocation(EjbRequestScopeActivationInterceptor.java:89)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.component.interceptors.CurrentInvocationCo
>> ntextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterc
>> eptor.processInvocation(WaitTimeInterceptor.java:47)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.security.SecurityContextInterceptor.proces
>> sInvocation(SecurityContextInterceptor.java:100)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.deployment.processors.StartupAwaitIntercep
>> tor.processInvocation(StartupAwaitInterceptor.java:22)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptor
>> Factory$1.processInvocation(ShutDownInterceptorFactory.java:64)
>> [wildfly-ejb3-11.0.0.Final.jar:11.0.0.Final]
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.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(InterceptorC
>> ontext.java:422)
>> at org.jboss.as.ee.component.Name
>> <http://org.jboss.as.ee.component.name/>spaceContextInterceptor.proces
>> sInvocation(NamespaceContextInterceptor.java:50)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.ContextClassLoaderInterceptor.processIn
>> vocation(ContextClassLoaderInterceptor.java:60)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.InterceptorContext.run(InterceptorConte
>> xt.java:438)
>> at org.wildfly.security.manager.WildFlySecurityManager.doChecke
>> d(WildFlySecurityManager.java:609)
>> at org.jboss.invocation.AccessCheckingInterceptor.processInvoca
>> tion(AccessCheckingInterceptor.java:57)
>> at org.jboss.invocation.InterceptorContext.proceed(InterceptorC
>> ontext.java:422)
>> at org.jboss.invocation.ChainedInterceptor.processInvocation(Ch
>> ainedInterceptor.java:53)
>> at org.jboss.as.ee.component.ViewService$View.invoke(ViewServic
>> e.java:198)
>> at org.jboss.as.ee.component.ViewDescription$1.processInvocatio
>> n(ViewDescription.java:185)
>> at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(Prox
>> yInvocationHandler.java:81)
>> at org.ovirt.engine.core.common.interfaces.BackendLocal$$$view4.runQuery(Unknown
>> Source) [common.jar:]
>> at org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTService
>> Impl.runQuery(GenericApiGWTServiceImpl.java:90)
>> at org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTService
>> Impl.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(R
>> PC.java:587)
>> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processC
>> all(RemoteServiceServlet.java:333)
>> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processC
>> all(RemoteServiceServlet.java:303)
>> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processP
>> ost(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.GenericApiGWTService
>> Impl.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(Se
>> rvletHandler.java:85)
>> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
>> oFilter(FilterHandler.java:129)
>> at
org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94)
>> [utils.jar:]
>> at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilte
>> r.java:61)
>> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
>> oFilter(FilterHandler.java:131)
>> at
org.ovirt.engine.core.utils.servlet.CachingFilter.doFilter(CachingFilter.java:133)
>> [utils.jar:]
>> at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilte
>> r.java:61)
>> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
>> oFilter(FilterHandler.java:131)
>> at
org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:73)
>> [branding.jar:]
>> at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilte
>> r.java:61)
>> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
>> oFilter(FilterHandler.java:131)
>> at
org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:65)
>> [utils.jar:]
>> at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilte
>> r.java:61)
>> at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.d
>> oFilter(FilterHandler.java:131)
>> at io.undertow.servlet.handlers.FilterHandler.handleRequest(Fil
>> terHandler.java:84)
>> at io.undertow.servlet.handlers.security.ServletSecurityRoleHan
>> dler.handleRequest(ServletSecurityRoleHandler.java:62)
>> at io.undertow.servlet.handlers.ServletDispatchingHandler.handl
>> eRequest(ServletDispatchingHandler.java:36)
>> at org.wildfly.extension.undertow.security.SecurityContextAssoc
>> iationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
>> at io.undertow.server.handlers.Pr
>> <http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(P
>> redicateHandler.java:43)
>> at io.undertow.servlet.handlers.security.SSLInformationAssociat
>> ionHandler.handleRequest(SSLInformationAssociationHandler.java:131)
>> at io.undertow.servlet.handlers.security.ServletAuthenticationC
>> allHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
>> at io.undertow.server.handlers.Pr
>> <http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(P
>> redicateHandler.java:43)
>> at io.undertow.security.handlers.AuthenticationConstraintHandle
>> r.handleRequest(AuthenticationConstraintHandler.java:53)
>> at io.undertow.security.handlers.AbstractConfidentialityHandler
>> .handleRequest(AbstractConfidentialityHandler.java:46)
>> at io.undertow.servlet.handlers.security.ServletConfidentiality
>> ConstraintHandler.handleRequest(ServletConfidentialityConstr
>> aintHandler.java:64)
>> at io.undertow.servlet.handlers.security.ServletSecurityConstra
>> intHandler.handleRequest(ServletSecurityConstraintHandler.java:59)
>> at io.undertow.security.handlers.AuthenticationMechanismsHandle
>> r.handleRequest(AuthenticationMechanismsHandler.java:60)
>> at io.undertow.servlet.handlers.security.CachedAuthenticatedSes
>> sionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
>> at io.undertow.security.handlers.NotificationReceiverHandler.ha
>> ndleRequest(NotificationReceiverHandler.java:50)
>> at io.undertow.security.handlers.AbstractSecurityContextAssocia
>> tionHandler.handleRequest(AbstractSecurityContextAssociation
>> Handler.java:43)
>> at io.undertow.server.handlers.Pr
>> <http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(P
>> redicateHandler.java:43)
>> at org.wildfly.extension.undertow.security.jacc.JACCContextIdHa
>> ndler.handleRequest(JACCContextIdHandler.java:61)
>> at io.undertow.server.handlers.Pr
>> <http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(P
>> redicateHandler.java:43)
>> at io.undertow.server.handlers.Pr
>> <http://io.undertow.server.handlers.pr/>edicateHandler.handleRequest(P
>> redicateHandler.java:43)
>> at io.undertow.servlet.handlers.ServletInitialHandler.handleFir
>> stRequest(ServletInitialHandler.java:292)
>> at io.undertow.servlet.handlers.ServletInitialHandler.access$10
>> 0(ServletInitialHandler.java:81)
>> at io.undertow.servlet.handlers.ServletInitialHandler$2.call(Se
>> rvletInitialHandler.java:138)
>> at io.undertow.servlet.handlers.ServletInitialHandler$2.call(Se
>> rvletInitialHandler.java:135)
>> at io.undertow.servlet.core.ServletRequestContextThreadSetupAct
>> ion$1.call(ServletRequestContextThreadSetupAction.java:48)
>> at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.cal
>> l(ContextClassLoaderSetupAction.java:43)
>> at org.wildfly.extension.undertow.security.SecurityContextThrea
>> dSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
>> at org.wildfly.extension.undertow.deployment.UndertowDeployment
>> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
>> owDeploymentInfoService.java:1508)
>> at org.wildfly.extension.undertow.deployment.UndertowDeployment
>> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
>> owDeploymentInfoService.java:1508)
>> at org.wildfly.extension.undertow.deployment.UndertowDeployment
>> InfoService$UndertowThreadSetupAction.lambda$create$0(Undert
>> owDeploymentInfoService.java:1508)
>> at io.undertow.servlet.handlers.ServletInitialHandler.dispatchR
>> equest(ServletInitialHandler.java:272)
>> at io.undertow.servlet.handlers.ServletInitialHandler.access$00
>> 0(ServletInitialHandler.java:81)
>> at io.undertow.servlet.handlers.ServletInitialHandler$1.handleR
>> equest(ServletInitialHandler.java:104)
>> at io.undertow.server.Connectors.executeRootHandler(Connectors.java:326)
>> at io.undertow.server.HttpServerExchange$1.run(HttpServerExchan
>> ge.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.receiveErrorRespons
>> e(QueryExecutorImpl.java:2157)
>> at org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer
>> yExecutorImpl.java:1886)
>> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut
>> orImpl.java:255)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract
>> Jdbc2Statement.java:555)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags
>> (AbstractJdbc2Statement.java:403)
>> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs
>> tractJdbc2Statement.java:283)
>> at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(Wr
>> appedStatement.java:397)
>> at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCa
>> llback.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.
>
2316
days inactive
2319
days old
5 comments
3 participants
participants (3)
-
Eli Mesika -
Filip Goll -
Martin Perina