./usr/share/ovirt-engine/dbscripts/upgrade.sh -s localhost -p 5432 -u engine -d engine


[root@storm dbscripts]# ./upgrade.sh -s localhost -p 5432 -u engine -d engine
/usr/share/ovirt-engine/dbscripts /usr/share/ovirt-engine/dbscripts
upgrade script detected a change in Config, View or Stored Procedure...
psql:common_sp.sql:524: NOTICE:  drop cascades to function fn_db_get_async_tasks()
psql:common_sp.sql:567: NOTICE:  type "fk_info_rs" does not exist, skipping
psql:drop_all_views.sql:1: NOTICE:  drop cascades to 9 other objects
DETAIL:  drop cascades to view luns_view
drop cascades to function getallfromluns()
drop cascades to function getlunbylunid(character varying)
drop cascades to function getlunsbystorage_server_connection(character varying)
drop cascades to function getlunsbyvolumegroupid(character varying)
drop cascades to function getallattachabledisksbypoolid(uuid,uuid,boolean)
drop cascades to function getallfromdisks()
drop cascades to function getdiskbydiskid(uuid)
drop cascades to function getdisksvmguid(uuid,uuid,boolean)
psql:drop_all_views.sql:25: NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to function getallfromevent_audit_log_subscriber()
drop cascades to function getallfromevent_audit_log_subscriber_only()
psql:drop_all_views.sql:26: NOTICE:  drop cascades to function getallfromevent_subscriber_notification_methods()
psql:drop_all_views.sql:27: NOTICE:  drop cascades to 13 other objects
DETAIL:  drop cascades to view vm_images_view
drop cascades to function getimagebyimageguid(uuid)
drop cascades to function getvmimagebyimageguid(uuid)
drop cascades to view vm_images_storage_domains_view
drop cascades to function getancestralimagebyimageguid(uuid)
drop cascades to function getimagebystorageidandtemplateid(uuid,uuid)
drop cascades to function getimagesbyquotaid(uuid)
drop cascades to function getimageswhichhavenodisk(uuid)
drop cascades to function getsnapshotbyguid(uuid)
drop cascades to function getsnapshotbyparentguid(uuid)
drop cascades to function getsnapshotsbyimagegroupid(uuid)
drop cascades to function getsnapshotsbystoragedomainid(uuid)
drop cascades to function getsnapshotsbyvmsnapshotid(uuid)
psql:drop_all_views.sql:28: NOTICE:  view "luns_view" does not exist, skipping
psql:drop_all_views.sql:29: NOTICE:  drop cascades to 4 other objects
DETAIL:  drop cascades to function getallfromnetwork()
drop cascades to function getallnetworkbystoragepoolid(uuid)
drop cascades to function getnetworkbyid(uuid)
drop cascades to function getnetworkbyname(character varying)
psql:drop_all_views.sql:30: NOTICE:  drop cascades to 28 other objects
DETAIL:  drop cascades to view user_vm_permissions_view_base
drop cascades to view user_vm_permissions_view
drop cascades to view user_vm_template_permissions_view_base
drop cascades to view user_vm_template_permissions_view
drop cascades to view user_disk_permissions_view_base
drop cascades to view user_disk_permissions_view
drop cascades to view user_storage_domain_permissions_view_base
drop cascades to view user_storage_domain_permissions_view
drop cascades to view user_storage_pool_permissions_view_base
drop cascades to view user_storage_pool_permissions_view
drop cascades to view user_vds_groups_permissions_view_base
drop cascades to view user_vds_groups_permissions_view
drop cascades to view user_vds_permissions_view_base
drop cascades to view user_vds_permissions_view
drop cascades to view user_vm_pool_permissions_view_base
drop cascades to view user_vm_pool_permissions_view
drop cascades to view user_permissions_permissions_view
drop cascades to function getconsumedpermissionsforquotaid(uuid)
drop cascades to function getdirectpermissionsbyadelementid(uuid)
drop cascades to function getforroleandadelementandobject_wgroupcheck(uuid,uuid,uuid)
drop cascades to function getpermissionsbyadelementid(uuid,uuid,boolean)
drop cascades to function getpermissionsbyentityid(uuid,uuid,boolean)
drop cascades to function getpermissionsbyid(uuid)
drop cascades to function getpermissionsbyroleid(uuid)
drop cascades to function getpermissionsbyroleidandadelementid(uuid,uuid)
drop cascades to function getpermissionsbyroleidandadelementidandobjectid(uuid,uuid,uuid)
drop cascades to function getpermissionsbyroleidandobjectid(uuid,uuid)
drop cascades to function getpermissionstreebyentityid(uuid,integer,uuid,boolean)
psql:drop_all_views.sql:31: NOTICE:  drop cascades to 4 other objects
DETAIL:  drop cascades to function getdefaultquotabystoragepoolid(uuid)
drop cascades to function getquotabyquotaguid(uuid)
drop cascades to function getquotabyquotaname(character varying)
drop cascades to function getquotabystoragepoolguid(uuid)
psql:drop_all_views.sql:33: NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to function getquotastoragebyquotaguid(uuid)
drop cascades to function getquotastoragebystorageguid(uuid,uuid,boolean)
psql:drop_all_views.sql:34: NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to function getquotavdsgroupbyquotaguid(uuid)
drop cascades to function getquotavdsgroupbyvdsgroupguid(uuid,uuid,boolean)
psql:drop_all_views.sql:35: NOTICE:  drop cascades to 3 other objects
DETAIL:  drop cascades to function getallthinquotasbystorageid(uuid)
drop cascades to function getallthinquotasbyvdsgroupid(uuid)
drop cascades to function getquotabyadelementid(uuid,uuid)
psql:drop_all_views.sql:37: NOTICE:  drop cascades to function getrepo_files_by_storage_domain_and_storage_pool(uuid,uuid,integer)
psql:drop_all_views.sql:38: NOTICE:  drop cascades to 11 other objects
DETAIL:  drop cascades to function getallfromstorage_domains(uuid,boolean)
drop cascades to function getfailingstorage_domains()
drop cascades to function getstorage_domain_by_id_with_permitted_action(uuid,integer,uuid)
drop cascades to function getstorage_domain_staticbystorage_type_and_storage_pool_id(integer,uuid)
drop cascades to function getstorage_domains_by_connection(character varying)
drop cascades to function getstorage_domains_by_id_and_by_storage_pool_id(uuid,uuid)
drop cascades to function getstorage_domains_by_storage_pool_id_and_connection(uuid,character varying)
drop cascades to function getstorage_domains_by_storage_pool_id_with_permitted_action(uuid,integer,uuid)
drop cascades to function getstorage_domains_by_storagepoolid(uuid,uuid,boolean)
drop cascades to function getstorage_domains_list_by_imageid(uuid)
drop cascades to function getstorage_domains_list_by_storagedomainid(uuid)
psql:drop_all_views.sql:39: NOTICE:  drop cascades to function getstorage_domain_staticbystorage_pool_id(uuid)
psql:drop_all_views.sql:41: NOTICE:  drop cascades to function getstorage_domains_by_id(uuid,uuid,boolean)
psql:drop_all_views.sql:43: NOTICE:  drop cascades to 4 other objects
DETAIL:  drop cascades to view vdc_users_with_tags
drop cascades to function gettags_user_group_mapbytagname(character varying)
drop cascades to function gettagsbyusergroupid(character varying)
drop cascades to function getusergrouptagsbytagids(character varying)
psql:drop_all_views.sql:44: NOTICE:  drop cascades to 3 other objects
DETAIL:  drop cascades to function gettags_user_mapbytagname(character varying)
drop cascades to function gettagsbyuserid(character varying)
drop cascades to function getusertagsbytagids(character varying)
psql:drop_all_views.sql:45: NOTICE:  drop cascades to 4 other objects
DETAIL:  drop cascades to view vds_with_tags
drop cascades to function gettags_vds_mapbytagname(character varying)
drop cascades to function gettagsbyvdsid(character varying)
drop cascades to function getvdstagsbytagids(character varying)
psql:drop_all_views.sql:46: NOTICE:  drop cascades to 4 other objects
DETAIL:  drop cascades to view vms_with_tags
drop cascades to function gettags_vm_mapbytagname(character varying)
drop cascades to function gettagsbyvmid(character varying)
drop cascades to function getvmtagsbytagid(character varying)
psql:drop_all_views.sql:47: NOTICE:  drop cascades to function gettagsbyvmpoolid(character varying)
psql:drop_all_views.sql:48: NOTICE:  view "user_disk_permissions_view" does not exist, skipping
psql:drop_all_views.sql:49: NOTICE:  view "user_disk_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:51: NOTICE:  view "user_permissions_permissions_view" does not exist, skipping
psql:drop_all_views.sql:53: NOTICE:  view "user_storage_domain_permissions_view" does not exist, skipping
psql:drop_all_views.sql:54: NOTICE:  view "user_storage_domain_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:55: NOTICE:  view "user_storage_pool_permissions_view" does not exist, skipping
psql:drop_all_views.sql:56: NOTICE:  view "user_storage_pool_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:57: NOTICE:  view "user_vds_groups_permissions_view" does not exist, skipping
psql:drop_all_views.sql:58: NOTICE:  view "user_vds_groups_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:59: NOTICE:  view "user_vds_permissions_view" does not exist, skipping
psql:drop_all_views.sql:60: NOTICE:  view "user_vds_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:61: NOTICE:  view "user_vm_permissions_view" does not exist, skipping
psql:drop_all_views.sql:62: NOTICE:  view "user_vm_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:63: NOTICE:  view "user_vm_pool_permissions_view" does not exist, skipping
psql:drop_all_views.sql:64: NOTICE:  view "user_vm_pool_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:65: NOTICE:  view "user_vm_template_permissions_view" does not exist, skipping
psql:drop_all_views.sql:66: NOTICE:  view "user_vm_template_permissions_view_base" does not exist, skipping
psql:drop_all_views.sql:68: NOTICE:  view "vdc_users_with_tags" does not exist, skipping
psql:drop_all_views.sql:69: NOTICE:  drop cascades to 13 other objects
DETAIL:  drop cascades to function getallfromvds(uuid,boolean)
drop cascades to function getfailingvdss()
drop cascades to function getupandprioritizedvds(uuid)
drop cascades to function getvdsbyhostname(character varying)
drop cascades to function getvdsbyip(character varying)
drop cascades to function getvdsbyname(character varying)
drop cascades to function getvdsbystoragepoolid(uuid,uuid,boolean)
drop cascades to function getvdsbytype(integer)
drop cascades to function getvdsbyuniqueid(character varying)
drop cascades to function getvdsbyvdsgroupid(uuid,uuid,boolean)
drop cascades to function getvdsbyvdsid(uuid,uuid,boolean)
drop cascades to function getvdsforvdsgroupwithstatus(uuid,integer)
drop cascades to function getvdswithoutmigratingvmsbyvdsgroupid(uuid)
psql:drop_all_views.sql:71: NOTICE:  drop cascades to 2 other objects
DETAIL:  drop cascades to function getinterface_viewbyvds_id(uuid,uuid,boolean)
drop cascades to function getvdsmanagedinterfacebyvdsid(uuid,uuid,boolean)
psql:drop_all_views.sql:72: NOTICE:  view "vds_with_tags" does not exist, skipping
psql:drop_all_views.sql:73: NOTICE:  drop cascades to 6 other objects
DETAIL:  drop cascades to function getallfromvmdevice()
drop cascades to function getvmdevicebydeviceid(uuid,uuid)
drop cascades to function getvmdevicebyvmid(uuid)
drop cascades to function getvmdevicebyvmidandtype(uuid,character varying)
drop cascades to function getvmdevicebyvmidtypeanddevice(uuid,character varying,character varying,uuid,boolean)
drop cascades to function getvmunmanageddevicesbyvmid(uuid)
psql:drop_all_views.sql:74: NOTICE:  view "vm_images_storage_domains_view" does not exist, skipping
psql:drop_all_views.sql:75: NOTICE:  view "vm_images_view" does not exist, skipping
psql:drop_all_views.sql:76: NOTICE:  drop cascades to 3 other objects
DETAIL:  drop cascades to function getvm_interfacebyid(uuid)
drop cascades to function getvm_interfacebytemplate_id(uuid,uuid,boolean)
drop cascades to function getvm_interfacebyvm_id(uuid,uuid,boolean)
psql:drop_all_views.sql:77: NOTICE:  drop cascades to 16 other objects
DETAIL:  drop cascades to view vms
drop cascades to view vms_with_plug_info
drop cascades to function getvmsbydiskid(uuid)
drop cascades to function getallfromvms()
drop cascades to function getallvmsrelatedtoquotaid(uuid)
drop cascades to function getrunningvmsbystoragedomainid(uuid)
drop cascades to function getvmbyhibernationimageid(character varying)
drop cascades to function getvmbyvmguid(uuid,uuid,boolean)
drop cascades to function getvmdatafrompoolbypoolid(uuid,uuid,boolean)
drop cascades to function getvmsbyadgroupnames(character varying)
drop cascades to function getvmsbystoragedomainid(uuid)
drop cascades to function getvmsbyuserid(uuid)
drop cascades to function getvmsbyuseridwithgroupsanduserroles(uuid)
drop cascades to function getvmsbyvmtguid(uuid)
drop cascades to function getvmsdedicatedtopowerclientbyvdsid(uuid)
drop cascades to function getvmsrunningonvds(uuid)
psql:drop_all_views.sql:78: NOTICE:  drop cascades to function getvm_poolsbyvm_pool_id(uuid,uuid,boolean)
psql:drop_all_views.sql:79: NOTICE:  drop cascades to 5 other objects
DETAIL:  drop cascades to function getallvm_poolsbyuser_id(uuid)
drop cascades to function getallvm_poolsbyuser_id_with_groups_and_userroles(uuid)
drop cascades to function getvm_pools_by_time_leased_id(uuid)
drop cascades to function getvm_poolsbyadgroup_names(character varying)
drop cascades to function getvm_poolsbyvm_pool_name(character varying)
psql:drop_all_views.sql:80: NOTICE:  view "vms" does not exist, skipping
psql:drop_all_views.sql:81: NOTICE:  view "vms_with_plug_info" does not exist, skipping
psql:drop_all_views.sql:82: NOTICE:  view "vms_with_tags" does not exist, skipping
psql:drop_all_views.sql:84: NOTICE:  drop cascades to 8 other objects
DETAIL:  drop cascades to view vm_templates_with_plug_info
drop cascades to function getvmtemplatesbyimageid(uuid)
drop cascades to function fn_perms_get_templates_with_permitted_action(uuid,integer)
drop cascades to function getallfromvmtemplates(uuid,boolean)
drop cascades to function getallvmtemplatesrelatedtoquotaid(uuid)
drop cascades to function getvmtemplatebyvdsgroupid(uuid)
drop cascades to function getvmtemplatebyvmtguid(uuid,uuid,boolean)
drop cascades to function getvmtemplatesbystoragedomainid(uuid,uuid,boolean)
psql:drop_all_views.sql:85: NOTICE:  view "vm_templates_with_plug_info" does not exist, skipping
psql:common_sp.sql:524: NOTICE:  drop cascades to function fn_db_get_async_tasks()
psql:drop_old_uuid_functions.sql:25: NOTICE:  extension "uuid" does not exist, skipping
CONTEXT:  SQL statement "DROP EXTENSION IF EXISTS uuid--ossp CASCADE;"
PL/pgSQL function __temp_drop_old_uuid_functions() line 6 at EXECUTE statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_nil() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_nil()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 10 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_ns_dns() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_ns_dns()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 11 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_ns_url() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_ns_url()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 12 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_ns_oid() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_ns_oid()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 13 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_ns_x500() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_ns_x500()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 14 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_generate_v1() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_generate_v1()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 15 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_generate_v1mc() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_generate_v1mc()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 16 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_generate_v3(uuid,text) does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_generate_v3(namespace uuid, name text)"
PL/pgSQL function __temp_drop_old_uuid_functions() line 17 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_generate_v4() does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_generate_v4()"
PL/pgSQL function __temp_drop_old_uuid_functions() line 18 at SQL statement
psql:drop_old_uuid_functions.sql:25: NOTICE:  function uuid_generate_v5(uuid,text) does not exist, skipping
CONTEXT:  SQL statement "drop function if exists  uuid_generate_v5(namespace uuid, name text)"
PL/pgSQL function __temp_drop_old_uuid_functions() line 19 at SQL statement
psql:create_functions.sql:379: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 25:          CREATE GLOBAL TEMPORARY TABLE tt_TEMP22
                         ^
