---------- Forwarded message ---------- From: 张亚琪 <zhangyingyun001@gmail.com> Date: 2014-11-19 18:31 GMT+08:00 Subject: Re: [ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data from db because of the bloody time problem. To: Yaniv Dary <ydary@redhat.com> hi Yaniv, It's very great to hear from you. 1. system time [root@zhangyingyun ~]# date Wed Nov 19 18:25:55 CST 2014 2. datebase time

ovirt_engine_history=# select now();

now ------------------------------- 2014-11-19 18:25:55.476386+08 (1 row)

3.

postgres=# \l

List of databases

Name | Owner | Encoding | Collation |

...

Ctype | Access pri

vileges

...

----------------------+----------------------+----------+-------------+-------------+-------------

----------

engine | engine | UTF8 | en_US.UTF-8 |

...

en_US.UTF-8 |

enginedev | engine | UTF8 | zh_CN.UTF-8 |

...

zh_CN.UTF-8 |

ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 |

...

en_US.UTF-8 |

ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 |

...

en_US.UTF-8 |

ovirtbackup | engine | UTF8 | zh_CN.UTF-8 |

...

zh_CN.UTF-8 |

postgres | postgres | UTF8 | zh_CN.UTF-8 |

...

zh_CN.UTF-8 |

template0 | postgres | UTF8 | zh_CN.UTF-8 |

...

zh_CN.UTF-8 | =c/postgres

...

: postgres=CTc

/postgres

template1 | postgres | UTF8 | zh_CN.UTF-8 |

...

zh_CN.UTF-8 | =c/postgres

...

: postgres=CTc

/postgres

(8 rows)

Thank you! :) 2014-11-19 17:50 GMT+08:00 Yaniv Dary <ydary@redhat.com>:

please run: # date in console and on postgres: # SELECT CURRENT_TIMESTAMP; and send outputs.

Also run: # sudo su - postgres # psql # \list and send output.

I think the error are happening because you manually created databases and either Encoding is not UTF8, Collate is not en_US.UTF-8 or Ctype is not en_US.UTF-8.

We only support that.

Yaniv

------------------------------

*From: *"张亚琪" <zhangyingyun001@gmail.com> *To: *"Shirly Radco" <sradco@redhat.com>, Devel@ovirt.org *Sent: *Wednesday, November 19, 2014 2:57:19 AM *Subject: *[ovirt-devel] Fwd: Fwd: DWH cannot gain hourly history data from db because of the bloody time problem.

---------- Forwarded message ---------- From: 张亚琪 <zhangyingyun001@gmail.com> Date: 2014-11-19 8:54 GMT+08:00 Subject: Re: [ovirt-devel] Fwd: DWH cannot gain hourly history data from db because of the bloody time problem. To: Shirly Radco <sradco@redhat.com>

hi Shirly, thank you for your reply and sorry for my late. I will show u all things u require and something I want to prove my view.

0. Log

0.1. engine.log （about reports）

...

2014-11-18 18:00:45,569 ERROR [org.ovirt.engine.core.bll.SearchQuery]

...

(ajp--127.0.0.1-8702-10) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62 : org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62: org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62

at

...

org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175) [dal.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156) [bll.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65) [bll.jar:]

at

...

org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73) [bll.jar:]

at

...

org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31) [dal.jar:]

at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)

...

[bll.jar:]

at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown Source) [common.jar:]

at

...

org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)

at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)

at com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)

at com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)

at

...

com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

at

...

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

at

...

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)

at

...

org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

at

...

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

at

...

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)

at

...

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at

...

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)

at

...

org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]

Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT

...

DISTINCT, ORDER BY表达式

Position: 62

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)

at

...

org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

at

...

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [spring-jdbc.jar:3.1.1.RELEASE]

... 113 more

...

2014-11-18 18:00:50,595 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp--127.0.0.1-8702-4) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62 : org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62: org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62

at

...

org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175) [dal.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156) [bll.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65) [bll.jar:]

at

...

org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73) [bll.jar:]

at

...

org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31) [dal.jar:]

at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)

...

[bll.jar:]

at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown Source) [common.jar:]

at

...

org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)

at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)

at com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)

at com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)

at

...

com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

at

...

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

at

...

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)

at

...

org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

at

...

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

at

...

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)

at

...

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at

...

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)

at

...

org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]

Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT

...

DISTINCT, ORDER BY表达式

Position: 62

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)

at

...

org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

at

...

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [spring-jdbc.jar:3.1.1.RELEASE]

... 113 more

...

2014-11-18 18:00:56,627 ERROR [org.ovirt.engine.core.bll.SearchQuery] (ajp--127.0.0.1-8702-1) Query SearchQuery failed. Exception message is StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62 : org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62: org.springframework.jdbc.BadSqlGrammarException:

...

StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms ) ORDER BY fn_get_comparable_ip_list(vm_ip) ASC,vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT DISTINCT, ORDER BY表达式

Position: 62

at

...

org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.ovirt.engine.core.dao.VmDAODbFacadeImpl.getAllUsingQuery(VmDAODbFacadeImpl.java:175) [dal.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.searchVmsFromDb(SearchQuery.java:156) [bll.jar:]

at

...

org.ovirt.engine.core.bll.SearchQuery.executeQueryCommand(SearchQuery.java:65) [bll.jar:]

at

...

org.ovirt.engine.core.bll.QueriesCommandBase.executeCommand(QueriesCommandBase.java:73) [bll.jar:]

at

...

org.ovirt.engine.core.dal.VdcCommandBase.execute(VdcCommandBase.java:31) [dal.jar:]

at org.ovirt.engine.core.bll.Backend.runQueryImpl(Backend.java:492)

...

[bll.jar:]

at org.ovirt.engine.core.bll.Backend.runQuery(Backend.java:466) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:114) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:125) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.ovirt.engine.core.bll.interceptors.ThreadLocalSessionCleanerInterceptor.injectWebContextToThreadLocal(ThreadLocalSessionCleanerInterceptor.java:13) [bll.jar:]

at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at

...

org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptorFactory$ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptorFactory.java:123) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82) [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:53) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]

at

...

org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]

at

...

org.ovirt.engine.core.common.interfaces.BackendLocal$$$view6.runQuery(Unknown Source) [common.jar:]

at

...

org.ovirt.engine.ui.frontend.server.gwt.GenericApiGWTServiceImpl.runQuery(GenericApiGWTServiceImpl.java:56)

at sun.reflect.GeneratedMethodAccessor295.invoke(Unknown Source)

...

[:1.7.0_71]

at

...

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]

at com.google.gwt.rpc.server.RPC.invokeAndStreamResponse(RPC.java:196)

at com.google.gwt.rpc.server.RpcServlet.processCall(RpcServlet.java:172)

at com.google.gwt.rpc.server.RpcServlet.processPost(RpcServlet.java:233)

at

...

com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

...

[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62) [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.HeaderFilter.doFilter(HeaderFilter.java:94) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.ui.frontend.server.gwt.GwtCachingFilter.doFilter(GwtCachingFilter.java:132)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64) [utils.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionMgmtFilter.doFilter(SessionMgmtFilter.java:31) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.LoginFilter.doFilter(LoginFilter.java:74) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.NegotiationFilter.doFilter(NegotiationFilter.java:113) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:75) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.ovirt.engine.core.aaa.filters.SessionValidationFilter.doFilter(SessionValidationFilter.java:63) [aaa.jar:]

at

...

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)

at

...

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

at

...

org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

at

...

org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

at

...

org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489)

at

...

org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

at

...

org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

at

...

org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.jboss.web.rewrite.RewriteValve.invoke(RewriteValve.java:466)

at

...

org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at

...

org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:505)

at

...

org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:445)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_71]

Caused by: org.postgresql.util.PSQLException: 错误: 在查询列表中必须出现SELECT

...

DISTINCT, ORDER BY表达式

Position: 62

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)

at

...

org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:340)

at

...

org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441) [spring-jdbc.jar:3.1.1.RELEASE]

at

...

org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) [spring-jdbc.jar:3.1.1.RELEASE]

... 113 more

0.2. ovirt-engine-dwh.log

2014-11-18

...

...

12:36:00|NmaVBj|ZdLGGX|gX18vw|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tRunJob*

...

_4Process(SampleRunJobs.java:953)

at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tJDBCConnection*

...

_2Process(SampleRunJobs.java:762)

at ovirt_engine_dwh.samplerunjobs_3_5.*SampleRunJobs.tJDBCConnection*

...

_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

