[ovirt-users] Postgres errors after updating to 9.5.7 from 9.5.4
support at jac-properties.com
support at jac-properties.com
Wed May 24 13:25:45 UTC 2017
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 at 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 at redhat.com mailto:didi at redhat.com > wrote:
>
> > > On Wed, May 24, 2017 at 12:06 AM, <support at jac-properties.com mailto:support at 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 at redhat.com mailto:didi at redhat.com > wrote:
> > >>
> > >>
> > >> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <support at jac-properties.com mailto:support at 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 at 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 at ovirt.org mailto:Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users http://lists.ovirt.org/mailman/listinfo/users
> >
> > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20170524/f8766054/attachment-0001.html>
More information about the Users
mailing list