New subject: Fwd: Fwd: DWH cannot gain hourly history data from db because of the bloody time problem.

20 Nov 2014


      hi,

    Are you there?  I try to test it on a new environment. But the problem
is still there. And every time I update the the field of lastHourAggr , the
reports can work successfully.
    So I have set the development environment and tried to study code in
there. Would you tell me which parts should I view.

    Thanks a lot.

2014-11-20 8:33 GMT+08:00 张亚琪 <zhangyingyun001@gmail.com>:
...
hi, Yaniv
1. set yum resource for ovirt 3.5
2. yum -y install ovirt-engine
3. yum -y install ovirt-engine-dwh
4. yum -y install ovirt-engine-reports
5. engine-setup
my environment is running normally. And have you seen that last part in
the previous mail ? I still view that the error is caused by the field of
lastHourAggr in the table of history_configuration.
2014-11-19 20:51 GMT+08:00 Yaniv Dary <ydary@redhat.com>:
...
Reviewing the log again I seeing a lot of issue with database, values are
missing and connection is dropping.
Can you please describe how you create this environment? Is the engine up
and running?
Yaniv
------------------------------
*From: *"张亚琪" <zhangyingyun001@gmail.com>
*To: *"Yaniv Dary" <ydary@redhat.com>
*Sent: *Wednesday, November 19, 2014 2:29:24 PM
*Subject: *Re: [ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history
data from db because of the bloody time problem.
hi Yaniv,
This is my environment's timezone.
[helen@zhangyingyun local]$ date -R
Wed, 19 Nov 2014 20:28:46 +0800
2014-11-19 18:31 GMT+08:00 张亚琪 <zhangyingyun001@gmail.com>:
...
hi Yaniv,
It's very great to hear from you.
1. system time
[root@zhangyingyun ~]# date
Wed Nov 19 18:25:55 CST 2014
2. datebase time
...
ovirt_engine_history=# select now();
now
-------------------------------
2014-11-19 18:25:55.476386+08
(1 row)
...
3.
...
postgres=# \l
List of databases
Name         |        Owner         | Encoding |  Collation  |
...
Ctype    |   Access pri
vileges
...
----------------------+----------------------+----------+-------------+-------------+-------------
----------
engine               | engine               | UTF8     | en_US.UTF-8 |
...
en_US.UTF-8 |
enginedev            | engine               | UTF8     | zh_CN.UTF-8 |
...
zh_CN.UTF-8 |
ovirt_engine_history | ovirt_engine_history | UTF8     | en_US.UTF-8 |
...
en_US.UTF-8 |
ovirt_engine_reports | ovirt_engine_reports | UTF8     | en_US.UTF-8 |
...
en_US.UTF-8 |
ovirtbackup          | engine               | UTF8     | zh_CN.UTF-8 |
...
zh_CN.UTF-8 |
postgres             | postgres             | UTF8     | zh_CN.UTF-8 |
...
zh_CN.UTF-8 |
template0            | postgres             | UTF8     | zh_CN.UTF-8 |
...
zh_CN.UTF-8 | =c/postgres
...
: postgres=CTc
/postgres
template1            | postgres             | UTF8     | zh_CN.UTF-8 |
...
zh_CN.UTF-8 | =c/postgres
...
: postgres=CTc
/postgres
(8 rows)
Thank you!  :)
2014-11-19 17:50 GMT+08:00 Yaniv Dary <ydary@redhat.com>:
...
please run:
# date
in console and on postgres:
# SELECT CURRENT_TIMESTAMP;
and send outputs.
Also run:
# sudo su - postgres
# psql
# \list
and send output.
I think the error are happening because you manually created databases
and either Encoding is not UTF8, Collate is not en_US.UTF-8 or Ctype
is not  en_US.UTF-8.
We only support that.
Yaniv
------------------------------
*From: *"张亚琪" <zhangyingyun001@gmail.com>
*To: *"Shirly Radco" <sradco@redhat.com>, Devel@ovirt.org
*Sent: *Wednesday, November 19, 2014 2:57:19 AM
*Subject: *[ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data
from db because of the bloody time problem.
---------- Forwarded message ----------
From: 张亚琪 <zhangyingyun001@gmail.com>
Date: 2014-11-19 8:54 GMT+08:00
Subject: Re: [ovirt-devel] Fwd: DWH cannot gain hourly history data
from db because of the bloody time problem.
To: Shirly Radco <sradco@redhat.com>
hi Shirly, thank you for your reply and sorry for my late.
I will show u all things u require and something I want to prove my
view.
0. Log
0.1. engine.log （about reports）
...
2014-11-18 18:00:45,569 ERROR [org.ovirt.engine.core.bll.SearchQuery]
...
(ajp--127.0.0.1-8702-10) Query SearchQuery failed. Exception message is
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62: org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62
at
...
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
[dal.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73)
[bll.jar:]
at
...
org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31)
[dal.jar:]
at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)
...
[bll.jar:]
at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
...
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13)
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown
Source) [common.jar:]
at
...
org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)
at
...
com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)
at
...
com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)
at
...
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at
...
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at
...
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)
at
...
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
at
...
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
at
...
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)
at
...
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
...
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)
at
...
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)
at
...
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
...
DISTINCT, ORDER BY表达式
Position: 62
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at
...
org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
at
...
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
[spring-jdbc.jar:3.1.1.RELEASE]
... 113 more
...
2014-11-18 18:00:50,595 ERROR [org.ovirt.engine.core.bll.SearchQuery]
(ajp--127.0.0.1-8702-4) Query SearchQuery failed. Exception message is
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62: org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62
at
...
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
[dal.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73)
[bll.jar:]
at
...
org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31)
[dal.jar:]
at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)
...
[bll.jar:]
at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
...
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13)
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown
Source) [common.jar:]
at
...
org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)
at
...
com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)
at
...
com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)
at
...
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at
...
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at
...
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)
at
...
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
at
...
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
at
...
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)
at
...
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
...
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)
at
...
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)
at
...
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
...
DISTINCT, ORDER BY表达式
Position: 62
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at
...
org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
at
...
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
[spring-jdbc.jar:3.1.1.RELEASE]
... 113 more
...
2014-11-18 18:00:56,627 ERROR [org.ovirt.engine.core.bll.SearchQuery]
(ajp--127.0.0.1-8702-1) Query SearchQuery failed. Exception message is
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62 : org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62: org.springframework.jdbc.BadSqlGrammarException:
...
StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.*
FROM  vms  )  ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC )
as T1 OFFSET (1 -1) LIMIT 100]; nested exception is
org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER
BY表达式
Position: 62
at
...
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175)
[dal.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65)
[bll.jar:]
at
...
org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73)
[bll.jar:]
at
...
org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31)
[dal.jar:]
at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)
...
[bll.jar:]
at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466)
...
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13)
[bll.jar:]
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at
...
org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
[jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
[jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
[jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
at
...
org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
[jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
at
...
org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown
Source) [common.jar:]
at
...
org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)
at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)
...
[:1.7.0_71]
at
...
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.7.0_71]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)
at
...
com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)
at
...
com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)
at
...
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
...
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
[weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64)
[utils.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63)
[aaa.jar:]
at
...
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
at
...
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
at
...
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
at
...
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
at
...
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)
at
...
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
at
...
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
at
...
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)
at
...
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
...
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)
at
...
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)
at
...
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]
Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT
...
DISTINCT, ORDER BY表达式
Position: 62
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at
...
org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)
at
...
org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
[spring-jdbc.jar:3.1.1.RELEASE]
at
...
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
[spring-jdbc.jar:3.1.1.RELEASE]
... 113 more
0.2. ovirt-engine-dwh.log
2014-11-18
...
...
12:36:00|NmaVBj|ZdLGGX|gX18vw|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tRunJob*
...
_4Process(SampleRunJobs.java:953)
at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tJDBCConnection*
...
_2Process(SampleRunJobs.java:762)
at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tJDBCConnection*
...
_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
12:36:00|gX18vw|ZdLGGX|iY0VVa|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tRunJob*
_1Process(SampleTimeKeepingJob.java:5941)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tJDBCInput*
_2Process(SampleTimeKeepingJob.java:5707)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tJDBCConnection*
_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tRowGenerator*
_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.*SampleTimeKeepingJob*
...
$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
12:36:00|iY0VVa|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCOutput_3
org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
12:37:00|xrgPmR|ZdLGGX|pSvwg0|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
由于管理员命令中断联接|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
12:37:00|pSvwg0|ZdLGGX|K3fwaz|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
12:37:05|K3fwaz|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCInput_6
java.lang.NullPointerException
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.tJDBCInput*
_6Process(AggregationToHourly.java:19335)
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.tJDBCConnection*
_1Process(AggregationToHourly.java:18891)
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.tPrejob*
_1Process(AggregationToHourly.java:18770)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.runJob*(AggregationToHourly.java:25464)
at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
...
*HourlyTimeKeepingJob.tRunJob*
_1Process(HourlyTimeKeepingJob.java:2541)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_1
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)
Exception in component tJDBCInput_3
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)
Exception in component tJDBCInput_2
Exception in component tJDBCInput_9
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)
Exception in component tJDBCInput_13
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
java.lang.NullPointerException
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)
Exception in component tJDBCInput_10
java.lang.NullPointerException
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)
Exception in component tJDBCInput_5
Exception in component tJDBCInput_11
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)
Exception in component tJDBCInput_4
java.lang.NullPointerException
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)
java.lang.NullPointerException2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
...
at
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tJDBCOutput_6
org.postgresql.util.PSQLException: An I/O error occured while sending
...
to the backend.
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.tRowGenerator*
_1Process(AggregationToHourly.java:19905)
at ovirt_engine_dwh.aggregationtohourly_3_5.
...
*AggregationToHourly.tPostjob*
_1Process(AggregationToHourly.java:19496)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
...
*HourlyTimeKeepingJob.tRunJob*
_1Process(HourlyTimeKeepingJob.java:2541)
at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
...
*HourlyTimeKeepingJob.tJDBCInput*
_1Process(HourlyTimeKeepingJob.java:2369)
at ovirt_engine_dwh.hourlytimekeepingjob_3_5.
...
*HourlyTimeKeepingJob.tJDBCConnection*
_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
at
...
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at org.postgresql.core.PGStream.flush(PGStream.java:521)
at
...
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
... 12 more
2014-11-18
...
13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error
occured while sending to the backend.|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
An I/O error occured while sending to the backend.An I/O error occured
...
while sending to the backend.2014-11-18
13:00:00|Qb7Vkj|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCInput_4
java.lang.NullPointerException
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tJDBCInput*
_4Process(SampleTimeKeepingJob.java:2121)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.
...
*SampleTimeKeepingJob.tJDBCConnection*
_3Process(SampleTimeKeepingJob.java:1537)
at ovirt_engine_dwh.sampletimekeepingjob_3_5.*SampleTimeKeepingJob*
...
$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
13:30:00|xb5OGC|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_4
java.lang.NullPointerException
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1371)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
13:31:00|tetatR|ZdLGGX|Aaa74D|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
13:31:00|Aaa74D|ZdLGGX|jYGdcg|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
13:31:00|jYGdcg|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCOutput_3
org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
13:32:00|AJFmu7|ZdLGGX|n34YZo|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
由于管理员命令中断联接|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
13:32:00|n34YZo|ZdLGGX|XZy3yU|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
13:32:05|XZy3yU|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCInput_4
java.lang.NullPointerException
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2121)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
16:29:01|R7YvSQ|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_4
java.lang.NullPointerException
at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tJDBCInput*
...
_4Process(OsEnumUpdate.java:1371)
at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tJDBCConnection*
...
_1Process(OsEnumUpdate.java:862)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.runJob*
...
(OsEnumUpdate.java:4144)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
16:30:01|AvgrjL|ZdLGGX|4eSwoN|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
16:30:01|4eSwoN|ZdLGGX|VtZtjF|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
16:30:01|VtZtjF|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCOutput_3
org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接
at
...
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
at
...
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tRowGenerator*
...
_1Process(OsEnumUpdate.java:1844)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)
at
...
ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
16:31:01|Jc5by2|ZdLGGX|r5BRqk|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java
Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误:
由于管理员命令中断联接|1
Exception in component tRunJob_4
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)
at
...
ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)
2014-11-18
...
16:31:01|r5BRqk|ZdLGGX|uyMqI5|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)
at
...
ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)
2014-11-18
...
16:31:06|uyMqI5|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCInput_6
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_6Process(AggregationToHourly.java:19335)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCConnection_1Process(AggregationToHourly.java:18891)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPrejob_1Process(AggregationToHourly.java:18770)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_1
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)
Exception in component tJDBCInput_11
Exception in component tJDBCInput_9
Exception in component tJDBCInput_10
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)
Exception in component tJDBCInput_13
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)
java.lang.NullPointerException
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)
Exception in component tJDBCInput_4
Exception in component tJDBCInput_3
java.lang.NullPointerException2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
...
at
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)
Exception in component tJDBCInput_52014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
...
Exception in component tJDBCInput_2
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)
java.lang.NullPointerException
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)
java.lang.NullPointerException
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
Exception in component tJDBCOutput_6
org.postgresql.util.PSQLException: An I/O error occured while sending
...
to the backend.
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
at
...
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tRowGenerator_1Process(AggregationToHourly.java:19905)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPostjob_1Process(AggregationToHourly.java:19496)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)
at
...
ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
Caused by: java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:159)
at
...
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at org.postgresql.core.PGStream.flush(PGStream.java:521)
at
...
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)
at
...
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)
... 12 more
2014-11-18
...
17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java
Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error
occured while sending to the backend.|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)
at
...
ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)
An I/O error occured while sending to the backend.An I/O error occured
...
while sending to the backend.2014-11-18
17:00:00|P66Bbl|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java
Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1
Exception in component tJDBCInput_5
java.lang.NullPointerException
at ovirt_engine_dwh.dailytimekeepingjob_3_5.
...
*DailyTimeKeepingJob.tJDBCInput*
_5Process(DailyTimeKeepingJob.java:3066)
at
...
ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCInput_1Process(DailyTimeKeepingJob.java:2535)
at ovirt_engine_dwh.dailytimekeepingjob_3_5.
...
*DailyTimeKeepingJob.tJDBCConnection*
_1Process(DailyTimeKeepingJob.java:1914)
at
...
ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCConnection_2Process(DailyTimeKeepingJob.java:1793)
at
...
ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob$2.run(DailyTimeKeepingJob.java:6687)
2014-11-19
...
00:00:00|qXv21T|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DailyTimeKeepingJob|Default|6|Java
Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_1
java.lang.NullPointerException
at ovirt_engine_dwh.historydelete_3_5.*HistoryDelete.tJDBCInput*
...
_1Process(HistoryDelete.java:1592)
at ovirt_engine_dwh.historydelete_3_5.*HistoryDelete*
...
$2.run(HistoryDelete.java:13315)
Exception in component tJDBCInput_20
Exception in component tJDBCInput_21
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_21Process(HistoryDelete.java:9981)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$22.run(HistoryDelete.java:14235)
Exception in component tJDBCInput_19
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_19Process(HistoryDelete.java:9142)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$20.run(HistoryDelete.java:14143)
Exception in component tJDBCInput_26
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_26Process(HistoryDelete.java:12295)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$27.run(HistoryDelete.java:14465)
Exception in component tJDBCInput_10
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_10Process(HistoryDelete.java:5367)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$11.run(HistoryDelete.java:13729)
Exception in component tJDBCInput_9
Exception in component tJDBCInput_12
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_12Process(HistoryDelete.java:6207)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$13.run(HistoryDelete.java:13821)
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_1|java.lang.NullPointerException:null|1
Exception in component tJDBCInput_14
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_26|java.lang.NullPointerException:null|1
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_14Process(HistoryDelete.java:7045)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$15.run(HistoryDelete.java:13913)
Exception in component tJDBCInput_23
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_23Process(HistoryDelete.java:11035)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$24.run(HistoryDelete.java:14327)
Exception in component tJDBCInput_13
Exception in component tJDBCInput_7
Exception in component tJDBCInput_11
Exception in component tJDBCInput_8
Exception in component tJDBCInput_4
Exception in component tJDBCInput_5
Exception in component tJDBCInput_6
Exception in component tJDBCInput_2
Exception in component tJDBCInput_3
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_2Process(HistoryDelete.java:2011)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$3.run(HistoryDelete.java:13361)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_6Process(HistoryDelete.java:3689)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$7.run(HistoryDelete.java:13545)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_5Process(HistoryDelete.java:3270)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$6.run(HistoryDelete.java:13499)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_4Process(HistoryDelete.java:2850)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$5.run(HistoryDelete.java:13453)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_8Process(HistoryDelete.java:4528)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$9.run(HistoryDelete.java:13637)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_11Process(HistoryDelete.java:5787)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$12.run(HistoryDelete.java:13775)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_7Process(HistoryDelete.java:4108)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$8.run(HistoryDelete.java:13591)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_13Process(HistoryDelete.java:6626)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$14.run(HistoryDelete.java:13867)
Exception in component tJDBCInput_22
Exception in component tJDBCInput_24
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_9Process(HistoryDelete.java:4947)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$10.run(HistoryDelete.java:13683)
Exception in component tJDBCInput_25
Exception in component tJDBCInput_16
Exception in component tJDBCInput_15
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_15Process(HistoryDelete.java:7464)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$16.run(HistoryDelete.java:13959)
Exception in component tJDBCInput_17
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_20Process(HistoryDelete.java:9562)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$21.run(HistoryDelete.java:14189)
Exception in component tJDBCInput_18
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_17Process(HistoryDelete.java:8303)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$18.run(HistoryDelete.java:14051)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_16Process(HistoryDelete.java:7884)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$17.run(HistoryDelete.java:14005)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_25Process(HistoryDelete.java:11875)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$26.run(HistoryDelete.java:14419)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_24Process(HistoryDelete.java:11455)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$25.run(HistoryDelete.java:14373)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_22Process(HistoryDelete.java:10615)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$23.run(HistoryDelete.java:14281)
java.lang.NullPointerException
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_18Process(HistoryDelete.java:8723)
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$19.run(HistoryDelete.java:14097)
java.lang.NullPointerException
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_19|java.lang.NullPointerException:null|1
at
...
ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_3Process(HistoryDelete.java:2431)2014-11-19
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_18|java.lang.NullPointerException:null|1
...
at
ovirt_engine_dwh.historydelete_3_5.HistoryDelete$4.run(HistoryDelete.java:13407)
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_22|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_24|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_25|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_16|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_17|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_20|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_15|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_9|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_13|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_3|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_7|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_11|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_8|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_4|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_5|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_6|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_2|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_23|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_14|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_12|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_21|java.lang.NullPointerException:null|1
2014-11-19
...
03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java
Exception|tJDBCInput_10|java.lang.NullPointerException:null|1
Exception in component tRunJob_2
java.lang.RuntimeException: Child job running failed
at ovirt_engine_dwh.deletetimekeepingjob_3_5.
...
*DeleteTimeKeepingJob.tRunJob*
_2Process(DeleteTimeKeepingJob.java:2794)
at ovirt_engine_dwh.deletetimekeepingjob_3_5.
...
*DeleteTimeKeepingJob.tJDBCInput*
_1Process(DeleteTimeKeepingJob.java:2589)
at ovirt_engine_dwh.deletetimekeepingjob_3_5.
...
*DeleteTimeKeepingJob.tJDBCConnection*
_1Process(DeleteTimeKeepingJob.java:2001)
at
...
ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob.tJDBCConnection_2Process(DeleteTimeKeepingJob.java:1880)
at
...
ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob$2.run(DeleteTimeKeepingJob.java:9473)
2014-11-19
...
03:00:00|5DCU4k|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java
Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1
0.3. ovirt-engine-reports.log
There is no useful info in jasperserver.log & reports.log
1. The version of my environment
[root@zhangyingyun ovirt-engine-reports]# rpm -qa|grep ovirt
ovirt-release35-snapshot-002-0.0.master.noarch
ovirt-engine-setup-plugin-ovirt-engine-common-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-backend-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-cli-3.5.0.6-0.1.20141107.gitcf7f1a1.el6.noarch
*ovirt-engine-setup-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch*
*ovirt-engine-reports-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch*
*ovirt-engine-dwh-setup-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch*
ovirt-optimizer-ui-0.6-1.el6.noarch
*ovirt-engine-dwh-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch*
ovirt-engine-lib-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-setup-plugin-ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-extensions-api-impl-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-webadmin-portal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
*ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch*
ovirt-iso-uploader-3.5.1-0.0.master.20140926055817.git472e66e.el6.noarch
ovirt-engine-setup-plugin-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
*ovirt-engine-reports-setup-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch*
ovirt-engine-restapi-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-dbscripts-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-host-deploy-java-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch
ovirt-engine-jboss-as-7.1.1-1.el6.x86_64
ovirt-guest-agent-1.0.10.2-1.el6.noarch
ovirt-image-uploader-3.5.1-0.0.master.20141027101643.git1b30d59.el6.noarch
ovirt-engine-sdk-python-3.5.0.9-0.1.20141111.gitd6eb612.el6.noarch
ovirt-engine-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-tools-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-host-deploy-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch
ovirt-release35-002-0.0.master.noarch
ovirt-engine-setup-base-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-engine-userportal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch
ovirt-guest-tools-3.5.0-0.5.master.noarch
2. the timezone for my machine
[root@zhangyingyun ovirt-engine-reports]# date -R
Wed, 19 Nov 2014 08:19:34 +0800
and my dbtime is normal too:
postgres=# select now();
              now
