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