[ovirt-users] Engine upgrade error

[Oved Ourfali]

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 at 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
> 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 at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151130/4ef77a2c/attachment-0001.html>