[Users] win 7 vm creation:

Hello, on F18 physical host configured all-in-one oVirt nightly ( ovirt-engine-3.2.0-1.20130101.git2184580.fc18.noarch ) Trying to setup a w7 vm in run once, I get Error win7tst: - Cannot run VM. There are no available running Hosts in the Host Cluster. Here are screenshots for: vm network https://docs.google.com/open?id=0BwoPbcrMv8mvQWpwMUh6ZGRVeGc host network, after setting it up with drag of ovirtmgmt to em3 (the host currently has only em3.65 configured) https://docs.google.com/open?id=0BwoPbcrMv8mvRkVLSlkxWnRwakE engine log gzipped: https://docs.google.com/open?id=0BwoPbcrMv8mvcXRERkEyQW5Yc1U Is there an evident error in my config or should I send any other log? screenshots for local_cluster and local_host situation https://docs.google.com/open?id=0BwoPbcrMv8mvNV8zWTJLWHFhdFU and https://docs.google.com/open?id=0BwoPbcrMv8mvejlGUW5UWkxKMDg Thanks, Gianluca

Current siuation if I select host and click on "setup host networks" for it: https://docs.google.com/open?id=0BwoPbcrMv8mvMjFONTd2UEdXWWM

Current network config on host: # ip addr list 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: em1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c4 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c4/64 scope link valid_lft forever preferred_lft forever 3: em2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c6 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c6/64 scope link valid_lft forever preferred_lft forever 4: em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq master ovirtmgmt state UP qlen 1000 link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff 5: em4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1c:c4:ab:3a:de brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3ade/64 scope link valid_lft forever preferred_lft forever 6: em3.65@em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet 10.4.4.59/24 brd 10.4.4.255 scope global em3.65 inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever 11: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN link/ether 96:14:65:da:bc:c5 brd ff:ff:ff:ff:ff:ff 12: bond0: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 13: bond4: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 14: bond1: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 15: ovirtmgmt: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever # brctl show bridge name bridge id STP enabled interfaces ;vdsmdummy; 8000.000000000000 no ovirtmgmt 8000.001cc4ab3add no em3 Do I have perhaps to say/config that ovirtmgmt is tagged in any way?

Hi Gianluca,
From looking in the logs it looks like you had some DB upgrade issue, or DB clean install issue.
"Caused by: org.postgresql.util.PSQLException: The column name count_threads_as_cores was not found in this ResultSet" Adding Doron to take take a look, and I think Einav also had some db upgrade issue last week... After fixing you DB issues, can you tell me if you have host in status up, I don't see any network related issue in the logs. Livnat On 01/05/2013 03:07 AM, Gianluca Cecchi wrote:
Current network config on host:
# ip addr list 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 <http://127.0.0.1/8> scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: em1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c4 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c4/64 scope link valid_lft forever preferred_lft forever 3: em2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c6 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c6/64 scope link valid_lft forever preferred_lft forever 4: em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq master ovirtmgmt state UP qlen 1000 link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff 5: em4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1c:c4:ab:3a:de brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3ade/64 scope link valid_lft forever preferred_lft forever 6: em3.65@em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet 10.4.4.59/24 <http://10.4.4.59/24> brd 10.4.4.255 scope global em3.65 inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever 11: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN link/ether 96:14:65:da:bc:c5 brd ff:ff:ff:ff:ff:ff 12: bond0: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 13: bond4: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 14: bond1: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 15: ovirtmgmt: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever
# brctl show bridge namebridge idSTP enabledinterfaces ;vdsmdummy;8000.000000000000no ovirtmgmt8000.001cc4ab3addnoem3
Do I have perhaps to say/config that ovirtmgmt is tagged in any way?
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

