Hi guys,

thanks for sharing. I can confirm that solved my problem.

I missed the email from Martin from 22th April. I wasn't member of mailing list yet. Maybe this information from Martin's email could be in release notes for 4.4.10 and 4.5.0 as known issue:
https://www.ovirt.org/release/4.4.10/#known-issues

Anyway, thanks again.

Regards
Honza


On 4/30/22 10:46, Maton, Brett wrote:
I ran in to this problem yesterday, if you've already upgraded 'everything' you can roll back the postgresql driver with

dnf downgrade postgresql-jdbc

and then restart the engine

systemctl restart ovirt-engine



On Sat, 30 Apr 2022 at 08:10, Latchezar Filtchev <lat...@aubg.bg> wrote:

    Dear Jan,

    Please check Martin's e-mail from 22.04.2022 (below). I confirm
    the workaround works for me.

    Best,
    Latcho]

    From: Martin Perina <mper...@redhat.com>
    Sent: Friday, April 22, 2022 6:35 PM
    To: users <users@ovirt.org>; devel <de...@ovirt.org>
    Cc: Eli Mesika <emes...@redhat.com>
    Subject: [ovirt-users] [IMPORTANT] Upgrade to
    postgresql-jdbc-42.2.14-1 breaks oVirt Engine 4.4/4.5

    Hi,
    Unfortunately we have just found that latest release of
    postgresql-jdbc-42.2.14-1 breaks existing oVirt Engine 4.4 and 4.5
    installations running on CentOS Stream.
    The workaround is to downgrade to previous version, for example
    postgresql-jdbc-42.2.3-3 should work fine.

    Here are detailed instructions:

    1. If you have already upgraded to postgresql-jdbc-42.2.14-1,
    please downgrade to previous version:

        $ dnf downgrade postgresql-jdbc
        $ systemctl restart ovirt-engine

    2. If you are going to upgrade your oVirt Engine machine, please
    exclude postgresql-jdbc package from upgrades:

        $ dnf update -x postgresql-jdbc

    We have created https://bugzilla.redhat.com/2077794 to track this
    issue, but unfortunately we don't have a fix yet.

    Regards,
    Martin

-- Martin Perina
    Manager, Software Engineering
    Red Hat Czech s.r.o.

    -----Original Message-----
    From: Jan Burian <jan.bur...@elostech.cz>
    Sent: Friday, April 29, 2022 9:19 PM
    To: users@ovirt.org
    Subject: [ovirt-users] Cannot start ovirt-engine java server - 500
    Internal Server Error - after update to 4.4.10

    Hi there,

    I updated hosted ovirt engine from within VM.
    At first I updated OS - yum update.
    Then rebooted VM.
    After VM booted again, I found out I cannot access GUI.

    Then I found out I had to run engine-setup even when updating
    between releases.
    So then I put cluster in global maintenance mode.
    And run engine-setup.
    The setup finished successfully.
    But the GUI is still not accessible. I got 500 Internal server error.
    Even after reboot or if I run engine-setup again. The errors are
    the same.

    In the engine.log is no error.
    There are errors in server.log.

    I updated from ovirt-engine-4.4.9.5-1.el8.noarch to
    ovirt-engine-4.4.10.7-1.el8.noarch.

    I tried to find some solution, but no luck.
    The part of error about failing to start engine.ear is common.
    But the java Caused by: error looks like different then I was able
    to find.

    Anyone who is able to find out where the problem lies and any tips
    for possible solution?

    Thanks.
    Regards
    Honza


    The errors from server.log:
    ----------------------------------------------------------------------
    2022-04-29 17:17:44,924+02 INFO [org.wildfly.extension.undertow]
    (ServerService Thread Pool -- 53) WFLYUT0021: Registered web context:
    '/ovirt-engine/webadmin' for server 'default-server'

    2022-04-29 17:17:45,110+02 INFO
    [org.springframework.jdbc.support.SQLErrorCodesFactory]
    (ServerService Thread Pool -- 54) SQLErrorCodes loaded: [DB2,
    Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL,
    Sybase, Hana]
    2022-04-29 17:17:45,187+02 ERROR [org.jboss.msc.service.fail]
    (ServerService Thread Pool -- 54) MSC000001: Failed to start service
    jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START:

    org.jboss.msc.service.StartException in service
    jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START:

    java.lang.IllegalStateException: WFLYEE0042: Failed to construct
    component instance
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:57)
         at
    
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
         at
    java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
         at
    
