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@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel