oVirt JBAS server start failed, ajp proxy cann't server correct. ovirt-engine URL cann't open-白红宇

最后发现这个错误的根源是, 没有使用public schema . 所以建议不要自建和用户同名的schema.

oVirt的管理web页无法打开, 使用代理到

ajp://127.0.0.1:8702.

/etc/httpd/conf.d/z-ovirt-engine-proxy.conf

ProxyPassMatch ajp://127.0.0.1:8702 timeout=3000 retry=5

AddOutputFilterByType DEFLATE text/javascript text/css text/html text/xml text/json application/xml application/json application/x-yaml

</IfModule>

</LocationMatch>x

报错

/var/log/ovirt-engine/server.log

2014-08-01 15:17:30,687 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report

JBAS014777: Services which failed to start: service jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START: org.jboss.msc.service.StartException in service jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START: Failed to start service

2014-08-01 15:17:30,690 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS014654: Composite operation was rolled back

2014-08-01 15:17:30,691 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.subunit.\"engine.ear\".\"bll.jar\".component.Backend.START" => "org.jboss.msc.service.StartException in service jboss.deployment.subunit.\"engine.ear\".\"bll.jar\".component.Backend.START: Failed to start service"}}}}

2014-08-01 15:32:43,371 ERROR [org.apache.coyote.ajp.AjpMessage] (ajp--127.0.0.1-8702-8) Invalid message received with signature 29045

jboss所在的位置

/usr/share/jboss-as-7.1.1.Final

网上找到的比较坑爹的解决方案

Hi Vang and All.

I build this rpm's for testing oVirt in CentOS 6.2, and it's working in my

test environment.

Today, I checked engine installation on fresh (but updated) CentOs 6.2

without problem.

You can try to cleanup ovirt (engine-cleanup) remove all ovirt, vdsm and

jboss packages (yum remove ovirt* vdsm* jboss*) clean yum cache and install

ovirt-engine again.

03.03.2012 2:01 пользователь "Fong Vang" <sudoy...@gmail.com> написал:

_______________________________________________

Users mailing list

Users@ovirt.org

http://lists.ovirt.org/mailman/listinfo/users

后来发现是防火墙问题, 修改后错误变成了

root cause

javax.ejb.EJBException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from  gettagsbyparent_id()]; nested exception is org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist  Hint: No function matches the given name and argument types. You might need to add explicit type casts.  Position: 16	org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166)	org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)	org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:333)	org.jboss.as.ejb3.tx.SingletonLifecycleCMTTxInterceptor.processInvocation(SingletonLifecycleCMTTxInterceptor.java:56)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)	org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)	org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85)	org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116)	org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:48)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211)	org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363)	org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)	org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)	org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)	org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)	org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)	org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)	org.ovirt.engine.core.common.interfaces.BackendLocal$$$view9.runPublicQuery(Unknown Source)	org.ovirt.engine.core.WelcomeServlet.doGet(WelcomeServlet.java:82)	javax.servlet.http.HttpServlet.service(HttpServlet.java:734)	javax.servlet.http.HttpServlet.service(HttpServlet.java:847)	org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72)	org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64)

root cause

太坑了, 居然会有这种错误, 数据库里没有这个函数, 只有一个带传入参数的.

ovirt=# \df gettagsbyparent_id

List of functions

Schema | Name | Result data type | Argument data types | Type

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

ovirt | gettagsbyparent_id | SETOF tags | v_parent_id uuid | normal

(1 row)

最后发现这个错误的根源是, 没有使用public schema . 所以建议不要自建和用户同名的schema.