Re: [ovirt-users] Upgrade to 4.0.1 failed with NPE on org.postgresql.jdbc.TypeInfoCache.getSQLType
Hi, we support only postgresql packages included in centos: postgresql-9.2.15-1.el7_2.x86_64 postgresql-libs-9.2.15-1.el7_2.x86_64 postgresql-jdbc-9.2.1002-5.el7.noarch postgresql-server-9.2.15-1.el7_2.x86_64 This is the postgresql version which we test. 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. Martin Perina On Wed, Aug 3, 2016 at 12:56 PM, Fabrice Bacchella < fabrice.bacche...@icloud.com> wrote: > Just a little investigation show : > > # lsof -p | grep postgresql-jdbc.jar > java2138 ovirt mem REG8,2486139 18729421 > /usr/share/java/postgresql-jdbc.jar > > rpm -qf /usr/share/java/postgresql-jdbc.jar > postgresql-jdbc-9.4.1208-1.rhel7.noarch > > rpm -qi postgresql-jdbc-9.4.1208-1.rhel7.noarch > ... > URL : https://jdbc.postgresql.org/ > > And indeed I needed to install pgdg-94-centos.repo, my note says the > package was needed by ovirt, I don't remember why. And indeed : > yum erase postgresql94-server > ... > Removing: > postgresql94-server > x86_64 9.4.8-1PGDG.rhel7 > @pgdg94 > 17 M > Removing for dependencies: > ovirt-engine > noarch 4.0.1.1-1.el7.centos > @ovirt-4.0 > 2.6 M > ovirt-engine-backend > noarch 4.0.1.1-1.el7.centos > @ovirt-4.0 > 13 M > > So I tried: > > yum downgrade postgresql-jdbc > ... > ---> Package postgresql-jdbc.noarch 0:9.2.1002-5.el7 will be a downgrade > ... > > And now it (almost) works. I have other not linked problems that needs > more investigations. > > > Le 3 août 2016 à 12:39, Martin Perina a écrit : > > Hi, > > 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. > > Thanks > > Martin Perina > > > On Wed, Aug 3, 2016 at 12:31 PM, Fabrice Bacchella < > fabrice.bacche...@icloud.com> wrote: > >> I'm running on Centos 7, just upgraded to ovirt 4.01 using the procedure >> given in the release notes. >> >> But now I'm getting that in /var/log/ovirt-engine/engine.log: >> >> 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-49: Unable to invoke >> private void org.ovirt.engine.core.vds >> broker.ResourceManager.init() on >> org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e >>at >> org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >>at >> org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) >> [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >> ... >> Caused by: java.lang.reflect.InvocationTargetException >>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> [rt.jar:1.8.0_92] >>at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> [rt.jar:1.8.0_92] >>at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> [rt.jar:1.8.0_92] >>at java.lang.reflect.Method.invoke(Method.java:498) >> [rt.jar:1.8.0_92] >>at >> org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:98) >> [weld-core-impl-2.3.2.F
Re: [ovirt-users] Upgrade to 4.0.1 failed with NPE on org.postgresql.jdbc.TypeInfoCache.getSQLType
Just a little investigation show : # lsof -p | grep postgresql-jdbc.jar java2138 ovirt mem REG8,2486139 18729421 /usr/share/java/postgresql-jdbc.jar rpm -qf /usr/share/java/postgresql-jdbc.jar postgresql-jdbc-9.4.1208-1.rhel7.noarch rpm -qi postgresql-jdbc-9.4.1208-1.rhel7.noarch ... URL : https://jdbc.postgresql.org/ And indeed I needed to install pgdg-94-centos.repo, my note says the package was needed by ovirt, I don't remember why. And indeed : yum erase postgresql94-server ... Removing: postgresql94-server x86_64 9.4.8-1PGDG.rhel7 @pgdg94 17 M Removing for dependencies: ovirt-engine noarch 4.0.1.1-1.el7.centos @ovirt-4.0 2.6 M ovirt-engine-backend noarch 4.0.1.1-1.el7.centos @ovirt-4.0 13 M So I tried: yum downgrade postgresql-jdbc ... ---> Package postgresql-jdbc.noarch 0:9.2.1002-5.el7 will be a downgrade ... And now it (almost) works. I have other not linked problems that needs more investigations. > Le 3 août 2016 à 12:39, Martin Perina a écrit : > > Hi, > > 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. > > Thanks > > Martin Perina > > > On Wed, Aug 3, 2016 at 12:31 PM, Fabrice Bacchella > mailto:fabrice.bacche...@icloud.com>> wrote: > I'm running on Centos 7, just upgraded to ovirt 4.01 using the procedure > given in the release notes. > > But now I'm getting that in /var/log/ovirt-engine/engine.log: > > 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-49: Unable to invoke > private void org.ovirt.engine.core.vds > broker.ResourceManager.init() on > org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] > ... > Caused by: java.lang.reflect.InvocationTargetException >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [rt.jar:1.8.0_92] >at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > [rt.jar:1.8.0_92] >at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [rt.jar:1.8.0_92] >at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92] >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:98) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >... 82 more > Caused by: java.lang.NullPointerException >at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:182) >at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:178) >at > org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1259) >at > org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.ja
Re: [ovirt-users] Upgrade to 4.0.1 failed with NPE on org.postgresql.jdbc.TypeInfoCache.getSQLType
Hi, 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. Thanks Martin Perina On Wed, Aug 3, 2016 at 12:31 PM, Fabrice Bacchella < fabrice.bacche...@icloud.com> wrote: > I'm running on Centos 7, just upgraded to ovirt 4.01 using the procedure > given in the release notes. > > But now I'm getting that in /var/log/ovirt-engine/engine.log: > > 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-49: Unable to invoke > private void org.ovirt.engine.core.vds > broker.ResourceManager.init() on > org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >at > org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] > ... > Caused by: java.lang.reflect.InvocationTargetException >at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > [rt.jar:1.8.0_92] >at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > [rt.jar:1.8.0_92] >at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [rt.jar:1.8.0_92] >at java.lang.reflect.Method.invoke(Method.java:498) > [rt.jar:1.8.0_92] >at > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:98) > [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] >... 82 more > Caused by: java.lang.NullPointerException >at > org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:182) >at > org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:178) >at > org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1259) >at > org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1040) >at > org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:353) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:112) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory$1.processMetaData(CallMetaDataProviderFactory.java:133) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:299) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:73) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:286) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:303) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.compileInternal(PostgresDbEngineDialect.java:108) > [dal.jar:] >at > org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:288) > [spring-jdbc.jar:4.2.4.RELEASE] >at > org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.getCall(SimpleJdbcCallsHandler.java:169) > [dal.jar:] >at > org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.j
[ovirt-users] Upgrade to 4.0.1 failed with NPE on org.postgresql.jdbc.TypeInfoCache.getSQLType
I'm running on Centos 7, just upgraded to ovirt 4.01 using the procedure given in the release notes. But now I'm getting that in /var/log/ovirt-engine/engine.log: 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-49: Unable to invoke private void org.ovirt.engine.core.vds broker.ResourceManager.init() on org.ovirt.engine.core.vdsbroker.ResourceManager@28b87a8e at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] ... Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_92] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_92] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_92] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_92] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:98) [weld-core-impl-2.3.2.Final.jar:2.3.2.Final] ... 82 more Caused by: java.lang.NullPointerException at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:182) at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:178) at org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1259) at org.postgresql.jdbc.PgDatabaseMetaData.getProcedureColumns(PgDatabaseMetaData.java:1040) at org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:353) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:112) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory$1.processMetaData(CallMetaDataProviderFactory.java:133) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:299) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:73) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:286) [spring-jdbc.jar:4.2.4.RELEASE] at org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:303) [spring-jdbc.jar:4.2.4.RELEASE] at org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.compileInternal(PostgresDbEngineDialect.java:108) [dal.jar:] at org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:288) [spring-jdbc.jar:4.2.4.RELEASE] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.getCall(SimpleJdbcCallsHandler.java:169) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:146) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:109) [dal.jar:] at org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeRead(SimpleJdbcCallsHandler.java:101) [dal.jar:] at org.ovirt.engine.core.dao.VdsDynamicDaoImpl.get(VdsDynamicDaoImpl.java:129) [dal.jar:] at org.ovirt.engine.core.dao.VdsDynamicDaoIm