RHV : Hosts reporting Non-operational with error message "Failed to configure management network on the host"
Issue
-
Activating host reports error Failed to configure management network on the host.
-
Engine.log
2018-02-27 08:57:02,724+03 ERROR [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (org.ovirt.thread.pool-6-thread-29) [6440280b] EVENT_ID: VDS_INSTALL_FAILED(505), Correlation ID: 6440280b, Job ID: df245970-0951-4e50-b4a6-a31a7e5ed54d, Call Stack: null, Custom Event ID: -1, Message: Host redhat-host-1 installation failed. Failed to configure management network on the host.
- Engine.log
2018-02-27 08:57:02,708+03 ERROR [org.ovirt.engine.core.vdsbroker.vdsbroker.CollectVdsNetworkDataAfterInstallationVDSCommand] (org.ovirt.thread.pool-6-thread-29) [6440280b] Failed in 'CollectVdsNetworkDataAfterInstallationVDS' method, for vds: 'redhat-host-1'; host: 'redhat-host-1': PreparedStatementCallback; bad SQL grammar [select * from getallnetworkbyclusterid(?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: structure of query does not match function result type
Detail: Returned type character varying(256) does not match expected type character varying(50) in column 2.
Where: PL/pgSQL function getallnetworkbyclusterid(uuid,uuid,boolean) line 3 at RETURN QUERY
Environment
- Red Hat Virtualization 4.1.x
- Engine Upgrade
- vdsm-4.19.42-1.el7ev.x86_64
- Engine-backup
- ovirt-engine-4.1.8
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.