6:35 a.m.
This is a multi-part message in MIME format.
--------------090000020507010902040907
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
On 01/31/2014 04:49 PM, Juan Pablo Lorier wrote:
Hi,
I'm about to hack engine db to remove a gluster volume and I'd like
someone to advise me on this. The environment is in production, I've
backed up the db and I'm planning to remove every entry I can find of
the volume (host members, cluster, etc) but I found that there's no
clusters table (and I need to remove a cluster that no longer exists
after a force remove of the DC but somehow the volume still is attached
to it).
delete from gluster_volume_bricks where volume_id = "..";
delete from gluster_volume_options where volume_id = "..";
delete from gluster_volume_transport_types where volume_id="..";
delete from gluster_volume_access_protocols where volume_id="..";
delete from gluster_volumes where id="..";
The above would delete all gluster volume information stored in the db.
Cluster information is stored in vds_groups table.
You should have been able to remove the host using "Force" option.
Didn't that work for you. I would be interested to see the logs if it
did not.
thanks
sahina
I'll try IRC also to see if someone can give me a hand.
Regards,
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--------------090000020507010902040907
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">On 01/31/2014 04:49 PM, Juan Pablo
Lorier wrote:<br>
</div>
<blockquote cite="mid:52EB86AB.7020908@gmail.com"
type="cite">
<pre wrap="">Hi,
I'm about to hack engine db to remove a gluster volume and I'd like
someone to advise me on this. The environment is in production, I've
backed up the db and I'm planning to remove every entry I can find of
the volume (host members, cluster, etc) but I found that there's no
clusters table (and I need to remove a cluster that no longer exists
after a force remove of the DC but somehow the volume still is attached
to it).</pre>
</blockquote>
<br>
delete from gluster_volume_bricks where volume_id = "..";<br>
delete from gluster_volume_options where volume_id = "..";<br>
delete from gluster_volume_transport_types where volume_id="..";<br>
delete from gluster_volume_access_protocols where volume_id="..";<br>
delete from gluster_volumes where id="..";<br>
<br>
The above would delete all gluster volume information stored in the
db.<br>
<br>
Cluster information is stored in vds_groups table.<br>
<br>
You should have been able to remove the host using "Force" option.
Didn't that work for you. I would be interested to see the logs if
it did not.<br>
<br>
thanks<br>
sahina<br>
<blockquote cite="mid:52EB86AB.7020908@gmail.com"
type="cite">
<pre wrap="">
I'll try IRC also to see if someone can give me a hand.
Regards,
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated"
href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext"
href="http://lists.ovirt.org/mailman/listinfo/users">http://...
</pre>
</blockquote>
<br>
</body>
</html>
--------------090000020507010902040907--