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

Thu Sep 15 04:09:25 EDT 2016

On Thu, Sep 15, 2016 at 10:05 AM, Marcin M. Jessa <lists at yazzy.org> wrote:

> Hi.
>
> I never claimed it was a release ;)
>

Sure, it was just a warning :-)

> 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
>

Please share setup log from /var/log/ovirt-engine/setup, exact name is
printed at the end of engine-setup and usually it's the latest file.
Also from which 4.0.x version are you upgrading?

Thanks

Martin

>
>
>
> 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 at yazzy.org
>> <mailto: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
>>     <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-201609142152
>> 52-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 <http://yumpackager.info:80> Yum Performing yum
>>     transaction rollback
>>
>>
>>     Any idea how to fix that?
>>
>>     --
>>
>>     Marcin M. Jessa
>>     _______________________________________________
>>     Users mailing list
>>     Users at ovirt.org <mailto:Users at ovirt.org>
>>     http://lists.ovirt.org/mailman/listinfo/users
>>     <http://lists.ovirt.org/mailman/listinfo/users>
>>
>>
>>
>
> --
>
> Marcin M. Jessa
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160915/857cfc27/attachment-0001.html>