[Users] RESOLVED: Problems after upgrading to latest rpms from the dre repository

Hello Roy, From: users-bounces(a)ovirt.org [mailto:users-bounces@ovirt.org] On Behalf Of Roy Golan Sent: Dienstag, 18. Dezember 2012 07:58 To: users(a)ovirt.org Subject: Re: [Users] Problems after upgrading to latest rpms from the dre repository On 12/17/2012 06:28 PM, Joern Ott wrote:         I needed a slight adjustment of the syntax as this gives me "Argument for set action must be in format of key=value" [root@leob220 ~]# engine-config -s AdminPassword=xxxxxxxxxxxxx Cannot set value xxxxxxxxxxxxx to key AdminPassword. It seems that the database setup failed (excerpt): 2012-12-17 15:18:54::DEBUG::engine-upgrade::425::root:: DB Update started 2012-12-17 15:18:54::DEBUG::common_utils::424::root:: Executing command --> '/usr/share/ovirt-engine/dbscripts/upgrade.sh -s localhost -p 5432 -u engine -d engine_2012_12_17_15_18_29' 2012-12-17 15:18:56::DEBUG::common_utils::462::root:: output = upgrade script detected a change in Config, View or Stored Procedure... 2012-12-17 15:18:56::DEBUG::common_utils::463::root:: stderr = psql:create_functions.sql:679: ERROR: must be owner of function uuid_generate_v1 2012-12-17 15:18:56::DEBUG::common_utils::464::root:: retcode = 3 2012-12-17 15:18:56::ERROR::engine-upgrade::1072::root:: Traceback (most recent call last): File "/usr/bin/engine-upgrade", line 1059, in main runFunc([db.update], MSG_INFO_DB_UPDATE) File "/usr/bin/engine-upgrade", line 607, in runFunc func() File "/usr/bin/engine-upgrade", line 442, in update output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=MSG_ERROR_UPDATE_DB) File "/usr/share/ovirt-engine/scripts/common_utils.py", line 467, in execCmd raise Exception(msg) Exception: Error: Database update failed 2012-12-17 15:18:56::ERROR::engine-upgrade::1073::root:: Rolling back update 2012-12-17 15:18:56::DEBUG::engine-upgrade::392::root:: DB Restore started 2012-12-17 15:18:56::DEBUG::common_utils::424::root:: Executing command --> '/usr/bin/dropdb -U engine -h localhost -p 5432 engine_2012_12_17_15_18_29' 2012-12-17 15:19:15::DEBUG::common_utils::462::root:: output = 2012-12-17 15:19:15::DEBUG::common_utils::463::root:: stderr = 2012-12-17 15:19:15::DEBUG::common_utils::464::root:: retcode = 0 2012-12-17 15:19:15::DEBUG::common_utils::424::root:: Executing command --> '/usr/bin/psql -U engine -h localhost -p 5432 -d template1 -f /var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql' Then the rollback happened causing these errors: 2012-12-17 15:19:20::DEBUG::common_utils::463::root:: stderr = psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:8121: WARNING: column "status" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:8121: WARNING: column "owner" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:8121: WARNING: column "storage_pool_id" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:8121: WARNING: column "storage_pool_name" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13543: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13546: ERROR: function public.uuid_generate_v1() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13554: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13557: ERROR: function public.uuid_generate_v1mc() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13565: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13568: ERROR: function public.uuid_generate_v3(uuid, text) does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13576: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13579: ERROR: function public.uuid_generate_v4() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13587: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13590: ERROR: function public.uuid_generate_v5(uuid, text) does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13598: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13601: ERROR: function public.uuid_nil() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13609: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13612: ERROR: function public.uuid_ns_dns() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13620: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13623: ERROR: function public.uuid_ns_oid() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13631: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13634: ERROR: function public.uuid_ns_url() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13642: ERROR: permission denied for language c psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:13645: ERROR: function public.uuid_ns_x500() does not exist psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:14015: WARNING: column "owner" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:14015: WARNING: column "storage_pool_id" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:14015: WARNING: column "storage_pool_name" has type "unknown" DETAIL: Proceeding with relation creation anyway. psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:21103: WARNING: no privileges could be revoked for "public" psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:21104: WARNING: no privileges could be revoked for "public" psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:21105: WARNING: no privileges were granted for "public" psql:/var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql:21106: WARNING: no privileges were granted for "public" 2012-12-17 15:19:20::DEBUG::common_utils::464::root:: retcode = 0 2012-12-17 15:19:20::DEBUG::engine-upgrade::414::root:: DB Restore completed successfully And finally, the yum downgrade failed: 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-backend-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-config-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-dbscripts-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-genericapi-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-notification-service-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-restapi-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-tools-common-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-userportal-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Failed to downgrade: ovirt-engine-webadmin-portal-3.1.0-3.26.el6.noarch 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Building transaction 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Transaction built 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Processing transaction 2012-12-17 15:19:33::INFO::common_utils::327::root:: YUM: OK: Status: Downloading Packages 2012-12-17 15:19:33::INFO::common_utils::327::root:: YUM: OK: Status: Running Test Transaction 2012-12-17 15:19:33::DEBUG::common_utils::324::root:: YUM: VERB: Running rpm_check_debug 2012-12-17 15:19:33::ERROR::common_utils::330::root:: YUM: FAIL: [u'ERROR with rpm_check_debug vs depsolve:', 'ovirt-engine-setup >= 3.2.0-1.33.el6 is needed by ovirt-engine-3.2.0-1.33.el6.noarch', u'Please report this error at http://bugs.centos.org/set_project.php?project_id=16&ref=http://bugs....] 2012-12-17 15:19:34::ERROR::common_utils::330::root:: YUM: FAIL: Transaction end failed: Traceback (most recent call last): File "/usr/share/ovirt-engine/scripts/miniyum.py", line 370, in _endTransaction self.processTransaction() File "/usr/share/ovirt-engine/scripts/miniyum.py", line 678, in processTransaction rpmDisplay=MiniYum._rpmcallback(sink=self._sink) File "/usr/lib/python2.6/site-packages/yum/__init__.py", line 4928, in processTransaction self._doTestTransaction(callback,display=rpmTestDisplay) File "/usr/lib/python2.6/site-packages/yum/__init__.py", line 5002, in _doTestTransaction raise Errors.YumRPMCheckError,retmsgs YumRPMCheckError: [u'ERROR with rpm_check_debug vs depsolve:', 'ovirt-engine-setup >= 3.2.0-1.33.el6 is needed by ovirt-engine-3.2.0-1.33.el6.noarch', u'Please report this error at http://bugs.centos.org/set_project.php?project_id=16&ref=http://bugs....] 2012-12-17 15:19:34::DEBUG::common_utils::1286::root:: Locking rpms in yum-version-lock 2012-12-17 15:19:36::ERROR::engine-upgrade::1123::root:: Traceback (most recent call last): File "/usr/bin/engine-upgrade", line 1116, in <module> main(options) File "/usr/bin/engine-upgrade", line 1059, in main runFunc([db.update], MSG_INFO_DB_UPDATE) File "/usr/bin/engine-upgrade", line 607, in runFunc func() File "/usr/bin/engine-upgrade", line 442, in update output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=MSG_ERROR_UPDATE_DB) File "/usr/share/ovirt-engine/scripts/common_utils.py", line 467, in execCmd raise Exception(msg) Exception: Error: Database update failed 2012-12-17 15:19:36::DEBUG::engine-upgrade::365::root:: DB Backup available at /var/lib/ovirt-engine/backups/ovirt-engine_db_backup_2012_12_17_15_18_29.sql So, what I did to resolve the issue was to manually downgrade all the RPMs which failed in the script. I had to provide absolute URLs to the RPMs though. After that I restarted ovirt-engine and ran the engine-upgrade again. Miraculously everything worked this time and now I am running ovirt-engine-3.2.0-1.33. Kind regards Jörn _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users