12:36:00|gX18vw|ZdLGGX|iY0VVa|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tRunJob*_1Process(SampleTimeKeepingJob.java:5941)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tJDBCInput* _2Process(SampleTimeKeepingJob.java:5707)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tJDBCConnection* _1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tRowGenerator* _2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.*SampleTimeKeepingJob*

...

$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

12:36:00|iY0VVa|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCOutput_3

org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

12:37:00|xrgPmR|ZdLGGX|pSvwg0|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误: 由于管理员命令中断联接|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

12:37:00|pSvwg0|ZdLGGX|K3fwaz|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

12:37:05|K3fwaz|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCInput_6

java.lang.NullPointerException

at ovirt_engine_dwh.aggregationtohourly_3_5.

...

*AggregationToHourly.tJDBCInput* _6Process(AggregationToHourly.java:19335)

at ovirt_engine_dwh.aggregationtohourly_3_5.

...

*AggregationToHourly.tJDBCConnection* _1Process(AggregationToHourly.java:18891)

at ovirt_engine_dwh.aggregationtohourly_3_5.*AggregationToHourly.tPrejob*

...

_1Process(AggregationToHourly.java:18770)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)

at ovirt_engine_dwh.aggregationtohourly_3_5.*AggregationToHourly.runJob*

...

(AggregationToHourly.java:25464)

at ovirt_engine_dwh.hourlytimekeepingjob_3_5.

...

*HourlyTimeKeepingJob.tRunJob*_1Process(HourlyTimeKeepingJob.java:2541)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_6|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_1

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)

Exception in component tJDBCInput_3

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)

Exception in component tJDBCInput_2

Exception in component tJDBCInput_9

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)

Exception in component tJDBCInput_13

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|1

java.lang.NullPointerException

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_1|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)

Exception in component tJDBCInput_10

java.lang.NullPointerException

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)

Exception in component tJDBCInput_5

Exception in component tJDBCInput_11

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_9|java.lang.NullPointerException:null|1

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)

Exception in component tJDBCInput_4

java.lang.NullPointerException

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)

java.lang.NullPointerException2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_10|java.lang.NullPointerException:null|1

...

at ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_11|java.lang.NullPointerException:null|1

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|1

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tJDBCOutput_6

org.postgresql.util.PSQLException: An I/O error occured while sending to

...

the backend.

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)

at ovirt_engine_dwh.aggregationtohourly_3_5.

...

*AggregationToHourly.tRowGenerator* _1Process(AggregationToHourly.java:19905)

at ovirt_engine_dwh.aggregationtohourly_3_5.

...

*AggregationToHourly.tPostjob*_1Process(AggregationToHourly.java:19496)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)

at ovirt_engine_dwh.hourlytimekeepingjob_3_5.

...

*HourlyTimeKeepingJob.tRunJob*_1Process(HourlyTimeKeepingJob.java:2541)

at ovirt_engine_dwh.hourlytimekeepingjob_3_5.

...

*HourlyTimeKeepingJob.tJDBCInput* _1Process(HourlyTimeKeepingJob.java:2369)

at ovirt_engine_dwh.hourlytimekeepingjob_3_5.

...

*HourlyTimeKeepingJob.tJDBCConnection* _1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

Caused by: java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

at java.net.SocketOutputStream.write(SocketOutputStream.java:159)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)

at org.postgresql.core.PGStream.flush(PGStream.java:521)

at

...

org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)

... 12 more

2014-11-18

...

13:00:00|iMEJow|ZdLGGX|Qb7Vkj|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error occured while sending to the backend.|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

An I/O error occured while sending to the backend.An I/O error occured

...

while sending to the backend.2014-11-18 13:00:00|Qb7Vkj|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCInput_4

java.lang.NullPointerException

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tJDBCInput* _4Process(SampleTimeKeepingJob.java:2121)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.

...

*SampleTimeKeepingJob.tJDBCConnection* _3Process(SampleTimeKeepingJob.java:1537)

at ovirt_engine_dwh.sampletimekeepingjob_3_5.*SampleTimeKeepingJob*

...

$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

13:30:00|xb5OGC|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_4

java.lang.NullPointerException

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1371)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

13:31:00|tetatR|ZdLGGX|Aaa74D|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

13:31:00|Aaa74D|ZdLGGX|jYGdcg|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

13:31:00|jYGdcg|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCOutput_3

org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tRowGenerator_1Process(OsEnumUpdate.java:1844)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

