[Users] [URGENT] hacking the DB
jplorier at gmail.com
jplorier at gmail.com
Sun Feb 2 11:21:27 UTC 2014
Hi Eli,
Thanks for the reply. My first measure was to backup the db. I have
managed to clean up the mess and as soon as I get the time, I'll send the
data so you can figure out what went wrong. I'll also try to post my
findings on several matters.
I thank you all for the fast help to get this problem fixed so I can get to
my dead line.
Regards,
El 01/02/2014 20:10, <users-request at ovirt.org> escribió:
> Send Users mailing list submissions to
> users at ovirt.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.ovirt.org/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
> users-request at ovirt.org
>
> You can reach the person managing the list at
> users-owner at ovirt.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
> 1. Re: Reattach storage domain (Itamar Heim)
> 2. Re: Reattach storage domain (Alexandr)
> 3. Re: Reattach storage domain (Itamar Heim)
> 4. Re: Reattach storage domain (Meital Bourvine)
> 5. Re: Reattach storage domain (Alexandr)
> 6. Re: Reattach storage domain (Itamar Heim)
> 7. Re: [URGENT] hacking the DB (Eli Mesika)
> 8. Re: Host x is installed with VDSM version (<UNKNOWN>)
> (Dan Kenigsberg)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 01 Feb 2014 18:51:19 +0100
> From: Itamar Heim <iheim at redhat.com>
> To: Alexandr <shuriku at shurik.kiev.ua>, users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID: <52ED3417.4050706 at redhat.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 02/01/2014 06:38 PM, Alexandr wrote:
> > Hello!
> >
> > Unfortunately my master storage domain (gluster) is dead. I setup
> > another gluster-storage and attach it to the ovirt. Hostname, path and
> > volume name are same as old ones. Then I restored from tar archive all
> > files. But I cannot activate master domain, operation failed and domain
> > status remains "inactive". I see - it mounted on nodes:
> >
> > vms02.lis.ua:STORAGE on /rhev/data-center/mnt/glusterSD/vms02.lis.ua:
> STORAGE
> >
> > I attached engine.log, can someone provide me recovery steps?
> >
> > P.S. Sorry for my english
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
> the right way to do this would be to restore it not via engine, then use
> the rest api to edit the storage domain connection (mount) in the engine.
>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 01 Feb 2014 19:56:36 +0200
> From: Alexandr <shuriku at shurik.kiev.ua>
> To: Itamar Heim <iheim at redhat.com>, users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID: <52ED3554.8080205 at shurik.kiev.ua>
> Content-Type: text/plain; charset=UTF-8
>
> Thank you. Can you provide me more detailed steps, I'm not familiar with
> rest api :(
>
> 01.02.2014 19:51, Itamar Heim ?????:
> > On 02/01/2014 06:38 PM, Alexandr wrote:
> >> Hello!
> >>
> >> Unfortunately my master storage domain (gluster) is dead. I setup
> >> another gluster-storage and attach it to the ovirt. Hostname, path and
> >> volume name are same as old ones. Then I restored from tar archive all
> >> files. But I cannot activate master domain, operation failed and domain
> >> status remains "inactive". I see - it mounted on nodes:
> >>
> >> vms02.lis.ua:STORAGE on
> >> /rhev/data-center/mnt/glusterSD/vms02.lis.ua:STORAGE
> >>
> >> I attached engine.log, can someone provide me recovery steps?
> >>
> >> P.S. Sorry for my english
> >>
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> >
> > the right way to do this would be to restore it not via engine, then
> > use the rest api to edit the storage domain connection (mount) in the
> > engine.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 01 Feb 2014 18:58:56 +0100
> From: Itamar Heim <iheim at redhat.com>
> To: Alexandr <shuriku at shurik.kiev.ua>, users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID: <52ED35E0.6000308 at redhat.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 02/01/2014 06:56 PM, Alexandr wrote:
> > Thank you. Can you provide me more detailed steps, I'm not familiar with
> > rest api :(
>
> sorry i can't give more details right now:
> manage connection details:
> http://www.ovirt.org/Features/Manage_Storage_Connections
>
> rest api (and other things):
>
> https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html-single/Developer_Guide/index.html
>
>
> >
> > 01.02.2014 19:51, Itamar Heim ?????:
> >> On 02/01/2014 06:38 PM, Alexandr wrote:
> >>> Hello!
> >>>
> >>> Unfortunately my master storage domain (gluster) is dead. I setup
> >>> another gluster-storage and attach it to the ovirt. Hostname, path and
> >>> volume name are same as old ones. Then I restored from tar archive all
> >>> files. But I cannot activate master domain, operation failed and domain
> >>> status remains "inactive". I see - it mounted on nodes:
> >>>
> >>> vms02.lis.ua:STORAGE on
> >>> /rhev/data-center/mnt/glusterSD/vms02.lis.ua:STORAGE
> >>>
> >>> I attached engine.log, can someone provide me recovery steps?
> >>>
> >>> P.S. Sorry for my english
> >>>
> >>>
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at ovirt.org
> >>> http://lists.ovirt.org/mailman/listinfo/users
> >>>
> >>
> >> the right way to do this would be to restore it not via engine, then
> >> use the rest api to edit the storage domain connection (mount) in the
> >> engine.
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 1 Feb 2014 14:57:02 -0500 (EST)
> From: Meital Bourvine <mbourvin at redhat.com>
> To: Itamar Heim <iheim at redhat.com>
> Cc: users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID:
> <1126371345.3012583.1391284622988.JavaMail.root at redhat.com>
> Content-Type: text/plain; charset=utf-8
>
> I think that it should be something like this:
>
> Method: PUT
>
> URL: https://<IP>/api/storageconnections/<ID>
>
> Body:
> <storage_connection>
> <address></address>
> <type></type>
> <port></port>
> <target></target>
> </storage_connection>
>
> (Add the correct details to the body.
>
> ----- Original Message -----
> > From: "Itamar Heim" <iheim at redhat.com>
> > To: "Alexandr" <shuriku at shurik.kiev.ua>, users at ovirt.org
> > Sent: Saturday, February 1, 2014 7:58:56 PM
> > Subject: Re: [Users] Reattach storage domain
> >
> > On 02/01/2014 06:56 PM, Alexandr wrote:
> > > Thank you. Can you provide me more detailed steps, I'm not familiar
> with
> > > rest api :(
> >
> > sorry i can't give more details right now:
> > manage connection details:
> > http://www.ovirt.org/Features/Manage_Storage_Connections
> >
> > rest api (and other things):
> >
> https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html-single/Developer_Guide/index.html
> >
> >
> > >
> > > 01.02.2014 19:51, Itamar Heim ?????:
> > >> On 02/01/2014 06:38 PM, Alexandr wrote:
> > >>> Hello!
> > >>>
> > >>> Unfortunately my master storage domain (gluster) is dead. I setup
> > >>> another gluster-storage and attach it to the ovirt. Hostname, path
> and
> > >>> volume name are same as old ones. Then I restored from tar archive
> all
> > >>> files. But I cannot activate master domain, operation failed and
> domain
> > >>> status remains "inactive". I see - it mounted on nodes:
> > >>>
> > >>> vms02.lis.ua:STORAGE on
> > >>> /rhev/data-center/mnt/glusterSD/vms02.lis.ua:STORAGE
> > >>>
> > >>> I attached engine.log, can someone provide me recovery steps?
> > >>>
> > >>> P.S. Sorry for my english
> > >>>
> > >>>
> > >>> _______________________________________________
> > >>> Users mailing list
> > >>> Users at ovirt.org
> > >>> http://lists.ovirt.org/mailman/listinfo/users
> > >>>
> > >>
> > >> the right way to do this would be to restore it not via engine, then
> > >> use the rest api to edit the storage domain connection (mount) in the
> > >> engine.
> > >
> >
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 01 Feb 2014 22:58:22 +0200
> From: Alexandr <shuriku at shurik.kiev.ua>
> To: Meital Bourvine <mbourvin at redhat.com>, Itamar Heim
> <iheim at redhat.com>
> Cc: users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID: <52ED5FEE.7090402 at shurik.kiev.ua>
> Content-Type: text/plain; charset="utf-8"
>
> 01.02.2014 21:57, Meital Bourvine ?????:
> > I think that it should be something like this:
> >
> > Method: PUT
> >
> > URL: https://<IP>/api/storageconnections/<ID>
> >
> > Body:
> > <storage_connection>
> > <address></address>
> > <type></type>
> > <port></port>
> > <target></target>
> > </storage_connection>
> >
> > (Add the correct details to the body.
> >
> > ----- Original Message -----
> >> From: "Itamar Heim" <iheim at redhat.com>
> >> To: "Alexandr" <shuriku at shurik.kiev.ua>, users at ovirt.org
> >> Sent: Saturday, February 1, 2014 7:58:56 PM
> >> Subject: Re: [Users] Reattach storage domain
> >>
> >> On 02/01/2014 06:56 PM, Alexandr wrote:
> >>> Thank you. Can you provide me more detailed steps, I'm not familiar
> with
> >>> rest api :(
> >> sorry i can't give more details right now:
> >> manage connection details:
> >> http://www.ovirt.org/Features/Manage_Storage_Connections
> >>
> >> rest api (and other things):
> >>
> https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html-single/Developer_Guide/index.html
> >>
> >>
> >>> 01.02.2014 19:51, Itamar Heim ?????:
> >>>> On 02/01/2014 06:38 PM, Alexandr wrote:
> >>>>> Hello!
> >>>>>
> >>>>> Unfortunately my master storage domain (gluster) is dead. I setup
> >>>>> another gluster-storage and attach it to the ovirt. Hostname, path
> and
> >>>>> volume name are same as old ones. Then I restored from tar archive
> all
> >>>>> files. But I cannot activate master domain, operation failed and
> domain
> >>>>> status remains "inactive". I see - it mounted on nodes:
> >>>>>
> >>>>> vms02.lis.ua:STORAGE on
> >>>>> /rhev/data-center/mnt/glusterSD/vms02.lis.ua:STORAGE
> >>>>> a
> >>>>> I attached engine.log, can someone provide me recovery steps?
> >>>>>
> >>>>> P.S. Sorry for my english
> >>>>>
> >>>>>
> >>>>> _______________________________________________
> >>>>> Users mailing list
> >>>>> Users at ovirt.org
> >>>>> http://lists.ovirt.org/mailman/listinfo/users
> >>>>>
> >>>> the right way to do this would be to restore it not via engine, then
> >>>> use the rest api to edit the storage domain connection (mount) in the
> >>>> engine.
> >> _______________________________________________
> >> Users mailing list
> >> Users at ovirt.org
> >> http://lists.ovirt.org/mailman/listinfo/users
> >>
> I tried to change it via ovirt-shell and receive an error:
>
> [oVirt shell (connected)]# update storageconnection
> 4a1d8b07-f393-4134-86cc-4f46145cca2b --address vms02.lis.ua --path STORAGE
>
> error:
> status: 400
> reason: Bad Request
> detail: Cannot edit Storage Connection. Storage connection parameters
> can be edited only for NFS, Posix, local or iSCSI data domains.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.ovirt.org/pipermail/users/attachments/20140201/7c4ad39f/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 6
> Date: Sat, 01 Feb 2014 22:12:56 +0100
> From: Itamar Heim <iheim at redhat.com>
> To: Alexandr <shuriku at shurik.kiev.ua>, Meital Bourvine
> <mbourvin at redhat.com>
> Cc: users at ovirt.org
> Subject: Re: [Users] Reattach storage domain
> Message-ID: <52ED6358.7060203 at redhat.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 02/01/2014 09:58 PM, Alexandr wrote:
> > 01.02.2014 21:57, Meital Bourvine ?????:
> >> I think that it should be something like this:
> >>
> >> Method: PUT
> >>
> >> URL:https://<IP>/api/storageconnections/<ID>
> >>
> >> Body:
> >> <storage_connection>
> >> <address></address>
> >> <type></type>
> >> <port></port>
> >> <target></target>
> >> </storage_connection>
> >>
> >> (Add the correct details to the body.
> >>
> >> ----- Original Message -----
> >>> From: "Itamar Heim"<iheim at redhat.com>
> >>> To: "Alexandr"<shuriku at shurik.kiev.ua>,users at ovirt.org
> >>> Sent: Saturday, February 1, 2014 7:58:56 PM
> >>> Subject: Re: [Users] Reattach storage domain
> >>>
> >>> On 02/01/2014 06:56 PM, Alexandr wrote:
> >>>> Thank you. Can you provide me more detailed steps, I'm not familiar
> with
> >>>> rest api :(
> >>> sorry i can't give more details right now:
> >>> manage connection details:
> >>> http://www.ovirt.org/Features/Manage_Storage_Connections
> >>>
> >>> rest api (and other things):
> >>>
> https://access.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html-single/Developer_Guide/index.html
> >>>
> >>>
> >>>> 01.02.2014 19:51, Itamar Heim ?????:
> >>>>> On 02/01/2014 06:38 PM, Alexandr wrote:
> >>>>>> Hello!
> >>>>>>
> >>>>>> Unfortunately my master storage domain (gluster) is dead. I setup
> >>>>>> another gluster-storage and attach it to the ovirt. Hostname, path
> and
> >>>>>> volume name are same as old ones. Then I restored from tar archive
> all
> >>>>>> files. But I cannot activate master domain, operation failed and
> domain
> >>>>>> status remains "inactive". I see - it mounted on nodes:
> >>>>>>
> >>>>>> vms02.lis.ua:STORAGE on
> >>>>>> /rhev/data-center/mnt/glusterSD/vms02.lis.ua:STORAGE
> >>>>>> a
> >>>>>> I attached engine.log, can someone provide me recovery steps?
> >>>>>>
> >>>>>> P.S. Sorry for my english
> >>>>>>
> >>>>>>
> >>>>>> _______________________________________________
> >>>>>> Users mailing list
> >>>>>> Users at ovirt.org
> >>>>>> http://lists.ovirt.org/mailman/listinfo/users
> >>>>>>
> >>>>> the right way to do this would be to restore it not via engine, then
> >>>>> use the rest api to edit the storage domain connection (mount) in the
> >>>>> engine.
> >>> _______________________________________________
> >>> Users mailing list
> >>> Users at ovirt.org
> >>> http://lists.ovirt.org/mailman/listinfo/users
> >>>
> > I tried to change it via ovirt-shell and receive an error:
> >
> > [oVirt shell (connected)]# update storageconnection
> > 4a1d8b07-f393-4134-86cc-4f46145cca2b --address vms02.lis.ua --path
> STORAGE
> >
> > error:
> > status: 400
> > reason: Bad Request
> > detail: Cannot edit Storage Connection. Storage connection parameters
> > can be edited only for NFS, Posix, local or iSCSI data domains.
>
> alisa/derez - any reason we don't support edit connection for gluster sd?
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 1 Feb 2014 16:13:37 -0500 (EST)
> From: Eli Mesika <emesika at redhat.com>
> To: Juan Pablo Lorier <jplorier at gmail.com>
> Cc: users <users at ovirt.org>
> Subject: Re: [Users] [URGENT] hacking the DB
> Message-ID:
> <1814059864.10645949.1391289217257.JavaMail.root at redhat.com>
> Content-Type: text/plain; charset=utf-8
>
>
>
> ----- Original Message -----
> > From: "Juan Pablo Lorier" <jplorier at gmail.com>
> > To: "Sahina Bose" <sabose at redhat.com>, "users" <users at 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 at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 8
> Date: Sat, 1 Feb 2014 22:09:51 +0000
> From: Dan Kenigsberg <danken at redhat.com>
> To: Matt Warren <mwarren at hnw.com>
> Cc: "users at ovirt.org" <users at ovirt.org>
> Subject: Re: [Users] Host x is installed with VDSM version (<UNKNOWN>)
> Message-ID: <20140201220951.GI9811 at redhat.com>
> Content-Type: text/plain; charset=us-ascii
>
> On Fri, Jan 31, 2014 at 01:26:20PM -0500, Matt Warren wrote:
> > Any troubleshooting ideas for vdsm reporting UNKNONW version when it's
> > clearly 4.13 installed?
> >
> > >>> Host x is installed with VDSM version (<UNKNOWN>) and cannot join
> > >>>cluster Default which is compatible with VDSM versions [4.13, 4.9,
> 4.11,
> > >>>4.12, 4.10].
> > >>>In reading some google searches, suggestion was to first run
> "vdsClient
> > >>>-s 0 getVdsCaps". This returns "Failed to initialize storage" for any
> > >>>vdsClient command.
>
> Engine cannot tell which Vdsm is install, since there's a serious
> problem there - so serious that Vdsm cannot report its own version.
>
> Could you restart Vdsm and follow vdsm.log and supervdsm.log for hints
> on why does the storage subsystem fail to start?
>
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
> End of Users Digest, Vol 29, Issue 4
> ************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140202/7c36b989/attachment-0001.html>
More information about the Users
mailing list