On 07/27/2015 02:48 PM, Alexander Wels wrote:
Hi,
When I run engine-setup in the latest master I get the following error in
my setup log:
Running upgrade sql script
'/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/upgrade/03_06_1750_pinning_to_multiple_hosts_connection_table.sql'...
2015-07-27 14:42:15 DEBUG
otopi.plugins.ovirt_**FILTERED**_setup.ovirt_**FILTERED**.db.schema
plugin.execute:940 execute-output:
['/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/schema
.sh', '-s', 'awels.localdomain', '-p', '5432',
'-u', '**FILTERED**', '-d',
'**FILTERED**', '-l',
'/home/awels/ovirt-**FILTERED**/var/log/ovirt-**FILTERED**/setup/ovirt-**FILTERED**-setup-20150727144156-0
y2bqn.log', '-c', 'apply', '-m',
'/home/awels/ovirt-**FILTERED**/var/lib/ovirt-**FILTERED**/dbmd5/awels.localdomain-**FILTERED**.scripts.md5']
stderr:
psql:/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/upgrade/03_06_1750_pinning_to_multiple_hosts_connection_table.sql:17:
ERROR: invalid input syntax for uuid: "0723ca8b-ecda-4328-919
8-5ac9690ca1b7,932f05b4-e3b0-4e9a-ab99-77ff749138b3"
FATAL: Cannot execute sql command:
--file=/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/upgrade/03_06_1750_pinning_to_multiple_hosts_connection_table.sql
2015-07-27 14:42:15 DEBUG otopi.context context._executeMethod:155 method
exception
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/otopi/context.py", line 145, in
_executeMethod
method['method']()
File
"/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/setup/bin/../plugins/ovirt-**FILTERED**-setup/ovirt-**FILTERED**/db/schema.py",
line 291, in _misc
o**FILTERED**cons.EngineDBEnv.PGPASS_FILE
File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 945, in
execute
command=args[0],
RuntimeError: Command
'/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/schema.sh'
failed to execute
2015-07-27 14:42:15 ERRORotopi.context context._executeMethod:164 Failed
to execute stage 'Misc configuration': Command
'/home/awels/ovirt-**FILTERED**/share/ovirt-**FILTERED**/dbscripts/schema.sh'
fail
ed to execute
The upgrade script looks fine, so I am sort of lost as to how to fix it.
Any help would be appreciated.
Hi Alexander,
It looks like a bug. The upgrade script casts the
vm_static.dedicated_vm_for_vds value to a UUID, but in VmBaseDaoDbFacade
we see that this field may consist of a comma-delimited list of UUIDs.
To work around it for now you can update the offending
vm_static.dedicated_vm_for_vds values to have only a single UUID.
Unfortunately I don't know the "proper" fix (guessing vm_host_pinning_map
needs one value per UUID in dedicated_vm_for_vds?), but this should at
least get you up and running.
HTH,
Greg P
Thanks,
Alexander
_______________________________________________
Devel mailing list
Devel(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel