On Fri, Dec 4, 2015 at 9:58 AM, Frank Rothenstein < f.rothenstein@bodden-kliniken.de> wrote:
Hi,
I found a "workaround" for my problem. In the release notes is noted just to yum update "ovirt-enigne-setup*" I did a yum install instead an was then able to complete the engine- setup.
Do you have the list of the additional packages (or just the full list) you got with your last yum install?
For now I still have not managed to get my nodes updatet, but the engine is running at 3.6... The nodes seem to have another, not DB- based, problem.
Am Dienstag, den 01.12.2015, 07:15 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky" <yz aspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 12:43:17 PM Subject: Re: [ovirt-users] Engine upgrade error
Oh, that looks not so good...
vds_id | network_name --------------------------------------+-------------- 6d9c0683-be85-4f70-9790-0f491b7c8021 | 6d9c0683-be85-4f70-9790-0f491b7c8021 | 6d9c0683-be85-4f70-9790-0f491b7c8021 | 6d9c0683-be85-4f70-9790-0f491b7c8021 | 6d9c0683-be85-4f70-9790-0f491b7c8021 | 6d9c0683-be85-4f70-9790-0f491b7c8021 | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | vlan111 2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHNetzVLAN1 2211ca5c-8d2c-42f3-939c-de11e085aa1c | ovirtmgmt 2211ca5c-8d2c-42f3-939c-de11e085aa1c | KHnetz 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 2211ca5c-8d2c-42f3-939c-de11e085aa1c | 6d9c0683-be85-4f70-9790-0f491b7c8021 | vlan111 6d9c0683-be85-4f70-9790-0f491b7c8021 | KHNetzVLAN1 6d9c0683-be85-4f70-9790-0f491b7c8021 | ovirtmgmt 6d9c0683-be85-4f70-9790-0f491b7c8021 | KHnetz
Now I have to drop something, I guess...
Alona, Yevgeny Table includes duplicate records and therefor dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_interfa ce.sql fails on creating a unique constraint. Please advice
1) What should be removed in that case 2) How can we fix the upgrade script to handle such cases in order that the full upgrade process will not fail ?
Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Oved Ourfali" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> Cc: Users@ovirt.org Sent: Monday, November 30, 2015 6:45:17 PM Subject: Re: [ovirt-users] Engine upgrade error
CC-ing Alona and Yevgeny from the network team to take a look.
Regards, Oved Ourfali On Nov 30, 2015 4:07 PM, "Frank Rothenstein" < f.rothenstein@bodden-kliniken.de > wrote:
Hello,
I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6. Every time the setup stops at updating the DB-schema. The log revealed when this happpens: The setup ist complaining about a duplicated key - here is the part of the log. Of course there is only one network in the interface.
Can anybody help me getting a solution?
Can you please attach the result of the following query :
select vds_id, network_name from vds_interface;
Thanks
Thnaks, Frank
Running upgrade sql script '/usr/share/ovirt- engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_nam e_vds_ inte rface.sql'... 2542964- 2542965-2015-11-30 08:15:26 DEBUG otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema plugin.execute:941 execute-output: ['/usr/share/ovirt- engine/dbscripts/schema.sh', '-s', 'localhost', '-p', '5432', '-u', 'engine', '-d', 'engine', '-l', '/var/log/ovirt- engine/setup/ovirt- engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr: 2543300-psql:/usr/share/ovirt- engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_nam e_vds_ inte rface.sql:1: ERROR: could not create unique index "vds_interface_vds_id_network_name_unique" 2543487:DETAIL: Key (vds_id, network_name)=(ba954f0f-6ecb- 4ec8- b169- 7e0a1147b4cd, KHnetz) is duplicated. 2543585-CONTEXT: SQL statement "ALTER TABLE vds_interface ADD CONSTRAINT vds_interface_vds_id_network_name_unique unique (vds_id, network_name)" 2543723-PL/pgSQL function fn_db_create_constraint(character varying,character varying,text) line 4 at EXECUTE statement 2543835-FATAL: Cannot execute sql command: -- file=/usr/share/ovirt- engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_nam e_vds_ inte rface.sql 2543975- 2543976-2015-11-30 08:15:26 DEBUG otopi.context context._executeMethod:156 method exception 2544060-Traceback (most recent call last): 2544095- File "/usr/lib/python2.7/site- packages/otopi/context.py", line 146, in _executeMethod 2544183- method['method']() 2544206- File "/usr/share/ovirt- engine/setup/bin/../plugins/ovirt- engine-setup/ovirt-engine/db/schema.py", line 291, in _misc 2544325- oenginecons.EngineDBEnv.PGPASS_FILE 2544365- File "/usr/lib/python2.7/site- packages/otopi/plugin.py", line 946, in execute 2544445- command=args[0], 2544466-RuntimeError: Command '/usr/share/ovirt- engine/dbscripts/schema.sh' failed to execute 2544552-2015-11-30 08:15:26 ERROR otopi.context context._executeMethod:165 Failed to execute stage 'Misc configuration': Command '/usr/share/ovirt- engine/dbscripts/schema.sh' failed to execute 2544737-2015-11-30 08:15:26 DEBUG otopi.transaction transaction.abort:134 aborting 'Yum Transaction' 2544830-2015-11-30 08:15:26 INFO otopi.plugins.otopi.packagers.yumpackager yumpackager.info:95 Yum Performing yum transaction rollback
_____________________________________________________________ ______ ___________ BODDEN-KLINIKEN Ribnitz-Damgarten GmbH Sandhufe 2 18311 Ribnitz-Damgarten
Telefon: 03821-700-0 Fax: 03821-700-240
E-Mail: info@bodden-kliniken.de Internet: http://www.bodden-k linike n.de
Sitz: Ribnitz-Damgarten, Amtsgericht: Stralsund, HRB 2919, Steuer- Nr.: 079/133/40188 Aufsichtsratsvorsitzende: Carmen Schröter, Geschäftsführer: Dr. Falko Milski
Der Inhalt dieser E-Mail ist ausschließlich für den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorge- sehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, beachten Sie bitte, dass jede Form der Veröf- fentlichung, Vervielfältigung oder Weitergabe des Inhalts dieser E- Mail unzulässig ist. Wir bitten Sie, sofort den Absender zu informieren und die E-Mail zu löschen.
Bodden-Kliniken Ribnitz-Damgarten GmbH 2015 *** Virenfrei durch Kerio Mail Server und Sophos Antivirus ***
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_________________________________________________________________ _____________ BODDEN-KLINIKEN Ribnitz-Damgarten GmbH Sandhufe 2 18311 Ribnitz-Damgarten
Telefon: 03821-700-0 Fax: 03821-700-240
E-Mail: info@bodden-kliniken.de Internet: http://www.bodden-kli niken.de
Sitz: Ribnitz-Damgarten, Amtsgericht: Stralsund, HRB 2919, Steuer-Nr.: 079/133/40188 Aufsichtsratsvorsitzende: Carmen Schröter, Geschäftsführer: Dr. Falko Milski
Der Inhalt dieser E-Mail ist ausschließlich für den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorge- sehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, beachten Sie bitte, dass jede Form der Veröf- fentlichung, Vervielfältigung oder Weitergabe des Inhalts dieser E-Mail unzulässig ist. Wir bitten Sie, sofort den Absender zu informieren und die E-Mail zu löschen.
Bodden-Kliniken Ribnitz-Damgarten GmbH 2015 *** Virenfrei durch Kerio Mail Server und Sophos Antivirus ***
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
______________________________________________________________________________ BODDEN-KLINIKEN Ribnitz-Damgarten GmbH Sandhufe 2 18311 Ribnitz-Damgarten
Telefon: 03821-700-0 Fax: 03821-700-240
E-Mail: info@bodden-kliniken.de Internet: http://www.bodden-kliniken.de
Sitz: Ribnitz-Damgarten, Amtsgericht: Stralsund, HRB 2919, Steuer-Nr.: 079/133/40188 Aufsichtsratsvorsitzende: Carmen Schröter, Geschäftsführer: Dr. Falko Milski
Der Inhalt dieser E-Mail ist ausschließlich für den bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorge- sehene Adressat dieser E-Mail oder dessen Vertreter sein sollten, beachten Sie bitte, dass jede Form der Veröf- fentlichung, Vervielfältigung oder Weitergabe des Inhalts dieser E-Mail unzulässig ist. Wir bitten Sie, sofort den Absender zu informieren und die E-Mail zu löschen.
Bodden-Kliniken Ribnitz-Damgarten GmbH 2015 *** Virenfrei durch Kerio Mail Server und Sophos Antivirus ***
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users