We actually hit this internally too, so looks like a bug. @Eli Mesika <[email protected]>
On Thu, Aug 2, 2018 at 4:17 AM Jan Siml <[email protected]> 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 -- [email protected] > To unsubscribe send an email to [email protected] > 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/[email protected]/message/IHPQ2EQ52MVTVZVABGSZO2Y7RO7RCQ66/ > -- GREG SHEREMETA SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX Red Hat NA <https://www.redhat.com/> [email protected] IRC: gshereme <https://red.ht/sig>
_______________________________________________ Users mailing list -- [email protected] To unsubscribe send an email to [email protected] 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/[email protected]/message/X2RKXVQVQLS7MF7XN4CB4ZT5ULVYQ5OV/

