6:19 a.m.
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--5U5vHVe2c4gErPcwPMiguIxge1AAH6cqN
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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).
I'll try IRC also to see if someone can give me a hand.
Regards,
--5U5vHVe2c4gErPcwPMiguIxge1AAH6cqN
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQEcBAEBAgAGBQJS64asAAoJEC5KDDg2+NMM9oIH/3i/XzV0VPnCS0TgrxiPY1Ik
AxK7MRt6hWCC1ZERZfJ0pURfd3MIzd4u08+Wy5NQaH2PWNGn4bTd8FxidaxqjJuU
a8JR6EuL5H91DDzoj4kaXxwg2kIKcjMT7CNnLnrR5AT7cYhB3ArqOE9qzqXXKY0j
G7ZtPg7+4H2qYbmALo6GnH9/Bd1RXDhNE2v2LPf/0/7xvkSW//e4YDm3Cf1P0sxs
gCz30sAvBvdplqRHWmHHMqD1CKpj+JVbwWujqmTh3PBqGasRgmqcXeY4Hr41VsZX
r9OJYtQodW7f+Qq2qMn46OlOLCTD69ONwqBs1h7pG5PTRp9thU+ZOQcAGd4GjUY=
=PjE8
-----END PGP SIGNATURE-----
--5U5vHVe2c4gErPcwPMiguIxge1AAH6cqN--
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--
6:50 a.m.
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT
Content-Type: multipart/alternative;
boundary="------------070802080601040009010105"
This is a multi-part message in MIME format.
--------------070802080601040009010105
Content-Type: text/plain; charset=ISO-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=
d
> 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
--------------070802080601040009010105
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta content=3D"text/html; charset=3DISO-8859-1"
http-equiv=3D"Content-Type">
</head>
<body text=3D"#000000" bgcolor=3D"#FFFFFF">
Thanks Sahina!!<br>
<br>
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.<br>
Regards,<br>
<br>
<div class=3D"moz-cite-prefix">On 31/01/14 09:35, Sahina Bose
wrote:<=
br>
</div>
<blockquote cite=3D"mid:52EB8A81.8030105@redhat.com"
type=3D"cite">
<meta content=3D"text/html; charset=3DISO-8859-1"
http-equiv=3D"Content-Type">
<br>
<div class=3D"moz-cite-prefix">On 01/31/2014 04:49 PM, Juan Pablo
Lorier wrote:<br>
</div>
<blockquote cite=3D"mid:52EB86AB.7020908@gmail.com"
type=3D"cite">
<pre wrap=3D"">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 =3D "..";<br>
delete from gluster_volume_options where volume_id =3D "..";<br>
delete from gluster_volume_transport_types where volume_id=3D"..";<=
br>
delete from gluster_volume_access_protocols where volume_id=3D"..";=
<br>
delete from gluster_volumes where id=3D"..";<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=3D"mid:52EB86AB.7020908@gmail.com"
type=3D"cite">
<pre wrap=3D"">I'll try IRC also to see if someone can give me
a =
hand.
Regards,
</pre>
<br>
<fieldset class=3D"mimeAttachmentHeader"></fieldset>
<br>
<pre wrap=3D"">_______________________________________________
Users mailing list
<a moz-do-not-send=3D"true" class=3D"moz-txt-link-abbreviated"
href=3D"ma=
ilto:Users@ovirt.org">Users@ovirt.org</a>
<a moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext"
href=3D"http:=
//lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/=
listinfo/users</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>
--------------070802080601040009010105--
--EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="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=
=sohr
-----END PGP SIGNATURE-----
--EnH4WVI8j3jdpIrw2R3swDSqAbxkfFgmT--
7:19 a.m.
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--8G5pNcxcMVOgGKxrIa8rhoI0HPAmd3bXT
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hi again,
I'm now in the process of deleting the removed cluster from the hosts. I
can't just delete it from vds_groups as is a external key to vds_static,
and it looks like vds_static has the hosts definition.
Can I safely update the vds_group_id to ' ' in the hosts to "detach"
them from the cluster?
Regards,
On 31/01/14 09:35, Sahina Bose wrote:
delete from gluster_volume_bricks where volume_id =3D "
--8G5pNcxcMVOgGKxrIa8rhoI0HPAmd3bXT
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQEcBAEBAgAGBQJS65S4AAoJEC5KDDg2+NMMFGsH/AkCT/MA5/UMgxvxVMxfZ83T
vEd45QNCo02kmupQ3td+d9q7M1zlbf17V7tVsj0l8Pffy+DaSd1sheOsGF106EwB
gXxmylJOXSu5ouTPYy8I5bOe4u1HL5dsgzJW6USuDuB9MYgLRejy43EYpXThC5uR
vryjcG3XENzaIcIcmu36MHuutUouTl0qZVlRItI/1dRlMnhCA4A3FdgjF8/0diaR
G860MAoAaiexMV5yv3RMK5vS8upSdfvbDINKPEYaUekOdGeGsTrShUTIBWZoz208
7D0qUd7Z5lklJtusFNSG9tUM5D9coC/oU5CMUTfEM+m8ZziEus8dEmqwaGlyzwU=
=L4aX
-----END PGP SIGNATURE-----
--8G5pNcxcMVOgGKxrIa8rhoI0HPAmd3bXT--
8:30 a.m.
On 01/31/2014 05:49 PM, Juan Pablo Lorier wrote:
Hi again,
I'm now in the process of deleting the removed cluster from the hosts. I
can't just delete it from vds_groups as is a external key to vds_static,
and it looks like vds_static has the hosts definition.
Can I safely update the vds_group_id to ' ' in the hosts to "detach"
them from the cluster?
Regards,
I think it would be safer to remove the host and then remove the cluster.
You would have to remove the host entry from vds_static as well as
vds_dynamic.
On 31/01/14 09:35, Sahina Bose wrote:
> delete from gluster_volume_bricks where volume_id = "
9:18 a.m.
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--nANwCoX7ooC1chHpEmkG6j6uKFFLvA46X
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
It also has a foreign key at vds_statistics,
Thanks for everything, I'll keep you updated on this matter.
Regards,
On 31/01/14 11:30, Sahina Bose wrote:
On 01/31/2014 05:49 PM, Juan Pablo Lorier wrote:
> Hi again,
>
> I'm now in the process of deleting the removed cluster from the hosts.=
I
> can't just delete it from vds_groups as is a external key to
vds_stati=
c,
> and it looks like vds_static has the hosts definition.
> Can I safely update the vds_group_id to ' ' in the hosts to
"detach"
> them from the cluster?
> Regards,
I think it would be safer to remove the host and then remove the cluste=
r.
You would have to remove the host entry from vds_static as well as
vds_dynamic.
>
> On 31/01/14 09:35, Sahina Bose wrote:
>> delete from gluster_volume_bricks where volume_id =3D "
>
--nANwCoX7ooC1chHpEmkG6j6uKFFLvA46X
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iQEcBAEBAgAGBQJS67DHAAoJEC5KDDg2+NMM9/gH/jrqOoIywzDs0+lpPEI1z609
VdFgfl7MO+UIwsrr4T1/GI7qBjkIptxH2DydX5LKAkghDYXoT+kYVhEWLAPc2ZRz
aVMOjKuDGxYws1GArdT5/1KKYCjlNQpkNZbONxa/2gZvEhw9D1WDFrtXkUEuYCh9
61lEoKWq8o0HXRAuVSTsSY/wvMemtNlu2OWyKRzx/VJ4C38oUQjNcw9W+AGPS/wh
q8dO7l+hDsM+87Lf6QV/k96eMM0jIeKZklYuMeSE24GffMhZA/2lHHUm3FPdTLhF
1ytj/QEpcWUusf4SvZ+NaOhhfKNCs8E8DIe5zM+WCoX5qSCCI6KGoMaVMiIML1A=
=tg5Y
-----END PGP SIGNATURE-----
--nANwCoX7ooC1chHpEmkG6j6uKFFLvA46X--
4:13 p.m.
----- Original Message -----
From: "Juan Pablo Lorier" <jplorier(a)gmail.com>
To: "Sahina Bose" <sabose(a)redhat.com>, "users"
<users(a)ovirt.org>
Sent: Friday, January 31, 2014 4:18:47 PM
Subject: Re: [Users] [URGENT] hacking the DB
It also has a foreign key at vds_statistics,
Thanks for everything, I'll keep you updated on this matter.
Regards,
Hi Juan
First of all let me recommend to backup your DB before playing with it.
My second comment is that this should not occur in the first place so if you removed
something and have leftovers that you been forced to delete manually it is certainly a bug
and I will appreciate if you can open one , describe the scenario and attach the relevant
logs
Thanks
Eli
On 31/01/14 11:30, Sahina Bose wrote:
>
> On 01/31/2014 05:49 PM, Juan Pablo Lorier wrote:
>> Hi again,
>>
>> I'm now in the process of deleting the removed cluster from the hosts. I
>> can't just delete it from vds_groups as is a external key to vds_static,
>> and it looks like vds_static has the hosts definition.
>> Can I safely update the vds_group_id to ' ' in the hosts to
"detach"
>> them from the cluster?
>> Regards,
>
> I think it would be safer to remove the host and then remove the cluster.
> You would have to remove the host entry from vds_static as well as
> vds_dynamic.
>
>>
>> On 31/01/14 09:35, Sahina Bose wrote:
>>> delete from gluster_volume_bricks where volume_id = "
>>
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
3982
days inactive
3983
days old
6 comments
3 participants
participants (3)
-
Eli Mesika -
Juan Pablo Lorier -
Sahina Bose