<p dir="ltr">CC-ing Alona and Yevgeny from the network team to take a look. </p>
<p dir="ltr">Regards, <br>
Oved Ourfali</p>
<div class="gmail_quote">On Nov 30, 2015 4:07 PM, "Frank Rothenstein" <<a href="mailto:f.rothenstein@bodden-kliniken.de">f.rothenstein@bodden-kliniken.de</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
I tried several times to upgrade my ovirt-engine 3.5.5 to 3.6. Every<br>
time the setup stops at updating the DB-schema. The log revealed when<br>
this happpens: The setup ist complaining about a duplicated key - here<br>
is the part of the log. Of course there is only one network in the<br>
interface.<br>
<br>
Can anybody help me getting a solution?<br>
<br>
Thnaks, Frank<br>
<br>
Running upgrade sql script '/usr/share/ovirt-<br>
engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_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', '-u',<br>
'engine', '-d', 'engine', '-l', '/var/log/ovirt-engine/setup/ovirt-<br>
engine-setup-20151130073216-erdh9f.log', '-c', 'apply'] stderr:<br>
2543300-psql:/usr/share/ovirt-<br>
engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_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-4ec8-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 (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: --file=/usr/share/ovirt-<br>
engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_vds_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-packages/otopi/context.py",<br>
line 146, in _executeMethod<br>
2544183- method['method']()<br>
2544206- File "/usr/share/ovirt-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-packages/otopi/plugin.py", 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-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> Yum<br>
Performing yum transaction rollback<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>
<br>
<br>
</blockquote></div>