Re: [ovirt-devel] Errors when upgrading from 4.0 to master
Martin(s) - we talked about this on another thread. Could it be the fix was partial and didn't handle upgrade from 4.0 to master? On Fri, Jun 3, 2016 at 11:08 AM, David Caro <dcaro@redhat.com> wrote:
Hi everyone!
We have been seeing for a few days errors in the upgrade jobs for the 4.0->master process, for example:
http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged...
The error happens when starting the engine again after the upgrade, it does not start up and shows this message in the engine.log:
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 Where: PL/pgSQL function getallmacsbymacpoolid(uuid) line 3 at RETURN QUERY
The question is, should we be doing something different to what we did before on the upgrade process? Is this a bug?
Thanks!
-- David Caro
Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D
Tel.: +420 532 294 605 Email: dcaro@redhat.com IRC: dcaro|dcaroest@{freenode|oftc|redhat} Web: www.redhat.com RHT Global #: 82-62605
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
-- Eyal Edri Associate Manager RHEV DevOps EMEA ENG Virtualization R&D Red Hat Israel phone: +972-9-7692018 irc: eedri (on #tlv #rhev-dev #rhev-integ)
Hi, not sure, I will investigate and reply to the thread. Martin On Fri, Jun 3, 2016 at 11:43 AM, Eyal Edri <eedri@redhat.com> wrote:
Martin(s) - we talked about this on another thread. Could it be the fix was partial and didn't handle upgrade from 4.0 to master?
On Fri, Jun 3, 2016 at 11:08 AM, David Caro <dcaro@redhat.com> wrote:
Hi everyone!
We have been seeing for a few days errors in the upgrade jobs for the 4.0->master process, for example:
http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged...
The error happens when starting the engine again after the upgrade, it does not start up and shows this message in the engine.log:
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 Where: PL/pgSQL function getallmacsbymacpoolid(uuid) line 3 at RETURN QUERY
The question is, should we be doing something different to what we did before on the upgrade process? Is this a bug?
Thanks!
-- David Caro
Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D
Tel.: +420 532 294 605 Email: dcaro@redhat.com IRC: dcaro|dcaroest@{freenode|oftc|redhat} Web: www.redhat.com RHT Global #: 82-62605
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
-- Eyal Edri Associate Manager RHEV DevOps EMEA ENG Virtualization R&D Red Hat Israel
phone: +972-9-7692018 irc: eedri (on #tlv #rhev-dev #rhev-integ)
Hi, I've found the issue and fixed it in [1]. 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. Martin [1] https://gerrit.ovirt.org/58604 On Fri, Jun 3, 2016 at 11:43 AM, Eyal Edri <eedri@redhat.com> wrote:
Martin(s) - we talked about this on another thread. Could it be the fix was partial and didn't handle upgrade from 4.0 to master?
On Fri, Jun 3, 2016 at 11:08 AM, David Caro <dcaro@redhat.com> wrote:
Hi everyone!
We have been seeing for a few days errors in the upgrade jobs for the 4.0->master process, for example:
http://jenkins.ovirt.org/job/ovirt-engine_master_upgrade-from-4.0_el7_merged...
The error happens when starting the engine again after the upgrade, it does not start up and shows this message in the engine.log:
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 Where: PL/pgSQL function getallmacsbymacpoolid(uuid) line 3 at RETURN QUERY
The question is, should we be doing something different to what we did before on the upgrade process? Is this a bug?
Thanks!
-- David Caro
Red Hat S.L. Continuous Integration Engineer - EMEA ENG Virtualization R&D
Tel.: +420 532 294 605 Email: dcaro@redhat.com IRC: dcaro|dcaroest@{freenode|oftc|redhat} Web: www.redhat.com RHT Global #: 82-62605
_______________________________________________ Devel mailing list Devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/devel
-- Eyal Edri Associate Manager RHEV DevOps EMEA ENG Virtualization R&D Red Hat Israel
phone: +972-9-7692018 irc: eedri (on #tlv #rhev-dev #rhev-integ)
participants (2)
-
Eyal Edri -
Martin Perina