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@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://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <br> </body> </html> --------------090000020507010902040907--