13:32:00|AJFmu7|ZdLGGX|n34YZo|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误: 由于管理员命令中断联接|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

13:32:00|n34YZo|ZdLGGX|XZy3yU|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

13:32:05|XZy3yU|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCInput_4

java.lang.NullPointerException

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2121)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

16:29:01|R7YvSQ|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_4

java.lang.NullPointerException

at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tJDBCInput*

...

_4Process(OsEnumUpdate.java:1371)

at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tJDBCConnection*

...

_1Process(OsEnumUpdate.java:862)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)

at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.runJob*

...

(OsEnumUpdate.java:4144)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

16:30:01|AvgrjL|ZdLGGX|4eSwoN|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

16:30:01|4eSwoN|ZdLGGX|VtZtjF|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

16:30:01|VtZtjF|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCOutput_3

org.postgresql.util.PSQLException: 致命错误: 由于管理员命令中断联接

at

...

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)

at

...

org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)

at ovirt_engine_dwh.osenumupdate_3_5.*OsEnumUpdate.tRowGenerator*

...

_1Process(OsEnumUpdate.java:1844)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCInput_4Process(OsEnumUpdate.java:1383)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_1Process(OsEnumUpdate.java:862)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.tJDBCConnection_2Process(OsEnumUpdate.java:729)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJobInTOS(OsEnumUpdate.java:4375)

at

...

ovirt_engine_dwh.osenumupdate_3_5.OsEnumUpdate.runJob(OsEnumUpdate.java:4144)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:928)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

16:31:01|Jc5by2|ZdLGGX|r5BRqk|OVIRT_ENGINE_DWH|OsEnumUpdate|Default|6|Java Exception|tJDBCOutput_3|org.postgresql.util.PSQLException:致命错误: 由于管理员命令中断联接|1

Exception in component tRunJob_4

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tRunJob_4Process(SampleRunJobs.java:953)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_2Process(SampleRunJobs.java:762)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs.tJDBCConnection_1Process(SampleRunJobs.java:641)

at

...

ovirt_engine_dwh.samplerunjobs_3_5.SampleRunJobs$2.run(SampleRunJobs.java:2560)

2014-11-18

...

16:31:01|r5BRqk|ZdLGGX|uyMqI5|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java Exception|tRunJob_4|java.lang.RuntimeException:Child job running failed|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:5941)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5707)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:4340)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4219)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4092)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3505)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2877)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2191)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1537)

at

...

ovirt_engine_dwh.sampletimekeepingjob_3_5.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:9546)

2014-11-18

...

16:31:06|uyMqI5|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCInput_6

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_6Process(AggregationToHourly.java:19335)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCConnection_1Process(AggregationToHourly.java:18891)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPrejob_1Process(AggregationToHourly.java:18770)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:25642)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_6|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_1

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_1Process(AggregationToHourly.java:2377)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$2.run(AggregationToHourly.java:25665)

Exception in component tJDBCInput_11

Exception in component tJDBCInput_9

Exception in component tJDBCInput_10

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_11Process(AggregationToHourly.java:15308)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$7.run(AggregationToHourly.java:25895)

Exception in component tJDBCInput_13

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_1|java.lang.NullPointerException:null|1

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_10Process(AggregationToHourly.java:24091)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$10.run(AggregationToHourly.java:26033)

java.lang.NullPointerException

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_11|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_9Process(AggregationToHourly.java:20681)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$9.run(AggregationToHourly.java:25987)

Exception in component tJDBCInput_4

Exception in component tJDBCInput_3

java.lang.NullPointerException2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_10|java.lang.NullPointerException:null|1

...

at ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_13Process(AggregationToHourly.java:18186)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$8.run(AggregationToHourly.java:25941)

Exception in component tJDBCInput_52014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_9|java.lang.NullPointerException:null|1

...

Exception in component tJDBCInput_2

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_3Process(AggregationToHourly.java:8231)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$4.run(AggregationToHourly.java:25757)

java.lang.NullPointerException

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_4Process(AggregationToHourly.java:11256)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$5.run(AggregationToHourly.java:25803)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_2Process(AggregationToHourly.java:5968)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$3.run(AggregationToHourly.java:25711)

java.lang.NullPointerException

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tJDBCInput_5Process(AggregationToHourly.java:13356)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly$6.run(AggregationToHourly.java:25849)

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|1

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|1

