On Tue, Mar 16, 2021 at 9:21 AM Vojtech Juranek <vjuranek@redhat.com> wrote:
On Tuesday, 16 March 2021 07:08:31 CET Yedidyah Bar David wrote:
On Mon, Mar 15, 2021 at 10:48 PM Vojtech Juranek <vjuranek@redhat.com> wrote:
Hi, when I try to upgrade my engine with built artifacts (e.g. [1]), it fails with:
psql:/usr/share/ovirt-engine/dbscripts/create_views.sql:1000: ERROR: column vm_templates.virtio_scsi_multi_queues_enabled does not exist LINE 86: vm_templates.virtio_scsi_multi_queues_enabled AS virtio_...> ^
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/create_views.sql
Same issue happens when I tried to update my dev engine with local build. However, OST is passing [2].
Any idea what's wrong? I don't see anything wrong in [3], which is probably the culprit, but I haven't much experience with engine/db though. Or maybe some issue on my side? I suppose this failure happens in engine-setup, right? Please share its logs. Thanks.
attached
Thanks. It has: 2021-03-15 16:28:56,292-0400 Skipping upgrade script /usr/share/ovirt-engine/dbscripts/upgrade/04_04_1010_add_virtio_scsi_multi_queues_enabled_to_vm_static.sql, its version 04041010 is <= current version 04041010 "current version" should be the version of the latest dbscript you applied to your db. In current master branch, this version (04041010) belongs to above script. Perhaps you have/had some other dbscript with this number (meaning, prefix 04_04_1010)? Perhaps chec/share the output of 'select * from schema_version order by id;', and 'ls -l packaging/dbscripts/upgrade' (although this might have been updated. The db is more relevant).
Best regards,
Thanks Vojta
[1] https://jenkins.ovirt.org/job/ovirt-engine_standard-check-patch/11174/art ifact/check-patch.el8.x86_64/ [2] https://jenkins.ovirt.org/job/ovirt-system-tests_manual/7880/ [3] https://github.com/oVirt/ovirt-engine/commit/52caf76e60ace2266d8283c131d4 673a2dd79289_______________________________________________ Devel mailing list -- devel@ovirt.org To unsubscribe send an email to devel-leave@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/devel@ovirt.org/message/DWCUVM4HRGV SUNLCS3TWL4LHKXDD2NPO/
-- Didi