[Users] win 7 vm creation:

[Gianluca Cecchi]

On Sun, Jan 13, 2013 at 1:32 PM, Eli Mesika wrote:
>
>
> ----- Original Message -----
>> From: "Livnat Peer"
>> To: "Gianluca Cecchi"
>> Cc: "users" <users at 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