From sabose at redhat.com Fri Jan 31 06:35:34 2014 Content-Type: multipart/mixed; boundary="===============7518686841414712814==" MIME-Version: 1.0 From: Sahina Bose To: users at ovirt.org Subject: Re: [Users] [URGENT] hacking the DB Date: Fri, 31 Jan 2014 17:05:29 +0530 Message-ID: <52EB8A81.8030105@redhat.com> In-Reply-To: 52EB86AB.7020908@gmail.com --===============7518686841414712814== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------090000020507010902040907 Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed 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 =3D ".."; delete from gluster_volume_options where volume_id =3D ".."; delete from gluster_volume_transport_types where volume_id=3D".."; delete from gluster_volume_access_protocols where volume_id=3D".."; delete from gluster_volumes where id=3D".."; 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=3DISO-8859-1 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 =3D "..";
delete from gluster_volume_options where volume_id =3D "..";
delete from gluster_volume_transport_types where volume_id=3D"..";
delete from gluster_volume_access_protocols where volume_id=3D"..";
delete from gluster_volumes where id=3D"..";

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
Use=
rs(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

--------------090000020507010902040907-- --===============7518686841414712814== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wOTAwMDAwMjA1MDcwMTA5MDIwNDA5MDcKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PUlTTy04ODU5LTE7IGZvcm1hdD1mbG93ZWQKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKCk9uIDAxLzMxLzIwMTQgMDQ6NDkgUE0sIEp1YW4gUGFibG8gTG9yaWVyIHdyb3RlOgo+ IEhpLAo+Cj4gSSdtIGFib3V0IHRvIGhhY2sgZW5naW5lIGRiIHRvIHJlbW92ZSBhIGdsdXN0ZXIg dm9sdW1lIGFuZCBJJ2QgbGlrZQo+IHNvbWVvbmUgdG8gYWR2aXNlIG1lIG9uIHRoaXMuIFRoZSBl bnZpcm9ubWVudCBpcyBpbiBwcm9kdWN0aW9uLCBJJ3ZlCj4gYmFja2VkIHVwIHRoZSBkYiBhbmQg SSdtIHBsYW5uaW5nIHRvIHJlbW92ZSBldmVyeSBlbnRyeSBJIGNhbiBmaW5kIG9mCj4gdGhlIHZv bHVtZSAoaG9zdCBtZW1iZXJzLCBjbHVzdGVyLCBldGMpIGJ1dCBJIGZvdW5kIHRoYXQgdGhlcmUn cyBubwo+IGNsdXN0ZXJzIHRhYmxlIChhbmQgSSBuZWVkIHRvIHJlbW92ZSBhIGNsdXN0ZXIgdGhh dCBubyBsb25nZXIgZXhpc3RzCj4gYWZ0ZXIgYSBmb3JjZSByZW1vdmUgb2YgdGhlIERDIGJ1dCBz b21laG93IHRoZSB2b2x1bWUgc3RpbGwgaXMgYXR0YWNoZWQKPiB0byBpdCkuCgpkZWxldGUgZnJv bSBnbHVzdGVyX3ZvbHVtZV9icmlja3Mgd2hlcmUgdm9sdW1lX2lkID0gIi4uIjsKZGVsZXRlIGZy b20gZ2x1c3Rlcl92b2x1bWVfb3B0aW9ucyB3aGVyZSB2b2x1bWVfaWQgPSAiLi4iOwpkZWxldGUg ZnJvbSBnbHVzdGVyX3ZvbHVtZV90cmFuc3BvcnRfdHlwZXMgd2hlcmUgdm9sdW1lX2lkPSIuLiI7 CmRlbGV0ZSBmcm9tIGdsdXN0ZXJfdm9sdW1lX2FjY2Vzc19wcm90b2NvbHMgd2hlcmUgdm9sdW1l X2lkPSIuLiI7CmRlbGV0ZSBmcm9tIGdsdXN0ZXJfdm9sdW1lcyB3aGVyZSBpZD0iLi4iOwoKVGhl IGFib3ZlIHdvdWxkIGRlbGV0ZSBhbGwgZ2x1c3RlciB2b2x1bWUgaW5mb3JtYXRpb24gc3RvcmVk IGluIHRoZSBkYi4KCkNsdXN0ZXIgaW5mb3JtYXRpb24gaXMgc3RvcmVkIGluIHZkc19ncm91cHMg dGFibGUuCgpZb3Ugc2hvdWxkIGhhdmUgYmVlbiBhYmxlIHRvIHJlbW92ZSB0aGUgaG9zdCB1c2lu ZyAiRm9yY2UiIG9wdGlvbi4gCkRpZG4ndCB0aGF0IHdvcmsgZm9yIHlvdS4gSSB3b3VsZCBiZSBp bnRlcmVzdGVkIHRvIHNlZSB0aGUgbG9ncyBpZiBpdCAKZGlkIG5vdC4KCnRoYW5rcwpzYWhpbmEK PiBJJ2xsIHRyeSBJUkMgYWxzbyB0byBzZWUgaWYgc29tZW9uZSBjYW4gZ2l2ZSBtZSBhIGhhbmQu Cj4gUmVnYXJkcywKPgo+Cj4KPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fXwo+IFVzZXJzIG1haWxpbmcgbGlzdAo+IFVzZXJzQG92aXJ0Lm9yZwo+IGh0dHA6 Ly9saXN0cy5vdmlydC5vcmcvbWFpbG1hbi9saXN0aW5mby91c2VycwoKCi0tLS0tLS0tLS0tLS0t MDkwMDAwMDIwNTA3MDEwOTAyMDQwOTA3CkNvbnRlbnQtVHlwZTogdGV4dC9odG1sOyBjaGFyc2V0 PUlTTy04ODU5LTEKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzogN2JpdAoKPGh0bWw+CiAgPGhl YWQ+CiAgICA8bWV0YSBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9SVNPLTg4NTktMSIKICAg ICAgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIj4KICA8L2hlYWQ+CiAgPGJvZHkgYmdjb2xvcj0i I0ZGRkZGRiIgdGV4dD0iIzAwMDAwMCI+CiAgICA8YnI+CiAgICA8ZGl2IGNsYXNzPSJtb3otY2l0 ZS1wcmVmaXgiPk9uIDAxLzMxLzIwMTQgMDQ6NDkgUE0sIEp1YW4gUGFibG8KICAgICAgTG9yaWVy IHdyb3RlOjxicj4KICAgIDwvZGl2PgogICAgPGJsb2NrcXVvdGUgY2l0ZT0ibWlkOjUyRUI4NkFC LjcwMjA5MDhAZ21haWwuY29tIiB0eXBlPSJjaXRlIj4KICAgICAgPHByZSB3cmFwPSIiPkhpLAoK SSdtIGFib3V0IHRvIGhhY2sgZW5naW5lIGRiIHRvIHJlbW92ZSBhIGdsdXN0ZXIgdm9sdW1lIGFu ZCBJJ2QgbGlrZQpzb21lb25lIHRvIGFkdmlzZSBtZSBvbiB0aGlzLiBUaGUgZW52aXJvbm1lbnQg aXMgaW4gcHJvZHVjdGlvbiwgSSd2ZQpiYWNrZWQgdXAgdGhlIGRiIGFuZCBJJ20gcGxhbm5pbmcg dG8gcmVtb3ZlIGV2ZXJ5IGVudHJ5IEkgY2FuIGZpbmQgb2YKdGhlIHZvbHVtZSAoaG9zdCBtZW1i ZXJzLCBjbHVzdGVyLCBldGMpIGJ1dCBJIGZvdW5kIHRoYXQgdGhlcmUncyBubwpjbHVzdGVycyB0 YWJsZSAoYW5kIEkgbmVlZCB0byByZW1vdmUgYSBjbHVzdGVyIHRoYXQgbm8gbG9uZ2VyIGV4aXN0 cwphZnRlciBhIGZvcmNlIHJlbW92ZSBvZiB0aGUgREMgYnV0IHNvbWVob3cgdGhlIHZvbHVtZSBz dGlsbCBpcyBhdHRhY2hlZAp0byBpdCkuPC9wcmU+CiAgICA8L2Jsb2NrcXVvdGU+CiAgICA8YnI+ CiAgICBkZWxldGUgZnJvbSBnbHVzdGVyX3ZvbHVtZV9icmlja3Mgd2hlcmUgdm9sdW1lX2lkID0g Ii4uIjs8YnI+CiAgICBkZWxldGUgZnJvbSBnbHVzdGVyX3ZvbHVtZV9vcHRpb25zIHdoZXJlIHZv bHVtZV9pZCA9ICIuLiI7PGJyPgogICAgZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVfdHJhbnNw b3J0X3R5cGVzIHdoZXJlIHZvbHVtZV9pZD0iLi4iOzxicj4KICAgIGRlbGV0ZSBmcm9tIGdsdXN0 ZXJfdm9sdW1lX2FjY2Vzc19wcm90b2NvbHMgd2hlcmUgdm9sdW1lX2lkPSIuLiI7PGJyPgogICAg ZGVsZXRlIGZyb20gZ2x1c3Rlcl92b2x1bWVzIHdoZXJlIGlkPSIuLiI7PGJyPgogICAgPGJyPgog ICAgVGhlIGFib3ZlIHdvdWxkIGRlbGV0ZSBhbGwgZ2x1c3RlciB2b2x1bWUgaW5mb3JtYXRpb24g c3RvcmVkIGluIHRoZQogICAgZGIuPGJyPgogICAgPGJyPgogICAgQ2x1c3RlciBpbmZvcm1hdGlv biBpcyBzdG9yZWQgaW4gdmRzX2dyb3VwcyB0YWJsZS48YnI+CiAgICA8YnI+CiAgICBZb3Ugc2hv dWxkIGhhdmUgYmVlbiBhYmxlIHRvIHJlbW92ZSB0aGUgaG9zdCB1c2luZyAiRm9yY2UiIG9wdGlv bi4KICAgIERpZG4ndCB0aGF0IHdvcmsgZm9yIHlvdS4gSSB3b3VsZCBiZSBpbnRlcmVzdGVkIHRv IHNlZSB0aGUgbG9ncyBpZgogICAgaXQgZGlkIG5vdC48YnI+CiAgICA8YnI+CiAgICB0aGFua3M8 YnI+CiAgICBzYWhpbmE8YnI+CiAgICA8YmxvY2txdW90ZSBjaXRlPSJtaWQ6NTJFQjg2QUIuNzAy MDkwOEBnbWFpbC5jb20iIHR5cGU9ImNpdGUiPgogICAgICA8cHJlIHdyYXA9IiI+CkknbGwgdHJ5 IElSQyBhbHNvIHRvIHNlZSBpZiBzb21lb25lIGNhbiBnaXZlIG1lIGEgaGFuZC4KUmVnYXJkcywK CjwvcHJlPgogICAgICA8YnI+CiAgICAgIDxmaWVsZHNldCBjbGFzcz0ibWltZUF0dGFjaG1lbnRI ZWFkZXIiPjwvZmllbGRzZXQ+CiAgICAgIDxicj4KICAgICAgPHByZSB3cmFwPSIiPl9fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fClVzZXJzIG1haWxpbmcgbGlz dAo8YSBjbGFzcz0ibW96LXR4dC1saW5rLWFiYnJldmlhdGVkIiBocmVmPSJtYWlsdG86VXNlcnNA b3ZpcnQub3JnIj5Vc2Vyc0BvdmlydC5vcmc8L2E+CjxhIGNsYXNzPSJtb3otdHh0LWxpbmstZnJl ZXRleHQiIGhyZWY9Imh0dHA6Ly9saXN0cy5vdmlydC5vcmcvbWFpbG1hbi9saXN0aW5mby91c2Vy cyI+aHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzPC9hPgo8L3By ZT4KICAgIDwvYmxvY2txdW90ZT4KICAgIDxicj4KICA8L2JvZHk+CjwvaHRtbD4KCi0tLS0tLS0t LS0tLS0tMDkwMDAwMDIwNTA3MDEwOTAyMDQwOTA3LS0K --===============7518686841414712814==--