<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body 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 moz-do-not-send="false"
href="cid:part1.0918F8E6.4389FAF5@1und1.de">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="moz-cite-prefix">On 21.02.2018 12:50, Eyal Shenitzky
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAGmmwPGJPxK3XOtywMEr1A7nkywCiFf1Gzem0zvryq1uk8WueA@mail.gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<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">
</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
</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">
</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>
</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"
moz-do-not-send="true">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" 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/<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>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
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: <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>