----- Original Message ----- > From: "InterNetX - Juergen Gotteswinter" <j...@internetx.com> > To: "Eli Mesika" <emes...@redhat.com> > Cc: users@ovirt.org > Sent: Monday, December 22, 2014 12:06:51 PM > Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5 > > Am 22.12.2014 um 10:41 schrieb Eli Mesika: > > > > > > ----- Original Message ----- > >> From: "InterNetX - Juergen Gotteswinter" <j...@internetx.com> > >> To: users@ovirt.org > >> Sent: Monday, December 22, 2014 11:08:05 AM > >> Subject: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5 > >> > >> Hi, > >> > >> i am currently trying to upgrade an existing 3.4.4 Setup (which got > >> upgraded several times before, starting at 3.3), but this time i run > >> into a Error while Upgrading the DB > > > > Hi > > Can you please attach the following data (this information does not include > > any customer info, just log of installed scripts) > > > > pg_dump -U engine -f schema-version.sql -t schema_version engine > > sure :) >
I It seems that somebody had deleted manually the constraint fk_event_subscriber_event_notification_methods from your database Therefor, the first line that attempts to drop this constraint in 03_05_0050_event_notification_methods.sql: ALTER TABLE event_subscriber DROP CONSTRAINT fk_event_subscriber_event_notification_methods; fails. Please try to run the following manually and upgrade again psql -U engine -c "ALTER TABLE ONLY event_subscriber ADD CONSTRAINT fk_event_subscriber_event_notification_methods FOREIGN KEY (method_id) REFERENCES event_notification_methods(method_id) ON DELETE CASCADE;" engine Let me know how it is going ... Eli > > > >> > >> -- snip -- > >> > >> > >> ********* QUERY ********** > >> ALTER TABLE event_subscriber DROP CONSTRAINT > >> fk_event_subscriber_event_notification_methods; > >> ************************** > >> > >> 2014-12-20 00:16:27 DEBUG > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema > >> plugin.executeRaw:803 execute-result: > >> ['/usr/share/ovirt-engine/dbscripts/schema.sh', '-s', 'localhost', '-p', > >> '5432', '-u', 'engine', '-d', 'engine', '-l', > >> '/var/log/ovirt-engine/setup/ovirt-engine-setup-20141220001232-3xjymi.log', > >> '-c', 'apply'], rc=1 > >> 2014-12-20 00:16:27 DEBUG > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema > >> plugin.execute:861 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-20141220001232-3xjymi.log', > >> '-c', 'apply'] stdout: > >> Creating schema engine@localhost:5432/engine > >> Saving custom users permissions on database objects... > >> upgrade script detected a change in Config, View or Stored Procedure... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0000_config.sql'... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0010_custom.sql'... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0020_add_materialized_views_table.sql'... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0030_materialized_views_extensions.sql'... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/pre_upgrade/0040_extend_installed_by_column.sql'... > >> Dropping materialized views... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0010_add_tables_for_gluster_volume_and_brick_details.sql'... > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0020_gluster_refresh_gluster_volume_details-event_map.sql'... > >> Skipping upgrade script > >> /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0030_add_ha_columns_to_vds_statistics.sql, > >> already installed by 03040610 > >> Skipping upgrade script > >> /usr/share/ovirt-engine/dbscripts/upgrade/03_05_0040_add_ha_maintenance_events.sql, > >> already installed by 03040620 > >> Running upgrade sql script > >> '/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql'... > >> > >> 2014-12-20 00:16:27 DEBUG > >> otopi.plugins.ovirt_engine_setup.ovirt_engine.db.schema > >> plugin.execute:866 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-20141220001232-3xjymi.log', > >> '-c', 'apply'] stderr: > >> psql:/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql:2: > >> ERROR: constraint "fk_event_subscriber_event_notification_methods" of > >> relation "event_subscriber" does not exist > >> FATAL: Cannot execute sql command: > >> --file=/usr/share/ovirt-engine/dbscripts/upgrade/03_05_0050_event_notification_methods.sql > >> > >> 2014-12-20 00:16:27 DEBUG otopi.context context._executeMethod:152 > >> method exception > >> Traceback (most recent call last): > >> File "/usr/lib/python2.6/site-packages/otopi/context.py", line 142, in > >> _executeMethod > >> method['method']() > >> File > >> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/schema.py", > >> line 291, in _misc > >> oenginecons.EngineDBEnv.PGPASS_FILE > >> File "/usr/lib/python2.6/site-packages/otopi/plugin.py", line 871, in > >> execute > >> command=args[0], > >> RuntimeError: Command '/usr/share/ovirt-engine/dbscripts/schema.sh' > >> failed to execute > >> 2014-12-20 00:16:27 ERROR otopi.context context._executeMethod:161 > >> Failed to execute stage 'Misc configuration': Command > >> '/usr/share/ovirt-engine/dbscripts/schema.sh' failed to execute > >> 2014-12-20 00:16:27 DEBUG otopi.transaction transaction.abort:131 > >> aborting 'Yum Transaction' > >> > >> -- snip -- > >> > >> after that, engine-setup starts doing a rollback to 3.4.4 which > >> worksflawless. > >> > >> Anyone got an Idea what is causing this? > >> > >> Thanks, > >> > >> Juergen > >> > >> _______________________________________________ > >> 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