[Engine-devel] problem when upgrading engine db?

Einav Cohen ecohen at redhat.com
Tue Jan 8 16:00:14 UTC 2013


Hi Eli,

When I tried to upgrade my oVirt engine DB (using backend/manager/dbscripts/upgrade.sh) I received the following output:

----
upgrade script detected a change in Config, View or Stored Procedure...
psql:drop_old_uuid_functions.sql:2: ERROR:  cannot drop function uuid_nil() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:3: ERROR:  cannot drop function uuid_ns_dns() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:4: ERROR:  cannot drop function uuid_ns_url() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:5: ERROR:  cannot drop function uuid_ns_oid() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:6: ERROR:  cannot drop function uuid_ns_x500() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:7: ERROR:  cannot drop function uuid_generate_v1() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:8: ERROR:  cannot drop function uuid_generate_v1mc() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:9: ERROR:  cannot drop function uuid_generate_v3(uuid,text) because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:10: ERROR:  cannot drop function uuid_generate_v4() because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
psql:drop_old_uuid_functions.sql:11: ERROR:  cannot drop function uuid_generate_v5(uuid,text) because extension uuid-ossp requires it
HINT:  You can drop extension uuid-ossp instead.
Running  upgrade sql script upgrade/pre_upgrade/0000_config.sql ...
Running  upgrade sql script upgrade/pre_upgrade/0010_custom.sql ...
Running  upgrade sql script upgrade/pre_upgrade/0020_add_comment_col_to_schema_version.sql ...
Creating views...
Creating stored procedures...
... 
[ regular output continues ] 
...
----

Is that expected?

----
Thanks,
Einav



More information about the Engine-devel mailing list