[ovirt-devel] upgrade script failing in latest master

[Greg Padgett]

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