<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
</head><body><p>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><br></p><p>Is this worth putting in an RFE?  Support for postgresql-jdbc 42+ and postgresql 9.5+</p><p><br></p><p>Logan</p><blockquote type="cite">On May 24, 2017 at 5:24 AM Martin Perina <mperina@redhat.com> wrote:<br><br><div dir="ltr"><div class="ox-03f7f44247-gmail_default" style="font-family: arial,helvetica,sans-serif;">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.<br></div></div><div class="ox-03f7f44247-gmail_extra"><br><div class="ox-03f7f44247-gmail_quote">On Tue, May 23, 2017 at 11:15 PM, Yedidyah Bar David <<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>> wrote:<br><blockquote>On Wed, May 24, 2017 at 12:06 AM,  <<a href="mailto:support@jac-properties.com">support@jac-properties.com</a>> wrote:<br> > Wow, that looks almost exactly like what we're seeing.<br> ><br> > Unfortunately, downgrading from postgresql-jdbc-42.1.1 to 42.0.0, restarting ovirt-engine and rerunning engine-setup produces the same error messages.<br> ><br> <br> Please try 9.2. Thanks!<br> <br> > Logan<br> ><br> >> On May 23, 2017 at 3:39 PM Yedidyah Bar David <<a href="mailto:didi@redhat.com">didi@redhat.com</a>> wrote:<br> >><br> >><br> >> On Tue, May 23, 2017 at 11:19 PM, Logan Kuhn <<a href="mailto:support@jac-properties.com">support@jac-properties.com</a>> 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 worked as expected.  After we<br> >> > updated to 9.5.7 we have started to get postgres errors in engine.log and a<br> >> > 404 error in the browser when we try to start ovirt-engine.<br> >> ><br> >> > Updates were done on client and server to keep them in sync.<br> >> ><br> >> > The error 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> >> > ovirt_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.<br> >> ><br> >> > 2017-05-23 15:07:48,418 INFO  [org.ovirt.engine.core.dal.<wbr/>dbbroker.DbFacade]<br> >> > (ServerService Thread Pool -- 51) [] Initializing the DbFacade<br> >> > 2017-05-23 15:07:48,480 INFO  [org.ovirt.engine.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/>Backend]<br> >> > (ServerService Thread Pool -- 51) [] Error during initialization:<br> >> > org.jboss.weld.exceptions.<wbr/>WeldException: WELD-000049: Unable to invoke<br> >> > public void<br> >> > org.ovirt.engine.core.bll.<wbr/>hostedengine.<wbr/>PreviousHostedEngineHost.cre<br> >> > ate() on<br> >> > org.ovirt.engine.core.bll.<wbr/>hostedengine.<wbr/>PreviousHostedEngineHost@<wbr/>3a35f461<br> >> >        at<br> >> > org.jboss.weld.injection.<wbr/>producer.<wbr/>DefaultLifecycleCallbackInvoke<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/>DefaultLifecycleCallbackInvoke<wbr/>r.postConstruct(<wbr/>DefaultLifecycleCallbackInvoke<wbr/>r.java:81)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.injection.<wbr/>producer.BasicInjectionTarget.<wbr/>postConstruct(<wbr/>BasicInjectionTarget.java:126)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at org.jboss.weld.bean.<wbr/>ManagedBean.create(<wbr/>ManagedBean.java:162)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.context.<wbr/>AbstractContext.get(<wbr/>AbstractContext.java:96)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.bean.<wbr/>ContextualInstanceStrategy$<wbr/>DefaultContextualInstanceStrat<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/>ApplicationScopedContextualIns<wbr/>tanceStrategy.get(<wbr/>ContextualInstanceStrategy.<wbr/>java:141)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.bean.<wbr/>ContextualInstance.get(<wbr/>ContextualInstance.java:50)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.manager.<wbr/>BeanManagerImpl.getReference(<wbr/>BeanManagerImpl.java:742)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.bean.builtin.<wbr/>InstanceImpl.getBeanInstance(<wbr/>InstanceImpl.java:189)<br> >> > [weld-core-impl-2.3.5.Final.<wbr/>jar:2.3.5.Final]<br> >> >        at<br> >> > org.jboss.weld.bean.builtin.<wbr/>InstanceImpl.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.<wbr/>java:301)<br> >> > [bll.jar:]<br> >> >        at org.ovirt.engine.core.bll.<wbr/>Backend.initialize(Backend.<wbr/>java:212)<br> >> > [bll.jar:]<br> >> >        at org.ovirt.engine.core.bll.<wbr/>Backend.create(Backend.java:<wbr/>159)<br> >> > [bll.jar:]<br> >> >        at sun.reflect.<wbr/>NativeMethodAccessorImpl.<wbr/>invoke0(Native Method)<br> >> > [rt.jar:1.8.0_131]<br> >> >        at<br> >> > sun.reflect.<wbr/>NativeMethodAccessorImpl.<wbr/>invoke(<wbr/>NativeMethodAccessorImpl.java:<wbr/>62)<br> >> > [rt.jar:1.8.0_131]<br> >> >        at<br> >> > sun.reflect.<wbr/>DelegatingMethodAccessorImpl.<wbr/>invoke(<wbr/>DelegatingMethodAccessorImpl.<wbr/>java:43)<br> >> > [rt.jar:1.8.0_131]<br> >> >        at java.lang.reflect.Method.<wbr/>invoke(Method.java:498)<br> >> > [rt.jar:1.8.0_131]<br> >> >        at<br> >> > org.jboss.as.ee.component.<wbr/>ManagedReferenceLifecycleMetho<wbr/>dInterceptor.<wbr/>processInvocation(<wbr/>ManagedReferenceLifecycleMetho<wbr/>dInterceptor.java:96)<br> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext$Invocation.<wbr/>proceed(InterceptorContext.<wbr/>java:437)<br> >> >        at<br> >> > org.jboss.as.weld.ejb.<wbr/>Jsr299BindingsInterceptor.<wbr/>delegateInterception(<wbr/>Jsr299BindingsInterceptor.<wbr/>java:70)<br> >> > [wildfly-weld-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >        at<br> >> > org.jboss.as.weld.ejb.<wbr/>Jsr299BindingsInterceptor.<wbr/>doLifecycleInterception(<wbr/>Jsr299BindingsInterceptor.<wbr/>java:117)<br> >> > [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/>Jsr299BindingsInterceptor.<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/>InterceptorContext$Invocation.<wbr/>proceed(InterceptorContext.<wbr/>java:437)<br> >> >        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> >> >        at<br> >> > org.jboss.as.weld.ejb.<wbr/>EjbRequestScopeActivationInter<wbr/>ceptor.processInvocation(<wbr/>EjbRequestScopeActivationInter<wbr/>ceptor.java:83)<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.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> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >        at<br> >> > org.jboss.as.ee.component.<wbr/>AroundConstructInterceptorFact<wbr/>ory$1.processInvocation(<wbr/>AroundConstructInterceptorFact<wbr/>ory.java:28)<br> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >        at<br> >> > org.jboss.as.weld.injection.<wbr/>WeldInterceptorInjectionInterc<wbr/>eptor.processInvocation(<wbr/>WeldInterceptorInjectionInterc<wbr/>eptor.java:56)<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.as.ee.component.<wbr/>ComponentInstantiatorIntercept<wbr/>or.processInvocation(<wbr/>ComponentInstantiatorIntercept<wbr/>or.java:74)<br> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >        at<br> >> > org.jboss.as.weld.ejb.<wbr/>Jsr299BindingsCreateIntercepto<wbr/>r.processInvocation(<wbr/>Jsr299BindingsCreateIntercepto<wbr/>r.java:100)<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.as.ee.component.<wbr/>NamespaceContextInterceptor.<wbr/>processInvocation(<wbr/>NamespaceContextInterceptor.<wbr/>java:50)<br> >> >        at<br> >> > org.jboss.invocation.<wbr/>InterceptorContext.proceed(<wbr/>InterceptorContext.java:340)<br> >> >        at<br> >> > org.jboss.as.ejb3.tx.<wbr/>CMTTxInterceptor.invokeInNoTx(<wbr/>CMTTxInterceptor.java:263)<br> >> > [wildfly-ejb3-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >        at<br> >> > org.jboss.as.ejb3.tx.<wbr/>CMTTxInterceptor.supports(<wbr/>CMTTxInterceptor.java:374)<br> >> > [wildfly-ejb3-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> >        at<br> >> > org.jboss.as.ejb3.tx.<wbr/>LifecycleCMTTxInterceptor.<wbr/>processInvocation(<wbr/>LifecycleCMTTxInterceptor.<wbr/>java:70)<br> >> > [wildfly-ejb3-10.1.0.Final.<wbr/>jar:10.1.0.Final]<br> >> ><br> >><br> >> A very similar report [1] was solved by downgrading postgresql-jdbc.<br> >><br> >> [1] <a href="http://lists.ovirt.org/pipermail/users/2017-April/081517.html" target="_blank">http://lists.ovirt.org/<wbr/>pipermail/users/2017-April/<wbr/>081517.html</a><br> >><br> >> Best,<br> <span class="ox-03f7f44247-HOEnZb"><span style="color: #888888;">>> --<br> >> Didi<br> <br> <br> <br> --<br> Didi<br> ______________________________<wbr/>_________________<br> Users mailing list<br> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/<wbr/>mailman/listinfo/users</a><br> </span></span></blockquote></div><br></div></blockquote></body></html>