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