Hello again,

the result is: ERROR:  permission denied to create temporary tables in database "engine"


- I forgot to mention we do not run the DB on localhost, but on dedicated server which is managed by DB-admins. After granting the necessary TEMPORARY privileges:





engine-log:

2018-02-22 08:47:57,678+01 INFO [org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Lock Acquired to object 'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', sharedLocks=''}' 2018-02-22 08:47:57,694+01 INFO [org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Running command: RemoveStorageDomainCommand internal: false. Entities affected :  ID: f5efd264-045b-48d5-b35c-661a30461de5 Type: StorageAction group DELETE_STORAGE_DOMAIN with role type ADMIN 2018-02-22 08:47:57,877+01 INFO [org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] EVENT_ID: USER_REMOVE_STORAGE_DOMAIN(960), Correlation ID: 6f250dbf-40d2-4017-861a-ae410fc382f5, Job ID: d825643c-3f2e-449c-a19d-dc55af74d153, Call Stack: null, Custom ID: null, Custom Event ID: -1, Message: Storage Domain bs09aF2C9kvm was removed by admin@internal 2018-02-22 08:47:57,881+01 INFO [org.ovirt.engine.core.bll.storage.domain.RemoveStorageDomainCommand] (default task-13) [6f250dbf-40d2-4017-861a-ae410fc382f5] Lock freed to object 'EngineLock:{exclusiveLocks='[f5efd264-045b-48d5-b35c-661a30461de5=STORAGE]', sharedLocks=''}'


Thank you for your help,

Ladislav


On 22.02.2018 06:11, Eyal Shenitzky wrote:
So here is the Query:

BEGIN -- Creating a temporary table which will give all the images and the disks which resids on only the specified storage domain. (copied template disks on multiple storage domains will not be part of this table) CREATE TEMPORARY TABLE STORAGE_DOMAIN_MAP_TABLEAS SELECT image_guidAS image_id,
         disk_id
     FROM memory_and_disk_images_storage_domain_view
     WHERE storage_id = v_storage_domain_id

     EXCEPT SELECT image_guidAS image_id,
         disk_id
     FROM memory_and_disk_images_storage_domain_view
     WHERE storage_id != v_storage_domain_id;

     exception when othersthen TRUNCATETABLE STORAGE_DOMAIN_MAP_TABLE;

     INSERT INTO STORAGE_DOMAIN_MAP_TABLE
     SELECT image_guidAS image_id,
         disk_id
     FROM memory_and_disk_images_storage_domain_view
     WHERE storage_id = v_storage_domain_id

     EXCEPT SELECT image_guidAS image_id,
         disk_id
     FROM memory_and_disk_images_storage_domain_view
     WHERE storage_id != v_storage_domain_id;
END;
Try to run it and share the results please.

On Wed, Feb 21, 2018 at 4:01 PM, Eyal Shenitzky <eshen...@redhat.com <mailto:eshen...@redhat.com>> wrote:

    Note that destroy and remove are two different operations.

    Did you try both?

    On Wed, Feb 21, 2018 at 3:17 PM, Ladislav Humenik
    <ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de>> wrote:

        Hi, of course i did. I put these domain's first in to
        maintenance, then Detached it from the datacenter.

        The last step is destroy or remove "just name it" and this
        last step is mysteriously not working.



        and throwing sql exception which I attached before.

        Thank you in advance
        ladislav

        On 21.02.2018 14:03, Eyal Shenitzky wrote:
        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.hume...@1und1.de
        <mailto:ladislav.hume...@1und1.de>> wrote:

            Hi, no


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

            based on link
            
<http://?ui=2&ik=0712e9a1b3&view=fimg&th=161b8714ec199ae3&attid=0.1.1&disp=emb&attbid=ANGjdJ9PPOWU6bxvze9lPAM_2gBE-uu8fFppbzl2kuXMhSwyKx4QWo0sFYbLjNBgMhB0RdoOM_e16gleR75ZmUYnx3ndhB0CgYgXtvtBs7wNxOYf-o9rWv42duaUwsw&sz=s0-l75-ft&ats=1519218030205&rm=161b8714ec199ae3&zw&atsh=0>
            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.hume...@1und1.de
            <mailto:ladislav.hume...@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 <mailto:Users@ovirt.org>
                http://lists.ovirt.org/mailman/listinfo/users
                <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
            
<https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
            Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
            E-Mail:ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de>  | 
Web:www.1und1.de <http://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

-- Ladislav Humenik

        System administrator / VI
        IT Operations Hosting Infrastructure

        1&1 Internet SE |Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
        
<https://maps.google.com/?q=Ernst-Frey-Str.+5+%7C+76135+Karlsruhe+%7C+Germany&entry=gmail&source=g>
        Phone:+49 721 91374-8361 <tel:+49%20721%20913748361>
        E-Mail:ladislav.hume...@1und1.de <mailto:ladislav.hume...@1und1.de>  | 
Web:www.1und1.de <http://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




--
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.hume...@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.

_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Reply via email to