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