org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
         at
    
org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
         at
    
org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
         at
    
org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
         at java.base/java.lang.Thread.run(Thread.java:829)
         at
    
org.jboss.threads@2.4.0.Final//org.jboss.threads.JBossThread.run(JBossThread.java:513)
    Caused by: java.lang.IllegalStateException: WFLYEE0042: Failed to
    construct component instance
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:163)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:134)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:88)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:127)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.component.singleton.SingletonComponent.start(SingletonComponent.java:141)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.ComponentStartService$1.run(ComponentStartService.java:54)
         ... 8 more
    Caused by: javax.ejb.EJBException:
    org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to
    invoke protected void
    org.ovirt.engine.core.bll.TagsDirector.init() on
    org.ovirt.engine.core.bll.TagsDirector@3d922f2d
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:239)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:446)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.tx.LifecycleCMTTxInterceptor.processInvocation(LifecycleCMTTxInterceptor.java:70)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.weld@23.0.2.Final//org.jboss.as.weld.injection.WeldInjectionContextInterceptor.processInvocation(WeldInjectionContextInterceptor.java:43)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.component.singleton.StartupCountDownInterceptor.processInvocation(StartupCountDownInterceptor.java:25)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161)
         ... 13 more
    Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049:
    Unable to invoke protected void
    org.ovirt.engine.core.bll.TagsDirector.init()
    on org.ovirt.engine.core.bll.TagsDirector@3d922f2d
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:85)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.postConstruct(DefaultLifecycleCallbackInvoker.java:66)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.BasicInjectionTarget.postConstruct(BasicInjectionTarget.java:122)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.ManagedBean.create(ManagedBean.java:174)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.contexts.AbstractContext.get(AbstractContext.java:96)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.ContextualInstanceStrategy$DefaultContextualInstanceStrategy.get(ContextualInstanceStrategy.java:100)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.ContextualInstanceStrategy$ApplicationScopedContextualInstanceStrategy.get(ContextualInstanceStrategy.java:140)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.ContextualInstance.get(ContextualInstance.java:50)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.manager.BeanManagerImpl.getReference(BeanManagerImpl.java:694)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.manager.BeanManagerImpl.getInjectableReference(BeanManagerImpl.java:794)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.FieldInjectionPoint.inject(FieldInjectionPoint.java:92)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.util.Beans.injectBoundFields(Beans.java:336)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.util.Beans.injectFieldsAndInitializers(Beans.java:347)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.DefaultInjector$1.proceed(DefaultInjector.java:71)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.InjectionContextImpl.run(InjectionContextImpl.java:48)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.DefaultInjector.inject(DefaultInjector.java:73)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.module.ejb.DynamicInjectionPointInjector.inject(DynamicInjectionPointInjector.java:61)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.module.ejb.SessionBeanInjectionTarget.inject(SessionBeanInjectionTarget.java:138)
         at
    
org.jboss.as.weld@23.0.2.Final//org.jboss.as.weld.injection.WeldInjectionContext.inject(WeldInjectionContext.java:39)
         at
    
org.jboss.as.weld@23.0.2.Final//org.jboss.as.weld.injection.WeldInjectionInterceptor.processInvocation(WeldInjectionInterceptor.java:51)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.AroundConstructInterceptorFactory$1.processInvocation(AroundConstructInterceptorFactory.java:28)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.weld@23.0.2.Final//org.jboss.as.weld.injection.WeldInterceptorInjectionInterceptor.processInvocation(WeldInterceptorInjectionInterceptor.java:56)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.ComponentInstantiatorInterceptor.processInvocation(ComponentInstantiatorInterceptor.java:74)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.weld@23.0.2.Final//org.jboss.as.weld.interceptors.Jsr299BindingsCreateInterceptor.processInvocation(Jsr299BindingsCreateInterceptor.java:111)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ee@23.0.2.Final//org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
         at
    
