<div dir="ltr"><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">Hi,<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">first of all there's no 4.1 release, it's master developement branch, so things can be broken there :-)<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">Anyway if you really want to try latest master, please use correct upgrade steps:<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">1. Do full backup of you 4.0 version<br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default"><br>2. Add ovirt-master repositories<br> yum install <a target="_blank" rel="noreferrer" href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm">http://resources.ovirt.org/pub<wbr>/yum-repo/ovirt-release-master<wbr>.rpm</a><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default"><br>3. Update engine-setup packages<br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default"> yum update 'ovirt-engine-setup*'<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">4. Execute engine-setup<br><br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">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.<br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">If above steps is not working for you please attach logs, especially logs generated during engine-setup.<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">Thanks<br><br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default">Martin<br></div><div style="font-family:arial,helvetica,sans-serif" class="gmail_default"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Sep 14, 2016 at 10:11 PM, Marcin M. Jessa <span dir="ltr"><<a target="_blank" href="mailto:lists@yazzy.org">lists@yazzy.org</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">Hi guys.<br>
<br>
I have problems upgrading from oVirt 4.0 to 4.1<br>
This is what I did:<br>
# <div style="font-family:arial,helvetica,sans-serif;display:inline" class="gmail_default"></div>yum install <a target="_blank" rel="noreferrer" href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm">http://resources.ovirt.org/pub<wbr>/yum-repo/ovirt-release-master<wbr>.rpm</a><br>
# yum -y update<br>
# engine-setup<br>
<br>
Then it fails with following error:<br>
[ ERROR ] schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine<wbr>/dbscripts/upgrade/04_01_0010_<wbr>add_mac_pool_id_to_vds_group.<wbr>sql<br>
[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed<br>
<br>
This is the 04_01_0010_add_mac_pool_id_to_<wbr>vds_group.sql script:<br>
<br>
SELECT fn_db_add_column('cluster',<br>
'mac_pool_id',<br>
'UUID REFERENCES mac_pools (id)');<br>
<br>
UPDATE<br>
cluster AS c<br>
SET<br>
mac_pool_id = (<br>
SELECT<br>
sp.mac_pool_id<br>
FROM<br>
storage_pool sp<br>
WHERE<br>
<a target="_blank" rel="noreferrer" href="http://sp.id">sp.id</a> = c.storage_pool_id<br>
);<br>
<br>
ALTER TABLE cluster ALTER COLUMN mac_pool_id SET NOT NULL;<br>
<br>
<br>
The relevant portion of the log file:<br>
2016-09-14 21:56:19 DEBUG otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema plugin.execute:926 execute-output: ['/usr/share/ovirt-engine/dbsc<wbr>ripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/o<wbr>virt-engine-setup-201609142152<wbr>52-64vhk6.log', <br>
'-c', 'apply'] stderr:<br>
psql:/usr/share/ovirt-engine/d<wbr>bscripts/upgrade/04_01_0010_ad<wbr>d_mac_pool_id_to_vds_group.sql<wbr>:17: ERROR: column "mac_pool_id" contains null values<br>
FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine<wbr>/dbscripts/upgrade/04_01_0010_<wbr>add_mac_pool_id_to_vds_group.<wbr>sql<br>
<br>
2016-09-14 21:56:19 ERROR otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema schema._misc:315 schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine<wbr>/dbscripts/upgrade/04_01_0010_<wbr>add_mac_pool_id_to_vds_group.<wbr>sql<br>
2016-09-14 21:56:19 DEBUG otopi.context context._executeMethod:142 method exception<br>
Traceback (most recent call last):<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/context.py", line 132, in _executeMethod<br>
method['method']()<br>
File "/usr/share/ovirt-engine/setup<wbr>/bin/../plugins/ovirt-engine-<wbr>setup/ovirt-engine/db/schema.<wbr>py", line 317, in _misc<br>
raise RuntimeError(_('Engine schema refresh failed'))<br>
RuntimeError: Engine schema refresh failed<br>
2016-09-14 21:56:19 ERROR otopi.context context._executeMethod:151 Failed to execute stage 'Misc configuration': Engine schema refresh failed<br>
2016-09-14 21:56:19 DEBUG otopi.transaction transaction.abort:119 aborting 'Yum Transaction'<br>
2016-09-14 21:56:19 INFO otopi.plugins.otopi.packagers.<wbr>yumpackager <a target="_blank" rel="noreferrer" href="http://yumpackager.info:80">yumpackager.info:80</a> Yum Performing yum transaction rollback<br>
<br>
<br>
Any idea how to fix that?<span class="gmail-HOEnZb"><font color="#888888"><br>
<br>
-- <br>
<br>
Marcin M. Jessa<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a target="_blank" href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a target="_blank" rel="noreferrer" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</font></span></blockquote></div><br></div></div>