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

Wednesday, 19 November 2014

---------- Forwarded message ----------
From: 张亚琪 <zhangyingyun001(a)gmail.com&gt;
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(a)redhat.com&gt;

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(a)redhat.com&gt;:

...
 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.

 ----- Original Message -----
 > From: "张亚琪" <zhangyingyun001(a)gmail.com&gt;
 > To: Devel(a)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(a)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(a)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(a)redhat.com > :
 >
 >
 >
 > Are all your servers sync to the same ntp and in UTM time?
 > Can you attach logs?
 >
 >
 > Yaniv
 >
 >
 >
 >
 > From: "张亚琪" < zhangyingyun001(a)gmail.com >
 > To: Devel(a)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 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(a)ovirt.org
 > http://lists.ovirt.org/mailman/listinfo/devel
 >
 >
 >
 >
 > _______________________________________________
 > Devel mailing list
 > Devel(a)ovirt.org
 > http://lists.ovirt.org/mailman/listinfo/devel

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011