----- Original Message -----
> From: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> To: "Eli Mesika" <emes...@redhat.com>
> Cc: Users@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
Hi
Error complains about the following key
Key (vds_id, network_name)=(ba954f0f-6ecb-4ec8-b169-7e0a1147b4cd, KHnetz) is
duplicated.
This was omitted from your data above
Can you please provide the full data ("select * from vds_interface;")
Thanks
>
>
> Now I have to drop something, I guess...
>
> Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
> >
> > ----- Original Message -----
> > > From: "Oved Ourfali" <oourf...@redhat.com>
> > > To: "Frank Rothenstein" <f.rothenst...@bodden-kliniken.de>
> > > Cc: Users@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.rothenst...@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: i...@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@ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> > >
> > >
> > >
> > > _______________________________________________
> > > Users mailing list
> > > Users@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: i...@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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
