<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi,<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">we support only postgresql packages included in centos:<br><br>postgresql-9.2.15-1.el7_2.x86_64<br>postgresql-libs-9.2.15-1.el7_2.x86_64<br>postgresql-jdbc-9.2.1002-5.el7.noarch<br>postgresql-server-9.2.15-1.el7_2.x86_64<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">This is the postgresql version which we test.<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">In your special case downgrading postgresql-jdbc package to 9.2 may solve the issue, but please be aware it's not tested and it may cause other issues. The only correct way is to use PostgreSQL 9.2.<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Martin Perina<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 3, 2016 at 12:56 PM, Fabrice Bacchella <span dir="ltr"><<a href="mailto:fabrice.bacchella@icloud.com" target="_blank">fabrice.bacchella@icloud.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Just a little investigation show :<div><br></div><div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span># lsof -p <enginepid> | grep postgresql-jdbc.jar</span></div></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span>java 2138 ovirt mem REG 8,2 486139 18729421 /usr/share/java/postgresql-jdbc.jar</span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span><br></span></div><div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span><div style="margin:0px;line-height:normal"><span>rpm -qf /usr/share/java/postgresql-jdbc.jar</span></div><div style="margin:0px;line-height:normal"><span>postgresql-jdbc-9.4.1208-1.rhel7.noarch</span></div><div><span><br></span></div><div><span>rpm -qi postgresql-jdbc-9.4.1208-1.rhel7.noarch</span></div><div><span>...</span></div><div><span>URL : <a href="https://jdbc.postgresql.org/" target="_blank">https://jdbc.postgresql.org/</a></span></div><div><span><br></span></div><div><span>And indeed I needed to install </span>pgdg-94-centos.repo, my note says the package was needed by ovirt, I don't remember why. And indeed :</div><div><div style="margin:0px;line-height:normal"><span>yum erase postgresql94-server</span></div></div><div style="margin:0px;line-height:normal"><span>...</span></div><div style="margin:0px;line-height:normal"><span><div style="margin:0px;line-height:normal"><span>Removing:</span></div><div style="margin:0px;line-height:normal"><span> postgresql94-server x86_64 9.4.8-1PGDG.rhel7 @pgdg94 17 M</span></div><div style="margin:0px;line-height:normal"><span>Removing for dependencies:</span></div><div style="margin:0px;line-height:normal"><span> ovirt-engine noarch 4.0.1.1-1.el7.centos @ovirt-4.0 2.6 M</span></div><div style="margin:0px;line-height:normal"><span> ovirt-engine-backend noarch 4.0.1.1-1.el7.centos @ovirt-4.0 13 M</span></div><div><span><br></span></div><div><span>So I tried:</span></div><div><span><br></span></div><div><span>yum downgrade postgresql-jdbc</span></div><div><span>...</span></div><div><span>---> Package postgresql-jdbc.noarch 0:9.2.1002-5.el7 will be a downgrade</span></div><div><span>...</span></div><div><span><br></span></div><div><span>And now it (almost) works. I have other not linked problems that needs more investigations.</span></div></span></div><div><br></div></span></div><div><br><div><blockquote type="cite"><div>Le 3 août 2016 à 12:39, Martin Perina <<a href="mailto:mperina@redhat.com" target="_blank">mperina@redhat.com</a>> a écrit :</div><br><div><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi,<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">what is the version of postgresql-jdbc package are you using? I saw this error only with latest postgresql-jdbc drivers 9.4-1209, but those are not packaged in RPMs AFAIK.<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Thanks<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Martin Perina<br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 3, 2016 at 12:31 PM, Fabrice Bacchella <span dir="ltr"><<a href="mailto:fabrice.bacchella@icloud.com" target="_blank">fabrice.bacchella@icloud.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm running on Centos 7, just upgraded to ovirt 4.01 using the procedure given in the release notes.<br>
<br>
But now I'm getting that in /var/log/ovirt-engine/engine.log:<br>
<br>
2016-08-03 12:04:39,751 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 54) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke private void org.ovirt.engine.core.vds<br>
broker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e<br>
at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
...<br>
Caused by: java.lang.reflect.InvocationTargetException<br>
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_92]<br>
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_92]<br>
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92]<br>
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92]<br>
at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:98) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final]<br>
... 82 more<br>
Caused by: java.lang.NullPointerException<br>
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:182)<br>
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:178)<br>
at org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1259)<br>
at org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1040)<br>
at org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:353) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:112) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory$1.processMetaData(CallMetaDataProviderFactory.java:133) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:299) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:73) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:286) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:303) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.compileInternal(PostgresDbEngineDialect.java:108) [dal.jar:]<br>
at org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:288) [spring-jdbc.jar:4.2.4.RELEASE]<br>
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.getCall(SimpleJdbcCallsHandler.java:169) [dal.jar:]<br>
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:146) [dal.jar:]<br>
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:109) [dal.jar:]<br>
at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeRead(SimpleJdbcCallsHandler.java:101) [dal.jar:]<br>
at org.ovirt.engine.core.dao.VdsDynamicDaoImpl.get(VdsDynamicDaoImpl.java:129) [dal.jar:]<br>
at org.ovirt.engine.core.dao.VdsDynamicDaoImpl.updateIfNeeded(VdsDynamicDaoImpl.java:296) [dal.jar:]<br>
at org.ovirt.engine.core.dao.VdsDynamicDaoImpl.updateIfNeeded(VdsDynamicDaoImpl.java:34) [dal.jar:]<br>
at org.ovirt.engine.core.vdsbroker.VdsManager.updateDynamicData(VdsManager.java:421) [vdsbroker.jar:]<br>
at org.ovirt.engine.core.vdsbroker.ResourceManager.addVds(ResourceManager.java:237) [vdsbroker.jar:]<br>
at org.ovirt.engine.core.vdsbroker.ResourceManager.init(ResourceManager.java:134) [vdsbroker.jar:]<br>
... 87 more<br>
<br>
And in server.log:<br>
2016-08-03 12:04:39,758 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 54) MSC000001: 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: java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance<br>
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:57) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_92]<br>
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_92]<br>
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]<br>
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]<br>
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]<br>
at org.jboss.threads.JBossThread.run(JBossThread.java:320)<br>
Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance<br>
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
at org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
at org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:124)<br>
at org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:138)<br>
at org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
... 6 more<br>
Caused by: javax.ejb.EJBException: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke private void org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e<br>
at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInNoTx(CMTTxInterceptor.java:213)<br>
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:265)<br>
at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374)<br>
at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:68)<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.4.1.Final.jar:1.4.1.Final]<br>
at org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161) [wildfly-ee-10.0.0.Final.jar:10.0.0.Final]<br>
... 11 more<br>
Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke private void org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e<br>
...<br>
2016-08-03 12:04:40,311 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" => "engine.ear")]) - failure description: {"WFLYCTL0080: 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: java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance<br>
Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to construct component instance<br>
Caused by: javax.ejb.EJBException: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke private void org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e<br>
Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke private void org.ovirt.engine.core.vdsbroker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e<br>
Caused by: java.lang.reflect.InvocationTargetException<br>
Caused by: java.lang.NullPointerException"}}<br>
...<br>
2016-08-03 12:04:40,916 ERROR [<a href="http://org.jboss.as/" rel="noreferrer" target="_blank">org.jboss.as</a>] (Controller Boot Thread) WFLYSRV0026: WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) started (with errors) in 29114ms - Started 1320 of 1633 services (5 services failed or missing dependencies, 438 services are lazy, passive or on-demand)<br>
2016-08-03 12:04:41,011 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 14) WFLYUT0022: Unregistered web context: /ovirt-engine/services<br>
2016-08-03 12:04:41,012 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 15) WFLYUT0022: Unregistered web context: /ovirt-engine/webadmin<br>
2016-08-03 12:04:41,015 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 4) WFLYUT0022: Unregistered web context: /ovirt-engine/api<br>
2016-08-03 12:04:41,022 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 13) WFLYUT0022: Unregistered web context: /ovirt-engine/docs<br>
2016-08-03 12:04:41,022 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 11) WFLYUT0022: Unregistered web context: /ovirt-engine/sso<br>
2016-08-03 12:04:41,022 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 18) WFLYUT0022: Unregistered web context: /ovirt-engine/userportal<br>
2016-08-03 12:04:41,019 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 20) WFLYUT0022: Unregistered web context: /ovirt-engine<br>
2016-08-03 12:04:41,013 INFO [org.wildfly.extension.undertow] (ServerService Thread Pool -- 7) WFLYUT0022: Unregistered web context: /<br>
<br>
I see no other error message. Any hint about that ?<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div><br></div>
</div></blockquote></div><br></div></div></blockquote></div><br></div>