----- 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 > > > 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" <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
