there is a known issue with postgresql jdbc driver, see [1]
[1]
https://lists.ovirt.org/archives/list/users@ovirt.org/message/3IQ5C4AK4K65MVEHCIWDAREWW4QPF5KJ/
On Tue, Apr 26, 2022 at 1:58 PM lists--- via Users wrote:
>
> Hello,
>
> today i updated from 4.4 to 4.5 and i am no longer able to access my oVirt
> Cluster. Accessing oVirt Web Interface fails with "500 - Internal Server
> Error". The API is also dead, My Backup Software and Foreman is no longer
> able to talk to oVirt.
>
> I rebooted the host an ran engine-setup again, it completed without issues
> but Engine ist still dead. If i ran it again, it tells me now that my cluster
> is not in global maintanance mode, but "hosted-engine --vm-status" tells me
> it is still in maintanance mode.
>
> one suspect thing i found in server.log is this:
>
> 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-26 12:32:32,129+02 INFO [org.wildfly.extension.undertow]
> (ServerService Thread Pool -- 60) WFLYUT0021: Registered web context:
> '/ovirt-engine/sso' for server 'default-server'
> 2022-04-26 12:32:32,137+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-49: Unable to invoke
> protected void org.ovirt.engine.core.bll.TagsDirector.init() on
> org.ovirt.engine.core.bll.TagsDirector@21c5d21d
> Caused by: org.jboss.weld.exceptions.WeldException: WELD-49: Unable
> to invoke protected void org.ovirt.engine.core.bll.TagsDirector.init() on
> org.ovirt.engine.core.bll.TagsDirector@21c5d21d
> 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-26 12:32:32,158+02 INFO [org.jboss.as.server] (ServerService Thread
> Pool -- 27) WFLYSRV0010: Deployed "ovirt-web-ui.war" (runtime-name :
> "ovirt-web-ui.war")
> 2022-04-26 12:32:32,159+02 INFO [org.jboss.as.server] (ServerService Thread
> Pool -- 27) WFLYSRV0010: Deployed "apidoc.war" (runtime-name : "apidoc.war")
> 2022-04-26 12:32:32,159+02 INFO [org.jboss.as.server] (ServerService Thread
> Pool -- 27) WFLYSRV0010: Deployed "restapi.war" (runtime-name : "restapi.war")
> 2022-04-26 12:32:32,159+02 INFO [org.jboss.as.server] (ServerService Thread
> Pool -- 27) WFLYSRV0010: Deployed "engine.ear" (runtime-name : "engine.ear")
> 2022-04-26 12:32:32,167+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
>