Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5

----- Original Message ----- > From: "InterNetX - Juergen Gotteswinter" <jg(a)internetx.com&gt; > To: users(a)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

> > -- 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(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users >