Did you manage to set the domain to maintenance?

If so you can try to 'Destroy' the domain.

On Wed, Feb 21, 2018 at 2:57 PM, Ladislav Humenik <ladislav.humenik@1und1.de> wrote:

Hi, no


this table "STORAGE_DOMAIN_MAP_TABLE" is not present at any of our ovirt's and

based on link this is just a temporary table. Can you point me to what query should I test?

thank you in advance

Ladislav


On 21.02.2018 12:50, Eyal Shenitzky wrote:
According to the logs, it seems like you somehow missing a table in the DB - 
STORAGE_DOMAIN_MAP_TABLE.

          
4211-b98f-a37604642251] Command 'org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand' failed: CallableStatementCallback; bad SQL grammar [{call force_delete_storage_domain(?)}]; nested exception is org.postgresql.util.PSQLException: ERROR: relation "storage_domain_map_table" does not exist


          

          
Did you tryied to run some SQL query which cause that issue?


          

        

        


        

      

      


        
On Wed, Feb 21, 2018 at 11:48 AM,
          Ladislav Humenik <ladislav.humenik@1und1.de>
          wrote:

          

            
 Hello, 

              

              we can not remove old NFS-data storage domains, this 4 are
              already deactivated and unattached:

              

                engine=> select id,storage_name from storage_domains
                where storage_name like 'bs09%';

                                  id                  | storage_name  

                --------------------------------------+---------------

                 819b419e-638b-43c7-9189-b93c0314d38a |
                bs09aF2C10kvm

                 9a403356-f58a-4e80-9435-026e6f853a9b |
                bs09bF2C10kvm

                 f5efd264-045b-48d5-b35c-661a30461de5 |
                bs09aF2C9kvm

                 a0989c64-fc41-4a8b-8544-914137d7eae8 |
                bs09bF2C9kvm

                (4 rows)

                

              

                The only images which still resides in DB are OVF_STORE
                templates:

                

                engine=> select image_guid,storage_name,disk_description
                from images_storage_domain_view where storage_name like
                'bs09%';

                              image_guid              | storage_name  |
                disk_description 

                --------------------------------------+---------------+------------------

                 6b72139d-a4b3-4e22-98e2-e8b1d64e8e50 |
                bs09bF2C9kvm  | OVF_STORE

                 997fe5a6-9647-4d42-b074-27767984b7d2 |
                bs09bF2C9kvm  | OVF_STORE

                 2b1884cb-eb37-475f-9c24-9638400f15af |
                bs09aF2C10kvm | OVF_STORE

                 85383ffe-68ba-4a82-a692-d93e38bf7f4c |
                bs09aF2C9kvm  | OVF_STORE

                 bca14796-aed1-4747-87c9-1b25861fad86 |
                bs09aF2C9kvm  | OVF_STORE

                 797c27bf-7c2d-4363-96f9-565fa58d0a5e |
                bs09bF2C10kvm | OVF_STORE

                 5d092a1b-597c-48a3-8058-cbe40d39c2c9 |
                bs09bF2C10kvm | OVF_STORE

                 dc61f42f-1330-4bfb-986a-d868c736da59 |
                bs09aF2C10kvm | OVF_STORE

                (8 rows)

                

                

                

              Current oVirt Engine version: 4.1.8.2-1.el7.centos

                Exception logs from engine are in attachment

                

                Do you have any magic sql statement to figure out what
                is causing this exception and how we can remove those
                storage domains without disruption ?

                

                Thank you in advance

                  
-- 
Ladislav Humenik

                

            

            _______________________________________________

            Users mailing list

            Users@ovirt.org

            http://lists.ovirt.org/mailman/listinfo/users

            

          

        

        

        

        


        

        -- 

        

          
Regards,
            
Eyal Shenitzky

          

        

      

    

    

    
-- 
Ladislav Humenik

System administrator / VI
IT Operations Hosting Infrastructure

1&1 Internet SE | Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8361
E-Mail: ladislav.humenik@1und1.de | Web: www.1und1.de

Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 24498

Vorstand: Robert Hoffmann, Hans-Henning Kettler, Uwe Lamnek, Matthias Steinberg
Aufsichtsratsvorsitzender: René Obermann


Member of United Internet

Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten Sie diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt, diese E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu verwenden.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient of this e-mail, you are hereby notified that saving, distribution or use of the content of this e-mail in any way is prohibited. If you have received this e-mail in error, please notify the sender and delete the e-mail.

  






-- 
Regards,
Eyal Shenitzky