Hi.

I never claimed it was a release ;)

Anyway. I followed your listed points adding the additional step but upgrade still fails exactly at the same point.

[ 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

Cheers,
Marcin.




On 15/09/2016 09:00, Martin Perina wrote:

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
<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@yazzy.org
<mailto:lists@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
    <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 <http://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_add_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 <http://yumpackager.info:80> Yum Performing yum
    transaction rollback


    Any idea how to fix that?

    --

    Marcin M. Jessa
    _______________________________________________
    Users mailing list
    Users@ovirt.org <mailto:Users@ovirt.org>
    http://lists.ovirt.org/mailman/listinfo/users
    <http://lists.ovirt.org/mailman/listinfo/users>

--

Marcin M. Jessa