Exception in component tJDBCOutput_6

org.postgresql.util.PSQLException: An I/O error occured while sending to

...

the backend.

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

at

...

org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tRowGenerator_1Process(AggregationToHourly.java:19905)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.tPostjob_1Process(AggregationToHourly.java:19496)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJobInTOS(AggregationToHourly.java:26081)

at

...

ovirt_engine_dwh.aggregationtohourly_3_5.AggregationToHourly.runJob(AggregationToHourly.java:25464)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2541)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

Caused by: java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

at java.net.SocketOutputStream.write(SocketOutputStream.java:159)

at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)

at org.postgresql.core.PGStream.flush(PGStream.java:521)

at

...

org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1134)

at

...

org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:254)

... 12 more

2014-11-18

...

17:00:00|OqOGJr|ZdLGGX|P66Bbl|OVIRT_ENGINE_DWH|AggregationToHourly|Default|6|Java Exception|tJDBCOutput_6|org.postgresql.util.PSQLException:An I/O error occured while sending to the backend.|1

Exception in component tRunJob_1

java.lang.RuntimeException: Child job running failed

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tRunJob_1Process(HourlyTimeKeepingJob.java:2566)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCInput_1Process(HourlyTimeKeepingJob.java:2369)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_1Process(HourlyTimeKeepingJob.java:1822)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob.tJDBCConnection_2Process(HourlyTimeKeepingJob.java:1694)

at

...

ovirt_engine_dwh.hourlytimekeepingjob_3_5.HourlyTimeKeepingJob$2.run(HourlyTimeKeepingJob.java:6371)

An I/O error occured while sending to the backend.An I/O error occured

...

while sending to the backend.2014-11-18 17:00:00|P66Bbl|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|6|Java Exception|tRunJob_1|java.lang.RuntimeException:Child job running failed|1

Exception in component tJDBCInput_5

java.lang.NullPointerException

at ovirt_engine_dwh.dailytimekeepingjob_3_5.

...

*DailyTimeKeepingJob.tJDBCInput*_5Process(DailyTimeKeepingJob.java:3066)

at

...

ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCInput_1Process(DailyTimeKeepingJob.java:2535)

at ovirt_engine_dwh.dailytimekeepingjob_3_5.

...

*DailyTimeKeepingJob.tJDBCConnection* _1Process(DailyTimeKeepingJob.java:1914)

at

...

ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob.tJDBCConnection_2Process(DailyTimeKeepingJob.java:1793)

at

...

ovirt_engine_dwh.dailytimekeepingjob_3_5.DailyTimeKeepingJob$2.run(DailyTimeKeepingJob.java:6687)

2014-11-19

...

00:00:00|qXv21T|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DailyTimeKeepingJob|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_1

java.lang.NullPointerException

at ovirt_engine_dwh.historydelete_3_5.*HistoryDelete.tJDBCInput*

...

_1Process(HistoryDelete.java:1592)

at ovirt_engine_dwh.historydelete_3_5.*HistoryDelete*

...

$2.run(HistoryDelete.java:13315)

Exception in component tJDBCInput_20

Exception in component tJDBCInput_21

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_21Process(HistoryDelete.java:9981)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$22.run(HistoryDelete.java:14235)

Exception in component tJDBCInput_19

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_19Process(HistoryDelete.java:9142)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$20.run(HistoryDelete.java:14143)

Exception in component tJDBCInput_26

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_26Process(HistoryDelete.java:12295)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$27.run(HistoryDelete.java:14465)

Exception in component tJDBCInput_10

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_10Process(HistoryDelete.java:5367)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$11.run(HistoryDelete.java:13729)

Exception in component tJDBCInput_9

Exception in component tJDBCInput_12

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_12Process(HistoryDelete.java:6207)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$13.run(HistoryDelete.java:13821)

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_1|java.lang.NullPointerException:null|1

Exception in component tJDBCInput_14

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_26|java.lang.NullPointerException:null|1

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_14Process(HistoryDelete.java:7045)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$15.run(HistoryDelete.java:13913)

Exception in component tJDBCInput_23

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_23Process(HistoryDelete.java:11035)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$24.run(HistoryDelete.java:14327)

Exception in component tJDBCInput_13

Exception in component tJDBCInput_7

Exception in component tJDBCInput_11

Exception in component tJDBCInput_8

Exception in component tJDBCInput_4