Gianluca, I do not see all the details, but based on Livnat's mail, it seems that you DB needs an upgrade, and it will pick up this addition- backend/manager/dbscripts/upgrade/03_02_0100_add_cpu_thread_columns.sql:select fn_db_add_column('vds_groups', 'count_threads_as_cores', 'BOOLEAN NOT NULL DEFAULT FALSE'); Is your setup based on RPMs or built from source? ----- Original Message -----
From: "Livnat Peer" <lpeer@redhat.com> To: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> Cc: "users" <users@ovirt.org>, "Doron Fediuck" <dfediuck@redhat.com>, "Einav Cohen" <ecohen@redhat.com> Sent: Sunday, January 13, 2013 12:27:57 PM Subject: Re: [Users] win 7 vm creation:
Hi Gianluca, From looking in the logs it looks like you had some DB upgrade issue, or DB clean install issue.
"Caused by: org.postgresql.util.PSQLException: The column name count_threads_as_cores was not found in this ResultSet"
Adding Doron to take take a look, and I think Einav also had some db upgrade issue last week...
After fixing you DB issues, can you tell me if you have host in status up, I don't see any network related issue in the logs.
Livnat
On 01/05/2013 03:07 AM, Gianluca Cecchi wrote:
Current network config on host:
# ip addr list 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 <http://127.0.0.1/8> scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: em1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c4 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c4/64 scope link valid_lft forever preferred_lft forever 3: em2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c6 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c6/64 scope link valid_lft forever preferred_lft forever 4: em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq master ovirtmgmt state UP qlen 1000 link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff 5: em4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1c:c4:ab:3a:de brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3ade/64 scope link valid_lft forever preferred_lft forever 6: em3.65@em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet 10.4.4.59/24 <http://10.4.4.59/24> brd 10.4.4.255 scope global em3.65 inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever 11: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN link/ether 96:14:65:da:bc:c5 brd ff:ff:ff:ff:ff:ff 12: bond0: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 13: bond4: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 14: bond1: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 15: ovirtmgmt: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever
# brctl show bridge namebridge idSTP enabledinterfaces ;vdsmdummy;8000.000000000000no ovirtmgmt8000.001cc4ab3addnoem3
Do I have perhaps to say/config that ovirtmgmt is tagged in any way?
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On Sun, Jan 13, 2013 at 12:37 PM, Doron Fediuck wrote:
Is your setup based on RPMs or built from source?
when I had the problem it was based on ovirt-nightly for Fedora 18 based on 3.2.0-1.20130101.git2184580 SO I don't know at that time what were the contents of the file indicated...

------=_Part_3938548_1901943431.1358078680670 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Doron Fediuck" <dfediuck@redhat.com> Cc: "Livnat Peer" <lpeer@redhat.com>, "users" <users@ovirt.org>, "Einav Cohen" <ecohen@redhat.com> Sent: Sunday, January 13, 2013 1:48:21 PM Subject: Re: [Users] win 7 vm creation:
On Sun, Jan 13, 2013 at 12:37 PM, Doron Fediuck wrote:
Is your setup based on RPMs or built from source?
when I had the problem it was based on ovirt-nightly for Fedora 18 based on 3.2.0-1.20130101.git2184580 SO I don't know at that time what were the contents of the file indicated...
Do you still have it? ------=_Part_3938548_1901943431.1358078680670 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><= div style=3D'font-family: times new roman,new york,times,serif; font-size: = 12pt; color: #000000'><br><hr id=3D"zwchr"><blockquote style=3D"border-left= :2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;fon= t-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetic= a,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Gianluca Cecchi" <gian= luca.cecchi@gmail.com><br><b>To: </b>"Doron Fediuck" <dfediuck@redhat= .com><br><b>Cc: </b>"Livnat Peer" <lpeer@redhat.com>, "users" <= users@ovirt.org>, "Einav Cohen" <ecohen@redhat.com><br><b>Sent: </= b>Sunday, January 13, 2013 1:48:21 PM<br><b>Subject: </b>Re: [Users] win 7 = vm creation:<br><br><div dir=3D"ltr"><div class=3D"gmail_extra"><br><div cl= ass=3D"gmail_quote">On Sun, Jan 13, 2013 at 12:37 PM, Doron Fediuck wrote:<= br><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord= er-left:1px solid rgb(204,204,204);padding-left:1ex"> <br> Is your setup based on RPMs or built from source?</blockquote></div><br><di= v>when I had the problem it was based on ovirt-nightly for Fedora 18 based = on <br>3.2.0-1.20130101.git2184580<br></div>SO I don't know at that time wh= at were the contents of the file indicated...<br> </div></div> </blockquote>Do you still have it?<br></div></body></html> ------=_Part_3938548_1901943431.1358078680670--