org.jboss.invocation@1.6.0.Final//org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
         at
    
org.jboss.as.ejb3@23.0.2.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:232)
         ... 28 more
    Caused by: java.lang.reflect.InvocationTargetException
         at
    java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
         at
    
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
         at
    
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
         at
    
org.jboss.weld.core@3.1.6.Final//org.jboss.weld.injection.producer.DefaultLifecycleCallbackInvoker.invokeMethods(DefaultLifecycleCallbackInvoker.java:83)
         ... 59 more
    Caused by:
    org.springframework.dao.InvalidDataAccessApiUsageException:
    Unable to determine the correct call signature - no
    procedure/function/signature for 'gettagsbyparent_id'
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.processProcedureColumns(GenericCallMetaDataProvider.java:362)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider.initializeWithProcedureColumnMetaData(GenericCallMetaDataProvider.java:114)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.lambda$createMetaDataProvider$0(CallMetaDataProviderFactory.java:127)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:324)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory.createMetaDataProvider(CallMetaDataProviderFactory.java:70)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.metadata.CallMetaDataContext.initializeMetaData(CallMetaDataContext.java:252)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.simple.AbstractJdbcCall.compileInternal(AbstractJdbcCall.java:313)
         at
    
org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.PostgresDbEngineDialect$PostgresSimpleJdbcCall.compileInternal(PostgresDbEngineDialect.java:106)
         at
    
org.springframework@5.0.4.RELEASE//org.springframework.jdbc.core.simple.AbstractJdbcCall.compile(AbstractJdbcCall.java:296)
         at
    
org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.getCall(SimpleJdbcCallsHandler.java:157)
         at
    
org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeImpl(SimpleJdbcCallsHandler.java:134)
         at
    
org.ovirt.engine.core.dal//org.ovirt.engine.core.dal.dbbroker.SimpleJdbcCallsHandler.executeReadList(SimpleJdbcCallsHandler.java:105)
         at
    
org.ovirt.engine.core.dal//org.ovirt.engine.core.dao.TagDaoImpl.getAllForParent(TagDaoImpl.java:82)
         at
    
deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.TagsDirector.addChildren(TagsDirector.java:116)
         at
    
