[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist
On Tue, Mar 16, 2021 at 9:21 AM Vojtech Juranek <vjuranek(a)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(a)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(a)ovirt.org
> > To unsubscribe send an email to devel-leave(a)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