5:19 a.m.
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]
5:39 a.m.
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support(a)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
6:06 a.m.
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(a)redhat.com>
wrote:
On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support(a)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
6:15 a.m.
On Wed, May 24, 2017 at 12:06 AM, <support(a)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(a)redhat.com> wrote:
>
>
> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support(a)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
6:53 a.m.
------=_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(a)redhat.com> wrote:
On Wed, May 24, 2017 at 12:06 AM, <support(a)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(a)redhat.com> wrote:
> >
> > On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn
<support(a)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 &#60;didi(a)redhat.com&#62; wrot=
e:</p><p>On Wed, May 24, 2017 at 12:06 AM,
&#60;support(a)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 &#60;didi(a)redhat.com&#62; wrote:</p><p>On Tue, May 23, 2017 at 11:19
PM, =
Logan Kuhn &#60;support(a)jac-properties.com&#62;
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/08...
/a></p><p>Best,<br>--<br>Didi</p></blockquote></blockquote><p>--<br>Didi</p=
</blockquote></body></html>
=20
------=_Part_117131_1593059334.1495576400315--
4:20 p.m.
In /etc/yum.repos.d/pgdg-94-centos.repo, I added :
[pgdg94]
...
exclude=postgresql-jdbc
Le 23 mai 2017 à 23:06, support(a)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(a)redhat.com> wrote:
>
>
> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
7:24 p.m.
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(a)redhat.com>
wrote:
On Wed, May 24, 2017 at 12:06 AM, <support(a)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(a)redhat.com> wrote:
>>
>>
>> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <
support(a)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.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.
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.AbstractEJBRequestScopeActivat
ionInterceptor.aroundInvoke(AbstractEJBRequestScopeActivat
ionInterceptor.java:73)
>> > [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.
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.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.
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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
10:23 p.m.
------=_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
=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(a)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=
poolid() does not exist
> > > 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=
ultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101)
> > >
[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.=
proceed(InterceptorContext.java:437)
> > > 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.=
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(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >=20
> > > >=20
> >=20
------=_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 &#60;fabrice.bacchella(a)orange.fr&#62; 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 &#60;didi(a)redhat.com&#62; wrote:</p><p>On Tue,
May 23=
, 2017 at 11:19 PM, Logan Kuhn &#60;support(a)jac-properties.com&#62; 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=
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.=
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(a)ovirt.org<br><a h=
ref=3D"http://lists.ovirt.org/mailman/listinfo/users">http:/...
g/mailman/listinfo/users</a></p></blockquote></blockquote></blockquote></bo=
dy></html>
=20
------=_Part_140543_1458984575.1495632230498--
10:25 p.m.
------=_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(a)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(a)redhat.com
mailto:didi@redhat.com > wrote:
> > On Wed, May 24, 2017 at 12:06 AM, <support(a)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(a)redhat.com
mailto:didi@redhat.com > wrote:
> >>
> >>
> >> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn
<support(a)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(a)ovirt.org mailto:Users@ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
http://lists.ovirt.org/mailman/listinfo/users
>
> >
------=_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
&#60;mperina(a)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(a)redhat.com</a>&#62;
wrote:<br><blockquote>On W=
ed, May 24, 2017 at 12:06 AM,  <<a
href=3D"mailto:support@jac-prop=
erties.com">support(a)jac-properties.com</a>&#62; 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/=
() 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=
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--
11:04 p.m.
--Apple-Mail=_7A63A86B-C79F-4862-869A-B52949907F85
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=utf-8
Le 24 mai 2017 =C3=A0 15:25, support(a)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 =
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(a)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--
11:26 p.m.
On Wed, May 24, 2017 at 5:04 PM, Fabrice Bacchella
<fabrice.bacchella(a)orange.fr> wrote:
Le 24 mai 2017 à 15:25, support(a)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
12:03 a.m.
Le 24 mai 2017 à 16:26, Yedidyah Bar David <didi(a)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!
Done:
https://bugzilla.redhat.com/show_bug.cgi?id=1455262
7:19 a.m.
On May 24, 2017, at 6:25 AM, support(a)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
2524
days inactive
2533
days old
12 comments
6 participants
participants (6)
-
Fabrice Bacchella -
Jamie Lawrence -
Logan Kuhn -
Martin Perina -
support＠jac-properties.com
-
Yedidyah Bar David