[ovirt-users] Problem Upgrading 3.4.4 -> 3.5

[InterNetX - Juergen Gotteswinter]

Am 23.12.2014 um 02:15 schrieb Eli Mesika:
> 
> 
> ----- Original Message -----
>> From: "InterNetX - Juergen Gotteswinter" <jg at internetx.com>
>> To: users at ovirt.org
>> Sent: Monday, December 22, 2014 2:07:55 PM
>> Subject: Re: [ovirt-users] Problem Upgrading 3.4.4 -> 3.5
>>
>> Hello again,
>>
>>> 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.
>>
>> uhm, interesting. could this be caused be deinstallation of dwh reporting?
>>
>>>
>>> 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
>>>
>>
>> it just drops "ERROR:  relation "event_notification_methods" does not
>> exist"
> 
> OK
> Lets check what do you have in your DB
> 
> Please attach the result of the following 
> 
> psql -U engine -c "select table_name from information_schema.tables where table_schema = 'public' order by table_name ;" engine 
> 
> Thanks 
> 

sure, here we go


> 
>>
>>> Let me know how it is going ...
>>>
>>> Eli
>>>
>>
>> Thank you already for your help!
>>
>> Juergen
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>

-------------- next part --------------
                  table_name                   
-----------------------------------------------
 action_version_map
 ad_groups
 affinity_group_members
 affinity_groups
 affinity_groups_view
 all_disks
 all_disks_including_snapshots
 async_tasks
 async_tasks_entities
 audit_log
 base_disks
 bookmarks
 business_entity_snapshot
 cluster_policies
 cluster_policy_units
 custom_actions
 desktop_vms
 disk_image_dynamic
 disk_lun_map
 dwh_add_tags_relations_history_view
 dwh_cluster_configuration_history_view
 dwh_datacenter_configuration_history_view
 dwh_datacenter_history_view
 dwh_datacenter_storage_map_history_view
 dwh_disk_vm_map_history_view
 dwh_history_timekeeping
 dwh_host_configuration_full_check_view
 dwh_host_configuration_history_view
 dwh_host_history_view
 dwh_host_interface_configuration_history_view
 dwh_host_interface_history_view
 dwh_osinfo
 dwh_remove_tags_relations_history_view
 dwh_storage_domain_configuration_history_view
 dwh_storage_domain_history_view
 dwh_tags_details_history_view
 dwh_vm_configuration_history_view
 dwh_vm_device_history_view
 dwh_vm_disk_configuration_history_view
 dwh_vm_disks_history_view
 dwh_vm_history_view
 dwh_vm_interface_configuration_history_view
 dwh_vm_interface_history_view
 event_map
 event_notification_hist
 event_subscriber
 gluster_cluster_services
 gluster_hooks
 gluster_server
 gluster_server_hooks
 gluster_server_hooks_view
 gluster_server_services
 gluster_server_services_view
 gluster_services
 gluster_service_types
 gluster_volume_access_protocols
 gluster_volume_bricks
 gluster_volume_bricks_view
 gluster_volume_options
 gluster_volumes
 gluster_volumes_view
 gluster_volume_task_steps
 gluster_volume_transport_types
 images
 images_storage_domain_view
 image_storage_domain_map
 image_types_storage_domain
 image_types_view
 instance_types_storage_domain
 instance_types_view
 internal_permissions_view
 iscsi_bonds
 iscsi_bonds_networks_map
 iscsi_bonds_storage_connections_map
 job
 job_subject_entity
 luns
 lun_storage_server_connection_map
 luns_view
 materialized_views
 network
 network_cluster
 network_cluster_view
 network_qos
 network_vds_view
 network_view
 object_column_white_list
 object_column_white_list_sql
 permissions
 permissions_view
 policy_units
 providers
 quota
 quota_global_view
 quota_limitation
 quota_limitations_view
 quota_storage_view
 quota_vds_group_view
 quota_view
 repo_file_meta_data
 roles
 roles_groups
 schema_version
 server_vms
 snapshots
 step
 storage_domain_dynamic
 storage_domain_file_repos
 storage_domains
 storage_domains_for_search
 storage_domain_static
 storage_domain_static_view
 storage_domains_with_hosts_view
 storage_domains_without_storage_pools
 storage_for_image_view
 storage_pool
 storage_pool_iso_map
 storage_pool_with_storage_domain
 storage_server_connections
 tags
 tags_user_group_map
 tags_user_group_map_view
 tags_user_map
 tags_user_map_view
 tags_vds_map
 tags_vds_map_view
 tags_vm_map
 tags_vm_map_view
 tags_vm_pool_map
 tags_vm_pool_map_view
 user_db_users_permissions_view
 user_disk_permissions_view
 user_disk_permissions_view_base
 user_flat_groups
 user_network_permissions_view
 user_network_permissions_view_base
 user_object_permissions_view
 user_permissions_permissions_view
 users
 users_and_groups_to_vm_pool_map_view
 user_storage_domain_permissions_view
 user_storage_domain_permissions_view_base
 user_storage_pool_permissions_view
 user_storage_pool_permissions_view_base
 user_vds_groups_permissions_view
 user_vds_groups_permissions_view_base
 user_vds_permissions_view
 user_vds_permissions_view_base
 user_vm_permissions_view
 user_vm_permissions_view_base
 user_vm_pool_permissions_view
 user_vm_pool_permissions_view_base
 user_vm_template_permissions_view
 user_vm_template_permissions_view_base
 user_vnic_profile_permissions_view
 user_vnic_profile_permissions_view_base
 vdc_db_log
 vdc_options
 vdc_users
 vdc_users_with_tags
 vds
 vds_dynamic
 vds_groups
 vds_groups_storage_domain
 vds_groups_view
 vds_interface
 vds_interface_statistics
 vds_interface_view
 vds_spm_id_map
 vds_static
 vds_statistics
 vds_with_tags
 vm_device
 vm_device_view
 vm_dynamic
 vm_guest_agent_interfaces
 vm_images_storage_domains_view
 vm_images_view
 vm_init
 vm_interface
 vm_interface_statistics
 vm_interface_view
 vm_ovf_generations
 vm_pool_map
 vm_pool_map_view
 vm_pools
 vm_pools_full_view
 vm_pools_view
 vms
 vms_for_disk_view
 vm_static
 vm_statistics
 vms_with_plug_info
 vms_with_tags
 vm_templates_storage_domain
 vm_templates_view
 vm_templates_with_plug_info
 vnic_profiles
 vnic_profiles_view
(199 rows)