Exception in component tJDBCInput_5

Exception in component tJDBCInput_6

Exception in component tJDBCInput_2

Exception in component tJDBCInput_3

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_2Process(HistoryDelete.java:2011)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$3.run(HistoryDelete.java:13361)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_6Process(HistoryDelete.java:3689)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$7.run(HistoryDelete.java:13545)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_5Process(HistoryDelete.java:3270)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$6.run(HistoryDelete.java:13499)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_4Process(HistoryDelete.java:2850)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$5.run(HistoryDelete.java:13453)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_8Process(HistoryDelete.java:4528)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$9.run(HistoryDelete.java:13637)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_11Process(HistoryDelete.java:5787)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$12.run(HistoryDelete.java:13775)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_7Process(HistoryDelete.java:4108)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$8.run(HistoryDelete.java:13591)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_13Process(HistoryDelete.java:6626)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$14.run(HistoryDelete.java:13867)

Exception in component tJDBCInput_22

Exception in component tJDBCInput_24

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_9Process(HistoryDelete.java:4947)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$10.run(HistoryDelete.java:13683)

Exception in component tJDBCInput_25

Exception in component tJDBCInput_16

Exception in component tJDBCInput_15

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_15Process(HistoryDelete.java:7464)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$16.run(HistoryDelete.java:13959)

Exception in component tJDBCInput_17

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_20Process(HistoryDelete.java:9562)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$21.run(HistoryDelete.java:14189)

Exception in component tJDBCInput_18

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_17Process(HistoryDelete.java:8303)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$18.run(HistoryDelete.java:14051)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_16Process(HistoryDelete.java:7884)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$17.run(HistoryDelete.java:14005)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_25Process(HistoryDelete.java:11875)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$26.run(HistoryDelete.java:14419)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_24Process(HistoryDelete.java:11455)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$25.run(HistoryDelete.java:14373)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_22Process(HistoryDelete.java:10615)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$23.run(HistoryDelete.java:14281)

java.lang.NullPointerException

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_18Process(HistoryDelete.java:8723)

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete$19.run(HistoryDelete.java:14097)

java.lang.NullPointerException

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_19|java.lang.NullPointerException:null|1

at

...

ovirt_engine_dwh.historydelete_3_5.HistoryDelete.tJDBCInput_3Process(HistoryDelete.java:2431)2014-11-19 03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_18|java.lang.NullPointerException:null|1

...

at ovirt_engine_dwh.historydelete_3_5.HistoryDelete$4.run(HistoryDelete.java:13407)

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_22|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_24|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_25|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_16|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_17|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_20|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_15|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_9|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_13|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_3|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_7|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_11|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_8|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_4|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_5|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_6|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_2|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_23|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_14|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_12|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_21|java.lang.NullPointerException:null|1

2014-11-19

...

03:00:00|fp7Lfv|ZdLGGX|5DCU4k|OVIRT_ENGINE_DWH|HistoryDelete|Default|6|Java Exception|tJDBCInput_10|java.lang.NullPointerException:null|1

Exception in component tRunJob_2

java.lang.RuntimeException: Child job running failed

at ovirt_engine_dwh.deletetimekeepingjob_3_5.

...

*DeleteTimeKeepingJob.tRunJob*_2Process(DeleteTimeKeepingJob.java:2794)

at ovirt_engine_dwh.deletetimekeepingjob_3_5.

...

*DeleteTimeKeepingJob.tJDBCInput* _1Process(DeleteTimeKeepingJob.java:2589)

at ovirt_engine_dwh.deletetimekeepingjob_3_5.

...

*DeleteTimeKeepingJob.tJDBCConnection* _1Process(DeleteTimeKeepingJob.java:2001)

at

...

ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob.tJDBCConnection_2Process(DeleteTimeKeepingJob.java:1880)

at

...

ovirt_engine_dwh.deletetimekeepingjob_3_5.DeleteTimeKeepingJob$2.run(DeleteTimeKeepingJob.java:9473)

2014-11-19

...

03:00:00|5DCU4k|ZdLGGX|y7Fni0|OVIRT_ENGINE_DWH|DeleteTimeKeepingJob|Default|6|Java Exception|tRunJob_2|java.lang.RuntimeException:Child job running failed|1

0.3. ovirt-engine-reports.log There is no useful info in jasperserver.log & reports.log

