We actually hit this internally too, so looks like a bug.

@Eli Mesika <emes...@redhat.com>

On Thu, Aug 2, 2018 at 4:17 AM Jan Siml <js...@plusline.net> wrote:

> Hello,
>
> I stumbled across the following bug when upgrading the ovirt engine from
> 4.2.4 to 4.2.5 (snippet from upgrade log):
>
> Running upgrade sql script
>
> '/usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql'...
>
> 2018-08-02 09:14:33,116+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-20180802091038-xclfnu.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_transfers_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-02 09:14:33,117+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/upgrade/04_02_12
> 10_add_foreign_key_to_image_transfers.sql
> 2018-08-02 09:14:33,119+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-02 09:14:33,122+0200 ERROR otopi.context
> context._executeMethod:152 Failed to execute stage 'Misc configuration':
> Engine schema refresh failed
>
> Are there already instructions on how to deal with this error and does
> anyone know why this error occurs?
>
> Kind 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/IHPQ2EQ52MVTVZVABGSZO2Y7RO7RCQ66/
>


-- 

GREG SHEREMETA

SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX

Red Hat NA

<https://www.redhat.com/>

gsher...@redhat.com    IRC: gshereme
<https://red.ht/sig>
_______________________________________________
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/X2RKXVQVQLS7MF7XN4CB4ZT5ULVYQ5OV/

Reply via email to