Postgres errors after updating to 9.5.7 from 9.5.4

Hi We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine. Updates were done on client and server to keep them in sync. The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck. 2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]

On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
A very similar report [1] was solved by downgrading postgresql-jdbc. [1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html Best, -- Didi

Wow, that looks almost exactly like what we're seeing. Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages. Logan
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com> wrote:
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
A very similar report [1] was solved by downgrading postgresql-jdbc.
[1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html
Best, -- Didi

On Wed, May 24, 2017 at 12:06 AM, <support@jac-properties.com> wrote:
Wow, that looks almost exactly like what we're seeing.
Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages.
Please try 9.2. Thanks!
Logan
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com> wrote:
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
A very similar report [1] was solved by downgrading postgresql-jdbc.
[1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html
Best, -- Didi
-- Didi

------=_Part_117131_1593059334.1495576400315 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I downgraded the jdbc to 9.2.1002 and it's working again. Thank you for your help! The full setup is as such in case it helps anyone in the future: OS: CentOS 7.3.1611 Backend: Ceph via Cinder oVirt: 4.0.6.3 Postgres is remote and 9.5.7 on client and server Postgres jdbc: 9.2.1002 Logan
On May 23, 2017 at 4:15 PM Yedidyah Bar David <didi@redhat.com> wrote:
On Wed, May 24, 2017 at 12:06 AM, <support@jac-properties.com> wrote:
> >
Wow, that looks almost exactly like what we're seeing.
Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages.
>
Please try 9.2. Thanks!
> >
Logan
> > >
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com> wrote:
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:
> > > >
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
> > >
A very similar report [1] was solved by downgrading postgresql-jdbc.
[1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html
Best, -- Didi
> >
>
-- Didi
------=_Part_117131_1593059334.1495576400315 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <!DOCTYPE html> <html><head> <meta charset=3D"UTF-8"> </head><body><p>I downgraded the jdbc to 9.2.1002 and it's working agai= n. Thank you for your help!</p><p>The full setup is as such in case i= t helps anyone in the future:</p><p>OS: CentOS 7.3.1611</p><p>Backend: Ceph= via Cinder</p><p>oVirt: 4.0.6.3</p><p>Postgres is remote and 9.5.7 on clie= nt and server</p><p>Postgres jdbc: 9.2.1002</p><p>Logan</p><blockquote><p>O= n May 23, 2017 at 4:15 PM Yedidyah Bar David <didi@redhat.com> wrot= e:</p><p>On Wed, May 24, 2017 at 12:06 AM, <support@jac-properties.com&= #62; wrote:</p><blockquote><p>Wow, that looks almost exactly like what we= 39;re seeing.</p><p>Unfortunately, downgrading from postgresql-jdbc-42.1.1 = to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the = same error messages.</p></blockquote><p>Please try 9.2. Thanks!</p><blockqu= ote><p>Logan</p><blockquote><p>On May 23, 2017 at 3:39 PM Yedidyah Bar Davi= d <didi@redhat.com> wrote:</p><p>On Tue, May 23, 2017 at 11:19 PM, = Logan Kuhn <support@jac-properties.com> wrote:</p><blockquote><p>Hi= </p><p>We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7.= We<br>restarted ovirt-engine between 9.5.4 and it worked as expected. Afte= r we<br>updated to 9.5.7 we have started to get postgres errors in engine.l= og and a<br>404 error in the browser when we try to start ovirt-engine.</p>= <p>Updates were done on client and server to keep them in sync.</p><p>The e= rror is complaining about a missing function, but we can verify that<br>the= function exists in the database. We've also restored engine and<br>ovi= rt_engine_history from a backup at 8am this morning when it was working<br>= and before we upgraded to 9.5.7 with no apparent help and run engine-setup<= br>afterwards, still no luck.</p><p>2017-05-23 15:07:48,418 INFO [org.ovirt= .engine.core.dal.dbbroker.DbFacade]<br>(ServerService Thread Pool -- 51) []= Initializing the DbFacade<br>2017-05-23 15:07:48,480 INFO [org.ovirt.engin= e.core.bll.Backend]<br>(ServerService Thread Pool -- 51) [] Start initializ= ing Backend<br>2017-05-23 15:07:48,502 ERROR<br>[org.ovirt.engine.core.bll.= network.macpool.MacPoolPerDc] (ServerService<br>Thread Pool -- 46) [] Error= initializing: PreparedStatementCallback; bad SQL<br>grammar [select * from= getallmacpoolrangesbymacpoolid()]; nested exception<br>is org.postgresql.u= til.PSQL<br>Exception: ERROR: function getallmacpoolrangesbymacpoolid() doe= s not exist<br> Hint: No function matches the given name and argument types= . You might need<br>to add explicit type casts.<br> Position: 16<br>2017-05= -23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend]<br>(ServerServic= e Thread Pool -- 51) [] Error during initialization:<br>org.jboss.weld.exce= ptions.WeldException: WELD-000049: Unable to invoke<br>public void<br>org.o= virt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre<br>ate() on<= br>org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461= <br> at<br>org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoke= r.invokeMethods(DefaultLifecycleCallbackInvoker.java:100)<br>[weld-core-imp= l-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.injection.producer.= DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvok= er.java:81)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.j= boss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInject= ionTarget.java:126)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at = org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162)<br>[weld-core-= impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.context.Abstract= Context.get(AbstractContext.java:96)<br>[weld-core-impl-2.3.5.Final.jar:2.3= .5.Final]<br> at<br>org.jboss.weld.bean.ContextualInstanceStrategy$DefaultC= ontextualInstanceStrategy.get(ContextualInstanceStrategy.java:101)<br>[weld= -core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.bean.Conte= xtualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(Conte= xtualInstanceStrategy.java:141)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Fi= nal]<br> at<br>org.jboss.weld.bean.ContextualInstance.get(ContextualInstanc= e.java:50)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jb= oss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742)<br>= [weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.bean.= builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189)<br>[weld-core-i= mpl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.bean.builtin.Inst= anceImpl.get(InstanceImpl.java:100)<br>[weld-core-impl-2.3.5.Final.jar:2.3.= 5.Final]<br> at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:= 301)<br>[bll.jar:]<br> at org.ovirt.engine.core.bll.Backend.initialize(Back= end.java:212)<br>[bll.jar:]<br> at org.ovirt.engine.core.bll.Backend.create= (Backend.java:159)<br>[bll.jar:]<br> at sun.reflect.NativeMethodAccessorImp= l.invoke0(Native Method)<br>[rt.jar:1.8.0_131]<br> at<br>sun.reflect.Native= MethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>[rt.jar:1.8.= 0_131]<br> at<br>sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegating= MethodAccessorImpl.java:43)<br>[rt.jar:1.8.0_131]<br> at java.lang.reflect.= Method.invoke(Method.java:498)<br>[rt.jar:1.8.0_131]<br> at<br>org.jboss.as= .ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(= ManagedReferenceLifecycleMethodInterceptor.java:96)<br> at<br>org.jboss.inv= ocation.InterceptorContext.proceed(InterceptorContext.java:340)<br> at<br>o= rg.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContex= t.java:437)<br> at<br>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.deleg= ateInterception(Jsr299BindingsInterceptor.java:70)<br>[wildfly-weld-10.1.0.= Final.jar:10.1.0.Final]<br> at<br>org.jboss.as.weld.ejb.Jsr299BindingsInter= ceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117)<br>[wild= fly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.as.weld.ejb.Jsr= 299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103= )<br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.invoc= ation.InterceptorContext.proceed(InterceptorContext.java:340)<br> at<br>org= .jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.= java:437)<br> at<br>org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInt= erceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73)= <br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.as.wel= d.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScop= eActivationInterceptor.java:83)<br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Fi= nal]<br> at<br>org.jboss.invocation.InterceptorContext.proceed(InterceptorC= ontext.java:340)<br> at<br>org.jboss.as.weld.injection.WeldInjectionInterce= ptor.processInvocation(WeldInjectionInterceptor.java:53)<br>[wildfly-weld-1= 0.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.invocation.InterceptorCon= text.proceed(InterceptorContext.java:340)<br> at<br>org.jboss.as.ee.compone= nt.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInt= erceptorFactory.java:28)<br> at<br>org.jboss.invocation.InterceptorContext.= proceed(InterceptorContext.java:340)<br> at<br>org.jboss.as.weld.injection.= WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInject= ionInterceptor.java:56)<br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Final]<br>= at<br>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.j= ava:340)<br> at<br>org.jboss.as.ee.component.ComponentInstantiatorIntercept= or.processInvocation(ComponentInstantiatorInterceptor.java:74)<br> at<br>or= g.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)<= br> at<br>org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvo= cation(Jsr299BindingsCreateInterceptor.java:100)<br>[wildfly-weld-10.1.0.Fi= nal.jar:10.1.0.Final]<br> at<br>org.jboss.invocation.InterceptorContext.pro= ceed(InterceptorContext.java:340)<br> at<br>org.jboss.as.ee.component.Names= paceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:5= 0)<br> at<br>org.jboss.invocation.InterceptorContext.proceed(InterceptorCon= text.java:340)<br> at<br>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx= (CMTTxInterceptor.java:263)<br>[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]= <br> at<br>org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.= java:374)<br>[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jbo= ss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInt= erceptor.java:70)<br>[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]</p></bloc= kquote><p>A very similar report [1] was solved by downgrading postgresql-jd= bc.</p><p>[1] <a href=3D"http://lists.ovirt.org/pipermail/users/2017-April/= 081517.html">http://lists.ovirt.org/pipermail/users/2017-April/081517.html<= /a></p><p>Best,<br>--<br>Didi</p></blockquote></blockquote><p>--<br>Didi</p=
</blockquote></body></html> =20 ------=_Part_117131_1593059334.1495576400315--

