Re: [ovirt-devel] Errors when upgrading from 4.0 to master

[Martin Perina]

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  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  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/58/
>>
>> 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
>>
>> Tel.: +420 532 294 605
>> Email: dc...@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
> Red Hat Israel
>
> phone: +972-9-7692018
> irc: eedri (on #tlv #rhev-dev #rhev-integ)
>
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

Re: [ovirt-devel] Errors when upgrading from 4.0 to master

[Eyal Edri]

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  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/58/
>
> 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
>
> Tel.: +420 532 294 605
> Email: dc...@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
Red Hat Israel

phone: +972-9-7692018
irc: eedri (on #tlv #rhev-dev #rhev-integ)
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel

[ovirt-devel] Errors when upgrading from 4.0 to master

[David Caro]

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/58/

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

Tel.: +420 532 294 605
Email: dc...@redhat.com
IRC: dcaro|dcaroest@{freenode|oftc|redhat}
Web: www.redhat.com
RHT Global #: 82-62605


signature.asc
Description: PGP signature
___
Devel mailing list
Devel@ovirt.org
http://lists.ovirt.org/mailman/listinfo/devel