On Fri, Aug 3, 2018 at 2:01 PM Jan Siml <js...@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'...
>
> 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
>
There are probably some more stale image transfers records,
can you please check whether 'image_transfers' table is empty?
If not, you can try removing them by executing:
"DELETE FROM image_transfers WHERE command_id NOT IN (SELECT
command_entities.command_id FROM command_entities);"
(you can simply prepend it to
'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-le...@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/
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@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/F5UMM27QBPMUTWYMEJJSFAH5JJO5CXVF/
