最后发现这个错误的根源是, 没有使用public schema . 所以建议不要自建和用户同名的schema.
oVirt的管理web页无法打开, 使用代理到
ajp://127.0.0.1:8702.
/etc/httpd/conf.d/z-ovirt-engine-proxy.conf
<LocationMatch ^/(ovirt-engine($|/)|api($|/)|RHEVManagerWeb/|OvirtEngineWeb/|ca.crt$|engine.ssh.key.txt$|rhevm.ssh.key.txt$)>
ProxyPassMatch ajp://127.0.0.1:8702 timeout=3000 retry=5
<IfModule deflate_module>
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.
