On Fri, Aug 3, 2018 at 7:01 AM Jan Siml <jsiml@plusline.net> wrote:
Hello,

> 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
'/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql'...

Turns out this is a regression that we are working urgently to fix:
https://bugzilla.redhat.com/show_bug.cgi?id=1609839

Thanks to all who have reported! 


2018-08-03 12:45:05,808+0200 DEBUG
otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
plugin.execute:926 execute-output:
['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p',
  '5432', '-u', 'engine', '-d', 'engine', '-l',
'/var/log/ovirt-engine/setup/ovirt-engine-setup-20180803124017-k94hg1.log',
'-c', 'apply'] stderr:
psql:/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql:1:
ERROR:  insert or update on table "image_transfers" violates foreign key
constraint "fk_image_tran
sfers_command_enitites"
DETAIL:  Key (command_id)=(312f711f-a5c3-477d-8533-82ef88a54b77) is not
present in table "command_entities".
FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql

2018-08-03 12:45:05,809+0200 ERROR
otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema schema._misc:434
schema.sh: FATAL: Cannot execute sql command:
--file=/usr/share/ovirt-engine/dbscripts/upg
rade/04_02_1210_add_foreign_key_to_image_transfers.sql
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,
in _executeMethod
     method['method']()
   File
"/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py",
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
EXTENSION "uuid-ossp"
pg_restore: [archiver (db)] could not execute query: ERROR:  must be
owner of extension uuid-ossp

Regards

Jan
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-leave@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/
List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/DSVVDV42APPUKQN6XV4ZUSI3PUAXPOWB/


--

GREG SHEREMETA

SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX

Red Hat NA

gshereme@redhat.com    IRC: gshereme