[ovirt-users] Upgrade to 3.4.2 failed

[Yedidyah Bar David]

----- Original Message -----
> From: "Demeter Tibor" <tdemeter at itsmart.hu>
> To: users at 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