Engine upgrade error
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@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 ***
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@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@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
----- Original Message -----
From: "Oved Ourfali" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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@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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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... Am Montag, den 30.11.2015, 18:04 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Oved Ourfali" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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@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: info@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 ***
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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@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: info@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 ***
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky" <yzaspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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@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: info@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
Hi, I found a "workaround" for my problem. In the release notes is noted just to yum update "ovirt-enigne-setup*" I did a yum install instead an was then able to complete the engine- setup. For now I still have not managed to get my nodes updatet, but the engine is running at 3.6... The nodes seem to have another, not DB- based, problem. Am Dienstag, den 01.12.2015, 07:15 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky" <yz aspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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_interfa ce.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@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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_nam e_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_nam e_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_nam e_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@bodden-kliniken.de Internet: http://www.bodden-k linike 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: info@bodden-kliniken.de Internet: http://www.bodden-kli niken.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: info@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 ***
On Fri, Dec 4, 2015 at 9:58 AM, Frank Rothenstein < f.rothenstein@bodden-kliniken.de> wrote:
Hi,
I found a "workaround" for my problem. In the release notes is noted just to yum update "ovirt-enigne-setup*" I did a yum install instead an was then able to complete the engine- setup.
Do you have the list of the additional packages (or just the full list) you got with your last yum install?
For now I still have not managed to get my nodes updatet, but the engine is running at 3.6... The nodes seem to have another, not DB- based, problem.
Am Dienstag, den 01.12.2015, 07:15 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky" <yz aspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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_interfa ce.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@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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_nam e_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_nam e_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_nam e_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@bodden-kliniken.de Internet: http://www.bodden-k linike 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: info@bodden-kliniken.de Internet: http://www.bodden-kli niken.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: info@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
Any hints how to question yum or rpm? Maybe I just test-run yum reinstall "ovirt-engine-setup*" - It should then reinstall all packages I hit with the former install, shouldn't it? Reinstalling: ovirt-engine-setup noarch 3.6.0.3- 1.el7.centos ovirt-3.6 4.0 k ovirt-engine-setup-base noarch 3.6.0.3- 1.el7.centos ovirt-3.6 97 k ovirt-engine-setup-plugin-allinone noarch 3.6.0.3- 1.el7.centos ovirt-3.6 5.2 k ovirt-engine-setup-plugin-dockerc noarch 3.6.0.3- 1.el7.centos ovirt-3.6 21 k ovirt-engine-setup-plugin-ovirt-engine noarch 3.6.0.3- 1.el7.centos ovirt-3.6 163 k ovirt-engine-setup-plugin-ovirt-engine-common noarch 3.6.0.3- 1.el7.centos ovirt-3.6 75 k ovirt-engine-setup-plugin-vmconsole-proxy-helper noarch 3.6.0.3- 1.el7.centos ovirt-3.6 20 k ovirt-engine-setup-plugin-websocket-proxy noarch 3.6.0.3- 1.el7.centos ovirt-3.6 21 k Am Freitag, den 04.12.2015, 10:09 +0100 schrieb Simone Tiraboschi:
Hi,
I found a "workaround" for my problem. In the release notes is noted just to yum update "ovirt-enigne-setup*" I did a yum install instead an was then able to complete the engine- setup. Do you have the list of the additional packages (or just the full
On Fri, Dec 4, 2015 at 9:58 AM, Frank Rothenstein <f.rothenstein@bodd en-kliniken.de> wrote: list) you got with your last yum install?
For now I still have not managed to get my nodes updatet, but the engine is running at 3.6... The nodes seem to have another, not DB- based, problem.
Am Dienstag, den 01.12.2015, 07:15 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky"
<yz
aspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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_interfa
ce.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@redhat.com> > To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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_nam > e_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_nam > e_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_nam > e_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@bodden-kliniken.de Internet: http://www.bodd en-k > linike > 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: info@bodden-kliniken.de Internet: http://www.bodden -kli niken.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: info@bodden-kliniken.de Internet: http://www.bodden-klini ken.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
______________________________________________________________________________ BODDEN-KLINIKEN Ribnitz-Damgarten GmbH Sandhufe 2 18311 Ribnitz-Damgarten Telefon: 03821-700-0 Fax: 03821-700-240 E-Mail: info@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 ***
On 4-12-2015 11:10, Frank Rothenstein wrote:
Any hints how to question yum or rpm? Maybe I just test-run yum reinstall "ovirt-engine-setup*" - It should then reinstall all packages I hit with the former install, shouldn't it? Check /var/log/yum.log or use 'yum history' command and its sub commands, e.g. yum history info XX
Joop
On Fri, Dec 4, 2015 at 11:10 AM, Frank Rothenstein < f.rothenstein@bodden-kliniken.de> wrote:
Any hints how to question yum or rpm? Maybe I just test-run yum
To get the transaction list: yum history list To get detailed info on a specific transaction (# 44 in my example): yum history info 44 Can you please check and post here the details of your initial failed transaction and the successful one? reinstall "ovirt-engine-setup*" - It should then reinstall all
packages I hit with the former install, shouldn't it?
Reinstalling: ovirt-engine-setup noarch 3.6.0.3- 1.el7.centos ovirt-3.6 4.0 k ovirt-engine-setup-base noarch 3.6.0.3- 1.el7.centos ovirt-3.6 97 k ovirt-engine-setup-plugin-allinone noarch 3.6.0.3- 1.el7.centos ovirt-3.6 5.2 k ovirt-engine-setup-plugin-dockerc noarch 3.6.0.3- 1.el7.centos ovirt-3.6 21 k ovirt-engine-setup-plugin-ovirt-engine noarch 3.6.0.3- 1.el7.centos ovirt-3.6 163 k ovirt-engine-setup-plugin-ovirt-engine-common noarch 3.6.0.3- 1.el7.centos ovirt-3.6 75 k ovirt-engine-setup-plugin-vmconsole-proxy-helper noarch 3.6.0.3- 1.el7.centos ovirt-3.6 20 k ovirt-engine-setup-plugin-websocket-proxy noarch 3.6.0.3- 1.el7.centos ovirt-3.6 21 k
Am Freitag, den 04.12.2015, 10:09 +0100 schrieb Simone Tiraboschi:
Hi,
I found a "workaround" for my problem. In the release notes is noted just to yum update "ovirt-enigne-setup*" I did a yum install instead an was then able to complete the engine- setup. Do you have the list of the additional packages (or just the full
On Fri, Dec 4, 2015 at 9:58 AM, Frank Rothenstein <f.rothenstein@bodd en-kliniken.de> wrote: list) you got with your last yum install?
For now I still have not managed to get my nodes updatet, but the engine is running at 3.6... The nodes seem to have another, not DB- based, problem.
Am Dienstag, den 01.12.2015, 07:15 -0500 schrieb Eli Mesika:
----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alpaslan Kaplan" <akaplan@redhat.com>, "Yevgeny Zaspitsky"
<yz
aspits@redhat.com> Cc: Users@ovirt.org Sent: Tuesday, December 1, 2015 1:57:53 PM Subject: Re: [ovirt-users] Engine upgrade error
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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_interfa
ce.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@redhat.com> > > To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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_nam > > e_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_nam > > e_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_nam > > e_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@bodden-kliniken.de Internet: http://www.bodd en-k > > linike > > 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: info@bodden-kliniken.de Internet: http://www.bodden -kli niken.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: info@bodden-kliniken.de Internet: http://www.bodden-klini ken.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
______________________________________________________________________________ BODDEN-KLINIKEN Ribnitz-Damgarten GmbH Sandhufe 2 18311 Ribnitz-Damgarten
Telefon: 03821-700-0 Fax: 03821-700-240
E-Mail: info@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 ***
----- Original Message -----
From: "Frank Rothenstein" <f.rothenstein@bodden-kliniken.de> To: "Eli Mesika" <emesika@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" <oourfali@redhat.com> To: "Frank Rothenstein" <f.rothenstein@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.rothenstein@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@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: info@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 ***
participants (5)
-
Eli Mesika -
Frank Rothenstein -
Joop -
Oved Ourfali -
Simone Tiraboschi