[ovirt-devel] Re: Migrate VMs between DCs

2021-03-16 Thread Daniel Gurgel 
Nir, thank you for your help and practical examples. I'll try to simulate.

In fact, most companies that actually have different offices do not share the 
same SAN/Storage structure , there are physical limitations and network details 
and time that make procedures impossible - As I said, storages that work 
differently, are also a limiting factor.

Export Domain, we can count today, but in six months, we don't know if it'll 
still be there.

Most hypervisors support Live Migrate/Off line migrate between "data centers". 
It would be great to have this feature up to oVirt 4.5.x
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/WYRHNO2V6RF4FSIDJCLCR2DMVAI4LLJR/

[ovirt-devel] Re: Migrate VMs between DCs

2021-03-16 Thread Nir Soffer 
On Tue, Mar 16, 2021 at 3:27 PM Daniel Gurgel <
danieldemoraisgur...@gmail.com> wrote:

> How to migrate virtual servers between different data centers that do not
> share the same SAN?
> There are limitations, including connection technology, depending on the
> Storage Model used.
>
> For example, Dell PowerStore uses only 1 iSCSI network and Dell EMC
> Compellent, 2 separate iSCSI networks.
> This connection is not possible, even for security and redundancy reasons.
>
> Exports Domains are marked as discontinued in 4.4.x.
>

Export domain is deprecated, but it is still available


> Are there plans for 4.4.x or 4.5.x Live Migrate Storage to be implemented?
>

I don't know about plans for live migration, but offline migration is
available
since 3.6 by detaching the storage domain from one DC, and attaching it
to another DC (or completely separate setup).

I'm not sure why networking should be an issue.

This is the most efficient way because no data is copied, but it works only
if
you want to move the entire storage domain from one DC to another. If you
want to move only a few VMs, you can export the VM to OVA and import the
OVA on the other DC.

Another way, which may require more work but can be faster is to
download the vm disks and upload them to the other storage.

Example - downloding disk from one DC/system:

# python3
/usr/share/doc/python3-ovirt-engine-sdk4/examples/upload_disk.py \
-c engine --disk-format=qcow2 --disk-sparse --sd-name fc_0
disk1.qcow2

And uploading to another DC/system, using different format:

# python3
/usr/share/doc/python3-ovirt-engine-sdk4/examples/upload_disk.py \
-c engine --disk-format=raw --disk-sparse --sd-name nfs_0
disk1.qcow2

This works for powered off VM. If you want move a running VM, it is
possible to use
the backup_vm.py example to download all the disk of a running VM. Then you
can upload them to another system and create a VM from the disks.

Here is an example backup downloading all the 9 disks of a running vm:

# python3 /usr/share/doc/python3-ovirt-engine-sdk4/examples/backup_vm.py -c
engine full --backup-dir /dev/shm/my-backup
20c83016-4c95-42d1-8aec-f75bdf62f471
[   0.0 ] Starting full backup for VM 20c83016-4c95-42d1-8aec-f75bdf62f471
[   1.9 ] Waiting until backup b9125cb5-c2eb-4f1e-953e-c2b8d5065996 is ready
[  34.4 ] Created checkpoint '222a88f7-14f2-46e5-a3aa-b618c79a6445' (to use
in --from-checkpoint-uuid for the next incremental backup)
[  34.5 ] Creating image transfer for disk
d6e3cca3-ca73-4169-b76e-f9928e727f9b
[  35.7 ] Image transfer d360c489-2fdb-4f4c-9d32-4bdb7d83a948 is ready
[ 100.00% ] 3.00 GiB, 0.07 seconds, 43.54 GiB/s

[  35.7 ] Finalizing image transfer
[  37.8 ] Creating image transfer for disk
f7fec022-dd6d-4170-b0f1-cab3bfa59e52
[  39.0 ] Image transfer ba3fc564-2d88-4cc6-a0e7-220b132082ed is ready
[ 100.00% ] 1.00 GiB, 1.41 seconds, 726.56 MiB/s

