[ovirt-users] engine upgrade 3.2.2 --> 3.2.3 Database rename failed
Neil
nwilson123 at gmail.com
Thu May 22 04:12:44 UTC 2014
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 at 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 at 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 at 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 at 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 at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140522/adb354a1/attachment-0001.html>
More information about the Users
mailing list