1. The version of my environment [root@zhangyingyun ovirt-engine-reports]# rpm -qa|grep ovirt ovirt-release35-snapshot-002-0.0.master.noarch

ovirt-engine-setup-plugin-ovirt-engine-common-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch ovirt-engine-backend-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch ovirt-engine-cli-3.5.0.6-0.1.20141107.gitcf7f1a1.el6.noarch *ovirt-engine-setup-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch*

*ovirt-engine-reports-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch*

*ovirt-engine-dwh-setup-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch* ovirt-optimizer-ui-0.6-1.el6.noarch *ovirt-engine-dwh-3.5.1-0.0.master.20141107092205.git2cf5ee9.el6.noarch* ovirt-engine-lib-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-engine-setup-plugin-ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-engine-extensions-api-impl-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-engine-webadmin-portal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch *ovirt-engine-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch* ovirt-iso-uploader-3.5.1-0.0.master.20140926055817.git472e66e.el6.noarch

ovirt-engine-setup-plugin-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

*ovirt-engine-reports-setup-3.5.1-0.2.master.20141112075822.20141112075822.gitac69a8b.el6.noarch* ovirt-engine-restapi-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-engine-dbscripts-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-host-deploy-java-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch ovirt-engine-jboss-as-7.1.1-1.el6.x86_64 ovirt-guest-agent-1.0.10.2-1.el6.noarch ovirt-image-uploader-3.5.1-0.0.master.20141027101643.git1b30d59.el6.noarch ovirt-engine-sdk-python-3.5.0.9-0.1.20141111.gitd6eb612.el6.noarch

ovirt-engine-websocket-proxy-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch ovirt-engine-tools-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch ovirt-host-deploy-1.3.1-0.0.master.20141117013215.git57b2b0b.el6.noarch ovirt-release35-002-0.0.master.noarch

ovirt-engine-setup-base-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch

ovirt-engine-userportal-3.5.1-0.0.master.20141112062025.git2c24911.el6.noarch ovirt-guest-tools-3.5.0-0.5.master.noarch

2. the timezone for my machine [root@zhangyingyun ovirt-engine-reports]# date -R Wed, 19 Nov 2014 08:19:34 +0800

and my dbtime is normal too: postgres=# select now(); now ------------------------------- 2014-11-19 08:20:44.849422+08 (1 row)

3. But I will show u something that can prove my opinion.

The following is DWH development environment:

​and I checked db according to its tips, contents are as follows:

ovirt_engine_history=# select distinct var_name, var_datetime from

...

...

history_configuration where var_name = 'lastHourAggr';

var_name | var_datetime

--------------+------------------------

*lastHourAggr | 2014-11-19 21:00:00+08*

(1 row)

the next is:

the sql in this pic is:

"SELECT history_id,

...

history_datetime,

datacenter_id,

datacenter_status,

minutes_in_status,

datacenter_configuration_version

FROM datacenter_samples_history

WHERE *history_datetime >= '"+context.lastHourAggr+"'*

AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr,

...

1,"HH")+"'

ORDER BY history_datetime,

datacenter_id,

datacenter_status"

the lastest info as follows: ovirt_engine_history=# select history_datetime from datacenter_samples_history; history_datetime ---------------------------- 2014-11-19 08:26:01.964+08 2014-11-19 08:27:01.988+08 2014-11-19 08:28:01.953+08 2014-11-19 08:29:01.962+08 2014-11-19 08:30:01.95+08 2014-11-19 08:31:01.949+08 2014-11-19 08:32:01.965+08 2014-11-19 08:33:01.98+08 2014-11-19 08:34:01.955+08 2014-11-19 08:35:01.969+08 2014-11-19 08:36:01.967+08 2014-11-19 08:37:01.958+08 2014-11-19 08:38:01.974+08 2014-11-19 08:39:01.974+08 2014-11-19 08:40:01.964+08 2014-11-19 08:41:01.961+08 2014-11-19 08:42:01.977+08 2014-11-19 08:43:01.96+08 (1994 rows)

​so the result is clear. *history_datetime < lastHourAggr *, so the data cannot be written to the db be from datacenter_samples_history to datacenter_hourly_history. Looking forward your reply . Thank you very much.

2014-11-17 14:31 GMT+08:00 Shirly Radco <sradco@redhat.com>:

...

Hi,