Yes, postgresql 9.2 JDBC drivers are the only working and supported JDBC drivers. Also please be aware that we test and only PostgreSQL 9.2 for oVirt, so there may be other issues with newer versions. On Tue, May 23, 2017 at 11:15 PM, Yedidyah Bar David <didi@redhat.com> wrote:
On Wed, May 24, 2017 at 12:06 AM, <support@jac-properties.com> wrote:
Wow, that looks almost exactly like what we're seeing.
Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages.
Please try 9.2. Thanks!
Logan
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com> wrote:
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify
the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal. dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@ 3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoke r.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoke r.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct( BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create( ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ ApplicationScopedContextualInstanceStrategy.get( ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get( ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference( BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance( InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend. java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend. java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke( NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn < support@jac-properties.com> wrote: that processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(
InterceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.
proceed(InterceptorContext.java:437)
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor. doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation( Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.
Jsr299BindingsInterceptor.java:70) proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivat
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInter ceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFact ory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterc eptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorIntercept or.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateIntercepto r.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed( InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.
ionInterceptor.aroundInvoke(AbstractEJBRequestScopeActivat ionInterceptor.java:73) processInvocation(WeldInjectionInterceptor.java:53) processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(
InterceptorContext.java:340)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(
CMTTxInterceptor.java:263)
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports( CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation( LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
A very similar report [1] was solved by downgrading postgresql-jdbc.
[1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html
Best, -- Didi
-- Didi _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

------=_Part_140563_705361331.1495632345559 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Which makes sense seeing as that's what Red Hat officially supports. It just made sense for our infrastructure to put it on our postgres cluster that is running 9.5.x. Unfortunately things like this happen sometimes when running a slightly unsupported infrastructure. Is this worth putting in an RFE? Support for postgresql-jdbc 42+ and postgresql 9.5+ Logan
On May 24, 2017 at 5:24 AM Martin Perina <mperina@redhat.com> wrote:
Yes, postgresql 9.2 JDBC drivers are the only working and supported JDBC drivers. Also please be aware that we test and only PostgreSQL 9.2 for oVirt, so there may be other issues with newer versions.
On Tue, May 23, 2017 at 11:15 PM, Yedidyah Bar David <didi@redhat.com mailto:didi@redhat.com > wrote:
> > On Wed, May 24, 2017 at 12:06 AM, <support@jac-properties.com mailto:support@jac-properties.com > wrote:
> Wow, that looks almost exactly like what we're seeing. > > Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages. >
Please try 9.2. Thanks!
> Logan > >> On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com mailto:didi@redhat.com > wrote: >> >> >> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com mailto:support@jac-properties.com > wrote: >> > Hi >> > >> > We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We >> > restarted ovirt-engine between 9.5.4 and it worked as expected. After we >> > updated to 9.5.7 we have started to get postgres errors in engine.log and a >> > 404 error in the browser when we try to start ovirt-engine. >> > >> > Updates were done on client and server to keep them in sync. >> > >> > The error is complaining about a missing function, but we can verify that >> > the function exists in the database. We've also restored engine and >> > ovirt_engine_history from a backup at 8am this morning when it was working >> > and before we upgraded to 9.5.7 with no apparent help and run engine-setup >> > afterwards, still no luck. >> > >> > 2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] >> > (ServerService Thread Pool -- 51) [] Initializing the DbFacade >> > 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] >> > (ServerService Thread Pool -- 51) [] Start initializing Backend >> > 2017-05-23 15:07:48,502 ERROR >> > [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService >> > Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL >> > grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception >> > is org.postgresql.util.PSQL >> > Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist >> > Hint: No function matches the given name and argument types. You might need >> > to add explicit type casts. >> > Position: 16 >> > 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] >> > (ServerService Thread Pool -- 51) [] Error during initialization: >> > org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke >> > public void >> > org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre >> > ate() on >> > org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 >> > at >> > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) >> > [bll.jar:] >> > at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) >> > [bll.jar:] >> > at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) >> > [bll.jar:] >> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> > [rt.jar:1.8.0_131] >> > at >> > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >> > [rt.jar:1.8.0_131] >> > at >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> > [rt.jar:1.8.0_131] >> > at java.lang.reflect.Method.invoke(Method.java:498) >> > [rt.jar:1.8.0_131] >> > at >> > org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) >> > at >> > org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) >> > at >> > org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) >> > [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] >> > at >> > org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) >> > [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) >> > at >> > org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) >> > at >> > org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) >> > [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) >> > [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] >> > at >> > org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) >> > [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] >> > >> >> A very similar report [1] was solved by downgrading postgresql-jdbc. >> >> [1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html http://lists.ovirt.org/pipermail/users/2017-April/081517.html >> >> Best, >> -- >> Didi
-- Didi _______________________________________________ Users mailing list Users@ovirt.org mailto:Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users http://lists.ovirt.org/mailman/listinfo/users
>
() does not exist<br> >> > Hint: No function matches the= given name and argument types. You might need<br> >> > to add = explicit type casts.<br> >> > Position: 16<br> >>= > 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.<wbr/>Backe= nd]<br> >> > (ServerService Thread Pool -- 51) [] Error during = initialization:<br> >> > org.jboss.weld.exceptions.<wbr/>WeldEx= ception: WELD-000049: Unable to invoke<br> >> > public void<br>= >> > org.ovirt.engine.core.bll.<wbr/>hostedengine.<wbr/>Previo= usHostedEngineHost.cre<br> >> > ate() on<br> >> > o= rg.ovirt.engine.core.bll.<wbr/>hostedengine.<wbr/>PreviousHostedEngineHost@= <wbr/>3a35f461<br> >> > at<br> >= > > org.jboss.weld.injection.<wbr/>producer.<wbr/>DefaultLifecycleC= allbackInvoke<wbr/>r.invokeMethods(<wbr/>DefaultLifecycleCallbackInvoke<wbr= />r.java:100)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.= 3.5.Final]<br> >> > at<br> >>= ; > org.jboss.weld.injection.<wbr/>producer.<wbr/>DefaultLifecycleCallb= ackInvoke<wbr/>r.postConstruct(<wbr/>DefaultLifecycleCallbackInvoke<wbr/>r.= java:81)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.F= inal]<br> >> > at<br> >> = 2; org.jboss.weld.injection.<wbr/>producer.BasicInjectionTarget.<wbr/>postC= onstruct(<wbr/>BasicInjectionTarget.java:126)<br> >> > [weld-co= re-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> > = ; at org.jboss.weld.bean.<wbr/>ManagedBean.create(<wbr/>Manag= edBean.java:162)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar= :2.3.5.Final]<br> >> > at<br> >&= #62; > org.jboss.weld.context.<wbr/>AbstractContext.get(<wbr/>AbstractC= ontext.java:96)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:= 2.3.5.Final]<br> >> > at<br> >= 62; > org.jboss.weld.bean.<wbr/>ContextualInstanceStrategy$<wbr/>Defaul= tContextualInstanceStrat<wbr/>egy.get(<wbr/>ContextualInstanceStrategy.<wbr= />java:101)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.= 5.Final]<br> >> > at<br> >> = > org.jboss.weld.bean.<wbr/>ContextualInstanceStrategy$<wbr/>Applicatio= nScopedContextualIns<wbr/>tanceStrategy.get(<wbr/>ContextualInstanceStrateg= y.<wbr/>java:141)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>ja= r:2.3.5.Final]<br> >> > at<br> >= > > org.jboss.weld.bean.<wbr/>ContextualInstance.get(<wbr/>Contextu= alInstance.java:50)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>= jar:2.3.5.Final]<br> >> > at<br> = 2;> > org.jboss.weld.manager.<wbr/>BeanManagerImpl.getReference(<wb= r/>BeanManagerImpl.java:742)<br> >> > [weld-core-impl-2.3.5.Fin= al.<wbr/>jar:2.3.5.Final]<br> >> > a= t<br> >> > org.jboss.weld.bean.builtin.<wbr/>InstanceImpl.getBe= anInstance(<wbr/>InstanceImpl.java:189)<br> >> > [weld-core-imp= l-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> > = 0; at<br> >> > org.jboss.weld.bean.builtin.<wbr/>Instanc= eImpl.get(InstanceImpl.<wbr/>java:100)<br> >> > [weld-core-impl= -2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> > = ; at org.ovirt.engine.core.bll.<wbr/>Backend.loadService(Backend.<wb= r/>java:301)<br> >> > [bll.jar:]<br> >> > = 60; at org.ovirt.engine.core.bll.<wbr/>Backend.initialize(Bac= kend.<wbr/>java:212)<br> >> > [bll.jar:]<br> >> >= 160; at org.ovirt.engine.core.bll.<wbr/>Backend.create= (Backend.java:<wbr/>159)<br> >> > [bll.jar:]<br> >> = 2; at sun.reflect.<wbr/>NativeMethodAccessorImpl= .<wbr/>invoke0(Native Method)<br> >> > [rt.jar:1.8.0_131]<br> &= #62;> > at<br> >> > sun.refl= ect.<wbr/>NativeMethodAccessorImpl.<wbr/>invoke(<wbr/>NativeMethodAccessorI= mpl.java:<wbr/>62)<br> >> > [rt.jar:1.8.0_131]<br> >> &= #62; at<br> >> > sun.reflect.<wbr/>D= elegatingMethodAccessorImpl.<wbr/>invoke(<wbr/>DelegatingMethodAccessorImpl= .<wbr/>java:43)<br> >> > [rt.jar:1.8.0_131]<br> >> >= ; at java.lang.reflect.Method.<wbr/>invoke(Metho= d.java:498)<br> >> > [rt.jar:1.8.0_131]<br> >> >= 60; at<br> >> > org.jboss.as.ee.component.= <wbr/>ManagedReferenceLifecycleMetho<wbr/>dInterceptor.<wbr/>processInvocat= ion(<wbr/>ManagedReferenceLifecycleMetho<wbr/>dInterceptor.java:96)<br> = 2;> > at<br> >> > org.jboss.= invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:3= 40)<br> >> > at<br> >> >= org.jboss.invocation.<wbr/>InterceptorContext$Invocation.<wbr/>proceed(Int= erceptorContext.<wbr/>java:437)<br> >> > = 160; at<br> >> > org.jboss.as.weld.ejb.<wbr/>Jsr299BindingsInte= rceptor.<wbr/>delegateInterception(<wbr/>Jsr299BindingsInterceptor.<wbr/>ja= va:70)<br> >> > [wildfly-weld-10.1.0.Final.<wbr/>jar:10.1.0.Fin= al]<br> >> > at<br> >> >= org.jboss.as.weld.ejb.<wbr/>Jsr299BindingsInterceptor.<wbr/>doLifecycleInt= erception(<wbr/>Jsr299BindingsInterceptor.<wbr/>java:117)<br> >> = 62; [wildfly-weld-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >= at<br> >> > org.jboss.as.weld.ejb.<= wbr/>Jsr299BindingsInterceptor.<wbr/>processInvocation(<wbr/>Jsr299Bindings= Interceptor.<wbr/>java:103)<br> >> > [wildfly-weld-10.1.0.Final= .<wbr/>jar:10.1.0.Final]<br> >> > at= <br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed= (<wbr/>InterceptorContext.java:340)<br> >> > = ; at<br> >> > org.jboss.invocation.<wbr/>InterceptorCont= ext$Invocation.<wbr/>proceed(InterceptorContext.<wbr/>java:437)<br> >= 62; > at<br> >> > org.jboss.weld= .ejb.<wbr/>AbstractEJBRequestScopeActivat<wbr/>ionInterceptor.aroundInvoke(= <wbr/>AbstractEJBRequestScopeActivat<wbr/>ionInterceptor.java:73)<br> >= > > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >= 2; > at<br> >> > org.jboss.as.we= ld.ejb.<wbr/>EjbRequestScopeActivationInter<wbr/>ceptor.processInvocation(<= wbr/>EjbRequestScopeActivationInter<wbr/>ceptor.java:83)<br> >> = 2; [wildfly-weld-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >&= #160; at<br> >> > org.jboss.invocation.<wb= r/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >&= #62; > at<br> >> > org.jboss.as.= weld.injection.<wbr/>WeldInjectionInterceptor.<wbr/>processInvocation(<wbr/= WeldInjectionInterceptor.java:<wbr/>53)<br> >> > [wildfly-weld= -10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> > = 60; at<br> >> > org.jboss.invocation.<wbr/>InterceptorCo= ntext.proceed(<wbr/>InterceptorContext.java:340)<br> >> > = at<br> >> > org.jboss.as.ee.component.<wb= r/>AroundConstructInterceptorFact<wbr/>ory$1.processInvocation(<wbr/>Around= ConstructInterceptorFact<wbr/>ory.java:28)<br> >> > = ; at<br> >> > org.jboss.invocation.<wbr/>Intercep= torContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >&= #160; at<br> >> > org.jboss.as.weld.inject= ion.<wbr/>WeldInterceptorInjectionInterc<wbr/>eptor.processInvocation(<wbr/= WeldInterceptorInjectionInterc<wbr/>eptor.java:56)<br> >> > [w= ildfly-weld-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> > = at<br> >> > org.jboss.invocation.<wbr/>In= terceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> = > at<br> >> > org.jboss.as.ee.co= mponent.<wbr/>ComponentInstantiatorIntercept<wbr/>or.processInvocation(<wbr= />ComponentInstantiatorIntercept<wbr/>or.java:74)<br> >> > = ; at<br> >> > org.jboss.invocation.<wbr/>I= nterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >>= > at<br> >> > org.jboss.as.weld= .ejb.<wbr/>Jsr299BindingsCreateIntercepto<wbr/>r.processInvocation(<wbr/>Js= r299BindingsCreateIntercepto<wbr/>r.java:100)<br> >> > [wildfly= -weld-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> > = ; at<br> >> > org.jboss.invocation.<wbr/>Intercep= torContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >&= #160; at<br> >> > org.jboss.as.ee.componen= t.<wbr/>NamespaceContextInterceptor.<wbr/>processInvocation(<wbr/>Namespace= ContextInterceptor.<wbr/>java:50)<br> >> > = at<br> >> > org.jboss.invocation.<wbr/>InterceptorContex= t.proceed(<wbr/>InterceptorContext.java:340)<br> >> > = 60; at<br> >> > org.jboss.as.ejb3.tx.<wbr/>CMTTxI= nterceptor.invokeInNoTx(<wbr/>CMTTxInterceptor.java:263)<br> >> = 2; [wildfly-ejb3-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >&= #160; at<br> >> > org.jboss.as.ejb3.tx.<wb= r/>CMTTxInterceptor.supports(<wbr/>CMTTxInterceptor.java:374)<br> >>= ; > [wildfly-ejb3-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> &= #62; at<br> >> > org.jboss.as.ejb3.t= x.<wbr/>LifecycleCMTTxInterceptor.<wbr/>processInvocation(<wbr/>LifecycleCM= TTxInterceptor.<wbr/>java:70)<br> >> > [wildfly-ejb3-10.1.0.Fin= al.<wbr/>jar:10.1.0.Final]<br> >> ><br> >><br> >= 2; A very similar report [1] was solved by downgrading postgresql-jdbc.<br>= >><br> >> [1] <a href=3D"http://lists.ovirt.org/pipermail/= users/2017-April/081517.html" target=3D"_blank">http://lists.ovirt.org/<wbr= />pipermail/users/2017-April/<wbr/>081517.html</a><br> >><br> >= > Best,<br> <span class=3D"ox-03f7f44247-HOEnZb"><span style=3D"color: = #888888;">>> --<br> >> Didi<br> <br> <br> <br> --<br> Didi<= br> ______________________________<wbr/>_________________<br> Users mailing=
------=_Part_140563_705361331.1495632345559 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <!DOCTYPE html> <html><head> <meta charset=3D"UTF-8"> </head><body><p>Which makes sense seeing as that's what Red Hat officia= lly supports. It just made sense for our infrastructure to put it on = our postgres cluster that is running 9.5.x. Unfortunately things like= this happen sometimes when running a slightly unsupported infrastructure.<= /p><p><br></p><p>Is this worth putting in an RFE? Support for postgre= sql-jdbc 42+ and postgresql 9.5+</p><p><br></p><p>Logan</p><blockquote type= =3D"cite">On May 24, 2017 at 5:24 AM Martin Perina <mperina@redhat.com&= #62; wrote:<br><br><div dir=3D"ltr"><div class=3D"ox-03f7f44247-gmail_defau= lt" style=3D"font-family: arial,helvetica,sans-serif;">Yes, postgresql 9.2 = JDBC drivers are the only working and supported JDBC drivers. Also please b= e aware that we test and only PostgreSQL 9.2 for oVirt, so there may = be other issues with newer versions.<br></div></div><div class=3D"ox-03f7f4= 4247-gmail_extra"><br><div class=3D"ox-03f7f44247-gmail_quote">On Tue, May = 23, 2017 at 11:15 PM, Yedidyah Bar David <<a href=3D"mailto:didi@redhat= .com" target=3D"_blank">didi@redhat.com</a>> wrote:<br><blockquote>On W= ed, May 24, 2017 at 12:06 AM, <<a href=3D"mailto:support@jac-prop= erties.com">support@jac-properties.com</a>> wrote:<br> > Wow, that = looks almost exactly like what we're seeing.<br> ><br> > Unfort= unately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovir= t-engine and rerunning engine-setup produces the same error messages.<br> &= #62;<br> <br> Please try 9.2. Thanks!<br> <br> > Logan<br> ><br> = 62;> On May 23, 2017 at 3:39 PM Yedidyah Bar David <<a href=3D"mail= to:didi@redhat.com">didi@redhat.com</a>> wrote:<br> >><br> >= ;><br> >> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <<a = href=3D"mailto:support@jac-properties.com">support@jac-properties.com</a>= 62; wrote:<br> >> > Hi<br> >> ><br> >> >= ; We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. = ; We<br> >> > restarted ovirt-engine between 9.5.4 and it worke= d as expected. After we<br> >> > updated to 9.5.7 we have= started to get postgres errors in engine.log and a<br> >> > 40= 4 error in the browser when we try to start ovirt-engine.<br> >> = 62;<br> >> > Updates were done on client and server to keep the= m in sync.<br> >> ><br> >> > The error is complaini= ng about a missing function, but we can verify that<br> >> > th= e function exists in the database. We've also restored engine and= <br> >> > ovirt_engine_history from a backup at 8am this mornin= g when it was working<br> >> > and before we upgraded to 9.5.7 = with no apparent help and run engine-setup<br> >> > afterwards,= still no luck.<br> >> ><br> >> > 2017-05-23 15:07:= 48,418 INFO [org.ovirt.engine.core.dal.<wbr/>dbbroker.DbFacade]<br> &= #62;> > (ServerService Thread Pool -- 51) [] Initializing the DbFac= ade<br> >> > 2017-05-23 15:07:48,480 INFO [org.ovirt.engi= ne.core.bll.<wbr/>Backend]<br> >> > (ServerService Thread Pool = -- 51) [] Start initializing Backend<br> >> > 2017-05-23 15:07:= 48,502 ERROR<br> >> > [org.ovirt.engine.core.bll.<wbr/>network.= macpool.MacPoolPerDc] (ServerService<br> >> > Thread Pool -- 46= ) [] Error initializing: PreparedStatementCallback; bad SQL<br> >> = > grammar [select * from getallmacpoolrangesbymacpoolid<wbr/>()];= nested exception<br> >> > is org.postgresql.util.PSQL<br> >= ;> > Exception: ERROR: function getallmacpoolrangesbymacpoolid<wbr/= list<br> <a href=3D"mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a hre= f=3D"http://lists.ovirt.org/mailman/listinfo/users" target=3D"_blank">http:= //lists.ovirt.org/<wbr/>mailman/listinfo/users</a><br> </span></span></bloc= kquote></div><br></div></blockquote></body></html> =20 ------=_Part_140563_705361331.1495632345559--

Le 24 mai 2017 =C3=A0 15:25, support@jac-properties.com a =C3=A9crit : =20 Which makes sense seeing as that's what Red Hat officially supports. = It just made sense for our infrastructure to put it on our postgres = cluster that is running 9.5.x. Unfortunately things like this happen = sometimes when running a slightly unsupported infrastructure. =20 =20 =20 Is this worth putting in an RFE? Support for postgresql-jdbc 42+ and =
--Apple-Mail=_7A63A86B-C79F-4862-869A-B52949907F85 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 postgresql 9.5+
=20 A good solution usually used by java app is to provide the need jars. = That the purpose of maven like tools.
--Apple-Mail=_7A63A86B-C79F-4862-869A-B52949907F85 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html = charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" = class=3D""><br class=3D""><div><blockquote type=3D"cite" class=3D""><div = class=3D"">Le 24 mai 2017 =C3=A0 15:25, <a = href=3D"mailto:support@jac-properties.com" = class=3D"">support@jac-properties.com</a> a =C3=A9crit :</div><br = class=3D"Apple-interchange-newline"><div class=3D""> <meta charset=3D"UTF-8" class=3D""> <div class=3D""><p class=3D"">Which makes sense seeing as that's what = Red Hat officially supports. It just made sense for our = infrastructure to put it on our postgres cluster that is running 9.5.x. = Unfortunately things like this happen sometimes when running a = slightly unsupported infrastructure.</p><p class=3D""><br = class=3D""></p><p class=3D"">Is this worth putting in an RFE? = Support for postgresql-jdbc 42+ and postgresql = 9.5+</p></div></div></blockquote>A good solution usually used by java = app is to provide the need jars. That the purpose of maven like = tools.</div><br class=3D""></body></html>= --Apple-Mail=_7A63A86B-C79F-4862-869A-B52949907F85--

On Wed, May 24, 2017 at 5:04 PM, Fabrice Bacchella <fabrice.bacchella@orange.fr> wrote:
Le 24 mai 2017 à 15:25, support@jac-properties.com a écrit :
Which makes sense seeing as that's what Red Hat officially supports. It just made sense for our infrastructure to put it on our postgres cluster that is running 9.5.x. Unfortunately things like this happen sometimes when running a slightly unsupported infrastructure.
Is this worth putting in an RFE? Support for postgresql-jdbc 42+ and postgresql 9.5+
Martin is already working on 9.5 support for oVirt 4.2. No idea about jdbc.
A good solution usually used by java app is to provide the need jars. That the purpose of maven like tools.
We can also simply add to the spec file '< 9.3' or something like that, until we fix the code to support newer. You are more than welcome to open a bug for this! Best, -- Didi

Le 24 mai 2017 à 16:26, Yedidyah Bar David <didi@redhat.com> a écrit :
A good solution usually used by java app is to provide the need jars. That the purpose of maven like tools.
We can also simply add to the spec file '< 9.3' or something like that, until we fix the code to support newer.
You are more than welcome to open a bug for this!

On May 24, 2017, at 6:25 AM, support@jac-properties.com wrote:
Which makes sense seeing as that's what Red Hat officially supports. It just made sense for our infrastructure to put it on our postgres cluster that is running 9.5.x. Unfortunately things like this happen sometimes when running a slightly unsupported infrastructure.
We have done the same thing. Be aware that it makes upgrades a PITA - the installer is picky about the version, as well as various PG config options and refuses to run if you don't satisfy it. I hacked the installer, because that was easier than standing up an ancient Postgres just for the upgrade in our environment; YMMV. -j

In /etc/yum.repos.d/pgdg-94-centos.repo, I added : [pgdg94] ... exclude=postgresql-jdbc
Le 23 mai 2017 à 23:06, support@jac-properties.com a écrit :
Wow, that looks almost exactly like what we're seeing.
Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages.
Logan
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redhat.com> wrote:
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:
Hi
We recently upgraded from postgres 9.5.4 to 9.5.6 and then to 9.5.7. We restarted ovirt-engine between 9.5.4 and it worked as expected. After we updated to 9.5.7 we have started to get postgres errors in engine.log and a 404 error in the browser when we try to start ovirt-engine.
Updates were done on client and server to keep them in sync.
The error is complaining about a missing function, but we can verify that the function exists in the database. We've also restored engine and ovirt_engine_history from a backup at 8am this morning when it was working and before we upgraded to 9.5.7 with no apparent help and run engine-setup afterwards, still no luck.
2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing the DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Start initializing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend] (ServerService Thread Pool -- 51) [] Error during initialization: org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke public void org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost.cre ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHost@3a35f461 at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:126) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:162) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(AbstractContext.java:96) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:141) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:742) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:189) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(InstanceImpl.java:100) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Backend.java:301) [bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Backend.java:212) [bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend.java:159) [bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.java:117) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:103) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:73) [weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.weld.ejb.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100) [wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:263) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:374) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70) [wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]
A very similar report [1] was solved by downgrading postgresql-jdbc.
[1] http://lists.ovirt.org/pipermail/users/2017-April/081517.html
Best, -- Didi
Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