deployment.engine.ear.bll.jar//org.ovirt.engine.core.bll.TagsDirector.init(TagsDirector.java:75)
         ... 64 more

    2022-04-29 17:17:47,922+02 INFO [org.wildfly.extension.undertow]
    (ServerService Thread Pool -- 56) WFLYUT0021: Registered web context:
    '/ovirt-engine/sso' for server 'default-server'
    2022-04-29 17:17:47,929+02 ERROR
    [org.jboss.as.controller.management-operation] (Controller Boot
    Thread)
    WFLYCTL0013: Operation ("deploy") failed - address: ([("deployment" =>
    "engine.ear")]) - failure description: {"WFLYCTL0080: Failed
    services"
    =>
    
{"jboss.deployment.subunit.\"engine.ear\".\"bll.jar\".component.Backend.START"

    => "java.lang.IllegalStateException: WFLYEE0042: Failed to
    construct component instance
         Caused by: java.lang.IllegalStateException: WFLYEE0042:
    Failed to construct component instance
         Caused by: javax.ejb.EJBException:
    org.jboss.weld.exceptions.WeldException: WELD-000049: Unable to
    invoke protected void
    org.ovirt.engine.core.bll.TagsDirector.init() on
    org.ovirt.engine.core.bll.TagsDirector@3d922f2d
         Caused by: org.jboss.weld.exceptions.WeldException: WELD-000049:
    Unable to invoke protected void
    org.ovirt.engine.core.bll.TagsDirector.init() on
    org.ovirt.engine.core.bll.TagsDirector@3d922f2d
         Caused by: java.lang.reflect.InvocationTargetException
         Caused by:
    org.springframework.dao.InvalidDataAccessApiUsageException: Unable
    to determine the correct call signature - no
    procedure/function/signature for 'gettagsbyparent_id'"}}
    2022-04-29 17:17:47,948+02 INFO  [org.jboss.as.server]
    (ServerService Thread Pool -- 25) WFLYSRV0010: Deployed
    "ovirt-web-ui.war"
    (runtime-name : "ovirt-web-ui.war")
    2022-04-29 17:17:48,020+02 INFO  [org.jboss.as.server]
    (ServerService Thread Pool -- 25) WFLYSRV0010: Deployed
    "apidoc.war" (runtime-name :
    "apidoc.war")
    2022-04-29 17:17:48,020+02 INFO  [org.jboss.as.server]
    (ServerService Thread Pool -- 25) WFLYSRV0010: Deployed
    "restapi.war" (runtime-name :
    "restapi.war")
    2022-04-29 17:17:48,020+02 INFO  [org.jboss.as.server]
    (ServerService Thread Pool -- 25) WFLYSRV0010: Deployed
    "engine.ear" (runtime-name :
    "engine.ear")
    2022-04-29 17:17:48,031+02 INFO  [org.jboss.as.controller]
    (Controller Boot Thread) WFLYCTL0183: Service status report
    WFLYCTL0186:   Services which failed to start:      service
    jboss.deployment.subunit."engine.ear"."bll.jar".component.Backend.START:

    java.lang.IllegalStateException: WFLYEE0042: Failed to construct
    component instance
    WFLYCTL0448: 2 additional services are down due to their
    dependencies being missing or failed
    2022-04-29 17:17:48,076+02 INFO  [org.jboss.as.server] (Controller
    Boot
    Thread) WFLYSRV0212: Resuming server
    2022-04-29 17:17:48,081+02 ERROR [org.jboss.as
    <http://org.jboss.as>] (Controller Boot Thread)
    WFLYSRV0026: WildFly Full 23.0.2.Final (WildFly Core 15.0.1.Final)
    started (with errors) in 15315ms - Started 1668 of 1888 services
    (6 services failed or missing dependencies, 393 services are lazy,
    passive or on-demand)
    2022-04-29 17:17:48,083+02 INFO  [org.jboss.as
    <http://org.jboss.as>] (Controller Boot Thread)
    WFLYSRV0060: Http management interface listening on
    http://127.0.0.1:8706/management
    2022-04-29 <http://127.0.0.1:8706/management2022-04-29>
    17:17:48,083+02 INFO  [org.jboss.as <http://org.jboss.as>]
    (Controller Boot Thread)
    WFLYSRV0051: Admin console listening on http://127.0.0.1:8706
    ----------------------------------------------------------------------

    _______________________________________________
    Users mailing list -- users@ovirt.org
    To unsubscribe send an email to users-le...@ovirt.org Privacy
    Statement: https://www.ovirt.org/privacy-policy.html
    oVirt Code of Conduct:
    https://www.ovirt.org/community/about/community-guidelines/
    List Archives:
    
https://lists.ovirt.org/archives/list/users@ovirt.org/message/7T7ZRYAG57ZSOOX5Z5VT6CRBBSL4U5IZ/
    _______________________________________________
    Users mailing list -- users@ovirt.org
    To unsubscribe send an email to users-le...@ovirt.org
    Privacy Statement: https://www.ovirt.org/privacy-policy.html
    oVirt Code of Conduct:
    https://www.ovirt.org/community/about/community-guidelines/
    List Archives:
    
https://lists.ovirt.org/archives/list/users@ovirt.org/message/25TASD5RTT24H2EITCJBF4YNQ6PCJ35T/
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/L2SDVPCPA3KZMR73C74UE7GCMQH5BBKN/

Reply via email to