If there are Disk Uploads that have not completed (i.e: currently
Paused or with Error) and were not canceled the upgrade will fail.This
is due to a foreign key being added on 4.2.5, relating image_transfers
table to command_entities table.
When the roll-back to the previous RHV-M version finishes, open the
Administration Portal and navigate to Storage -> Disks.
there was indeed one disk upload which wasn't finshed. I have canceled
it and removed the disk.
If it fails then share your observations with us, so we need to do
some manual changes in database.
The seconds attempt to update failed to:
Running upgrade sql script
2018-08-03 12:45:05,808+0200 DEBUG
['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost',
'5432', '-u', 'engine', '-d', 'engine',
'-c', 'apply'] stderr:
ERROR: insert or update on table "image_transfers" violates foreign key
DETAIL: Key (command_id)=(312f711f-a5c3-477d-8533-82ef88a54b77) is not
present in table "command_entities".
FATAL: Cannot execute sql command:
2018-08-03 12:45:05,809+0200 ERROR
schema.sh: FATAL: Cannot execute sql command:
2018-08-03 12:45:05,812+0200 DEBUG otopi.context
context._executeMethod:143 method exception
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133,
line 436, in _misc
raise RuntimeError(_('Engine schema refresh failed'))
RuntimeError: Engine schema refresh failed
2018-08-03 12:45:05,815+0200 ERROR otopi.context
context._executeMethod:152 Failed to execute stage 'Misc configuration':
Engine schema refresh failed
The restore for both databases (engine and engine_hirory) fails too:
pg_restore: [archiver (db)] Error from TOC entry 7339; 0 0 COMMENT
pg_restore: [archiver (db)] could not execute query: ERROR: must be
owner of extension uuid-ossp