[Engine-devel] engine database upgrade failure with latest

Sat Nov 10 00:14:30 UTC 2012

Very odd I stopped the engine service manually and ran engine-upgrade. This
time it succeeded. For fun I removed the engine and re-installed the prior
build. I again ran engine-upgrade and the failure reproduced again. I
stopped the engine service again and ran engine-upgrade and it succeeded
the second attempt.
- DHC

On Fri, Nov 9, 2012 at 3:10 PM, Dead Horse <deadhorseconsulting at gmail.com>wrote:

> Clarifying further:
> What is running that I am attempting to upgrade:
> (parent: 6125e33<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=6125e335cbb49730899c6feeb05147db6d0c4eaa>
> )
> core: Improve error logging when there are LDAP queries errors <http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commitdiff;h=a665ec3af7b2dd04e80007b1c062868d3e049fce>
> 28/9028/2<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=shortlog;h=refs/changes/28/9028/2>
>  authorYair Zaslavsky<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=a665ec3af7b2dd04e80007b1c062868d3e049fce;s=Yair+Zaslavsky;st=author>
>  <yzaslavs at redhat.com><http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=a665ec3af7b2dd04e80007b1c062868d3e049fce;s=yzaslavs@redhat.com;st=author>
>
> Mon, 5 Nov 2012 10:28:23 +0000 (12:28 +0200)committerYair Zaslavsky<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=a665ec3af7b2dd04e80007b1c062868d3e049fce;s=Yair+Zaslavsky;st=committer>
>  <yzaslavs at redhat.com><http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=a665ec3af7b2dd04e80007b1c062868d3e049fce;s=yzaslavs@redhat.com;st=committer>
>
> Mon, 5 Nov 2012 15:43:40 +0000 (17:43 +0200)commita665ec3af7b2dd04e80007b1c062868d3e049fce
> treef448ae8313c2417dd578469de20e7d332e085490<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=tree;h=f448ae8313c2417dd578469de20e7d332e085490;hb=a665ec3af7b2dd04e80007b1c062868d3e049fce>
> <http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=tree;h=f448ae8313c2417dd578469de20e7d332e085490;hb=a665ec3af7b2dd04e80007b1c062868d3e049fce>
> parent6125e335cbb49730899c6feeb05147db6d0c4eaa<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=6125e335cbb49730899c6feeb05147db6d0c4eaa>
> <http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=6125e335cbb49730899c6feeb05147db6d0c4eaa>
>
> What I just built and attempting to upgrade with:
> (parent: 025b98c<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=025b98c2a7f7b4a7f4bca417d2dfa95199adfa91>
> )
> core: removed getVmNetworkInterfaceDao <http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commitdiff;h=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8>
> 05/9105/2<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=shortlog;h=refs/changes/05/9105/2>
>  master<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=shortlog;h=refs/heads/master>
>  authorLaszlo Hornyak<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8;s=Laszlo+Hornyak;st=author>
>  <lhornyak at redhat.com><http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8;s=lhornyak@redhat.com;st=author>
>
> Wed, 7 Nov 2012 14:25:03 +0000 (15:25 +0100)committerLaszlo Hornyak<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8;s=Laszlo+Hornyak;st=committer>
>  <lhornyak at redhat.com><http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=search;h=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8;s=lhornyak@redhat.com;st=committer>
>
> Thu, 8 Nov 2012 20:01:59 +0000 (21:01 +0100)commit2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8
> tree71f522f4a30dea8871e7d5f95dbd126045aa8135<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=tree;h=71f522f4a30dea8871e7d5f95dbd126045aa8135;hb=2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8>
> parent 025b98c2a7f7b4a7f4bca417d2dfa95199adfa91<http://gerrit.ovirt.org/gitweb?p=ovirt-engine.git;a=commit;h=025b98c2a7f7b4a7f4bca417d2dfa95199adfa91>
>
>
>
> On Fri, Nov 9, 2012 at 2:52 PM, Dead Horse <deadhorseconsulting at gmail.com>wrote:
>
>> Correct the version I am attempting to upgrade was built from master on
>> Monday. I just built master from today and attempted to upgrade the running
>> instance I built from master on Monday.
>>
>>
>>
>> On Fri, Nov 9, 2012 at 2:49 PM, Alon Bar-Lev <alonbl at redhat.com> wrote:
>>
>>> You wrote version from Monday...
>>> (a665ec3af7b2dd04e80007b1c062868d3e049fce)
>>> Which was before patch was applied.
>>>
>>> ----- Original Message -----
>>> > From: "Dead Horse" <deadhorseconsulting at gmail.com>
>>> > To: "Alon Bar-Lev" <alonbl at redhat.com>
>>> > Cc: engine-devel at ovirt.org
>>> > Sent: Friday, November 9, 2012 10:42:28 PM
>>> > Subject: Re: [Engine-devel] engine database upgrade failure with latest
>>> >
>>> > cloned via git clone http://gerrit.ovirt.org/p/ovirt-engine (so
>>> > master by default)
>>> > current master commit appears to me as:
>>> > commit        2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8
>>> >
>>> >
>>> >
>>> > On Fri, Nov 9, 2012 at 2:32 PM, Alon Bar-Lev < alonbl at redhat.com >
>>> > wrote:
>>> >
>>> >
>>> >
>>> > Strange...
>>> >
>>> > This[1] patch should have solved this. It is merged to master.
>>> > Are you using master?
>>> >
>>> > [1] http://gerrit.ovirt.org/#/c/8955/
>>> >
>>> >
>>> >
>>> > ----- Original Message -----
>>> > > From: "Dead Horse" < deadhorseconsulting at gmail.com >
>>> > > To: engine-devel at ovirt.org
>>> > > Sent: Friday, November 9, 2012 10:28:18 PM
>>> > > Subject: [Engine-devel] engine database upgrade failure with latest
>>> > >
>>> > >
>>> > > I built the latest ovirt-engine from GIT and attempted to upgrade.
>>> > > Version that I attempting to upgrade was built Monday from master
>>> > > (commit: a665ec3af7b2dd04e80007b1c062868d3e049fce).
>>> > >
>>> > > Below is the what was logged by engine-upgrade:
>>> > > 2012-11-09 14:15:54::DEBUG::engine-upgrade::425::root:: DB Update
>>> > > started
>>> > > 2012-11-09 14:15:54::DEBUG::common_utils::390::root:: Executing
>>> > > command --> '/usr/share/ovirt-engine/dbscripts/upgrade.sh -s
>>> > > localhost -p 5432 -u engine -d engine_2012_11_09_14_12_52'
>>> > > 2012-11-09 14:15:58::DEBUG::common_utils::428::root:: output =
>>> > > upgrade script detected a change in Config, View or Stored
>>> > > Procedure...
>>> > >
>>> > > 2012-11-09 14:15:58::DEBUG::common_utils::429::root:: stderr =
>>> > > psql:create_functions.sql:666: ERROR: must be owner of function
>>> > > uuid_generate_v1
>>> > >
>>> > > 2012-11-09 14:15:58::DEBUG::common_utils::430::root:: retcode = 3
>>> > > 2012-11-09 14:15:58::ERROR::engine-upgrade::1072::root:: Traceback
>>> > > (most recent call last):
>>> > > File "/usr/bin/engine-upgrade", line 1059, in main
>>> > > runFunc([db.update], MSG_INFO_DB_UPDATE)
>>> > > File "/usr/bin/engine-upgrade", line 607, in runFunc
>>> > > func()
>>> > > File "/usr/bin/engine-upgrade", line 442, in update
>>> > > output, rc = utils.execCmd(cmdList=cmd, failOnError=True,
>>> > > msg=MSG_ERROR_UPDATE_DB)
>>> > > File "/usr/share/ovirt-engine/scripts/common_utils.py", line 433,
>>> > > in
>>> > > execCmd
>>> > > raise Exception(msg)
>>> > > Exception: Error: Database update failed
>>> > >
>>> > > - DHC
>>> > >
>>> > >
>>> > > _______________________________________________
>>> > > Engine-devel mailing list
>>> > > Engine-devel at ovirt.org
>>> > > http://lists.ovirt.org/mailman/listinfo/engine-devel
>>> > >
>>> >
>>> >
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/devel/attachments/20121109/68d63a2f/attachment-0002.html>