Re: [Engine-devel] engine database upgrade failure with latest

From: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; Cc: engine-devel(a)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(a)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(a)redhat.com&gt; Mon, 5 Nov 2012 10:28:23 +0000 (12:28 +0200) committer Yair Zaslavsky <yzaslavs(a)redhat.com&gt; 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(a)redhat.com&gt; Wed, 7 Nov 2012 14:25:03 +0000 (15:25 +0100) committer Laszlo Hornyak <lhornyak(a)redhat.com&gt; 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(a)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(a)redhat.com > wrote: You wrote version from Monday... (a665ec3af7b2dd04e80007b1c062868d3e049fce) Which was before patch was applied. ----- Original Message ----- > From: "Dead Horse" < deadhorseconsulting(a)gmail.com > > To: "Alon Bar-Lev" < alonbl(a)redhat.com > > Cc: engine-devel(a)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(a)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(a)gmail.com > > > To: engine-devel(a)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(a)ovirt.org > > http://lists.ovirt.org/mailman/listinfo/engine-devel > > > >