<p dir="ltr">Hi guys,  sorry to repost but getting a bit desperate. Is anyone able to assist?  </p>
<p dir="ltr">Thanks. </p>
<p dir="ltr">Regards. </p>
<p dir="ltr">Neil Wilson </p>
<div class="gmail_quote">On 21 May 2014 12:06 PM, &quot;Neil&quot; &lt;<a href="mailto:nwilson123@gmail.com">nwilson123@gmail.com</a>&gt; wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi guys,<br>
<br>
Just a little more info on the problem. I&#39;ve upgraded another oVirt<br>
system before from Dreyou and it worked perfectly, however on this<br>
particular system, we had to restore from backups (DB PKI and<br>
etc/ovirt-engine) as the physical machine died that was hosting the<br>
engine, so perhaps this is the reason we encountering this problem<br>
this time around...<br>
<br>
Any help is greatly appreciated.<br>
<br>
Thank you.<br>
<br>
Regards.<br>
<br>
Neil Wilson.<br>
<br>
<br>
<br>
On Wed, May 21, 2014 at 11:46 AM, Sven Kieske &lt;<a href="mailto:S.Kieske@mittwald.de">S.Kieske@mittwald.de</a>&gt; wrote:<br>
&gt; Hi,<br>
&gt;<br>
&gt; I don&#39;t know the exact resolution for this, but I&#39;ll add some people<br>
&gt; who managed to make it work, following this tutorial:<br>
&gt; <a href="http://wiki.dreyou.org/dokuwiki/doku.php?id=ovirt_rpm_start33" target="_blank">http://wiki.dreyou.org/dokuwiki/doku.php?id=ovirt_rpm_start33</a><br>
&gt;<br>
&gt; See this thread on the users ML:<br>
&gt;<br>
&gt; <a href="http://lists.ovirt.org/pipermail/users/2013-December/018341.html" target="_blank">http://lists.ovirt.org/pipermail/users/2013-December/018341.html</a><br>
&gt;<br>
&gt; HTH<br>
&gt;<br>
&gt;<br>
&gt; Am 20.05.2014 17:00, schrieb Neil:<br>
&gt;&gt; Hi guys,<br>
&gt;&gt;<br>
&gt;&gt; I&#39;m trying to upgrade from Dreyou to the official repo, I&#39;ve installed<br>
&gt;&gt; the official 3.2 repo (I&#39;ll do the 3.3 update once this works). I&#39;ve<br>
&gt;&gt; updated to ovirt-engine-setup.noarch 0:3.2.3-1.el6 and when I run<br>
&gt;&gt; engine upgrade it bombs out when trying to rename my database with the<br>
&gt;&gt; following error...<br>
&gt;&gt;<br>
&gt;&gt; [root@engine01 /]#  cat<br>
&gt;&gt; /var/log/ovirt-engine/ovirt-engine-upgrade_2014_05_20_16_34_21.log<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB host value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB port value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB user value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Loaded plugins: refresh-packagekit, versionlock<br>
&gt;&gt; 2014-05-20 16:34:21::INFO::engine-upgrade::969::root:: Info:<br>
&gt;&gt; /etc/ovirt-engine/.pgpass file found. Continue.<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB admin value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB host value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::804::root:: found existing<br>
&gt;&gt; pgpass file /etc/ovirt-engine/.pgpass, fetching DB port value<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;SELECT pg_database_size(&#39;engine&#39;)&#39; on db server: &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U postgres -d<br>
&gt;&gt; postgres -c SELECT pg_database_size(&#39;engine&#39;)&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::472::root:: output =  pg_database_size<br>
&gt;&gt; ------------------<br>
&gt;&gt;          11976708<br>
&gt;&gt; (1 row)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::1567::root:: Found mount<br>
&gt;&gt; point of &#39;/var/cache/yum&#39; at &#39;/&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::663::root:: Checking<br>
&gt;&gt; available space on /var/cache/yum<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::668::root:: Available space<br>
&gt;&gt; on /var/cache/yum is 172329<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::1567::root:: Found mount<br>
&gt;&gt; point of &#39;/var/lib/ovirt-engine/backups&#39; at &#39;/&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::663::root:: Checking<br>
&gt;&gt; available space on /var/lib/ovirt-engine/backups<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::668::root:: Available space<br>
&gt;&gt; on /var/lib/ovirt-engine/backups is 172329<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::1567::root:: Found mount<br>
&gt;&gt; point of &#39;/usr/share&#39; at &#39;/&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::663::root:: Checking<br>
&gt;&gt; available space on /usr/share<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::668::root:: Available space<br>
&gt;&gt; on /usr/share is 172329<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::1590::root:: Mount points<br>
&gt;&gt; are: {&#39;/&#39;: {&#39;required&#39;: 1511, &#39;free&#39;: 172329}}<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::1599::root:: Comparing free<br>
&gt;&gt; space 172329 MB with required 1511 MB<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;SELECT compatibility_version FROM storage_pool;&#39; on db server:<br>
&gt;&gt; &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c<br>
&gt;&gt; SELECT compatibility_version FROM storage_pool;&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; compatibility_version<br>
&gt;&gt; -----------------------<br>
&gt;&gt;  3.2<br>
&gt;&gt; (1 row)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;SELECT compatibility_version FROM vds_groups;&#39; on db server:<br>
&gt;&gt; &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c<br>
&gt;&gt; SELECT compatibility_version FROM vds_groups;&#39;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; compatibility_version<br>
&gt;&gt; -----------------------<br>
&gt;&gt;  3.2<br>
&gt;&gt; (1 row)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::engine-upgrade::280::root:: Yum unlock started<br>
&gt;&gt; 2014-05-20 16:34:21::DEBUG::engine-upgrade::292::root:: Yum unlock<br>
&gt;&gt; completed successfully<br>
&gt;&gt; 2014-05-20 16:34:22::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdu5SB03tmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:22::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdu5SB03tmp.xml 3.7 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:30::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdf3Wi70tmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:30::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdf3Wi70tmp.xml 2.9 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:30::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdf3Wi70tmp.xml 2.9 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:31::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdHz6Ctstmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:31::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdHz6Ctstmp.xml 3.4 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:37::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdyHOcNQtmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:37::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdyHOcNQtmp.xml 2.9 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:38::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdTvp5RWtmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:39::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdTvp5RWtmp.xml 2.9 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:40::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdpoFiQgtmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:40::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomdpoFiQgtmp.xml 3.4 k(100%)<br>
&gt;&gt; 2014-05-20 16:34:41::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomddmRA9ttmp.xml (0%)<br>
&gt;&gt; 2014-05-20 16:34:41::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Downloading: repomddmRA9ttmp.xml 951 (100%)<br>
&gt;&gt; 2014-05-20 16:34:41::DEBUG::common_utils::332::root:: YUM: VERB: queue<br>
&gt;&gt; package ovirt-engine for update<br>
&gt;&gt; 2014-05-20 16:34:42::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; package ovirt-engine queued<br>
&gt;&gt; 2014-05-20 16:34:42::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Building transaction<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Transaction built<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::314::root:: Transaction Summary:<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-backend-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-dbscripts-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-genericapi-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-restapi-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-tools-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-userportal-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::318::root::     update -<br>
&gt;&gt; ovirt-engine-webadmin-portal-3.2.3-1.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::329::root:: Yum<br>
&gt;&gt; rollback-avail started<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:44::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-backend-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:45::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-dbscripts-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:45::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-genericapi-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:46::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-restapi-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:46::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-tools-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:47::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-userportal-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:47::DEBUG::engine-upgrade::335::root:: Checking<br>
&gt;&gt; package ovirt-engine-webadmin-portal-3.2.2-1.1.43.el6.noarch<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::engine-upgrade::340::root:: Yum<br>
&gt;&gt; rollback-avail completed successfully<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::engine-upgrade::1045::root:: related to<br>
&gt;&gt; database package ovirt-engine-backend<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::engine-upgrade::1045::root:: related to<br>
&gt;&gt; database package ovirt-engine-dbscripts<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::engine-upgrade::200::root:: checking the<br>
&gt;&gt; status of ovirt-engine service<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/sbin/service ovirt-engine status&#39;<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::472::root:: output = The<br>
&gt;&gt; engine is not running.<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::474::root:: retcode = 3<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::engine-upgrade::595::root:: stopping<br>
&gt;&gt; ovirt-engine service.<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/sbin/service ovirt-engine stop&#39;<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; Stopping engine-service: [  OK  ]<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::1289::root:: getting status<br>
&gt;&gt; for engine-notifierd<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::1298::root:: executing<br>
&gt;&gt; action engine-notifierd on service status<br>
&gt;&gt; 2014-05-20 16:34:48::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/sbin/service engine-notifierd status&#39;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; /etc/init.d/engine-notifierd is stopped<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::474::root:: retcode = 1<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::engine-upgrade::840::root:: Checking<br>
&gt;&gt; active system tasks<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -U engine -f<br>
&gt;&gt; /usr/share/ovirt-engine/scripts/add_fn_db_get_async_tasks_function.sql<br>
&gt;&gt; -d engine&#39;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::472::root:: output = DROP TYPE<br>
&gt;&gt; CREATE TYPE<br>
&gt;&gt; CREATE FUNCTION<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; psql:/usr/share/ovirt-engine/scripts/add_fn_db_get_async_tasks_function.sql:18:<br>
&gt;&gt; NOTICE:  drop cascades to function fn_db_get_async_tasks()<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;select * from fn_db_get_async_tasks();&#39; on db server:<br>
&gt;&gt; &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c<br>
&gt;&gt; select * from fn_db_get_async_tasks();&#39;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::472::root:: output =  dc_id<br>
&gt;&gt; | dc_name | spm_host_id | spm_host_name | task_count<br>
&gt;&gt; -------+---------+-------------+---------------+------------<br>
&gt;&gt; (0 rows)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;select command_type, entity_type from<br>
&gt;&gt; business_entity_snapshot;&#39; on db server: &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c<br>
&gt;&gt; select command_type, entity_type from business_entity_snapshot;&#39;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; command_type | entity_type<br>
&gt;&gt; --------------+-------------<br>
&gt;&gt; (0 rows)<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;copy (select vds_id, vds_name, host_name, vds_unique_id, status<br>
&gt;&gt; from vds) to stdout with csv header;&#39; on db server: &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d engine -c<br>
&gt;&gt; copy (select vds_id, vds_name, host_name, vds_unique_id, status from<br>
&gt;&gt; vds) to stdout with csv header;&#39;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; vds_id,vds_name,host_name,vds_unique_id,status<br>
&gt;&gt; b108549c-1700-11e2-b936-9f5243b8ce13,<a href="http://node01.ukdm.gov.za" target="_blank">node01.ukdm.gov.za</a>,10.251.193.8,4C4C4544-0056-5910-8048-B7C04F43354A,3<br>
&gt;&gt; 322cbee8-16e6-11e2-9d38-6388c61dd004,<a href="http://node02.ukdm.gov.za" target="_blank">node02.ukdm.gov.za</a>,10.251.193.9,4C4C4544-0056-5910-8048-C4C04F43354A,3<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::engine-upgrade::358::root:: DB Backup started<br>
&gt;&gt; 2014-05-20 16:34:49::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/pg_dump -C -E UTF8 --disable-dollar-quoting<br>
&gt;&gt; --disable-triggers -U engine -h localhost -p 5432 --format=p -f<br>
&gt;&gt; /var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2014_05_20_16_34_21.sql<br>
&gt;&gt; engine&#39;<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::473::root:: stderr =<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::474::root:: retcode = 0<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::engine-upgrade::374::root:: DB Backup<br>
&gt;&gt; completed successfully<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::481::root:: running sql<br>
&gt;&gt; query &#39;ALTER DATABASE engine RENAME TO engine_2014_05_20_16_34_21&#39; on<br>
&gt;&gt; db server: &#39;localhost&#39;.<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::434::root:: Executing<br>
&gt;&gt; command --&gt; &#39;/usr/bin/psql -h localhost -p 5432 -U engine -d template1<br>
&gt;&gt; -c ALTER DATABASE engine RENAME TO engine_2014_05_20_16_34_21&#39;<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::472::root:: output =<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::473::root:: stderr = ERROR:<br>
&gt;&gt; must be owner of database engine<br>
&gt;&gt;<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::474::root:: retcode = 1<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::332::root:: YUM: VERB:<br>
&gt;&gt; Performing rollback<br>
&gt;&gt; 2014-05-20 16:34:51::DEBUG::common_utils::1377::root:: Locking rpms in<br>
&gt;&gt; yum-version-lock<br>
&gt;&gt; 2014-05-20 16:34:51::ERROR::engine-upgrade::1159::root:: Traceback<br>
&gt;&gt; (most recent call last):<br>
&gt;&gt;   File &quot;/usr/bin/engine-upgrade&quot;, line 1152, in &lt;module&gt;<br>
&gt;&gt;     main(options)<br>
&gt;&gt;   File &quot;/usr/bin/engine-upgrade&quot;, line 1079, in main<br>
&gt;&gt;     runFunc([[db.rename, DB_NAME_TEMP]], MSG_INFO_RENAME_DB)<br>
&gt;&gt;   File &quot;/usr/bin/engine-upgrade&quot;, line 621, in runFunc<br>
&gt;&gt;     func[0](*func[1:])<br>
&gt;&gt;   File &quot;/usr/bin/engine-upgrade&quot;, line 447, in rename<br>
&gt;&gt;     utils.execRemoteSqlCommand(SERVER_ADMIN, SERVER_NAME, SERVER_PORT,<br>
&gt;&gt; basedefs.DB_TEMPLATE, query, True, MSG_ERROR_RENAME_DB)<br>
&gt;&gt;   File &quot;/usr/share/ovirt-engine/scripts/common_utils.py&quot;, line 490, in<br>
&gt;&gt; execRemoteSqlCommand<br>
&gt;&gt;     return execCmd(cmdList=cmd, failOnError=failOnError, msg=errMsg,<br>
&gt;&gt; envDict=getPgPassEnv())<br>
&gt;&gt;   File &quot;/usr/share/ovirt-engine/scripts/common_utils.py&quot;, line 477, in execCmd<br>
&gt;&gt;     raise Exception(msg)<br>
&gt;&gt; Exception: Error: Database rename failed. Check that there are no<br>
&gt;&gt; active connections to the DB and try again.<br>
&gt;&gt;<br>
&gt;&gt; I&#39;m guessing it&#39;s probably something simple, but I&#39;m not much of a<br>
&gt;&gt; postgres user, so it&#39;s unfortunately a bit beyond me to resolve.<br>
&gt;&gt;<br>
&gt;&gt; Please could someone point me in the right direction.<br>
&gt;&gt;<br>
&gt;&gt; Thank you.<br>
&gt;&gt;<br>
&gt;&gt; Regards<br>
&gt;&gt;<br>
&gt;&gt; Neil Wilson.<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Users mailing list<br>
&gt;&gt; <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
&gt;&gt; <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;<br>
&gt; --<br>
&gt; Mit freundlichen Grüßen / Regards<br>
&gt;<br>
&gt; Sven Kieske<br>
&gt;<br>
&gt; Systemadministrator<br>
&gt; Mittwald CM Service GmbH &amp; Co. KG<br>
&gt; Königsberger Straße 6<br>
&gt; 32339 Espelkamp<br>
&gt; T: <a href="tel:%2B49-5772-293-100" value="+495772293100">+49-5772-293-100</a><br>
&gt; F: <a href="tel:%2B49-5772-293-333" value="+495772293333">+49-5772-293-333</a><br>
&gt; <a href="https://www.mittwald.de" target="_blank">https://www.mittwald.de</a><br>
&gt; Geschäftsführer: Robert Meyer<br>
&gt; St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen<br>
&gt; Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen<br>
&gt; _______________________________________________<br>
&gt; Users mailing list<br>
&gt; <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
&gt; <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div>