-------------------------------
 2014-11-19 08:20:44.849422+08
(1 row)
3. But I will show u something that can prove my opinion.
The following is DWH development environment:
and I checked db according to its tips,  contents are as follows:
ovirt_engine_history=# select distinct var_name, var_datetime from
...
...
history_configuration where var_name = 'lastHourAggr';
var_name   |      var_datetime
--------------+------------------------
*lastHourAggr | 2014-11-19 21:00:00+08*
(1 row)
the next is:
the sql in this pic is:
"SELECT history_id,
...
history_datetime,
datacenter_id,
datacenter_status,
minutes_in_status,
datacenter_configuration_version
FROM datacenter_samples_history
WHERE *history_datetime >= '"+context.lastHourAggr+"'*
AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,
...
1,"HH")+"'
ORDER BY history_datetime,
datacenter_id,
datacenter_status"
the lastest info as follows:
ovirt_engine_history=# select history_datetime from
datacenter_samples_history;
      history_datetime
----------------------------
 2014-11-19 08:26:01.964+08
 2014-11-19 08:27:01.988+08
 2014-11-19 08:28:01.953+08
 2014-11-19 08:29:01.962+08
 2014-11-19 08:30:01.95+08
 2014-11-19 08:31:01.949+08
 2014-11-19 08:32:01.965+08
 2014-11-19 08:33:01.98+08
 2014-11-19 08:34:01.955+08
 2014-11-19 08:35:01.969+08
 2014-11-19 08:36:01.967+08
 2014-11-19 08:37:01.958+08
 2014-11-19 08:38:01.974+08
 2014-11-19 08:39:01.974+08
 2014-11-19 08:40:01.964+08
 2014-11-19 08:41:01.961+08
 2014-11-19 08:42:01.977+08
 2014-11-19 08:43:01.96+08
