From jplorier at gmail.com Fri Jan 31 06:50:31 2014 Content-Type: multipart/mixed; boundary="===============6613108697532199468==" MIME-Version: 1.0 From: Juan Pablo Lorier To: users at ovirt.org Subject: Re: [Users] [URGENT] hacking the DB Date: Fri, 31 Jan 2014 09:50:27 -0200 Message-ID: <52EB8E03.5050506@gmail.com> In-Reply-To: 52EB8A81.8030105@redhat.com --===============6613108697532199468== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT Content-Type: multipart/alternative; boundary=3D"------------070802080601040009010105" This is a multi-part message in MIME format. --------------070802080601040009010105 Content-Type: text/plain; charset=3DISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Sahina!! The hosts are there as the volume. What is gone is the DC and mostly everything else. I'll send you the logs, but due to the lack of time, they are going to be the raw logs for several days as the force was last week. Regards, On 31/01/14 09:35, Sahina Bose wrote: > > 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 attache= =3D d >> to it). > > delete from gluster_volume_bricks where volume_id =3D3D ".."; > delete from gluster_volume_options where volume_id =3D3D ".."; > delete from gluster_volume_transport_types where volume_id=3D3D".."; > delete from gluster_volume_access_protocols where volume_id=3D3D".."; > delete from gluster_volumes where id=3D3D".."; > > The above would delete all gluster volume information stored in the db.= =3D > > 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 > --------------070802080601040009010105 Content-Type: text/html; charset=3DISO-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Sahina!!

The hosts are there as the volume. What is gone is the DC and mostly everything else. I'll send you the logs, but due to the lack of time, they are going to be the raw logs for several days as the force was last week.
Regards,

On 31/01/14 09:35, Sahina Bose wrote:<= =3D br>

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 =3D3D "..";
delete from gluster_volume_options where volume_id =3D3D "..";
delete from gluster_volume_transport_types where volume_id=3D3D"..";<= =3D br> delete from gluster_volume_access_protocols where volume_id=3D3D"..";= =3D
delete from gluster_volumes where id=3D3D"..";

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 =
=3D
hand.
Regards,
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/=
=3D
listinfo/users

