<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 15, 2016 at 10:05 AM, Marcin M. Jessa <span dir="ltr"><<a href="mailto:lists@yazzy.org" target="_blank">lists@yazzy.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi.<br>
<br>
I never claimed it was a release ;)<br></blockquote><div><br><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">Sure, it was just a warning :-)<br></div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Anyway. I followed your listed points adding the additional step but upgrade still fails exactly at the same point.<br>
<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></blockquote><div><br><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">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.<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">Also from which 4.0.x version are you upgrading?<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">Thanks<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif;display:inline">Martin<br></div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
<br>
Cheers,<br>
Marcin.<br>
<br>
<br>
<br>
<br>
On 15/09/2016 09:00, Martin Perina wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
first of all there's no 4.1 release, it's master developement branch, so<br>
things can be broken there :-)<br>
<br>
Anyway if you really want to try latest master, please use correct<br>
upgrade steps:<br>
<br>
1. Do full backup of you 4.0 version<br>
<br>
2. Add ovirt-master repositories<br>
yum install<br>
<a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm" rel="noreferrer" target="_blank">http://resources.ovirt.org/pub<wbr>/yum-repo/ovirt-release-master<wbr>.rpm</a><br>
<<a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm" rel="noreferrer" target="_blank">http://resources.ovirt.org/pu<wbr>b/yum-repo/ovirt-release-maste<wbr>r.rpm</a>><br>
<br>
3. Update engine-setup packages<br>
yum update 'ovirt-engine-setup*'<br>
<br>
4. Execute engine-setup<br>
<br>
<br>
We have CI jobs testing regularly upgrade between 4.0 and master and<br>
upgrade should be working OK unless we have a new bug here.<br>
If above steps is not working for you please attach logs, especially<br>
logs generated during engine-setup.<br>
<br>
Thanks<br>
<br>
Martin<br>
<br>
<br>
On Wed, Sep 14, 2016 at 10:11 PM, Marcin M. Jessa <<a href="mailto:lists@yazzy.org" target="_blank">lists@yazzy.org</a><br>
<mailto:<a href="mailto:lists@yazzy.org" target="_blank">lists@yazzy.org</a>>> wrote:<br>
<br>
Hi guys.<br>
<br>
I have problems upgrading from oVirt 4.0 to 4.1<br>
This is what I did:<br>
#<br>
<br>
yum install<br>
<a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm" rel="noreferrer" target="_blank">http://resources.ovirt.org/pub<wbr>/yum-repo/ovirt-release-master<wbr>.rpm</a><br>
<<a href="http://resources.ovirt.org/pub/yum-repo/ovirt-release-master.rpm" rel="noreferrer" target="_blank">http://resources.ovirt.org/pu<wbr>b/yum-repo/ovirt-release-maste<wbr>r.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:<br>
--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<br>
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 href="http://sp.id" rel="noreferrer" target="_blank">sp.id</a> <<a href="http://sp.id" rel="noreferrer" target="_blank">http://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<br>
otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema<br>
plugin.execute:926 execute-output:<br>
['/usr/share/ovirt-engine/dbsc<wbr>ripts/schema.sh', '-s', 'localhost',<br>
'-p', '5432', '-u', 'engine', '-d', 'engine', '-l',<br>
'/var/log/ovirt-engine/setup/o<wbr>virt-engine-setup-201609142152<wbr>52-64vhk6.log',<br>
<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:<br>
ERROR: column "mac_pool_id" contains null values<br>
FATAL: Cannot execute sql command:<br>
--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<br>
otopi.plugins.ovirt_engine_set<wbr>up.ovirt_engine.db.schema<br>
schema._misc:315 schema.sh: FATAL: Cannot execute sql command:<br>
--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<br>
method exception<br>
Traceback (most recent call last):<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/context.py", line<br>
132, in _executeMethod<br>
method['method']()<br>
File<br>
"/usr/share/ovirt-engine/setup<wbr>/bin/../plugins/ovirt-engine-<wbr>setup/ovirt-engine/db/schema.<wbr>py",<br>
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<br>
Failed to execute stage 'Misc configuration': Engine schema refresh<br>
failed<br>
2016-09-14 21:56:19 DEBUG otopi.transaction transaction.abort:119<br>
aborting 'Yum Transaction'<br>
2016-09-14 21:56:19 INFO otopi.plugins.otopi.packagers.<wbr>yumpackager<br>
<a href="http://yumpackager.info:80" rel="noreferrer" target="_blank">yumpackager.info:80</a> <<a href="http://yumpackager.info:80" rel="noreferrer" target="_blank">http://yumpackager.info:80</a>> Yum Performing yum<br>
transaction rollback<br>
<br>
<br>
Any idea how to fix that?<br>
<br>
--<br>
<br>
Marcin M. Jessa<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
<<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailma<wbr>n/listinfo/users</a>><br>
<br>
<br><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<br>
-- <br>
<br>
Marcin M. Jessa<br>
</font></span></blockquote></div><br></div></div>