[Users] hacking at the ovirt db howto?
Hi All -- I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this? Thanks, Jason --- Jason Brooks Red Hat Open Source and Standards @jasonbrooks | @redhatopen http://community.redhat.com
Useful information can be found in: http://www.ovirt.org/OVirt-DB-Issues Also, some useful commands appear in different wiki pages in the ovirt.org wiki. Just search for psql. Hope it helps, Oved ----- Original Message -----
From: "Jason Brooks" <jbrooks@redhat.com> To: users@ovirt.org Sent: Thursday, October 17, 2013 7:02:35 AM Subject: [Users] hacking at the ovirt db howto?
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
Thanks, Jason
---
Jason Brooks Red Hat Open Source and Standards
@jasonbrooks | @redhatopen http://community.redhat.com
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On 10/17/2013 12:02 AM, Jason Brooks wrote:
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
I'd be interested to know when you need to hack it, which in most normal flows shouldn't be needed? thanks, Itamar
On Thu, 2013-10-17 at 03:31 -0400, Itamar Heim wrote:
On 10/17/2013 12:02 AM, Jason Brooks wrote:
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
I'd be interested to know when you need to hack it, which in most normal flows shouldn't be needed?
I was running oVirt 3.2 w/ POSIXFS storage and Gluster. After 3.3 came out, I exported a few VMs, and imported them into a GlusterFS domain on 3.3. After lots of trouble w/ that domain type, I exported the VMs again, blew away that GlusterFS data center, made a new POSIXFS data center, and went to re-import them. oVirt told me no, there were already disks in the system with these names, and I'd have to clone then instead. I went ahead and cloned, even though that's a bit less convenient, and required some config file fiddling to deal with the changed MAC address, but it's times like these when I feel a desire to crack the DB, if not to change things, then to figure out what ovirt thinks is happening. Jason
thanks, Itamar
On 10/17/2013 12:56 PM, Jason Brooks wrote:
On Thu, 2013-10-17 at 03:31 -0400, Itamar Heim wrote:
On 10/17/2013 12:02 AM, Jason Brooks wrote:
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
I'd be interested to know when you need to hack it, which in most normal flows shouldn't be needed?
I was running oVirt 3.2 w/ POSIXFS storage and Gluster. After 3.3 came out, I exported a few VMs, and imported them into a GlusterFS domain on 3.3. After lots of trouble w/ that domain type, I exported the VMs again, blew away that GlusterFS data center, made a new POSIXFS data center, and went to re-import them. oVirt told me no, there were already disks in the system with these names, and I'd have to clone then instead.
so sounds like a bug when you blew the DC the disks remained? maybe this one (should be in 3.3.1, beta real-soon-now) Bug 999048 - VM permissions entries remain in database after force deleting data-center
I went ahead and cloned, even though that's a bit less convenient, and required some config file fiddling to deal with the changed MAC address, but it's times like these when I feel a desire to crack the DB, if not to change things, then to figure out what ovirt thinks is happening.
Jason
thanks, Itamar
----- Original Message -----
From: "Jason Brooks" <jbrooks@redhat.com> To: users@ovirt.org Sent: Wednesday, October 16, 2013 9:02:35 PM Subject: hacking at the ovirt db howto?
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
For posterity, what I was missing was: su - postgres psql engine And then hack away. I've had to do a bunch of manual unlocking to allow me to remove VMs following failed snapshot operations.
Thanks, Jason
---
Jason Brooks Red Hat Open Source and Standards
@jasonbrooks | @redhatopen http://community.redhat.com
----- Original Message -----
From: "Jason Brooks" <jbrooks@redhat.com> To: users@ovirt.org Sent: Saturday, November 23, 2013 2:48:23 AM Subject: Re: [Users] hacking at the ovirt db howto?
----- Original Message -----
From: "Jason Brooks" <jbrooks@redhat.com> To: users@ovirt.org Sent: Wednesday, October 16, 2013 9:02:35 PM Subject: hacking at the ovirt db howto?
Hi All --
I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?
No, we didn't write such a wiki since if you got to hacking the DB , we have a bug and we want to know about it and fix it. Hacking the database should be done with care and with an assistant of one of the oVirt developers that knows the impacts of the requested fix. Please let me know if you have any specific issues and I will be glad to help. Thanks Eli
For posterity, what I was missing was:
su - postgres
psql engine
And then hack away. I've had to do a bunch of manual unlocking to allow me to remove VMs following failed snapshot operations.
Thanks, Jason
---
Jason Brooks Red Hat Open Source and Standards
@jasonbrooks | @redhatopen http://community.redhat.com
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (4)
-
Eli Mesika -
Itamar Heim -
Jason Brooks -
Oved Ourfalli