[  40.4 ] Finalizing image transfer
[  44.5 ] Creating image transfer for disk
6797a952-6219-4baf-9b37-c7905b3e8431
[  45.7 ] Image transfer 3b8e5bf6-bc95-4d3e-bc76-a169f44259df is ready
[ 100.00% ] 2.00 GiB, 0.06 seconds, 34.33 GiB/s

[  45.7 ] Finalizing image transfer
[  47.8 ] Creating image transfer for disk
e57e7263-3683-4e7e-8f91-1b3d2784ba7f
[  49.0 ] Image transfer 9dca0ce2-bcae-45f9-8372-5c3444392e06 is ready
[ 100.00% ] 1.00 GiB, 1.49 seconds, 686.21 MiB/s

[  50.5 ] Finalizing image transfer
[  51.5 ] Creating image transfer for disk
def1bf0b-f4bb-4c55-acad-3407b4fa51a3
[  52.7 ] Image transfer 9420754f-26ae-463e-9b4b-8d16bbc639bf is ready
[ 100.00% ] 1.00 GiB, 1.49 seconds, 689.46 MiB/s

[  54.2 ] Finalizing image transfer
[  58.3 ] Creating image transfer for disk
505a9363-d7b0-4a31-ab24-a02157d5da0a
[  59.4 ] Image transfer 82cb3e00-cedb-486e-b0a7-938b7ad85ddf is ready
[ 100.00% ] 3.00 GiB, 0.06 seconds, 49.46 GiB/s

[  59.5 ] Finalizing image transfer
[  61.5 ] Creating image transfer for disk
29943aa5-2ffc-408e-950b-a2f6ded72f89
[  62.7 ] Image transfer fa9bc0dc-5167-4b3c-adc5-394cfb3c3b76 is ready
[ 100.00% ] 3.00 GiB, 0.06 seconds, 51.15 GiB/s

[  62.7 ] Finalizing image transfer
[  64.8 ] Creating image transfer for disk
524cff40-3f54-4d16-bd94-9902e6619190
[  65.9 ] Image transfer 7d053497-3830-4548-a9fb-d75f7b816dde is ready
[ 100.00% ] 10.00 GiB, 3.36 seconds, 2.98 GiB/s

[  69.3 ] Finalizing image transfer
[  72.4 ] Creating image transfer for disk
ff71c7d3-5af3-4943-b922-b5baeb0be67c
[  73.5 ] Image transfer 5cb9efb9-537c-4e16-b9b3-44ef44ab59dd is ready
[ 100.00% ] 2.00 GiB, 0.06 seconds, 33.31 GiB/s

[  73.5 ] Finalizing image transfer
[  74.6 ] Creating image transfer for disk
b49df79e-7b26-402b-bf11-328fddeca1ec
[  75.7 ] Image transfer 3ccc44f2-ba6d-4545-bc96-1b924b2c1dd8 is ready
[ 100.00% ] 2.00 GiB, 0.10 seconds, 20.20 GiB/s

[  75.8 ] Finalizing image transfer
[  77.9 ] Finalizing backup
[  78.0 ] Waiting until backup is finalized
[  78.2 ] Full backup completed successfully

# ls -lhs /dev/shm/my-backup/
total 5.4G
196K

[ovirt-devel] docs: pointers to more in-depth internals?

2021-03-16 Thread Greg King 
I am new to vdsm and trying to understand the architecture/internals much better

The ovirt documentation for architecture I have found so far seems to be 
relatively high level

My effort to understand the architecture by walking through the vdsm code using 
pdb/rpdb is slow and probably not all that efficient

Does anyone have pointers to documentation that might explain the vdsm modules, 
classes and internals a little more in depth?

I'd also like to understand where I might be able to add rpdb.set_trace() so I 
can step through functions being called in libvirt.py

[oracle-email-sig-198324-355094]
Gregory King | Software Development Manager | +1.303.272.2427
Oracle Virtualization Sustaining Engineering
500 Eldorado Boulevard Build 5 | Broomfield Colorado 80021
Mobile: +1.303.968.8169 | Fax: +1.303.272.2427