(1994 rows)
so the result is clear.  *history_datetime < lastHourAggr *, so the
data cannot be written to the db be from datacenter_samples_history to
datacenter_hourly_history.
Looking forward your reply . Thank you very much.
2014-11-17 14:31 GMT+08:00 Shirly Radco <sradco@redhat.com>:
...
Hi,
UTC time is the coordinated Universal Time,
and we recommend syncing the machines according to it,
so the data will not be affected when changing the clock from summer
time to winter time and back.
All reports can be shown in the local time you choose in the reports
portal.
But still, this should not cause issues with hourly reports not
showing.
Please attach all logs. Should be located at:
/var/log/ovirt-engine
/var/log/ovirt-engine-dwh
/var/log/ovirt-engine-reports
Also please let us know what ovirt 3.5 version you are using:
rpm -qa |grep ovirt
For ovirt-engine-dwh, ovirt-engine-reports and ovirt-engine.
Last, please let us now what timezone is set currently for your
machine.
Best regards,
---
Shirly Radco
BI Software Engineer
Red Hat Israel Ltd.
...
From: "张亚琪" <zhangyingyun001@gmail.com>
To: Devel@ovirt.org
Sent: Monday, November 17, 2014 3:51:07 AM
Subject: [ovirt-devel] Fwd: DWH cannot gain hourly history data from
db because of the bloody time problem.
---------- Forwarded message ----------
From: 张亚琪 < zhangyingyun001@gmail.com >
Date: 2014-11-16 20:04 GMT+08:00
Subject: Re: [ovirt-devel] DWH cannot gain hourly history data from
db
because of the bloody time problem.
To: Yaniv Dary < ydary@redhat.com >
hi, Yaniv. Thank you for your reply. However, I think that there is
no sync
problem in my setup, because the engine, dwh and reports are in the
same
machine. As a new, I am not familiar with UTM time.
And please see the attachment. Looking forward your reply. Thanks a
lot.
2014-11-16 7:31 GMT+08:00 Yaniv Dary < ydary@redhat.com > :
Are all your servers sync to the same ntp and in UTM time?
Can you attach logs?
Yaniv
From: "张亚琪" < zhangyingyun001@gmail.com >
To: Devel@ovirt.org
Sent: Friday, November 14, 2014 11:22:38 AM
Subject: [ovirt-devel] DWH cannot gain hourly history data from db
because of
the bloody time problem.
hi everybody,
Recently, I have tested oVirt Reports. And I encountered a problem
about some
reports that cannot show data. And then I setup the DWH development
environment. I found maybe this reason for missing data is the
AggregationToHourly3.5. When data from datacenter_samples_history
were
inserted to datacenter_hourly_history, u will find nothing happened.
Because
the select sql before inserting data reads：
"SELECT history_id,
history_datetime,
datacenter_id,
datacenter_status,
minutes_in_status,
datacenter_configuration_version
FROM datacenter_samples_history
WHERE history_datetime >= '"+context.lastHourAggr+ "'
AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,
1,"HH")+"'
ORDER BY history_datetime,
datacenter_id,
datacenter_status"
And then I queried the table of datacenter_samples_history &
history_configuration (has the field of lastHourAggr) in the db of
ovirt_engine_history. The results are as follows:
ovirt_engine_history=# select * from history_configuration;
var_name | var_value | var_datetime
-------------------+-----------+------------------------
MinimalETLVersion | 3.5.0 |
default_language | en_US |
firstSync | false | 2014-10-13 19:42:00+08
lastDayAggr | | 2014-11-14 00:00:00+08
lastHourAggr | | 2014- 11-15 06:00:00+08
HourlyAggFailed | false |
(6 rows)
ovirt_engine_history=# select history_datetime from
datacenter_samples_history;
history_datetime
----------------------------
2014- 11-13 03:07:00.23+08
2014-11-13 03:08:00.238+08
2014-11-13 03:09:00.229+08
2014-11-13 03:10:00.221+08
2014-11-13 03:11:00.229+08
2014-11-13 03:12:00.221+08
2014-11-13 03:13:00.237+08
2014-11-13 03:14:00.22+08
2014-11-13 03:15:00.221+08
2014-11-13 03:16:00.238+08
2014-11-13 03:17:00.238+08
Obviously， history_datetime < lastHourAggr , the data will never be
inserted
to the datacenter_hourly_history. And the place where I bold is the
root
cause of the error. Then , I try to update the lastHourAggr in the
----- Original Message -----
table of
...
history_configuration. Reports works successfully. However, the
lastHourAggr
will change to 2014-11-15 afterwards. But u know Today is 2014-11-14
! I
have no idea about why the value of lastHourAggr is 2014-11-15.
Would u help
me solve this problem. Thanks a lot !
_______________________________________________
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

Re: [ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data from db because of the bloody time problem.

张亚琪

Shirly Radco

Shirly Radco

tags

participants (2)