<div dir="ltr"><div>According to the logs, it seems like you somehow missing a table in the DB - </div><div><pre class="gmail-aLF-aPX-K0-aPE" style="display:block;font-family:"Courier New",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="gmail-aLF-aPX-K0-aPE" style="display:block;font-family:"Courier New",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"><br></pre><pre class="gmail-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.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<br></span></font></pre><pre class="gmail-aLF-aPX-K0-aPE" style="display:block;font-family:"Courier New",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"><br></pre><pre class="gmail-aLF-aPX-K0-aPE" style="display:block;font-family:"Courier New",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><br></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"><<a href="mailto:ladislav.humenik@1und1.de" target="_blank">ladislav.humenik@1und1.de</a>></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_2572608747032311022gwt-InlineLabel"><br>
engine=> select id,storage_name from storage_domains where
storage_name like 'bs09%';<br>
id | storage_name <br>
------------------------------<wbr>--------+---------------<br>
819b419e-638b-43c7-9189-<wbr>b93c0314d38a | bs09aF2C10kvm<br>
9a403356-f58a-4e80-9435-<wbr>026e6f853a9b | bs09bF2C10kvm<br>
f5efd264-045b-48d5-b35c-<wbr>661a30461de5 | bs09aF2C9kvm<br>
a0989c64-fc41-4a8b-8544-<wbr>914137d7eae8 | bs09bF2C9kvm<br>
(4 rows)<br>
<br>
</span><span class="m_2572608747032311022gwt-InlineLabel"><br>
The only images which still resides in DB are OVF_STORE templates:<br>
<br>
engine=> select image_guid,storage_name,disk_<wbr>description 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-<wbr>e8b1d64e8e50 | bs09bF2C9kvm | OVF_STORE<br>
997fe5a6-9647-4d42-b074-<wbr>27767984b7d2 | bs09bF2C9kvm | OVF_STORE<br>
2b1884cb-eb37-475f-9c24-<wbr>9638400f15af | bs09aF2C10kvm | OVF_STORE<br>
85383ffe-68ba-4a82-a692-<wbr>d93e38bf7f4c | bs09aF2C9kvm | OVF_STORE<br>
bca14796-aed1-4747-87c9-<wbr>1b25861fad86 | bs09aF2C9kvm | OVF_STORE<br>
797c27bf-7c2d-4363-96f9-<wbr>565fa58d0a5e | bs09bF2C10kvm | OVF_STORE<br>
5d092a1b-597c-48a3-8058-<wbr>cbe40d39c2c9 | bs09bF2C10kvm | OVF_STORE<br>
dc61f42f-1330-4bfb-986a-<wbr>d868c736da59 | bs09aF2C10kvm | OVF_STORE<br>
(8 rows)<br>
<br>
<br>
<br>
</span>Current oVirt Engine version: <span class="m_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="HOEnZb"><font color="#888888"><br>
<pre class="m_2572608747032311022moz-signature" cols="72">--
Ladislav Humenik</pre>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></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>