<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hi,<br><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">I've found the issue and fixed it in [1].<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">The problem was that upgrade scripts numbering for 4.0 version was different between master and ovirt-engine-4.0 branch. We will need to be careful about that until we will introduce 4.1 db upgrade scripts. This is planned to be done right after oVirt 4.0 GA, because we didn't want to complicate cherry picking of patches from master to 4.0.<br><br>Martin<br><br>[1] <a href="https://gerrit.ovirt.org/58604">https://gerrit.ovirt.org/58604</a><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jun 3, 2016 at 11:43 AM, Eyal Edri <span dir="ltr"><<a href="mailto:eedri@redhat.com" target="_blank">eedri@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Martin(s) - we talked about this on another thread.<div>Could it be the fix was partial and didn't handle upgrade from 4.0 to master?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jun 3, 2016 at 11:08 AM, David Caro <span dir="ltr"><<a href="mailto:dcaro@redhat.com" target="_blank">dcaro@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
Hi everyone!<br>
<br>
We have been seeing for a few days errors in the upgrade jobs for the<br>
4.0->master process, for example:<br>
<br>
<a href="http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged/58/" rel="noreferrer" target="_blank">http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged/58/</a><br>
<br>
The error happens when starting the engine again after the upgrade, it does not<br>
start up and shows this message in the engine.log:<br>
<br>
<br>
2016-06-03 07:27:22,331 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerCluster] (ServerService Thread Pool -- 50) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacsbymacpoolid(?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column c.mac_pool_id does not exist<br>
Where: PL/pgSQL function getallmacsbymacpoolid(uuid) line 3 at RETURN QUERY<br>
<br>
<br>
The question is, should we be doing something different to what we did before<br>
on the upgrade process? Is this a bug?<br>
<br>
<br>
Thanks!<br>
<span><font color="#888888"><br>
<br>
--<br>
David Caro<br>
<br>
Red Hat S.L.<br>
Continuous Integration Engineer - EMEA ENG Virtualization R&D<br>
<br>
Tel.: <a href="tel:%2B420%20532%20294%20605" value="+420532294605" target="_blank">+420 532 294 605</a><br>
Email: <a href="mailto:dcaro@redhat.com" target="_blank">dcaro@redhat.com</a><br>
IRC: dcaro|dcaroest@{freenode|oftc|redhat}<br>
Web: <a href="http://www.redhat.com" rel="noreferrer" target="_blank">www.redhat.com</a><br>
RHT Global #: 82-62605<br>
</font></span><br>_______________________________________________<br>
Devel mailing list<br>
<a href="mailto:Devel@ovirt.org" target="_blank">Devel@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/devel" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/devel</a><span class=""><font color="#888888"><br></font></span></blockquote></div><span class=""><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Eyal Edri<br>Associate Manager</div><div>RHEV DevOps<br>EMEA ENG Virtualization R&D<br>Red Hat Israel<br><br>phone: <a href="tel:%2B972-9-7692018" value="+97297692018" target="_blank">+972-9-7692018</a><br>irc: eedri (on #tlv #rhev-dev #rhev-integ)</div></div></div></div></div>
</font></span></div>
</blockquote></div><br></div></div>