On 12/18/2012 12:10 PM, Joern Ott wrote:
Hello Roy,
From: [email protected] [mailto:[email protected]] On Behalf Of Roy
Golan
Sent: Dienstag, 18. Dezember 2012 07:58
To: [email protected]
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@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@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
[email protected]
http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users
