<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi, of course i did. I put these domain's first in to
      maintenance, then Detached it from the datacenter. <br>
    </p>
    <p>The last step is destroy or remove "just name it" and this last
      step is mysteriously not working. <br>
    </p>
    <img src="cid:part1.F9B078FC.7148F417@1und1.de" alt=""><br>
    <br>
    and throwing sql exception which I attached before.<br>
    <br>
    Thank you in advance<br>
    ladislav<br>
    <br>
    <div class="moz-cite-prefix">On 21.02.2018 14:03, Eyal Shenitzky
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAGmmwPEDrYXwM6foTQpwHqpKFy4UV0MD+hZo0DYtsj9n3ntzdQ@mail.gmail.com">
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <div dir="ltr">Did you manage to set the domain to maintenance?
        <div><br>
        </div>
        <div>If so you can try to 'Destroy' the domain.</div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Wed, Feb 21, 2018 at 2:57 PM,
          Ladislav Humenik <span dir="ltr">&lt;<a
              href="mailto:ladislav.humenik@1und1.de" target="_blank"
              moz-do-not-send="true">ladislav.humenik@1und1.de</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF">
              <p>Hi, no</p>
              <p><br>
              </p>
              <p>this table "STORAGE_DOMAIN_MAP_TABLE" is not present at
                any of our ovirt's and <br>
              </p>
              <p>based on <a
href="?ui=2&amp;ik=0712e9a1b3&amp;view=fimg&amp;th=161b8714ec199ae3&amp;attid=0.1.1&amp;disp=emb&amp;attbid=ANGjdJ9PPOWU6bxvze9lPAM_2gBE-uu8fFppbzl2kuXMhSwyKx4QWo0sFYbLjNBgMhB0RdoOM_e16gleR75ZmUYnx3ndhB0CgYgXtvtBs7wNxOYf-o9rWv42duaUwsw&amp;sz=s0-l75-ft&amp;ats=1519218030205&amp;rm=161b8714ec199ae3&amp;zw&amp;atsh=0"
                  target="_blank" moz-do-not-send="true">link</a> this
                is just a temporary table. Can you point me to what
                query should I test?</p>
              <p>thank you in advance</p>
              <p>Ladislav<br>
              </p>
              <br>
              <div class="m_1598474974025300265moz-cite-prefix">On
                21.02.2018 12:50, Eyal Shenitzky wrote:<br>
              </div>
              <blockquote type="cite">
                <div dir="ltr">
                  <div>According to the logs, it seems like you somehow
                    missing a table in the DB - </div>
                  <div>
                    <pre class="m_1598474974025300265gmail-aLF-aPX-K0-aPE" style="display:block;font-family:&quot;Courier New&quot;,Courier,monospace,arial,sans-serif;margin:0px;white-space:pre-wrap;word-wrap:break-word;background-color:rgb(255,255,255);color:rgb(0,0,0);font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">STORAGE_DOMAIN_MAP_TABLE.</pre>
                    <pre class="m_1598474974025300265gmail-aLF-aPX-K0-aPE" style="display:block;margin:0px;word-wrap:break-word;background-color:rgb(255,255,255);text-align:left;text-indent:0px;text-decoration-style:initial;text-decoration-color:initial"><font color="#000000" face="Courier New, Courier, monospace, arial, sans-serif"><span style="font-size:14px;white-space:pre-wrap">4211-b98f-a37604642251] Command 'org.ovirt.engine.core.bll.<wbr>storage.domain.<wbr>RemoveStorageDomainCommand' failed: CallableStatementCallback; bad SQL grammar [{call force_delete_storage_domain(?)<wbr>}]; nested exception is org.postgresql.util.<wbr>PSQLException: ERROR: relation "storage_domain_map_table" does not exist
</span></font></pre>
                    <pre class="m_1598474974025300265gmail-aLF-aPX-K0-aPE" style="display:block;font-family:&quot;Courier New&quot;,Courier,monospace,arial,sans-serif;margin:0px;white-space:pre-wrap;word-wrap:break-word;background-color:rgb(255,255,255);color:rgb(0,0,0);font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Did you tryied to run some SQL query which cause that issue?</span>
