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? Thanks in advance Tibor
----- 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
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
Hi, ----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-) But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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
-- Didi
Hi, I got this: -bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist Is this mean, my engine database does not exist? Thanks, Tibor ----- Eredeti üzenet -----
Hi,
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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
-- Didi
Ok, I have listed my databases: postgres-# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------------+-----------------------+----------+-------------+-------------+----------------------- engine_20140130075536 | engine_20140130075536 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres ... and I have used these command for engine_2014.... -bash-4.1$ psql engine_20140130075536 Password: psql (8.4.20) Type "help" for help. engine_20140130075536=# select count(*), external_id from users group by external_id having count(*)>1; count | external_id -------+--------------------------------------------------- 2 | \031\250_\336\265\234\021\343\2168\000\032JP_\022 (1 row) Tibor ----- Eredeti üzenet -----
Hi,
I got this:
-bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist
Is this mean, my engine database does not exist?
Thanks,
Tibor
----- Eredeti üzenet -----
Hi,
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Friday, June 20, 2014 10:00:43 AM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Ok, I have listed my databases:
postgres-# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------------+-----------------------+----------+-------------+-------------+----------------------- engine_20140130075536 | engine_20140130075536 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres
... and I have used these command for engine_2014....
-bash-4.1$ psql engine_20140130075536 Password: psql (8.4.20) Type "help" for help.
engine_20140130075536=# select count(*), external_id from users group by external_id having count(*)>1; count | external_id -------+--------------------------------------------------- 2 | \031\250_\336\265\234\021\343\2168\000\032JP_\022 (1 row)
Ok, so there lies your problem... You have two users (in the ovirt engine db) that use the same external id. Not sure what's the best way to proceed. If you do not use them, might be simplest to just drop them. If you use one and not the other, might be possible to drop the unused one, but this might be a bit more delicate. If you use both, I think you should somehow change the external id of one of them. Also not sure if this condition is expected or a result of some bug. Adding Yair, the owner of [1]. Yair - any idea how to proceed? [1] http://www.ovirt.org/Features/Authentication-Rewrite Best regards, -- Didi
Tibor
----- Eredeti üzenet -----
Hi,
I got this:
-bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist
Is this mean, my engine database does not exist?
Thanks,
Tibor
----- Eredeti üzenet -----
Hi,
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
Hi, Thank you for your help. Please help me in psql how can I drop the second record because I don't know how can I made it. Best Regards, Demeter Tibor ----- Eredeti üzenet -----
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Friday, June 20, 2014 10:00:43 AM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Ok, I have listed my databases:
postgres-# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------------+-----------------------+----------+-------------+-------------+----------------------- engine_20140130075536 | engine_20140130075536 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres
... and I have used these command for engine_2014....
-bash-4.1$ psql engine_20140130075536 Password: psql (8.4.20) Type "help" for help.
engine_20140130075536=# select count(*), external_id from users group by external_id having count(*)>1; count | external_id -------+--------------------------------------------------- 2 | \031\250_\336\265\234\021\343\2168\000\032JP_\022 (1 row)
Ok, so there lies your problem...
You have two users (in the ovirt engine db) that use the same external id.
Not sure what's the best way to proceed. If you do not use them, might be simplest to just drop them. If you use one and not the other, might be possible to drop the unused one, but this might be a bit more delicate. If you use both, I think you should somehow change the external id of one of them.
Also not sure if this condition is expected or a result of some bug.
Adding Yair, the owner of [1]. Yair - any idea how to proceed?
[1] http://www.ovirt.org/Features/Authentication-Rewrite
Best regards, -- Didi
Tibor
----- Eredeti üzenet -----
Hi,
I got this:
-bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist
Is this mean, my engine database does not exist?
Thanks,
Tibor
----- Eredeti üzenet -----
Hi,
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
Sorry for the late reply - was this solved? -- Didi ----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org, "Yair Zaslavsky" <yzaslavs@redhat.com> Sent: Tuesday, June 24, 2014 7:36:31 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi, Thank you for your help.
Please help me in psql how can I drop the second record because I don't know how can I made it.
Best Regards,
Demeter Tibor
----- Eredeti üzenet -----
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Friday, June 20, 2014 10:00:43 AM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Ok, I have listed my databases:
postgres-# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------------+-----------------------+----------+-------------+-------------+----------------------- engine_20140130075536 | engine_20140130075536 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres
... and I have used these command for engine_2014....
-bash-4.1$ psql engine_20140130075536 Password: psql (8.4.20) Type "help" for help.
engine_20140130075536=# select count(*), external_id from users group by external_id having count(*)>1; count | external_id -------+--------------------------------------------------- 2 | \031\250_\336\265\234\021\343\2168\000\032JP_\022 (1 row)
Ok, so there lies your problem...
You have two users (in the ovirt engine db) that use the same external id.
Not sure what's the best way to proceed. If you do not use them, might be simplest to just drop them. If you use one and not the other, might be possible to drop the unused one, but this might be a bit more delicate. If you use both, I think you should somehow change the external id of one of them.
Also not sure if this condition is expected or a result of some bug.
Adding Yair, the owner of [1]. Yair - any idea how to proceed?
[1] http://www.ovirt.org/Features/Authentication-Rewrite
Best regards, -- Didi
Tibor
----- Eredeti üzenet -----
Hi,
I got this:
-bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist
Is this mean, my engine database does not exist?
Thanks,
Tibor
----- Eredeti üzenet -----
Hi,
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, June 18, 2014 7:37:24 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi,
Yes, I have a FreeIPA server, but it was a running virtual server on ovirt :) Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
- Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
- If no, then how can I remove the ipaserver from ovirt configuration ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
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 >
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
Hi, Yes, I could make an upgrade succesful. It was easy. First, I started the ovirt-engine service and second I could remove the extra users by ovirt user manager. Thank you for your help. Best regards, Tibor ok helyesbítését, illetve törlését írásos kérelemben a fenti e-mail címen. ----- Eredeti üzenet -----
Sorry for the late reply - was this solved? -- Didi
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org, "Yair Zaslavsky" <yzaslavs@redhat.com> Sent: Tuesday, June 24, 2014 7:36:31 PM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Hi, Thank you for your help.
Please help me in psql how can I drop the second record because I don't know how can I made it.
Best Regards,
Demeter Tibor
----- Eredeti üzenet -----
----- Original Message -----
From: "Demeter Tibor" <tdemeter@itsmart.hu> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Friday, June 20, 2014 10:00:43 AM Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed
Ok, I have listed my databases:
postgres-# \list List of databases Name | Owner | Encoding | Collation | Ctype | Access privileges -----------------------+-----------------------+----------+-------------+-------------+----------------------- engine_20140130075536 | engine_20140130075536 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ovirt_engine_reports | ovirt_engine_reports | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres
... and I have used these command for engine_2014....
-bash-4.1$ psql engine_20140130075536 Password: psql (8.4.20) Type "help" for help.
engine_20140130075536=# select count(*), external_id from users group by external_id having count(*)>1; count | external_id -------+--------------------------------------------------- 2 | \031\250_\336\265\234\021\343\2168\000\032JP_\022 (1 row)
Ok, so there lies your problem...
You have two users (in the ovirt engine db) that use the same external id.
Not sure what's the best way to proceed. If you do not use them, might be simplest to just drop them. If you use one and not the other, might be possible to drop the unused one, but this might be a bit more delicate. If you use both, I think you should somehow change the external id of one of them.
Also not sure if this condition is expected or a result of some bug.
Adding Yair, the owner of [1]. Yair - any idea how to proceed?
[1] http://www.ovirt.org/Features/Authentication-Rewrite
Best regards, -- Didi
Tibor
----- Eredeti üzenet -----
Hi,
I got this:
-bash-4.1$ psql engine Password: psql: FATAL: database "engine" does not exist
Is this mean, my engine database does not exist?
Thanks,
Tibor
----- Eredeti üzenet -----
Hi,
----- Original Message ----- > From: "Demeter Tibor" <tdemeter@itsmart.hu> > To: "Yedidyah Bar David" <didi@redhat.com> > Cc: users@ovirt.org > Sent: Wednesday, June 18, 2014 7:37:24 PM > Subject: Re: [ovirt-users] Upgrade to 3.4.2 failed > > Hi, > > Yes, I have a FreeIPA server, but it was a running virtual server > on > ovirt > :) > Yes, I know, it was a stupid idea,
Not necessarily, if you can also use admin@internal for maintenance.
> 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.
Is ovirt down? Didn't the upgrade rollback cleanly? If not, please provide logs, it should have. If it did, you can simply 'service ovirt-engine start'.
> > - Can I re-run this vm without ovirt?
I guess you can, but it won't be easy.
> - If no, then how can I remove the ipaserver from ovirt > configuration > ?
Same :-)
But I do not think that the upgrade failure was caused due to ipa being down. There is something else. Did you try running the below query? Did it return anything? You run it inside psql, with: # su - postgres $ psql engine engine=# select count(*), external_id from users group by external_id having count(*)>1; (All in one line, in case it's cut during mail processing)
> > 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 > > >
-- Didi
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
-- Didi
participants (2)
-
Demeter Tibor -
Yedidyah Bar David