[ovirt-users] Fail to upgrade to 4.1 from 4.0

[Martin Perina]

Hi,

first of all there's no 4.1 release, it's master developement branch, so
things can be broken there :-)

Anyway if you really want to try latest master, please use correct upgrade
steps:

1. Do full backup of you 4.0 version

2. Add ovirt-master repositories
     ​yum install http://resources.ovirt.org/pub
/yum-repo/ovirt-release-master.rpm

3. Update engine-setup packages
    yum update 'ovirt-engine-setup*'

4. Execute engine-setup


We have CI jobs testing regularly upgrade between 4.0 and master and
upgrade should be working OK unless we have a new bug here.
If above steps is not working for you please attach logs, especially logs
generated during engine-setup.

Thanks

Martin


On Wed, Sep 14, 2016 at 10:11 PM, Marcin M. Jessa <lists at yazzy.org> wrote:

> Hi guys.
>
> I have problems upgrading from oVirt 4.0 to 4.1
> This is what I did:
> #
> ​​
> yum install http://resources.ovirt.org/pub/yum-repo/ovirt-release-master
> .rpm
> # yum -y update
> # engine-setup
>
> Then it fails with following error:
> [ ERROR ] schema.sh: FATAL: Cannot execute sql command:
> --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_01_0010_
> add_mac_pool_id_to_vds_group.sql
> [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema
> refresh failed
>
> This is the 04_01_0010_add_mac_pool_id_to_vds_group.sql script:
>
> SELECT fn_db_add_column('cluster',
>                         'mac_pool_id',
>                         'UUID REFERENCES mac_pools (id)');
>
> UPDATE
>   cluster AS c
> SET
>   mac_pool_id = (
>       SELECT
>         sp.mac_pool_id
>       FROM
>         storage_pool sp
>       WHERE
>         sp.id = c.storage_pool_id
>     );
>
> ALTER TABLE cluster ALTER COLUMN mac_pool_id SET NOT NULL;
>
>
> The relevant portion of the log file:
> 2016-09-14 21:56:19 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbscripts/schema.sh',
> '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l',
> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20160914215252-64vhk6.log',
>
> '-c', 'apply'] stderr:
> psql:/usr/share/ovirt-engine/dbscripts/upgrade/04_01_0010_ad
> d_mac_pool_id_to_vds_group.sql:17: ERROR:  column "mac_pool_id" contains
> null values
> FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine
> /dbscripts/upgrade/04_01_0010_add_mac_pool_id_to_vds_group.sql
>
> 2016-09-14 21:56:19 ERROR otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema
> schema._misc:315 schema.sh: FATAL: Cannot execute sql command:
> --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_01_0010_
> add_mac_pool_id_to_vds_group.sql
> 2016-09-14 21:56:19 DEBUG otopi.context context._executeMethod:142 method
> exception
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/site-packages/otopi/context.py", line 132, in
> _executeMethod
>     method['method']()
>   File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-
> setup/ovirt-engine/db/schema.py", line 317, in _misc
>     raise RuntimeError(_('Engine schema refresh failed'))
> RuntimeError: Engine schema refresh failed
> 2016-09-14 21:56:19 ERROR otopi.context context._executeMethod:151 Failed
> to execute stage 'Misc configuration': Engine schema refresh failed
> 2016-09-14 21:56:19 DEBUG otopi.transaction transaction.abort:119 aborting
> 'Yum Transaction'
> 2016-09-14 21:56:19 INFO otopi.plugins.otopi.packagers.yumpackager
> yumpackager.info:80 Yum Performing yum transaction rollback
>
>
> Any idea how to fix that?
>
> --
>
> Marcin M. Jessa
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160915/871a330e/attachment.html>