___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/G5FQG6TFWJFBPBPMKKX7G3AZFOOM/

[ovirt-devel] Re: [oVirt Jenkins] ovirt-system-tests_basic-suite-master_nightly - Build # 962 - Still Failing!

2021-03-16 Thread Michal Skrivanek 


> On 16. 3. 2021, at 15:53, Yedidyah Bar David  wrote:
> 
> On Tue, Mar 16, 2021 at 10:09 AM Yedidyah Bar David  > wrote:
>> 
>> On Tue, Mar 16, 2021 at 7:06 AM  wrote:
>>> 
>>> Project: 
>>> https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/
>>> Build: 
>>> https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/962/
>>> Build Number: 962
>>> Build Status:  Still Failing
>>> Triggered By: Started by timer
>>> 
>>> -
>>> Changes Since Last Success:
>>> -
>>> Changes for Build #953
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #954
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #955
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #956
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #957
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #958
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #959
>>> [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
>>> 
>>> 
>>> Changes for Build #960
>>> [Andrej Cernek] pylint: Upgrade to 2.7
>>> 
>>> 
>>> Changes for Build #961
>>> [Andrej Cernek] pylint: Upgrade to 2.7
>>> 
>>> 
>>> Changes for Build #962
>>> [Andrej Cernek] pylint: Upgrade to 2.7
>>> 
>>> 
>>> 
>>> 
>>> -
>>> Failed Tests:
>>> -
>>> 1 tests failed.
>>> FAILED:  
>>> basic-suite-master.test-scenarios.test_001_initialize_engine.test_set_hostnames
>>> 
>>> Error Message:
>>> failed on setup with "TypeError: __new__() missing 2 required positional 
>>> arguments: 'version' and 'repo'"
>>> 
>>> Stack Trace:
>>> ansible_by_hostname = 
>>> 
>>>@pytest.fixture(scope="session", autouse=True)
>>>def check_installed_packages(ansible_by_hostname):
>>>vms_pckgs_dict_list = []
>>>for hostname in backend.default_backend().hostnames():
>>>vm_pckgs_dict = _get_custom_repos_packages(
  ansible_by_hostname(hostname))
>>> 
>>> ost_utils/ost_utils/pytest/fixtures/check_repos.py:39:
>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
>>> _ _
>>> ost_utils/ost_utils/pytest/fixtures/check_repos.py:55: in 
>>> _get_custom_repos_packages
>>>repo_name)
>>> ost_utils/ost_utils/pytest/fixtures/check_repos.py:69: in 
>>> _get_installed_packages
>>>Package(*line) for line in result
>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
>>> _ _
>>> 
>>> .0 = 
>>> 
  Package(*line) for line in result
