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