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

hi, Yaniv 1. set yum resource for ovirt 3.5 2. yum -y install ovirt-engine 3. yum -y install ovirt-engine-dwh 4. yum -y install ovirt-engine-reports 5. engine-setup my environment is running normally. And have you seen that last part in the previous mail ? I still view that the error is caused by the field of lastHourAggr in the table of history_configuration. 2014-11-19 20:51 GMT+08:00 Yaniv Dary <ydary(a)redhat.com&gt;: > Reviewing the log again I seeing a lot of issue with database, values are > missing and connection is dropping. > Can you please describe how you create this environment? Is the engine up > and running? > > > > Yaniv > > ------------------------------ > > *From: *"张亚琪" <zhangyingyun001(a)gmail.com&gt; > *To: *"Yaniv Dary" <ydary(a)redhat.com&gt; > *Sent: *Wednesday, November 19, 2014 2:29:24 PM > *Subject: *Re: [ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history > data from db because of the bloody time problem. > > hi Yaniv, > > This is my environment's timezone. > [helen@zhangyingyun local]$ date -R > Wed, 19 Nov 2014 20:28:46 +0800 > > 2014-11-19 18:31 GMT+08:00 张亚琪 <zhangyingyun001(a)gmail.com&gt;: > >> hi Yaniv, >> >> It's very great to hear from you. >> 1. system time >> >> [root@zhangyingyun ~]# date >> >> Wed Nov 19 18:25:55 CST 2014 >> >> >> >> 2. datebase time >> >> >>> ovirt_engine_history=# select now(); >> >> now >> >> ------------------------------- >> >> 2014-11-19 18:25:55.476386+08 >> >> (1 row) >> >> >>> >> >> 3. >> >>> postgres=# \l >>> >>> List of databases >>> >>> Name | Owner | Encoding | Collation | >>>> Ctype | Access pri >>> >>> vileges >>> >>> >>>> ----------------------+----------------------+----------+-------------+-------------+------------- >>> >>> ---------- >>> >>> engine | engine | UTF8 | en_US.UTF-8 | >>>> en_US.UTF-8 | >>> >>> enginedev | engine | UTF8 | zh_CN.UTF-8 | >>>> zh_CN.UTF-8 | >>> >>> ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | >>>> en_US.UTF-8 | >>> >>> ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | >>>> en_US.UTF-8 | >>> >>> ovirtbackup | engine | UTF8 | zh_CN.UTF-8 | >>>> zh_CN.UTF-8 | >>> >>> postgres | postgres | UTF8 | zh_CN.UTF-8 | >>>> zh_CN.UTF-8 | >>> >>> template0 | postgres | UTF8 | zh_CN.UTF-8 | >>>> zh_CN.UTF-8 | =c/postgres >>> >>> >>>> : postgres=CTc >>> >>> /postgres >>> >>> template1 | postgres | UTF8 | zh_CN.UTF-8 | >>>> zh_CN.UTF-8 | =c/postgres >>> >>> >>>> : postgres=CTc >>> >>> /postgres >>> >>> (8 rows) >>> >>> >>> >> Thank you! :) >> >> 2014-11-19 17:50 GMT+08:00 Yaniv Dary <ydary(a)redhat.com&gt;: >> >>> please run: >>> # date >>> in console and on postgres: >>> # SELECT CURRENT_TIMESTAMP; >>> and send outputs. >>> >>> Also run: >>> # sudo su - postgres >>> # psql >>> # \list >>> and send output. >>> >>> I think the error are happening because you manually created databases >>> and either Encoding is not UTF8, Collate is not en_US.UTF-8 or Ctype >>> is not en_US.UTF-8. >>> >>> We only support that. >>> >>> >>> >>> Yaniv >>> >>> ------------------------------ >>> >>> *From: *"张亚琪" <zhangyingyun001(a)gmail.com&gt; >>> *To: *"Shirly Radco" <sradco(a)redhat.com&gt;, Devel(a)ovirt.org >>> *Sent: *Wednesday, November 19, 2014 2:57:19 AM >>> *Subject: *[ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data >>> from db because of the bloody time problem. >>> >>> >>> ---------- Forwarded message ---------- >>> From: 张亚琪 <zhangyingyun001(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 >>>> >>> >>> >>> >>> _______________________________________________ >>> Devel mailing list >>> Devel(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/devel >>> >>> >>> >> > >