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

Joern Ott joern.ott at ciao.leguide.com
Tue Dec 18 10:10:09 UTC 2012 

Hello Roy,

From: users-bounces at ovirt.org [mailto:users-bounces at ovirt.org] On Behalf Of Roy Golan
Sent: Dienstag, 18. Dezember 2012 07:58
To: users at 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:
>Hello everybody,
 
>> I just upgraded the engine with the engine upgrade script and get a lot of these errors:
>> 2012-12-17 17:25:00,498 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-84) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:00,498 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-72) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:03,033 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-94) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:03,033 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-7) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:15,606 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-60) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:15,606 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-55) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:39,663 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-69) Failed to decrypt Data must not be longer than 256 bytes
>> 2012-12-17 17:25:39,663 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-68) Failed to decrypt java.lang.NullPointerException
 
>> In addition, I am no longer able to log in with admin at internal and the password we set before. As we use keepass generated passwords, I am pretty sure that I don't have any typing errors >> in there. The engine log shows this:
 
>> 2012-12-17 17:26:43,328 ERROR [org.ovirt.engine.core.bll.LoginAdminUserCommand] (ajp--127.0.0.1-8702-2) USER_FAILED_TO_AUTHENTICATE : admin
>> 2012-12-17 17:26:43,328 WARN  [org.ovirt.engine.core.bll.LoginAdminUserCommand] (ajp--127.0.0.1-8702-2) CanDoAction of action LoginAdminUser failed. >> >> Reasons:USER_FAILED_TO_AUTHENTICATE
>> 2012-12-17 17:26:46,290 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-94) Failed to decrypt Blocktype mismatch: 0
>> 2012-12-17 17:26:46,290 ERROR [org.ovirt.engine.core.engineencryptutils.EncryptionUtils] (QuartzScheduler_Worker-91) Failed to decrypt Blocktype mismatch: 0
 
>> Any way of resetting the password in the database or fixing some encryption routines?

> engine-config -s AdminPassword {your passwd}

I needed a slight adjustment of the syntax as this gives me "Argument for set action must be in format of key=value"

[root at leob220 ~]# engine-config -s AdminPassword=xxxxxxxxxxxxx
Cannot set value xxxxxxxxxxxxx to key AdminPassword.

>can you please also search the upgrade/install log to see if the engine setup threw an error *encrypting* your supplied password?

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.centos.org/bug_report_page.php?category=yum']
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.centos.org/bug_report_page.php?category=yum']

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 at ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

More information about the Users mailing list