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

Roy Golan rgolan at redhat.com
Tue Dec 18 10:23:47 UTC 2012


On 12/18/2012 12:10 PM, Joern Ott wrote:
> 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
Eli is that related to your recent uuid function?
>
> 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