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?

Thanks Vojta [1] https://jenkins.ovirt.org/job/ovirt-engine_standard-check-patch/11174/art... [2] https://jenkins.ovirt.org/job/ovirt-system-tests_manual/7880/ [3] https://github.com/oVirt/ovirt-engine/commit/52caf76e60ace2266d8283c131d4... 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...

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&gt; 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 > 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/ _______________________________________________ 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/TDSBKKXB42Y...

On Tuesday, 16 March 2021 08:29:07 CET Ales Musil wrote: > On Tue, Mar 16, 2021 at 8:24 AM Vojtech Juranek <vjuranek(a)redhat.com&gt; 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&gt; > > > > 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 > > > > > 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/ > > > > _______________________________________________ > > 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/TDSBKKXB42Y4 > > V644AI3PDRMV5QWWUF5J/ > Hi, > it happened to me as well on my dev engine. > I workaround this by cleaning my engine and running setup again from > scratch. this would very likely work as OST is passing, but I'd like to avoid it as I have quite a lot of stuff configured there and don't want to do it again > I suspect that it is related to [0]. > > Thanks, > Ales > > [0] https://gerrit.ovirt.org/c/ovirt-engine/+/112642 _______________________________________________ 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/XUSTEKEJT67...

On Tuesday, 16 March 2021 08:48:46 CET Benny Zlotnik wrote: > I think you had an issue because you clashed with the script number > (or something like that, since you have a patch with an upgrade > script), I think if you run manually the SQL in[1] and rerun > engine-setup it should sort it out Thanks Benny and Didi, indeed, in my patch I *had* upgrade script 04_04_1010_something, which I renamed after to 04_04_1020_something after I rebased on top of gerrit #112642. However, DB remembers it and skips 04_04_1010_*.

Running 04_04_1010_add_virtio_scsi_multi_queues_enabled_to_vm_static.sq manually fixed the issue.

Thanks! Vojta > [1] > https://gerrit.ovirt.org/c/ovirt-engine/+/112642/16/packaging/dbscripts/upg > rade/04_04_1010_add_virtio_scsi_multi_queues_enabled_to_vm_static.sql#1 > On Tue, Mar 16, 2021 at 9:40 AM Vojtech Juranek <vjuranek(a)redhat.com&gt; > wrote: > > > > > > On Tuesday, 16 March 2021 08:29:07 CET Ales Musil wrote: > > > > > On Tue, Mar 16, 2021 at 8:24 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&gt; > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > 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/52caf76e60ace2266d8283c13 > > > > 1d4 > > > > > > > > > > > > > > > > > > 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/DWCUVM4H > > > > RGV > > > > > > > > > > > > > > > > > > SUNLCS3TWL4LHKXDD2NPO/ > > > > > > > > > > > > > > > > _______________________________________________ > > > > 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/TDSBKKXB > > > > 42Y4 > > > > V644AI3PDRMV5QWWUF5J/ > > > > > > Hi, > > > it happened to me as well on my dev engine. > > > I workaround this by cleaning my engine and running setup again from > > > scratch. > > > > > > > > this would very likely work as OST is passing, but I'd like to avoid it as > > I have quite a lot of stuff configured there and don't want to do it > > again> > > > > > > > I suspect that it is related to [0]. > > > > > > > > > > > > Thanks, > > > Ales > > > > > > > > > > > > [0] https://gerrit.ovirt.org/c/ovirt-engine/+/112642 > > > > > > > > _______________________________________________ > > 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/XUSTEKEJT67 > > E5TEVO2WYHNPUHSIPC2AR/ > _______________________________________________ > 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/WQPKY6UZHY77B > REVAI5MCTTNGGK6UMIZ/ _______________________________________________ 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/BATU3QTZS6Y...