[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

InterNetX - Juergen Gotteswinter jg at internetx.com
Mon Dec 22 09:08:05 UTC 2014


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

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




More information about the Users mailing list