Re: [Users] [URGENT] hacking the DB

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@ovirt.org> escribió:
Send Users mailing list submissions to users@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@ovirt.org
You can reach the person managing the list at users-owner@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@redhat.com> To: Alexandr <shuriku@shurik.kiev.ua>, users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <52ED3417.4050706@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@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@shurik.kiev.ua> To: Itamar Heim <iheim@redhat.com>, users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <52ED3554.8080205@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@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@redhat.com> To: Alexandr <shuriku@shurik.kiev.ua>, users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <52ED35E0.6000308@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_Virtua...
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@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@redhat.com> To: Itamar Heim <iheim@redhat.com> Cc: users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <1126371345.3012583.1391284622988.JavaMail.root@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@redhat.com> To: "Alexandr" <shuriku@shurik.kiev.ua>, users@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_Virtua...
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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
------------------------------
Message: 5 Date: Sat, 01 Feb 2014 22:58:22 +0200 From: Alexandr <shuriku@shurik.kiev.ua> To: Meital Bourvine <mbourvin@redhat.com>, Itamar Heim <iheim@redhat.com> Cc: users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <52ED5FEE.7090402@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@redhat.com> To: "Alexandr" <shuriku@shurik.kiev.ua>, users@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_Virtua...
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@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@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/attachm...
------------------------------
Message: 6 Date: Sat, 01 Feb 2014 22:12:56 +0100 From: Itamar Heim <iheim@redhat.com> To: Alexandr <shuriku@shurik.kiev.ua>, Meital Bourvine <mbourvin@redhat.com> Cc: users@ovirt.org Subject: Re: [Users] Reattach storage domain Message-ID: <52ED6358.7060203@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@redhat.com> To: "Alexandr"<shuriku@shurik.kiev.ua>,users@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_Virtua...
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@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@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@redhat.com> To: Juan Pablo Lorier <jplorier@gmail.com> Cc: users <users@ovirt.org> Subject: Re: [Users] [URGENT] hacking the DB Message-ID: <1814059864.10645949.1391289217257.JavaMail.root@redhat.com> Content-Type: text/plain; charset=utf-8
----- Original Message -----
From: "Juan Pablo Lorier" <jplorier@gmail.com> To: "Sahina Bose" <sabose@redhat.com>, "users" <users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
------------------------------
Message: 8 Date: Sat, 1 Feb 2014 22:09:51 +0000 From: Dan Kenigsberg <danken@redhat.com> To: Matt Warren <mwarren@hnw.com> Cc: "users@ovirt.org" <users@ovirt.org> Subject: Re: [Users] Host x is installed with VDSM version (<UNKNOWN>) Message-ID: <20140201220951.GI9811@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
End of Users Digest, Vol 29, Issue 4 ************************************
participants (1)
-
jplorier@gmail.com