Hi, Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea, but it's only a test system for testing ovirt capabilites. So, this vm (the freeipa) at this moment doesn't running and I cannot run without ovirt. - Can I re-run this vm without ovirt? - If no, then how can I remove the ipaserver from ovirt configuration ? Thank in advance. Tibor ----- Eredeti üzenet -----
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: users@ovirt.org Sent: Tuesday, June 17, 2014 3:11:54 PM Subject: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
I just did an upgrade to my 3.4.0 box. I did a yum update and an engine-setup After the package downloading process got this:
[ INFO ] Yum Verify: 14/14: ovirt-engine.noarch 0:3.4.0-1.el6 - ud [ INFO ] Stage: Misc configuration [ INFO ] Backing up database localhost:engine_20140130075536 to '/var/lib/ovirt-engine/backups/engine-20140617140129.QZGO9x.dump'. [ INFO ] Updating Engine database schema [ ERROR ] Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute [ INFO ] Yum Performing yum transaction rollback [ INFO ] Yum Status: Downloading Packages [ INFO ] Yum Download/Verify: ovirt-engine-3.4.0-1.el6.noarch
A cut from the log file:
running upgrade sql script upgrade/03_04_0720_add_host_interface_high_network_use_event.sql ... Running upgrade sql script upgrade/03_04_0730_change_group_ids.sql ... Running upgrade sql script upgrade/03_04_0740_update_user_ids.sql ...
2014-06-17 14:01:41 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:866 execute-output: ['/usr/share/ovirt-engine/dbscripts/upgrade.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine_20140130075536', '-d', 'engine_20140130075536', '-l', '/var/log/ovirt-engine/setup/ovirt-engine-setup-20140617135909-a7zbn6.log', '-g'] stderr: psql:upgrade/03_04_0740_update_user_ids.sql:41: ERROR: duplicate key value violates unique constraint "pk_users" CONTEXT: SQL statement "UPDATE users SET user_id = temp_id" PL/pgSQL function "__temp_update_user_ids_03_04_0740" line 30 at SQL statement
2014-06-17 14:01:41 DEBUG otopi.context context._executeMethod:152 method exception Traceback (most recent call last): File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in _executeMethod method['method']() File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", line 345, in _miscUpgrade osetupcons.DBEnv.PGPASS_FILE File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 871, in execute command=args[0], RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute 2014-06-17 14:01:41 ERROR otopi.context context._executeMethod:161 Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt-engine/dbscripts/upgrade.sh' failed to execute 2014-06-17 14:01:41 DEBUG otopi.transaction transaction.abort:131 aborting 'Yum Transaction' 2014-06-17 14:01:41 INFO otopi.plugins.otopi.packagers.yumpackager yumpackager.info:92 Yum Performing yum transaction rollback 2014-06-17 14:01:41 DEBUG otopi.plugins.otopi.packagers.yumpackager yumpackager.verbose:88 Yum Building transaction 2014-06-17 14:01:42 DEBUG otopi.plugins.otopi.packagers.yumpackager yumpackager.verbose:88 Yum Transaction built 2014-06-17 14:01:42 DEBUG otopi.plugins.otopi.packagers.yumpackager yumpackager.verbose:88 Yum Transaction Summary: 2014-06-17 14:01:42 DEBUG otopi.plugins.otopi.packagers.yumpackager yumpackager.verbose:88 Yum install - ovirt-engine-3.4.0-1.el6.noarch
Anybody help me?
Is it possible that you use an external directory and have two users pointing at the same directory user?
Does the following query return anything?
select count(*), external_id from users group by external_id having count(*)>1; -- Didi