5:57 a.m.
----- Original Message -----
From: "Frank Rothenstein"
<f.rothenstein(a)bodden-kliniken.de>
To: "Eli Mesika" <emesika(a)redhat.com>
Cc: Users(a)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_interface.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(a)redhat.com>
> > To: "Frank Rothenstein" <f.rothenstein(a)bodden-kliniken.de>
> > Cc: Users(a)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(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?
>
> 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_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(a)bodden-kliniken.de Internet: http://www.bodden-klinike
> > 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(a)ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)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(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 ***