psql:create_functions.sql:535: NOTICE:  type "all_vds_group_usage_rs" does not exist, skipping
psql:create_functions.sql:570: NOTICE:  type "all_storage_usage_rs" does not exist, skipping
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 ...
Running  upgrade sql script upgrade/pre_upgrade/0030_add_materialized_views_table.sql ...
psql:upgrade/pre_upgrade/0030_add_materialized_views_table.sql:18: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "materialized_views_pkey" for table "materialized_views"
CONTEXT:  SQL statement "CREATE TABLE materialized_views (
          mv_name NAME NOT NULL PRIMARY KEY,
          v_name NAME NOT NULL,
          refresh_rate_in_sec INTEGER,
          last_refresh TIMESTAMP WITH TIME ZONE,
          avg_cost_ms int not null default 0
        )"
PL/pgSQL function __temp__0030_add_materialized_views_table() line 4 at SQL statement
Dropping materialized views...
Running  upgrade sql script upgrade/03_01_1250_add_custom_props_action_group.sql ...
Running  upgrade sql script upgrade/03_01_1260_remove_time_lease_vm_pool_map_table.sql ...
Running  upgrade sql script upgrade/03_01_1270_add_task_idx_audit_log.sql ...
psql:upgrade/03_01_1270_add_task_idx_audit_log.sql:1: NOTICE:  index "idx_audit_log_job_id" does not exist, skipping
psql:upgrade/03_01_1270_add_task_idx_audit_log.sql:4: NOTICE:  index "idx_audit_log_correlation_id" does not exist, skipping
Running  upgrade sql script upgrade/03_01_1280_add_async_task_entities_table.sql ...
Running  upgrade sql script upgrade/03_01_1290_add_last_time_used_as_master_col.sql ...
Running  upgrade sql script upgrade/03_01_1300_remove_allow_snapshot_col.sql ...
Running  upgrade sql script upgrade/03_01_1310_remove_default_quota.sql ...
Running  upgrade sql script upgrade/03_01_1320_update_usb_policy_of_linux_vms.sql ...
Running  upgrade sql script upgrade/03_01_1330_gluster_add_host_event_map.sql ...
Running  upgrade sql script upgrade/03_01_1340_add_disk_permissions_to_vm_creator_role.sql ...
Running  upgrade sql script upgrade/03_01_1350_add_AddPermission_to_roles.sql ...
Running  upgrade sql script upgrade/03_01_1360_add_vdsm_rpm_version_column.sql ...
Running  upgrade sql script upgrade/03_01_1370_update_roles_description.sql ...
Running  upgrade sql script upgrade/03_01_1380_add_ssh_key_fingerprint_column_to_vds_static.sql ...
Running  upgrade sql script upgrade/03_01_1390_update_power_user_role.sql ...
Running  upgrade sql script upgrade/03_01_1400_add_host_time_drift_event.sql ...
Running  upgrade sql script upgrade/03_01_1410_change_storage_status.sql ...
Running  upgrade sql script upgrade/03_01_1420_add_create_vm_to_vm_pool_admin.sql ...
Running  upgrade sql script upgrade/03_01_1430_extend_host_mac_address_size.sql ...
Running  upgrade shell script upgrade/03_01_1440_encrypt_chap_password.sh ...
Running  upgrade sql script upgrade/03_01_1450_add_timestamp_to_async_tasks_and_compensation.sql ...
Running  upgrade sql script upgrade/03_01_1460_add_storage_pool_id_and_task_type_to_async_tasks.sql ...
Running  upgrade sql script upgrade/03_01_1470_add_smartcard.sql ...
Running  upgrade sql script upgrade/03_01_1480_change_nfs_version_to_string.sql ...
Running  upgrade sql script upgrade/03_01_1490_gluster_refresh_event_map.sql ...
Running  upgrade sql script upgrade/03_01_1500_drop_hypervisor_type.sql ...
Running  upgrade sql script upgrade/03_01_1510_drop_operation_mode.sql ...
Running  upgrade sql script upgrade/03_01_1520_add_fk_vm_interface_vm_static_template.sql ...
Running  upgrade sql script upgrade/03_01_1530_configure_disk_storage_action_group_changes.sql ...
Running helper functions from action_version_map_sp.sql for upgrade/03_02_0010_delete_action_version_map.sql 
Running  upgrade sql script upgrade/03_02_0010_delete_action_version_map.sql ...
Running  upgrade sql script upgrade/03_02_0020_add_libvirt_version_col.sql ...
Running  upgrade sql script upgrade/03_02_0030_delete_permissions_on_vnic.sql ...
Running  upgrade sql script upgrade/03_02_0040_add_permissions_on_networks.sql ...
Running  upgrade sql script upgrade/03_02_0050_add_vm_guest_agent_interfaces_table.sql ...
Running  upgrade sql script upgrade/03_02_0060_change_host_to_server_event_map.sql ...
Running  upgrade sql script upgrade/03_02_0070_ha_vm_event_notifications.sql ...
Running  upgrade sql script upgrade/03_02_0080_add_user_vm_manager_to_vm_power_users.sql ...
Running  upgrade sql script upgrade/03_02_0090_cpuhost_support.sql ...
Running  upgrade sql script upgrade/03_02_0100_add_cpu_thread_columns.sql ...
Running  upgrade sql script upgrade/03_02_0110_add_nic_hash_column_to_vm_dynamic.sql ...
Running  upgrade sql script upgrade/03_02_0120_add_index_to_vm_guest_agent_interfaces.sql ...
Running  upgrade sql script upgrade/03_02_0130_add_linked_to_vm_interface.sql ...
Running  upgrade sql script upgrade/03_02_0140_allow_null_network_name_in_vm_interfaces.sql ...
Running  upgrade sql script upgrade/03_02_0150_add_console_cur_user_name.sql ...
Running  upgrade sql script upgrade/03_02_0160_drop_guest_user_id_column.sql ...
Running  upgrade sql script upgrade/03_02_0170_add_admin_internal_user_role_system.sql ...
Running  upgrade sql script upgrade/03_02_0180_add_pm_proxy_preferences.sql ...
Running  upgrade sql script upgrade/03_02_0190_add_vds_hardware_info.sql ...
Running  upgrade sql script upgrade/03_02_0200_add_vm_generation_columns.sql ...
psql:upgrade/03_02_0200_add_vm_generation_columns.sql:9: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "vm_ovf_generations_pkey" for table "vm_ovf_generations"
Running  upgrade sql script upgrade/03_02_0210_add_external_events.sql ...
Running  upgrade sql script upgrade/03_02_0220_add_pm_multi_agent_support.sql ...
Running  upgrade sql script upgrade/03_02_0230_extend_lun_size.sql ...
Running  upgrade sql script upgrade/03_02_0240_add_gluster_action_version_map.sql ...
Running  upgrade sql script upgrade/03_02_0250_delete_actiongroups_uservmmanager.sql ...
Running  upgrade sql script upgrade/03_02_0260_add_delete_protection.sql ...
Running  upgrade sql script upgrade/03_02_0270_gluster_volume_name_unique_constraint.sql ...
psql:upgrade/03_02_0270_gluster_volume_name_unique_constraint.sql:5: NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index "gluster_volumes_name_unique" for table "gluster_volumes"
CONTEXT:  SQL statement "ALTER TABLE gluster_volumes ADD CONSTRAINT gluster_volumes_name_unique UNIQUE(cluster_id, vol_name)"
PL/pgSQL function fn_db_create_constraint(character varying,character varying,text) line 4 at EXECUTE statement
Running  upgrade sql script upgrade/03_02_0280_drop_licenses.sql ...
psql:upgrade/03_02_0280_drop_licenses.sql:2: NOTICE:  table "engine_license_usage" does not exist, skipping
Running  upgrade sql script upgrade/03_02_0290_change_vm_guest_agent_interface_mac_address_type.sql ...
Running  upgrade sql script upgrade/03_02_0300_add_quota_consume_action_group_link.sql ...
Running  upgrade sql script upgrade/03_02_0310_add_disabled_to_vm_static.sql ...
Running  upgrade sql script upgrade/03_02_0320_fix_principal_name_in_users_for_ad_users.sql ...
Running  upgrade sql script upgrade/03_02_0330_add_vds_event_notifications.sql ...
Creating views...
psql:create_views.sql:313: WARNING:  column "owner" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
psql:create_views.sql:313: WARNING:  column "storage_pool_id" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
psql:create_views.sql:313: WARNING:  column "storage_pool_name" has type "unknown"
DETAIL:  Proceeding with relation creation anyway.
Creating stored procedures...
Creating stored procedures from action_version_map_sp.sql ...
Creating stored procedures from ad_groups_sp.sql ...
Creating stored procedures from all_disks_sp.sql ...
Creating stored procedures from async_tasks_sp.sql ...
Creating stored procedures from audit_log_sp.sql ...
Creating stored procedures from base_disks_sp.sql ...
Creating stored procedures from bookmarks_sp.sql ...
Creating stored procedures from business_entity_snapshot_sp.sql ...
Creating stored procedures from common_sp.sql ...
psql:common_sp.sql:524: NOTICE:  drop cascades to function fn_db_get_async_tasks()
Creating stored procedures from custom_actions_sp.sql ...
Creating stored procedures from disk_image_dynamic_sp.sql ...
Creating stored procedures from disk_images_sp.sql ...
Creating stored procedures from disk_lun_map_sp.sql ...
Creating stored procedures from event_sp.sql ...
Creating stored procedures from gluster_volumes_sp.sql ...
Creating stored procedures from images_sp.sql ...
Creating stored procedures from image_storage_domain_map_sp.sql ...
Creating stored procedures from inst_sp.sql ...
Creating stored procedures from job_sp.sql ...
Creating stored procedures from materialized_views_sp.sql ...
Creating stored procedures from multi_level_administration_sp.sql ...
Creating stored procedures from network_sp.sql ...
Creating stored procedures from quota_sp.sql ...
Creating stored procedures from repo_files_meta_data_sp.sql ...
Creating stored procedures from snapshots_sp.sql ...
Creating stored procedures from storages_san_sp.sql ...
Creating stored procedures from storages_sp.sql ...
psql:storages_sp.sql:593: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 8:       CREATE GLOBAL TEMPORARY TABLE tt_TEMPSTORAGEDOMAINMAPT...
                     ^
