"Engine schema refresh failed" during an upgrade to RHV 4.2

Solution Verified - Updated -

Issue

  • during the upgrade from RHV 4.1 to 4.2 the engine-setup fails with following errors:
[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1300_add_auth_url_valid_constraint.sql
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed
  • in ovirt-engine-setup*.log there is PostgreSQL message with FATAL severity level:
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1300_add_auth_url_valid_constraint.sql

ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:435 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1300_add_auth_url_valid_constraint.sql

Environment

RHV 4.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In