UTC time is the coordinated Universal Time, and we recommend syncing the machines according to it, so the data will not be affected when changing the clock from summer time to winter time and back.

All reports can be shown in the local time you choose in the reports portal.

But still, this should not cause issues with hourly reports not showing.

Please attach all logs. Should be located at:

/var/log/ovirt-engine /var/log/ovirt-engine-dwh /var/log/ovirt-engine-reports

Also please let us know what ovirt 3.5 version you are using: rpm -qa |grep ovirt

For ovirt-engine-dwh, ovirt-engine-reports and ovirt-engine.

Last, please let us now what timezone is set currently for your machine.

Best regards, --- Shirly Radco BI Software Engineer Red Hat Israel Ltd.

...

From: "张亚琪" <zhangyingyun001@gmail.com> To: Devel@ovirt.org Sent: Monday, November 17, 2014 3:51:07 AM Subject: [ovirt-devel] Fwd: DWH cannot gain hourly history data from db because of the bloody time problem.

---------- Forwarded message ---------- From: 张亚琪 < zhangyingyun001@gmail.com > Date: 2014-11-16 20:04 GMT+08:00 Subject: Re: [ovirt-devel] DWH cannot gain hourly history data from db because of the bloody time problem. To: Yaniv Dary < ydary@redhat.com >

hi, Yaniv. Thank you for your reply. However, I think that there is no sync problem in my setup, because the engine, dwh and reports are in the same machine. As a new, I am not familiar with UTM time. And please see the attachment. Looking forward your reply. Thanks a lot.

2014-11-16 7:31 GMT+08:00 Yaniv Dary < ydary@redhat.com > :

Are all your servers sync to the same ntp and in UTM time? Can you attach logs?

Yaniv

From: "张亚琪" < zhangyingyun001@gmail.com > To: Devel@ovirt.org Sent: Friday, November 14, 2014 11:22:38 AM Subject: [ovirt-devel] DWH cannot gain hourly history data from db because of the bloody time problem.

hi everybody, Recently, I have tested oVirt Reports. And I encountered a problem about some reports that cannot show data. And then I setup the DWH development environment. I found maybe this reason for missing data is the AggregationToHourly3.5. When data from datacenter_samples_history were inserted to datacenter_hourly_history, u will find nothing happened. Because the select sql before inserting data reads：

"SELECT history_id,

history_datetime,

datacenter_id,

datacenter_status,

minutes_in_status,

datacenter_configuration_version

FROM datacenter_samples_history

WHERE history_datetime >= '"+context.lastHourAggr+ "'

AND history_datetime < '"+TalendDate.addDate(context.lastHourAggr, 1,"HH")+"'

ORDER BY history_datetime,

datacenter_id,

datacenter_status"

And then I queried the table of datacenter_samples_history & history_configuration (has the field of lastHourAggr) in the db of ovirt_engine_history. The results are as follows:

ovirt_engine_history=# select * from history_configuration;

var_name | var_value | var_datetime

-------------------+-----------+------------------------

MinimalETLVersion | 3.5.0 |

default_language | en_US |

firstSync | false | 2014-10-13 19:42:00+08

lastDayAggr | | 2014-11-14 00:00:00+08

lastHourAggr | | 2014- 11-15 06:00:00+08

HourlyAggFailed | false |

(6 rows)

ovirt_engine_history=# select history_datetime from datacenter_samples_history;

history_datetime

----------------------------

2014- 11-13 03:07:00.23+08

2014-11-13 03:08:00.238+08

2014-11-13 03:09:00.229+08

2014-11-13 03:10:00.221+08

2014-11-13 03:11:00.229+08

2014-11-13 03:12:00.221+08

2014-11-13 03:13:00.237+08

2014-11-13 03:14:00.22+08

2014-11-13 03:15:00.221+08

2014-11-13 03:16:00.238+08

2014-11-13 03:17:00.238+08

Obviously， history_datetime < lastHourAggr , the data will never be inserted to the datacenter_hourly_history. And the place where I bold is the root cause of the error. Then , I try to update the lastHourAggr in the

----- Original Message ----- table of

...

history_configuration. Reports works successfully. However, the lastHourAggr will change to 2014-11-15 afterwards. But u know Today is 2014-11-14 ! I have no idea about why the value of lastHourAggr is 2014-11-15. Would u help me solve this problem. Thanks a lot !

_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel

_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel

_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel