Re: [ovirt-users] Engine upgrade error

----- Original Message ----- > From: "Oved Ourfali" <oourfali(a)redhat.com&gt; > To: "Frank Rothenstein" <f.rothenstein(a)bodden-kliniken.de&gt; > 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 >