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