</pre>
                    <br>
                  </div>
                  <div><br>
                  </div>
                </div>
                <div class="gmail_extra"><br>
                  <div class="gmail_quote">On Wed, Feb 21, 2018 at 11:48
                    AM, Ladislav Humenik <span dir="ltr">&lt;<a
                        href="mailto:ladislav.humenik@1und1.de"
                        target="_blank" moz-do-not-send="true">ladislav.humenik@1und1.de</a>&gt;</span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0
                      .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div text="#000000" bgcolor="#FFFFFF"> Hello, <br>
                        <br>
                        we can not remove old NFS-data storage domains,
                        this 4 are already deactivated and unattached:<br>
                        <span
                          class="m_1598474974025300265m_2572608747032311022gwt-InlineLabel"><br>
                          engine=&gt; select id,storage_name from
                          storage_domains where storage_name like
                          'bs09%';<br>
                                            id                  |
                          storage_name  <br>
                          ------------------------------<wbr>--------+---------------<br>
                           819b419e-638b-43c7-9189-b93c0<wbr>314d38a |
                          bs09aF2C10kvm<br>
                           9a403356-f58a-4e80-9435-026e6<wbr>f853a9b |
                          bs09bF2C10kvm<br>
                           f5efd264-045b-48d5-b35c-661a3<wbr>0461de5 |
                          bs09aF2C9kvm<br>
                           a0989c64-fc41-4a8b-8544-91413<wbr>7d7eae8 |
                          bs09bF2C9kvm<br>
                          (4 rows)<br>
                          <br>
                        </span><span
                          class="m_1598474974025300265m_2572608747032311022gwt-InlineLabel"><br>
                          The only images which still resides in DB are
                          OVF_STORE templates:<br>
                          <br>
                          engine=&gt; select
                          image_guid,storage_name,disk_d<wbr>escription
                          from images_storage_domain_view where
                          storage_name like 'bs09%';<br>
                                        image_guid              |
                          storage_name  | disk_description <br>
                          ------------------------------<wbr>--------+---------------+-----<wbr>-------------<br>
                           6b72139d-a4b3-4e22-98e2-e8b1d<wbr>64e8e50 |
                          bs09bF2C9kvm  | OVF_STORE<br>
                           997fe5a6-9647-4d42-b074-27767<wbr>984b7d2 |
                          bs09bF2C9kvm  | OVF_STORE<br>
                           2b1884cb-eb37-475f-9c24-96384<wbr>00f15af |
                          bs09aF2C10kvm | OVF_STORE<br>
                           85383ffe-68ba-4a82-a692-d93e3<wbr>8bf7f4c |
                          bs09aF2C9kvm  | OVF_STORE<br>
                           bca14796-aed1-4747-87c9-1b258<wbr>61fad86 |
                          bs09aF2C9kvm  | OVF_STORE<br>
                           797c27bf-7c2d-4363-96f9-565fa<wbr>58d0a5e |
                          bs09bF2C10kvm | OVF_STORE<br>
                           5d092a1b-597c-48a3-8058-cbe40<wbr>d39c2c9 |
                          bs09bF2C10kvm | OVF_STORE<br>
                           dc61f42f-1330-4bfb-986a-d868c<wbr>736da59 |
                          bs09aF2C10kvm | OVF_STORE<br>
                          (8 rows)<br>
                          <br>
                          <br>
                          <br>
                        </span>Current oVirt Engine version: <span
                          class="m_1598474974025300265m_2572608747032311022gwt-InlineLabel">4.1.8.2-1.el7.centos<br>
                          Exception logs from engine are in attachment<br>
                          <br>
                          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 ?<br>
                          <br>
                          Thank you in advance</span><span
                          class="m_1598474974025300265HOEnZb"><font
                            color="#888888"><br>
                            <pre class="m_1598474974025300265m_2572608747032311022moz-signature" cols="72">-- 
Ladislav Humenik</pre>
                          </font></span></div>
                      <br>
                      ______________________________<wbr>_________________<br>
                      Users mailing list<br>
                      <a href="mailto:Users@ovirt.org" target="_blank"
                        moz-do-not-send="true">Users@ovirt.org</a><br>
                      <a
                        href="http://lists.ovirt.org/mailman/listinfo/users"
                        rel="noreferrer" target="_blank"
                        moz-do-not-send="true">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
                      <br>
                    </blockquote>
                  </div>
                  <br>
                  <br clear="all">
                  <div><br>
                  </div>
                  -- <br>
                  <div class="m_1598474974025300265gmail_signature"
                    data-smartmail="gmail_signature">
                    <div dir="ltr">Regards,
                      <div>Eyal Shenitzky</div>
                    </div>
                  </div>
                </div>
              </blockquote>
              <br>
              <pre class="m_1598474974025300265moz-signature" cols="72">-- 
Ladislav Humenik

System administrator / VI
IT Operations Hosting Infrastructure

1&amp;1 Internet SE | Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
Phone: <a href="tel:+49%20721%20913748361" value="+49721913748361" target="_blank" moz-do-not-send="true">+49 721 91374-8361</a>
E-Mail: <a class="m_1598474974025300265moz-txt-link-abbreviated" href="mailto:ladislav.humenik@1und1.de" target="_blank" moz-do-not-send="true">ladislav.humenik@1und1.de</a> | Web: <a class="m_1598474974025300265moz-txt-link-abbreviated" href="http://www.1und1.de" target="_blank" moz-do-not-send="true">www.1und1.de</a>

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.</pre>
            </div>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        <div class="gmail_signature" data-smartmail="gmail_signature">
          <div dir="ltr">Regards,
            <div>Eyal Shenitzky</div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Ladislav Humenik

System administrator / VI
IT Operations Hosting Infrastructure

1&amp;1 Internet SE | Ernst-Frey-Str. 5 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8361
E-Mail: <a class="moz-txt-link-abbreviated" href="mailto:ladislav.humenik@1und1.de">ladislav.humenik@1und1.de</a> | Web: <a class="moz-txt-link-abbreviated" href="http://www.1und1.de">www.1und1.de</a>

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.</pre>
  </body>
</html>