Re: [ovirt-users] Upgrade to 3.4.2 failed

From: "Demeter Tibor" <tdemeter(a)itsmart.hu&gt; To: users(a)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?