>>>]
>>> E   TypeError: __new__() missing 2 required positional arguments: 'version' 
>>> and 'repo'
>> 
>> This failed, because 'dnf repo-pkgs' has split the output to two
>> lines, so the first
>> didn't include a version [1]:
>> 
>> lago-basic-suite-master-host-1 | CHANGED | rc=0 >>
>> Installed Packages
>> ovirt-ansible-collection.noarch 1.3.2-0.1.master.20210315141358.el8 
>> @extra-src-1
>> python3-ovirt-engine-sdk4.x86_64
>>4.4.10-1.20210315.gitf8b9f2a.el8
>> @extra-src-1
>> 
>> We should either give up on this, or rewrite the call 'dnf repo-pkgs'
>> in some other
>> language that does not require parsing of human-targeted output
>> (perhaps python or
>> ansible), or amend a bit the current code and hope it will survive longer...
>> 
>> Trying last one:
>> 
>> https://gerrit.ovirt.org/c/ovirt-system-tests/+/113895
> 
> Merged, but we still fail in nightly (which I ran manually):
> 
> https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/963/console
>  
> 
> 
> 16:06:44 >   raise RuntimeError('None of user custom repos has
> been used')
> 16:06:44 E   RuntimeError: None of user custom repos has been used
> 
> I think this is "by design" - this job runs with a "custom repo"
> pointing at master-snapshot, and apparently at least in this run it
> didn't see updates, so failed.

wouldn’t it fail exactly during the night when we build a fresh ost-image and 
run with custom repo that has nothing newer, obviously, since we just built the 
image?

> 
> I wonder if this is simply a design issue, or we should change the
> nightly run to not use a custom repo, or something else.

> 
> In any case, perhaps we should consider completely reverting
> check_repos.py for now, until we decide what we want. It was a good
> idea, but we can't let basic-suite remain red for so long. And then,
> we can get back to the issue of ovirt-log-collector...

we don’t need so radical changes/investment just yet, just dropping it from 
nightly config should be enough
I think it is

[ovirt-devel] Re: [oVirt Jenkins] ovirt-system-tests_basic-suite-master_nightly - Build # 962 - Still Failing!

2021-03-16 Thread Yedidyah Bar David 
On Tue, Mar 16, 2021 at 10:09 AM Yedidyah Bar David  wrote:
>
> On Tue, Mar 16, 2021 at 7:06 AM  wrote:
> >
> > Project: 
> > https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/
> > Build: 
> > https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/962/
> > Build Number: 962
> > Build Status:  Still Failing
> > Triggered By: Started by timer
> >
> > -
> > Changes Since Last Success:
> > -
> > Changes for Build #953
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #954
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #955
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #956
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #957
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #958
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #959
> > [Michal Skrivanek] randomize /dev/shm logcollector tmp directory
> >
> >
> > Changes for Build #960
> > [Andrej Cernek] pylint: Upgrade to 2.7
> >
> >
> > Changes for Build #961
> > [Andrej Cernek] pylint: Upgrade to 2.7
> >
> >
> > Changes for Build #962
> > [Andrej Cernek] pylint: Upgrade to 2.7
> >
> >
> >
> >
> > -
> > Failed Tests:
> > -
> > 1 tests failed.
> > FAILED:  
> > basic-suite-master.test-scenarios.test_001_initialize_engine.test_set_hostnames
> >
> > Error Message:
> > failed on setup with "TypeError: __new__() missing 2 required positional 
> > arguments: 'version' and 'repo'"
> >
> > Stack Trace:
> > ansible_by_hostname = 
> >
> > @pytest.fixture(scope="session", autouse=True)
> > def check_installed_packages(ansible_by_hostname):
> > vms_pckgs_dict_list = []
> > for hostname in backend.default_backend().hostnames():
> > vm_pckgs_dict = _get_custom_repos_packages(
> > >   ansible_by_hostname(hostname))
> >
> > ost_utils/ost_utils/pytest/fixtures/check_repos.py:39:
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
> > _ _
> > ost_utils/ost_utils/pytest/fixtures/check_repos.py:55: in 
> > _get_custom_repos_packages
> > repo_name)
> > ost_utils/ost_utils/pytest/fixtures/check_repos.py:69: in 
> > _get_installed_packages
> > Package(*line) for line in result
> > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
> > _ _
> >
> > .0 = 
> >
> > >   Package(*line) for line in result
> > ]
> > E   TypeError: __new__() missing 2 required positional arguments: 'version' 
> > and 'repo'
>
> This failed, because 'dnf repo-pkgs' has split the output to two
> lines, so the first
> didn't include a version [1]:
>
> lago-basic-suite-master-host-1 | CHANGED | rc=0 >>
> Installed Packages
> ovirt-ansible-collection.noarch 1.3.2-0.1.master.20210315141358.el8 
> @extra-src-1
> python3-ovirt-engine-sdk4.x86_64
> 4.4.10-1.20210315.gitf8b9f2a.el8
> @extra-src-1
>
> We should either give up on this, or rewrite the call 'dnf repo-pkgs'
> in some other
> language that does not require parsing of human-targeted output
> (perhaps python or
> ansible), or amend a bit the current code and hope it will survive longer...
>
> Trying last one:
>
> https://gerrit.ovirt.org/c/ovirt-system-tests/+/113895

Merged, but we still fail in nightly (which I ran manually):

https://jenkins.ovirt.org/job/ovirt-system-tests_basic-suite-master_nightly/963/console

16:06:44 >   raise RuntimeError('None of user custom repos has
been used')
16:06:44 E   RuntimeError: None of user custom repos has been used

I think this is "by design" - this job runs with a "custom repo"
pointing at master-snapshot, and apparently at least in this run it
didn't see updates, so failed.

I wonder if this is simply a design issue, or we should change the
nightly run to not use a custom repo, or something else.

In any case, perhaps we should consider completely reverting
check_repos.py for now, until we decide what we want. It was a good
idea, but we can't let basic-suite remain red for so long. And then,
we can get back to the issue of ovirt-log-collector...

Best regards,
-- 
Didi
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/XA6E4AFRT7SDMZX23QZGJ3XJV3KVDMY5/

[ovirt-devel] Migrate VMs between DCs

2021-03-16 Thread Daniel Gurgel 
How to migrate virtual servers between different data centers that do not share 
the same SAN? 
There are limitations, including connection technology, depending on the 
Storage Model used.

For example, Dell PowerStore uses only 1 iSCSI network and Dell EMC Compellent, 
2 separate iSCSI networks. 
This connection is not possible, even for security and redundancy reasons.

Exports Domains are marked as discontinued in 4.4.x.
Are there plans for 4.4.x or 4.5.x Live Migrate Storage to be implemented?
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/TING2CJAUC6YXVWD54XE4DPYIIGJ7OW6/

[ovirt-devel] Re: Jenkins CI broken

2021-03-16 Thread Ehud Yonasi 
Hi Sandro,

I've merged a patch to update all the slave repos. I think the issue will
be solved now.

On Fri, Mar 12, 2021 at 10:06 AM Sandro Bonazzola 
wrote:

> Hi,
> looks like we have some issues in Jenkins:
> https://jenkins.ovirt.org/job/imgbased_standard-check-patch/663/console
>
> We have an issue with our local mirror which is quite outdated (2020-10-08)
>
> *08:45:53*  Loading mirror speeds from cached hostfile*08:45:53*  
> http://mirrors.phx.ovirt.org/repos/yum/epel-el7/2020-10-08-04-48/repodata/c5aca79919795cf95dd0cc28a4837e5fb9cd12be67f24f6767866a0df183a662-primary.sqlite.bz2:
>  [Errno 14] HTTP Error 404 - Not Found*08:45:53*  Trying other 
> mirror.*08:45:53*  To address this issue please refer to the below wiki 
> article *08:45:53*  *08:45:53*  https://wiki.centos.org/yum-errors*08:45:53*  
> *08:45:53*  If above article doesn't help to resolve this issue please use 
> https://bugs.centos.org/.*08:45:53*  *08:45:54*  
> http://mirrors.phx.ovirt.org/repos/yum/epel-el7/2020-10-08-04-48/repodata/c5aca79919795cf95dd0cc28a4837e5fb9cd12be67f24f6767866a0df183a662-primary.sqlite.bz2:
>  [Errno 14] HTTP Error 404 - Not Found*08:45:54*  Trying other 
> mirror.*08:45:54*  No package python36-docker available.*08:45:54*  Error: 
> Nothing to do
>
>
> and it's missing a python36-docker package which cause the global setup of
> the job to fail:
>
> *08:45:54*  global_setup[docker_setup] ERROR: Failed to install Docker 
> Python36 API.*08:45:54*  + return 1*08:45:54*  + failed=true
>
>
> There's also some weird firewalld configuration which is failing:
>
> *08:45:54*  + sudo -nl firewall-cmd*08:45:54*  ++ sudo -n firewall-cmd 
> --query-service=ovirtlago*08:46:03*  Error: INVALID_SERVICE: ovirtlago
>
>
> Can you please have a look? Thanks,
>
> --
>
> Sandro Bonazzola
>
> MANAGER, SOFTWARE ENGINEERING, EMEA R RHV
>
> Red Hat EMEA 
>
> sbona...@redhat.com
> 
>
> *Red Hat respects your work life balance. Therefore there is no need to
> answer this email out of your office hours.*
>
>
>
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/5FKL5AJ5JPKEWKMEZ26QIWMGX2JMQFZZ/

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Vojtech Juranek 
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 
> wrote:
> >
> >
> > On Tuesday, 16 March 2021 08:29:07 CET Ales Musil wrote:
> > 
> > > On Tue, Mar 16, 2021 at 8:24 AM Vojtech Juranek 
> > > 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
> > > > > 
> > > >
> > > >
> > > >
> > > > 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@ovirt.org
> > > > > > To unsubscribe send an email to devel-le...@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@ovirt.org
> > > > To unsubscribe send an email to devel-le...@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@ovirt.org
> > To

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Yedidyah Bar David 
On Tue, Mar 16, 2021 at 9:21 AM Vojtech Juranek  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 
> 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-le...@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
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/K5G7GEY7ED5MWU2SXYDROF5T2VHS2G7R/

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Benny Zlotnik 
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

[1] 
https://gerrit.ovirt.org/c/ovirt-engine/+/112642/16/packaging/dbscripts/upgrade/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  wrote:
>
> On Tuesday, 16 March 2021 08:29:07 CET Ales Musil wrote:
> > On Tue, Mar 16, 2021 at 8:24 AM Vojtech Juranek  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 
> > >
> > > 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@ovirt.org
> > > > > To unsubscribe send an email to devel-le...@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@ovirt.org
> > > To unsubscribe send an email to devel-le...@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@ovirt.org
> To unsubscribe send an email to devel-le...@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/XUSTEKEJT67E5TEVO2WYHNPUHSIPC2AR/
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/WQPKY6UZHY77BREVAI5MCTTNGGK6UMIZ/

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Vojtech Juranek 
On Tuesday, 16 March 2021 08:29:07 CET Ales Musil wrote:
> On Tue, Mar 16, 2021 at 8:24 AM Vojtech Juranek  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 
> > 
> > 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@ovirt.org
> > > > To unsubscribe send an email to devel-le...@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@ovirt.org
> > To unsubscribe send an email to devel-le...@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



signature.asc
Description: This is a digitally signed message part.
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/XUSTEKEJT67E5TEVO2WYHNPUHSIPC2AR/

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Ales Musil 
On Tue, Mar 16, 2021 at 8:24 AM Vojtech Juranek  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 
> 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@ovirt.org
> > > To unsubscribe send an email to devel-le...@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@ovirt.org
> To unsubscribe send an email to devel-le...@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/TDSBKKXB42Y4V644AI3PDRMV5QWWUF5J/
>

Hi,
it happened to me as well on my dev engine.
I workaround this by cleaning my engine and running setup again from
scratch.
I suspect that it is related to [0].

Thanks,
Ales

[0] https://gerrit.ovirt.org/c/ovirt-engine/+/112642

-- 

Ales Musil

Software Engineer - RHV Network

Red Hat EMEA 

amu...@redhat.comIM: amusil

___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/FZFGK6L2KG2YE2IYPYSJTJFLTXK4WO22/

[ovirt-devel] Re: Engine upgrade fails with virtio_scsi_multi_queues_enabled does not exist

2021-03-16 Thread Yedidyah Bar David 
On Mon, Mar 15, 2021 at 10:48 PM Vojtech Juranek  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.

Best regards,

>
> Thanks
> Vojta
>
> [1] 
> https://jenkins.ovirt.org/job/ovirt-engine_standard-check-patch/11174/artifact/check-patch.el8.x86_64/
> [2] https://jenkins.ovirt.org/job/ovirt-system-tests_manual/7880/
> [3] 
> https://github.com/oVirt/ovirt-engine/commit/52caf76e60ace2266d8283c131d4673a2dd79289___
> Devel mailing list -- devel@ovirt.org
> To unsubscribe send an email to devel-le...@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/DWCUVM4HRGVSUNLCS3TWL4LHKXDD2NPO/



-- 
Didi
___
Devel mailing list -- devel@ovirt.org
To unsubscribe send an email to devel-le...@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/Y2KBZO2XIY5BQIGSKAN2IGQ3APB3J7ZM/