=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@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=
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=
[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.=
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.=
------=_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 poolid() does not exist ultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:101) proceed(InterceptorContext.java:437) 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users =20 > >=20 >=20
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.=
------=_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 <fabrice.bacchella@orange.fr> 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 <didi@redhat.com> wrote:</p><p>On Tue, May 23= , 2017 at 11:19 PM, Logan Kuhn <support@jac-properties.com> 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= 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@ovirt.org<br><a h= ref=3D"http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.or= g/mailman/listinfo/users</a></p></blockquote></blockquote></blockquote></bo= dy></html> =20 ------=_Part_140543_1458984575.1495632230498--