=20 On May 24, 2017 at 2:20 AM Fabrice Bacchella <fabrice.bacchella@orang= e.fr> wrote: =20 In /etc/yum.repos.d/pgdg-94-centos.repo, I added : =20 [pgdg94] ... exclude=3Dpostgresql-jdbc =20 > >=20
Le 23 mai 2017 =C3=A0 23:06, support@jac-properties.com a =C3=
=A9crit :
=20 Wow, that looks almost exactly like what we're seeing. =20 Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.= 0, restarting ovirt-engine and rerunning engine-setup produces the same err= or messages. =20 Logan =20 > > >=20
On May 23, 2017 at 3:39 PM Yedidyah Bar David <didi@redha=
t.com> wrote:
=20 On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support@jac= -properties.com> wrote: =20 > > > >=20
Hi =20 We recently upgraded from postgres 9.5.4 to 9.5.6 a=
nd then to 9.5.7. We
restarted ovirt-engine between 9.5.4 and it worked =
as expected. After we
updated to 9.5.7 we have started to get postgres er=
rors in engine.log and a
404 error in the browser when we try to start ovirt=
-engine.
=20 Updates were done on client and server to keep them= in sync. =20 The error is complaining about a missing function, = but we can verify that the function exists in the database. We've also res= tored engine and ovirt_engine_history from a backup at 8am this morn= ing when it was working and before we upgraded to 9.5.7 with no apparent he= lp and run engine-setup afterwards, still no luck. =20 2017-05-23 15:07:48,418 INFO [org.ovirt.engine.core= .dal.dbbroker.DbFacade] (ServerService Thread Pool -- 51) [] Initializing t= he DbFacade 2017-05-23 15:07:48,480 INFO [org.ovirt.engine.core= .bll.Backend] (ServerService Thread Pool -- 51) [] Start initiali= zing Backend 2017-05-23 15:07:48,502 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolP= erDc] (ServerService Thread Pool -- 46) [] Error initializing: PreparedS= tatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpool= id()]; nested exception is org.postgresql.util.PSQL Exception: ERROR: function getallmacpoolrangesbymac=
Hint: No function matches the given name and argume=
nt types. You might need
to add explicit type casts. Position: 16 2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.cor=
e.bll.Backend]
(ServerService Thread Pool -- 51) [] Error during i=
nitialization:
org.jboss.weld.exceptions.WeldException: WELD-00004=
9: Unable to invoke
public void org.ovirt.engine.core.bll.hostedengine.PreviousHost=
edEngineHost.cre
ate() on org.ovirt.engine.core.bll.hostedengine.PreviousHost=
edEngineHost@3a35f461
at org.jboss.weld.injection.producer.DefaultLifecycleC=
allbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.DefaultLifecycleC=
allbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:81)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.injection.producer.BasicInjectionTar=
get.postConstruct(BasicInjectionTarget.java:126)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ManagedBean.create(ManagedBe=
an.java:162)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.context.AbstractContext.get(Abstract=
Context.java:96)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$Defa=
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstanceStrategy$Appl=
icationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java= :141)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.ContextualInstance.get(Contextu=
alInstance.java:50)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.manager.BeanManagerImpl.getReference=
(BeanManagerImpl.java:742)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.getBeanIns=
tance(InstanceImpl.java:189)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.weld.bean.builtin.InstanceImpl.get(Instan=
ceImpl.java:100)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.ovirt.engine.core.bll.Backend.loadService(Ba=
ckend.java:301)
[bll.jar:] at org.ovirt.engine.core.bll.Backend.initialize(Bac=
kend.java:212)
[bll.jar:] at org.ovirt.engine.core.bll.Backend.create(Backend=
.java:159)
[bll.jar:] at sun.reflect.NativeMethodAccessorImpl.invoke0(Nat=
ive Method)
[rt.jar:1.8.0_131] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeM=
ethodAccessorImpl.java:62)
[rt.jar:1.8.0_131] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Del=
egatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_131] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131] at org.jboss.as.ee.component.ManagedReferenceLifecycle=
MethodInterceptor.processInvocation(ManagedReferenceLifecycleMethodIntercep= tor.java:96)
at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.=
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.del=
egateInterception(Jsr299BindingsInterceptor.java:70)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doL=
ifecycleInterception(Jsr299BindingsInterceptor.java:117)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.pro=
cessInvocation(Jsr299BindingsInterceptor.java:103)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.invocation.InterceptorContext$Invocation.=
------=_Part_140543_1458984575.1495632230498 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks, that's what we've put in place too Logan poolid() does not exist ultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) proceed(InterceptorContext.java:437) proceed(InterceptorContext.java:437)
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivatio=
nInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java= :73)
[weld-core-impl-2.3.5.Final.jar:2.3.5.Final] at org.jboss.as.weld.ejb.EjbRequestScopeActivationInte=
rceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInjectionIntercepto=
r.processInvocation(WeldInjectionInterceptor.java:53)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.ee.component.AroundConstructIntercepto=
rFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.weld.injection.WeldInterceptorInjectio=
nInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.ee.component.ComponentInstantiatorInte=
rceptor.processInvocation(ComponentInstantiatorInterceptor.java:74)
at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.weld.ejb.Jsr299BindingsCreateIntercept=
or.processInvocation(Jsr299BindingsCreateInterceptor.java:100)
[wildfly-weld-10.1.0.Final.jar:10.1.0.Final] at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.ee.component.NamespaceContextIntercept=
or.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(Int=
erceptorContext.java:340)
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(=
CMTTxInterceptor.java:263)
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTT=
xInterceptor.java:374)
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] at org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.proc=
essInvocation(LifecycleCMTTxInterceptor.java:70)
[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final] =20 > > >=20
A very similar report [1] was solved by downgrading postg= resql-jdbc. =20 [1] http://lists.ovirt.org/pipermail/users/2017-April/081= 517.html =20 Best, -- Didi =20 _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users =20 > >=20 >=20
is org.postgresql.util.PSQL<br>Exception: ERROR: function getallmacpoolran= gesbymacpoolid() does not exist<br>Hint: No function matches the given name= and argument types. You might need<br>to add explicit type casts.<br>Posit= ion: 16<br>2017-05-23 15:07:48,517 ERROR [org.ovirt.engine.core.bll.Backend= ]<br>(ServerService Thread Pool -- 51) [] Error during initialization:<br>o= rg.jboss.weld.exceptions.WeldException: WELD-000049: Unable to invoke<br>pu= blic void<br>org.ovirt.engine.core.bll.hostedengine.PreviousHostedEngineHos= t.cre<br>ate() on<br>org.ovirt.engine.core.bll.hostedengine.PreviousHostedE= ngineHost@3a35f461<br> at<br>org.jboss.weld.injection.producer.DefaultLifec= ycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:100)= <br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.i= njection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLife= cycleCallbackInvoker.java:81)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Fina= l]<br> at<br>org.jboss.weld.injection.producer.BasicInjectionTarget.postCon= struct(BasicInjectionTarget.java:126)<br>[weld-core-impl-2.3.5.Final.jar:2.= 3.5.Final]<br> at org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:1= 62)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.wel= d.context.AbstractContext.get(AbstractContext.java:96)<br>[weld-core-impl-2= .3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.bean.ContextualInstanc= eStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.= java:101)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jbo= ss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstance= Strategy.get(ContextualInstanceStrategy.java:141)<br>[weld-core-impl-2.3.5.= Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld.bean.ContextualInstance.get= (ContextualInstance.java:50)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final= ]<br> at<br>org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManager= Impl.java:742)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>or= g.jboss.weld.bean.builtin.InstanceImpl.getBeanInstance(InstanceImpl.java:18= 9)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<br>org.jboss.weld= .bean.builtin.InstanceImpl.get(InstanceImpl.java:100)<br>[weld-core-impl-2.= 3.5.Final.jar:2.3.5.Final]<br> at org.ovirt.engine.core.bll.Backend.loadSer= vice(Backend.java:301)<br>[bll.jar:]<br> at org.ovirt.engine.core.bll.Backe= nd.initialize(Backend.java:212)<br>[bll.jar:]<br> at org.ovirt.engine.core.= bll.Backend.create(Backend.java:159)<br>[bll.jar:]<br> at sun.reflect.Nativ= eMethodAccessorImpl.invoke0(Native Method)<br>[rt.jar:1.8.0_131]<br> at<br>= sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:6= 2)<br>[rt.jar:1.8.0_131]<br> at<br>sun.reflect.DelegatingMethodAccessorImpl= .invoke(DelegatingMethodAccessorImpl.java:43)<br>[rt.jar:1.8.0_131]<br> at = java.lang.reflect.Method.invoke(Method.java:498)<br>[rt.jar:1.8.0_131]<br> = at<br>org.jboss.as.ee.component.ManagedReferenceLifecycleMethodInterceptor.=
------=_Part_140543_1458984575.1495632230498 MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <!DOCTYPE html> <html><head> <meta charset=3D"UTF-8"> </head><body><p>Thanks, that's what we've put in place too<br></p><= p><br></p><p>Logan</p><blockquote><p>On May 24, 2017 at 2:20 AM Fabrice Bac= chella <fabrice.bacchella@orange.fr> wrote:</p><p>In /etc/yum.repos= .d/pgdg-94-centos.repo, I added :</p><p>[pgdg94]<br>...<br>exclude=3Dpostgr= esql-jdbc</p><blockquote><p>Le 23 mai 2017 à 23:06, support@jac-proper= ties.com a écrit :</p><p>Wow, that looks almost exactly like what we= 39;re seeing.</p><p>Unfortunately, downgrading from postgresql-jdbc-42.1.1 = to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the = same error messages.</p><p>Logan</p><blockquote><p>On May 23, 2017 at 3:39 = PM Yedidyah Bar David <didi@redhat.com> wrote:</p><p>On Tue, May 23= , 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> wrote:<= /p><blockquote><p>Hi</p><p>We recently upgraded from postgres 9.5.4 to 9.5.= 6 and then to 9.5.7. We<br>restarted ovirt-engine between 9.5.4 and it work= ed as expected. After we<br>updated to 9.5.7 we have started to get postgre= s errors in engine.log and a<br>404 error in the browser when we try to sta= rt ovirt-engine.</p><p>Updates were done on client and server to keep them = in sync.</p><p>The error is complaining about a missing function, but we ca= n verify that<br>the function exists in the database. We've also restor= ed engine and<br>ovirt_engine_history from a backup at 8am this morning whe= n it was working<br>and before we upgraded to 9.5.7 with no apparent help a= nd run engine-setup<br>afterwards, still no luck.</p><p>2017-05-23 15:07:48= ,418 INFO [org.ovirt.engine.core.dal.dbbroker.DbFacade]<br>(ServerService T= hread Pool -- 51) [] Initializing the DbFacade<br>2017-05-23 15:07:48,480 I= NFO [org.ovirt.engine.core.bll.Backend]<br>(ServerService Thread Pool -- 51= ) [] Start initializing Backend<br>2017-05-23 15:07:48,502 ERROR<br>[org.ov= irt.engine.core.bll.network.macpool.MacPoolPerDc] (ServerService<br>Thread = Pool -- 46) [] Error initializing: PreparedStatementCallback; bad SQL<br>gr= ammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception<br= processInvocation(ManagedReferenceLifecycleMethodInterceptor.java:96)<br> a= t<br>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.jav= a:340)<br> at<br>org.jboss.invocation.InterceptorContext$Invocation.proceed= (InterceptorContext.java:437)<br> at<br>org.jboss.as.weld.ejb.Jsr299Binding= sInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70)<br>[wi= ldfly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.as.weld.ejb.J= sr299BindingsInterceptor.doLifecycleInterception(Jsr299BindingsInterceptor.= java:117)<br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jbo= ss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsIn= terceptor.java:103)<br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<= br>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:= 340)<br> at<br>org.jboss.invocation.InterceptorContext$Invocation.proceed(I= nterceptorContext.java:437)<br> at<br>org.jboss.weld.ejb.AbstractEJBRequest= ScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationIn= terceptor.java:73)<br>[weld-core-impl-2.3.5.Final.jar:2.3.5.Final]<br> at<b= r>org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocat= ion(EjbRequestScopeActivationInterceptor.java:83)<br>[wildfly-weld-10.1.0.F= inal.jar:10.1.0.Final]<br> at<br>org.jboss.invocation.InterceptorContext.pr= oceed(InterceptorContext.java:340)<br> at<br>org.jboss.as.weld.injection.We= ldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:53)<= br>[wildfly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.invocat= ion.InterceptorContext.proceed(InterceptorContext.java:340)<br> at<br>org.j= boss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(= AroundConstructInterceptorFactory.java:28)<br> at<br>org.jboss.invocation.I= nterceptorContext.proceed(InterceptorContext.java:340)<br> at<br>org.jboss.= as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(Wel= dInterceptorInjectionInterceptor.java:56)<br>[wildfly-weld-10.1.0.Final.jar= :10.1.0.Final]<br> at<br>org.jboss.invocation.InterceptorContext.proceed(In= terceptorContext.java:340)<br> at<br>org.jboss.as.ee.component.ComponentIns= tantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.jav= a:74)<br> at<br>org.jboss.invocation.InterceptorContext.proceed(Interceptor= Context.java:340)<br> at<br>org.jboss.as.weld.ejb.Jsr299BindingsCreateInter= ceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:100)<br>[wild= fly-weld-10.1.0.Final.jar:10.1.0.Final]<br> at<br>org.jboss.invocation.Inte= rceptorContext.proceed(InterceptorContext.java:340)<br> at<br>org.jboss.as.= ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContext= Interceptor.java:50)<br> at<br>org.jboss.invocation.InterceptorContext.proc= eed(InterceptorContext.java:340)<br> at<br>org.jboss.as.ejb3.tx.CMTTxInterc= eptor.invokeInNoTx(CMTTxInterceptor.java:263)<br>[wildfly-ejb3-10.1.0.Final= .jar:10.1.0.Final]<br> at<br>org.jboss.as.ejb3.tx.CMTTxInterceptor.supports= (CMTTxInterceptor.java:374)<br>[wildfly-ejb3-10.1.0.Final.jar:10.1.0.Final]= <br> at<br>org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation= (LifecycleCMTTxInterceptor.java:70)<br>[wildfly-ejb3-10.1.0.Final.jar:10.1.= 0.Final]</p></blockquote><p>A very similar report [1] was solved by downgra= ding postgresql-jdbc.</p><p>[1] <a href=3D"http://lists.ovirt.org/pipermail= /users/2017-April/081517.html">http://lists.ovirt.org/pipermail/users/2017-= April/081517.html</a></p><p>Best,<br>--<br>Didi</p><p>_____________________= __________________________<br>Users mailing list<br>Users@ovirt.org<br><a h= ref=3D"http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.or= g/mailman/listinfo/users</a></p></blockquote></blockquote></blockquote></bo= dy></html> =20 ------=_Part_140543_1458984575.1495632230498--
participants (6)
-
Fabrice Bacchella
-
Jamie Lawrence
-
Logan Kuhn
-
Martin Perina
-
support@jac-properties.com
-
Yedidyah Bar David