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 > [email protected] > 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 [email protected] http://lists.ovirt.org/mailman/listinfo/users
