<div dir="ltr"><div class="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="gmail_extra"><br><div class="gmail_quote">On Tue, May 23, 2017 at 11:15 PM, Yedidyah Bar David <span dir="ltr"><<a href="mailto:didi@redhat.com" target="_blank">didi@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>pipermail/users/2017-April/<wbr>081517.html</a><br>
>><br>
>> Best,<br>
<span class="HOEnZb"><font 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" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
</font></span></blockquote></div><br></div>