----- Original Message -----
From: "Livnat Peer" <lpeer@redhat.com> To: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> Cc: "users" <users@ovirt.org> Sent: Sunday, January 13, 2013 12:27:57 PM Subject: Re: [Users] win 7 vm creation:
Hi Gianluca, From looking in the logs it looks like you had some DB upgrade issue, or DB clean install issue.
"Caused by: org.postgresql.util.PSQLException: The column name count_threads_as_cores was not found in this ResultSet"
Adding Doron to take take a look, and I think Einav also had some db upgrade issue last week...
Yes, she had, there was a bug on upgrade for pg 9.x (f18 defaulted to that) Anyway, this was merged already upstream http://gerrit.ovirt.org/#/c/10778/ You can fix and rerun the upgrade again
After fixing you DB issues, can you tell me if you have host in status up, I don't see any network related issue in the logs.
Livnat
On 01/05/2013 03:07 AM, Gianluca Cecchi wrote:
Current network config on host:
# ip addr list 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 <http://127.0.0.1/8> scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: em1: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c4 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c4/64 scope link valid_lft forever preferred_lft forever 3: em2: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1e:0b:21:b8:c6 brd ff:ff:ff:ff:ff:ff inet6 fe80::21e:bff:fe21:b8c6/64 scope link valid_lft forever preferred_lft forever 4: em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq master ovirtmgmt state UP qlen 1000 link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff 5: em4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc mq state UP qlen 1000 link/ether 00:1c:c4:ab:3a:de brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3ade/64 scope link valid_lft forever preferred_lft forever 6: em3.65@em3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet 10.4.4.59/24 <http://10.4.4.59/24> brd 10.4.4.255 scope global em3.65 inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever 11: ;vdsmdummy;: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN link/ether 96:14:65:da:bc:c5 brd ff:ff:ff:ff:ff:ff 12: bond0: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 13: bond4: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 14: bond1: <BROADCAST,MULTICAST,MASTER> mtu 1500 qdisc noop state DOWN link/ether 00:00:00:00:00:00 brd ff:ff:ff:ff:ff:ff 15: ovirtmgmt: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc noqueue state UP link/ether 00:1c:c4:ab:3a:dd brd ff:ff:ff:ff:ff:ff inet6 fe80::21c:c4ff:feab:3add/64 scope link valid_lft forever preferred_lft forever
# brctl show bridge namebridge idSTP enabledinterfaces ;vdsmdummy;8000.000000000000no ovirtmgmt8000.001cc4ab3addnoem3
Do I have perhaps to say/config that ovirtmgmt is tagged in any way?
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On Sun, Jan 13, 2013 at 1:32 PM, Eli Mesika wrote:
----- Original Message -----
From: "Livnat Peer" To: "Gianluca Cecchi" Cc: "users" <users@ovirt.org> Sent: Sunday, January 13, 2013 12:27:57 PM Subject: Re: [Users] win 7 vm creation:
Hi Gianluca, From looking in the logs it looks like you had some DB upgrade issue, or DB clean install issue.
"Caused by: org.postgresql.util.PSQLException: The column name count_threads_as_cores was not found in this ResultSet"
Adding Doron to take take a look, and I think Einav also had some db upgrade issue last week...
Yes, she had, there was a bug on upgrade for pg 9.x (f18 defaulted to that) Anyway, this was merged already upstream http://gerrit.ovirt.org/#/c/10778/ You can fix and rerun the upgrade again
Hello, now I have a setup with engine and host on separate servers, both fedora 18 and on engine rpm nightly as of 3.2.0-1.20130113.gitc954518 I get again this problem with a w7 vm. If I select run on any host I get w7test: Cannot run VM. There are no available running Hosts in the Host Cluster. If I select this particular (and currently only) host I get w7test: Cannot run VM. VM is pinned to a specific Host but cannot run on it due to: Invalid Host status or not enough free resources on it. You may free resources on the Host by migrating other VMs. Cannot run VM. There are no available running Hosts in the Host Cluster. My 03_02_0100_add_cpu_thread_columns.sql contains " select fn_db_add_column('vds_groups', 'count_threads_as_cores', 'BOOLEAN NOT NULL DEFAULT FALSE'); select fn_db_add_column('vds_dynamic', 'cpu_threads', 'INTEGER'); " So what should I do? My latest engine-upgrade was run on 14th of January If I want to stay at the moment on this release version should I only do upgrade of db after patch? so - stop engine # systemctl stop ovirt-engine.service cd /usr/share/ovirt-engine/dbscripts - patch drop_old_uuid_functions.sql - backup DB ./backup.sh - upgrade DB agan ./upgrade.sh ? Thanks Gianluca

On Thu, Jan 24, 2013 at 7:07 PM, Gianluca Cecchi wrote:
My latest engine-upgrade was run on 14th of January If I want to stay at the moment on this release version should I only do upgrade of db after patch?
Never mind, I decided to update to 3.2.0-1.20130123.git2ad65d0 that contains the fix and I was able to start the windows 7 vm Gianluca
participants (4)
-
Doron Fediuck
-
Eli Mesika
-
Gianluca Cecchi
-
Livnat Peer