"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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content