From: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; 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

From: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; 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 >

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&gt; wrote: > You wrote version from Monday... > (a665ec3af7b2dd04e80007b1c062868d3e049fce) > Which was before patch was applied. > > ----- Original Message ----- > > From: "Dead Horse" <deadhorseconsulting(a)gmail.com&gt; > > To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; > > 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 > > > > > > > >

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