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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
