On Mon, Nov 30, 2015 at 3:34 PM, Frank Rothenstein
<f.rothenstein(a)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?
Thnaks, Frank
Running upgrade sql script '/usr/share/ovirt-
engine/dbscripts/upgrade/03_06_1670_unique_vds_id_network_name_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_name_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_name_vds_inte
rface.sql
Can you post output of 'select * from vds_interface' from engine database?
Adding Eli and changing subject.
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(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--
Didi