--------------070802080601040009010105-- --EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT Content-Type: application/pgp-signature; name=3D"signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename=3D"signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJS644DAAoJEC5KDDg2+NMM0RwH/0H70FT3HIcKpsxRuE2mmiHm rpmQj8vYItZ1FUOm7uEHhjudAp2LGHNEcJ/WY5KM3e3P4Cax7xBW9Zaq3yeKX37r Zg7CUZglD+WjUTH6nVkqiBRgGRSQ40sEA/8SB9YRlXz29BnsRkpcjF3CkJ3QO5wO fHk9gPeGmSbXHmn3P4Zl6NvkNkLyRl0qJUlhWibHCa7KWHUk+i5bc8P6Cmt5lHAY O4Ff5KsUgXnZ+TsAMh919zp/mJOn7CfP+Fa4lx4aI2Z4H6QolG3XMmv918VNr9tQ emKIKniTfvtOfkWbMA+rcbIVv2PVEsEuu62pvBxl+c5MKythSdrHY0huzlWzcXI=3D =3Dsohr -----END PGP SIGNATURE----- --EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT-- --===============6613108697532199468== Content-Type: multipart/signed MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhbiBPcGVuUEdQL01JTUUgc2lnbmVkIG1lc3NhZ2UgKFJGQyA0ODgwIGFuZCAzMTU2 KQotLUVuSDRXVkk4ajNqZHBJcncyUjNzd0RTcUFieGtmRmdtVApDb250ZW50LVR5cGU6IG11bHRp cGFydC9hbHRlcm5hdGl2ZTsKIGJvdW5kYXJ5PSItLS0tLS0tLS0tLS0wNzA4MDIwODA2MDEwNDAw MDkwMTAxMDUiCgpUaGlzIGlzIGEgbXVsdGktcGFydCBtZXNzYWdlIGluIE1JTUUgZm9ybWF0Lgot LS0tLS0tLS0tLS0tLTA3MDgwMjA4MDYwMTA0MDAwOTAxMDEwNQpDb250ZW50LVR5cGU6IHRleHQv cGxhaW47IGNoYXJzZXQ9SVNPLTg4NTktMQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiBxdW90 ZWQtcHJpbnRhYmxlCgpUaGFua3MgU2FoaW5hISEKClRoZSBob3N0cyBhcmUgdGhlcmUgYXMgdGhl IHZvbHVtZS4gV2hhdCBpcyBnb25lIGlzIHRoZSBEQyBhbmQgbW9zdGx5CmV2ZXJ5dGhpbmcgZWxz ZS4gSSdsbCBzZW5kIHlvdSB0aGUgbG9ncywgYnV0IGR1ZSB0byB0aGUgbGFjayBvZiB0aW1lLAp0 aGV5IGFyZSBnb2luZyB0byBiZSB0aGUgcmF3IGxvZ3MgZm9yIHNldmVyYWwgZGF5cyBhcyB0aGUg Zm9yY2Ugd2FzIGxhc3QKd2Vlay4KUmVnYXJkcywKCk9uIDMxLzAxLzE0IDA5OjM1LCBTYWhpbmEg Qm9zZSB3cm90ZToKPgo+IE9uIDAxLzMxLzIwMTQgMDQ6NDkgUE0sIEp1YW4gUGFibG8gTG9yaWVy IHdyb3RlOgo+PiBIaSwKPj4KPj4gSSdtIGFib3V0IHRvIGhhY2sgZW5naW5lIGRiIHRvIHJlbW92 ZSBhIGdsdXN0ZXIgdm9sdW1lIGFuZCBJJ2QgbGlrZQo+PiBzb21lb25lIHRvIGFkdmlzZSBtZSBv biB0aGlzLiBUaGUgZW52aXJvbm1lbnQgaXMgaW4gcHJvZHVjdGlvbiwgSSd2ZQo+PiBiYWNrZWQg dXAgdGhlIGRiIGFuZCBJJ20gcGxhbm5pbmcgdG8gcmVtb3ZlIGV2ZXJ5IGVudHJ5IEkgY2FuIGZp bmQgb2YKPj4gdGhlIHZvbHVtZSAoaG9zdCBtZW1iZXJzLCBjbHVzdGVyLCBldGMpIGJ1dCBJIGZv dW5kIHRoYXQgdGhlcmUncyBubwo+PiBjbHVzdGVycyB0YWJsZSAoYW5kIEkgbmVlZCB0byByZW1v dmUgYSBjbHVzdGVyIHRoYXQgbm8gbG9uZ2VyIGV4aXN0cwo+PiBhZnRlciBhIGZvcmNlIHJlbW92 ZSBvZiB0aGUgREMgYnV0IHNvbWVob3cgdGhlIHZvbHVtZSBzdGlsbCBpcyBhdHRhY2hlPQpkCj4+ IHRvIGl0KS4KPgo+IGRlbGV0ZSBmcm9tIGdsdXN0ZXJfdm9sdW1lX2JyaWNrcyB3aGVyZSB2b2x1 bWVfaWQgPTNEICIuLiI7Cj4gZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVfb3B0aW9ucyB3aGVy ZSB2b2x1bWVfaWQgPTNEICIuLiI7Cj4gZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVfdHJhbnNw b3J0X3R5cGVzIHdoZXJlIHZvbHVtZV9pZD0zRCIuLiI7Cj4gZGVsZXRlIGZyb20gZ2x1c3Rlcl92 b2x1bWVfYWNjZXNzX3Byb3RvY29scyB3aGVyZSB2b2x1bWVfaWQ9M0QiLi4iOwo+IGRlbGV0ZSBm cm9tIGdsdXN0ZXJfdm9sdW1lcyB3aGVyZSBpZD0zRCIuLiI7Cj4KPiBUaGUgYWJvdmUgd291bGQg ZGVsZXRlIGFsbCBnbHVzdGVyIHZvbHVtZSBpbmZvcm1hdGlvbiBzdG9yZWQgaW4gdGhlIGRiLj0K Cj4KPiBDbHVzdGVyIGluZm9ybWF0aW9uIGlzIHN0b3JlZCBpbiB2ZHNfZ3JvdXBzIHRhYmxlLgo+ Cj4gWW91IHNob3VsZCBoYXZlIGJlZW4gYWJsZSB0byByZW1vdmUgdGhlIGhvc3QgdXNpbmcgIkZv cmNlIiBvcHRpb24uCj4gRGlkbid0IHRoYXQgd29yayBmb3IgeW91LiBJIHdvdWxkIGJlIGludGVy ZXN0ZWQgdG8gc2VlIHRoZSBsb2dzIGlmIGl0Cj4gZGlkIG5vdC4KPgo+IHRoYW5rcwo+IHNhaGlu YQo+PiBJJ2xsIHRyeSBJUkMgYWxzbyB0byBzZWUgaWYgc29tZW9uZSBjYW4gZ2l2ZSBtZSBhIGhh bmQuCj4+IFJlZ2FyZHMsCj4+Cj4+Cj4+Cj4+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fCj4+IFVzZXJzIG1haWxpbmcgbGlzdAo+PiBVc2Vyc0BvdmlydC5v cmcKPj4gaHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzCj4KCgot LS0tLS0tLS0tLS0tLTA3MDgwMjA4MDYwMTA0MDAwOTAxMDEwNQpDb250ZW50LVR5cGU6IHRleHQv aHRtbDsgY2hhcnNldD1JU08tODg1OS0xCkNvbnRlbnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3Rl ZC1wcmludGFibGUKCjxodG1sPgogIDxoZWFkPgogICAgPG1ldGEgY29udGVudD0zRCJ0ZXh0L2h0 bWw7IGNoYXJzZXQ9M0RJU08tODg1OS0xIgogICAgICBodHRwLWVxdWl2PTNEIkNvbnRlbnQtVHlw ZSI+CiAgPC9oZWFkPgogIDxib2R5IHRleHQ9M0QiIzAwMDAwMCIgYmdjb2xvcj0zRCIjRkZGRkZG Ij4KICAgIFRoYW5rcyBTYWhpbmEhITxicj4KICAgIDxicj4KICAgIFRoZSBob3N0cyBhcmUgdGhl cmUgYXMgdGhlIHZvbHVtZS4gV2hhdCBpcyBnb25lIGlzIHRoZSBEQyBhbmQgbW9zdGx5CiAgICBl dmVyeXRoaW5nIGVsc2UuIEknbGwgc2VuZCB5b3UgdGhlIGxvZ3MsIGJ1dCBkdWUgdG8gdGhlIGxh Y2sgb2YKICAgIHRpbWUsIHRoZXkgYXJlIGdvaW5nIHRvIGJlIHRoZSByYXcgbG9ncyBmb3Igc2V2 ZXJhbCBkYXlzIGFzIHRoZQogICAgZm9yY2Ugd2FzIGxhc3Qgd2Vlay48YnI+CiAgICBSZWdhcmRz LDxicj4KICAgIDxicj4KICAgIDxkaXYgY2xhc3M9M0QibW96LWNpdGUtcHJlZml4Ij5PbiAzMS8w MS8xNCAwOTozNSwgU2FoaW5hIEJvc2Ugd3JvdGU6PD0KYnI+CiAgICA8L2Rpdj4KICAgIDxibG9j a3F1b3RlIGNpdGU9M0QibWlkOjUyRUI4QTgxLjgwMzAxMDVAcmVkaGF0LmNvbSIgdHlwZT0zRCJj aXRlIj4KICAgICAgPG1ldGEgY29udGVudD0zRCJ0ZXh0L2h0bWw7IGNoYXJzZXQ9M0RJU08tODg1 OS0xIgogICAgICAgIGh0dHAtZXF1aXY9M0QiQ29udGVudC1UeXBlIj4KICAgICAgPGJyPgogICAg ICA8ZGl2IGNsYXNzPTNEIm1vei1jaXRlLXByZWZpeCI+T24gMDEvMzEvMjAxNCAwNDo0OSBQTSwg SnVhbiBQYWJsbwogICAgICAgIExvcmllciB3cm90ZTo8YnI+CiAgICAgIDwvZGl2PgogICAgICA8 YmxvY2txdW90ZSBjaXRlPTNEIm1pZDo1MkVCODZBQi43MDIwOTA4QGdtYWlsLmNvbSIgdHlwZT0z RCJjaXRlIj4KICAgICAgICA8cHJlIHdyYXA9M0QiIj5IaSwKCkknbSBhYm91dCB0byBoYWNrIGVu Z2luZSBkYiB0byByZW1vdmUgYSBnbHVzdGVyIHZvbHVtZSBhbmQgSSdkIGxpa2UKc29tZW9uZSB0 byBhZHZpc2UgbWUgb24gdGhpcy4gVGhlIGVudmlyb25tZW50IGlzIGluIHByb2R1Y3Rpb24sIEkn dmUKYmFja2VkIHVwIHRoZSBkYiBhbmQgSSdtIHBsYW5uaW5nIHRvIHJlbW92ZSBldmVyeSBlbnRy eSBJIGNhbiBmaW5kIG9mCnRoZSB2b2x1bWUgKGhvc3QgbWVtYmVycywgY2x1c3RlciwgZXRjKSBi dXQgSSBmb3VuZCB0aGF0IHRoZXJlJ3Mgbm8KY2x1c3RlcnMgdGFibGUgKGFuZCBJIG5lZWQgdG8g cmVtb3ZlIGEgY2x1c3RlciB0aGF0IG5vIGxvbmdlciBleGlzdHMKYWZ0ZXIgYSBmb3JjZSByZW1v dmUgb2YgdGhlIERDIGJ1dCBzb21laG93IHRoZSB2b2x1bWUgc3RpbGwgaXMgYXR0YWNoZWQKdG8g aXQpLjwvcHJlPgogICAgICA8L2Jsb2NrcXVvdGU+CiAgICAgIDxicj4KICAgICAgZGVsZXRlIGZy b20gZ2x1c3Rlcl92b2x1bWVfYnJpY2tzIHdoZXJlIHZvbHVtZV9pZCA9M0QgIi4uIjs8YnI+CiAg ICAgIGRlbGV0ZSBmcm9tIGdsdXN0ZXJfdm9sdW1lX29wdGlvbnMgd2hlcmUgdm9sdW1lX2lkID0z RCAiLi4iOzxicj4KICAgICAgZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVfdHJhbnNwb3J0X3R5 cGVzIHdoZXJlIHZvbHVtZV9pZD0zRCIuLiI7PD0KYnI+CiAgICAgIGRlbGV0ZSBmcm9tIGdsdXN0 ZXJfdm9sdW1lX2FjY2Vzc19wcm90b2NvbHMgd2hlcmUgdm9sdW1lX2lkPTNEIi4uIjs9Cjxicj4K ICAgICAgZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVzIHdoZXJlIGlkPTNEIi4uIjs8YnI+CiAg ICAgIDxicj4KICAgICAgVGhlIGFib3ZlIHdvdWxkIGRlbGV0ZSBhbGwgZ2x1c3RlciB2b2x1bWUg aW5mb3JtYXRpb24gc3RvcmVkIGluCiAgICAgIHRoZSBkYi48YnI+CiAgICAgIDxicj4KICAgICAg Q2x1c3RlciBpbmZvcm1hdGlvbiBpcyBzdG9yZWQgaW4gdmRzX2dyb3VwcyB0YWJsZS48YnI+CiAg ICAgIDxicj4KICAgICAgWW91IHNob3VsZCBoYXZlIGJlZW4gYWJsZSB0byByZW1vdmUgdGhlIGhv c3QgdXNpbmcgIkZvcmNlIiBvcHRpb24uCiAgICAgIERpZG4ndCB0aGF0IHdvcmsgZm9yIHlvdS4g SSB3b3VsZCBiZSBpbnRlcmVzdGVkIHRvIHNlZSB0aGUgbG9ncyBpZgogICAgICBpdCBkaWQgbm90 Ljxicj4KICAgICAgPGJyPgogICAgICB0aGFua3M8YnI+CiAgICAgIHNhaGluYTxicj4KICAgICAg PGJsb2NrcXVvdGUgY2l0ZT0zRCJtaWQ6NTJFQjg2QUIuNzAyMDkwOEBnbWFpbC5jb20iIHR5cGU9 M0QiY2l0ZSI+CiAgICAgICAgPHByZSB3cmFwPTNEIiI+SSdsbCB0cnkgSVJDIGFsc28gdG8gc2Vl IGlmIHNvbWVvbmUgY2FuIGdpdmUgbWUgYSA9CmhhbmQuClJlZ2FyZHMsCgo8L3ByZT4KICAgICAg ICA8YnI+CiAgICAgICAgPGZpZWxkc2V0IGNsYXNzPTNEIm1pbWVBdHRhY2htZW50SGVhZGVyIj48 L2ZpZWxkc2V0PgogICAgICAgIDxicj4KICAgICAgICA8cHJlIHdyYXA9M0QiIj5fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpVc2VycyBtYWlsaW5nIGxpc3QK PGEgbW96LWRvLW5vdC1zZW5kPTNEInRydWUiIGNsYXNzPTNEIm1vei10eHQtbGluay1hYmJyZXZp YXRlZCIgaHJlZj0zRCJtYT0KaWx0bzpVc2Vyc0BvdmlydC5vcmciPlVzZXJzQG92aXJ0Lm9yZzwv YT4KPGEgbW96LWRvLW5vdC1zZW5kPTNEInRydWUiIGNsYXNzPTNEIm1vei10eHQtbGluay1mcmVl dGV4dCIgaHJlZj0zRCJodHRwOj0KLy9saXN0cy5vdmlydC5vcmcvbWFpbG1hbi9saXN0aW5mby91 c2VycyI+aHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuLz0KbGlzdGluZm8vdXNlcnM8L2E+ CjwvcHJlPgogICAgICA8L2Jsb2NrcXVvdGU+CiAgICAgIDxicj4KICAgIDwvYmxvY2txdW90ZT4K ICAgIDxicj4KICA8L2JvZHk+CjwvaHRtbD4KCi0tLS0tLS0tLS0tLS0tMDcwODAyMDgwNjAxMDQw MDA5MDEwMTA1LS0KCi0tRW5INFdWSThqM2pkcElydzJSM3N3RFNxQWJ4a2ZGZ21UCkNvbnRlbnQt VHlwZTogYXBwbGljYXRpb24vcGdwLXNpZ25hdHVyZTsgbmFtZT0ic2lnbmF0dXJlLmFzYyIKQ29u dGVudC1EZXNjcmlwdGlvbjogT3BlblBHUCBkaWdpdGFsIHNpZ25hdHVyZQpDb250ZW50LURpc3Bv c2l0aW9uOiBhdHRhY2htZW50OyBmaWxlbmFtZT0ic2lnbmF0dXJlLmFzYyIKCi0tLS0tQkVHSU4g UEdQIFNJR05BVFVSRS0tLS0tClZlcnNpb246IEdudVBHIHYxCkNvbW1lbnQ6IFVzaW5nIEdudVBH IHdpdGggVGh1bmRlcmJpcmQgLSBodHRwOi8vd3d3LmVuaWdtYWlsLm5ldC8KCmlRRWNCQUVCQWdB R0JRSlM2NDREQUFvSkVDNUtERGcyK05NTTBSd0gvMEg3MEZUM0hJY0twc3hSdUUybW1pSG0KcnBt UWo4dllJdFoxRlVPbTd1RUhoanVkQXAyTEdITkVjSi9XWTVLTTNlM1A0Q2F4N3hCVzlaYXEzeWVL WDM3cgpaZzdDVVpnbEQrV2pVVEg2blZrcWlCUmdHUlNRNDBzRUEvOFNCOVlSbFh6MjlCbnNSa3Bj akYzQ2tKM1FPNXdPCmZIazlnUGVHbVNiWEhtbjNQNFpsNk52a05rTHlSbDBxSlVsaFdpYkhDYTdL V0hVaytpNWJjOFA2Q210NWxIQVkKTzRGZjVLc1VnWG5aK1RzQU1oOTE5enAvbUpPbjdDZlArRmE0 bHg0YUkyWjRINlFvbEczWE1tdjkxOFZOcjl0UQplbUtJS25pVGZ2dE9ma1diTUErcmNiSVZ2MlBW RXNFdXU2MnB2QnhsK2M1TUt5dGhTZHJIWTBodXpsV3pjWEk9Cj1zb2hyCi0tLS0tRU5EIFBHUCBT SUdOQVRVUkUtLS0tLQoKLS1Fbkg0V1ZJOGozamRwSXJ3MlIzc3dEU3FBYnhrZkZnbVQtLQo= --===============6613108697532199468==--