Bug 1650574
| Summary: | default graphics console SPICE+VNC for new VMs | ||
|---|---|---|---|
| Product: | [oVirt] ovirt-engine | Reporter: | Michal Skrivanek <michal.skrivanek> |
| Component: | BLL.Virt | Assignee: | Michal Skrivanek <michal.skrivanek> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | meital avital <mavital> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | future | CC: | bugs, rbarry, rob |
| Target Milestone: | ovirt-4.3.0 | Flags: | rule-engine:
ovirt-4.3+
|
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | ovirt-engine-4.3.0_rc2 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2019-02-13 07:45:08 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Virt | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
Michal Skrivanek
2018-11-16 14:11:13 UTC
Hi, I'm trying to upgrade from 4.2.7 to 4.3.0_alpha1 and I'm getting the following error: [ INFO ] Creating/refreshing Engine database schema [ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0450_change_default_graphics.sql [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed [ INFO ] Yum Performing yum transaction rollback Looking at the commit and manually trying to apply it I get: engine=# select * from vm_device; device_id | vm_id | type | device | address | spec_params | is_managed | is_plugged | is_readonly | _create_date | _update_date | alias | custom_properties | snapshot_id | logical_nam e | host_device -----------+-------+------+--------+---------+-------------+------------+------------+-------------+--------------+--------------+-------+-------------------+-------------+------------ --+------------- (0 rows) engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '00000000-0000-0000-0000-000000000000', 'graphics', 'vnc', '', '', true, true, false); INSERT 0 1 engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '00000003-0003-0003-0003-0000000000be', 'graphics', 'vnc', '', '', true, true, false); ERROR: insert or update on table "vm_device" violates foreign key constraint "fk_vm_device_vm_static" DETAIL: Key (vm_id)=(00000003-0003-0003-0003-0000000000be) is not present in table "vm_static". engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '00000005-0005-0005-0005-0000000002e6', 'graphics', 'vnc', '', '', true, true, false); ERROR: insert or update on table "vm_device" violates foreign key constraint "fk_vm_device_vm_static" DETAIL: Key (vm_id)=(00000005-0005-0005-0005-0000000002e6) is not present in table "vm_static". engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '00000007-0007-0007-0007-00000000010a', 'graphics', 'vnc', '', '', true, true, false); ERROR: insert or update on table "vm_device" violates foreign key constraint "fk_vm_device_vm_static" DETAIL: Key (vm_id)=(00000007-0007-0007-0007-00000000010a) is not present in table "vm_static". engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '00000009-0009-0009-0009-0000000000f1', 'graphics', 'vnc', '', '', true, true, false); ERROR: insert or update on table "vm_device" violates foreign key constraint "fk_vm_device_vm_static" DETAIL: Key (vm_id)=(00000009-0009-0009-0009-0000000000f1) is not present in table "vm_static". engine=# INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, is_readonly) VALUES (uuid_generate_v1(), '0000000b-000b-000b-000b-00000000021f', 'graphics', 'vnc', '', '', true, true, false); ERROR: insert or update on table "vm_device" violates foreign key constraint "fk_vm_device_vm_static" DETAIL: Key (vm_id)=(0000000b-000b-000b-000b-00000000021f) is not present in table "vm_static". did you by any chance remove all the predefined instance types? Yeah, I did. None of the previous upgrades complained about it. could you try again with https://jenkins.ovirt.org/job/ovirt-engine_master_build-artifacts-on-demand-el7-x86_64/1273/artifact/exported-artifacts/? The upgrade script assumed it's left intact even though it's quite possible to remove those indeed. It would be very helpful if you can confirm it works Hi Michal, It's looking good. Thank you! thanks. should be in current nightlies already Verified on: 4.3.0-0.8.master.20190122102235.git7a1ef10.el7 This bugzilla is included in oVirt 4.3.0 release, published on February 4th 2019. Since the problem described in this bug report should be resolved in oVirt 4.3.0 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report. |