[Engine-devel] engine database upgrade failure with latest

[Alon Bar-Lev]

Indeed odd, as the engine-upgrade stops the engine service if you answer 'yes' at the beginning.
Or maybe you upgrade using unattended mode and this is skipped.

----- Original Message -----
> From: "Dead Horse" <deadhorseconsulting at gmail.com>
> To: "Alon Bar-Lev" <alonbl at redhat.com>
> Cc: engine-devel at ovirt.org
> Sent: Saturday, November 10, 2012 2:14:30 AM
> Subject: Re: [Engine-devel] engine database upgrade failure with latest
> 
> 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 )
> 
> core: Improve error logging when there are LDAP queries errors
> 28/9028/2
> author 	Yair Zaslavsky <yzaslavs at redhat.com>
> 
> 
> 	Mon, 5 Nov 2012 10:28:23 +0000 (12:28 +0200)
> committer 	Yair Zaslavsky <yzaslavs at redhat.com>
> 
> 
> 	Mon, 5 Nov 2012 15:43:40 +0000 (17:43 +0200)
> commit 	a665ec3af7b2dd04e80007b1c062868d3e049fce
> tree 	f448ae8313c2417dd578469de20e7d332e085490
> 
> parent 	6125e335cbb49730899c6feeb05147db6d0c4eaa
> 
> What I just built and attempting to upgrade with:
> 
> (parent: 025b98c )
> 
> core: removed getVmNetworkInterfaceDao 05/9105/2 master
> author 	Laszlo Hornyak <lhornyak at redhat.com>
> 
> 
> 	Wed, 7 Nov 2012 14:25:03 +0000 (15:25 +0100)
> committer 	Laszlo Hornyak <lhornyak at redhat.com>
> 
> 
> 	Thu, 8 Nov 2012 20:01:59 +0000 (21:01 +0100)
> commit 	2dc9b518099ec1ac3995abf1483f43cdcb6eb2b8
> tree 	71f522f4a30dea8871e7d5f95dbd126045aa8135
> 
> parent 	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
> > > 
> > 
> > 
> 
> 
> 
>