[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

[Eli Mesika]

----- Original Message -----
> From: "InterNetX - Juergen Gotteswinter" <jg at internetx.com>
> To: "Eli Mesika" <emesika at redhat.com>
> Cc: users at 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" <jg at internetx.com>
> >> To: users at 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 at 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 at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> 
>