3:09 a.m.
On Thu, Sep 15, 2016 at 10:05 AM, Marcin M. Jessa <lists(a)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(a)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-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(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users>
>
>
>
--
Marcin M. Jessa