psql:storages_sp.sql:593: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 20:       CREATE GLOBAL TEMPORARY TABLE TEMPLATES_IDS_TEMPORARY_...
                      ^
Creating stored procedures from system_statistics_sp.sql ...
Creating stored procedures from tags_sp.sql ...
Creating stored procedures from tags_vm_pool_map_sp.sql ...
Creating stored procedures from user_sp.sql ...
Creating stored procedures from vdc_option_sp.sql ...
Creating stored procedures from vds_groups_sp.sql ...
Creating stored procedures from vds_spm_id_map_sp.sql ...
Creating stored procedures from vds_sp.sql ...
Creating stored procedures from vm_device_sp.sql ...
Creating stored procedures from vm_pool_maps_sp.sql ...
Creating stored procedures from vm_pools_sp.sql ...
psql:vm_pools_sp.sql:162: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 6:          CREATE GLOBAL TEMPORARY TABLE tt_VM_POOL_GROUP
                        ^
psql:vm_pools_sp.sql:162: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 23:          CREATE GLOBAL TEMPORARY TABLE tt_VM_POOL_RUNNING
                         ^
psql:vm_pools_sp.sql:162: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 40:          CREATE GLOBAL TEMPORARY TABLE tt_VM_POOL_PRERESULT
                         ^
psql:vm_pools_sp.sql:162: WARNING:  GLOBAL is deprecated in temporary table creation
LINE 59:          CREATE GLOBAL TEMPORARY TABLE tt_VM_POOL_RESULT
                         ^
Creating stored procedures from vms_sp.sql ...
Creating stored procedures from vm_templates_sp.sql ...
psql:common_sp.sql:524: NOTICE:  drop cascades to function fn_db_get_async_tasks()
Running  upgrade sql script upgrade/post_upgrade/0010_add_object_column_white_list_table.sql ...
Running  upgrade sql script upgrade/post_upgrade/0020_create_materialized_views.sql ...
Refreshing materialized views...
Done.
/usr/share/ovirt-engine/dbscripts
