You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Matthew Midgett <cl...@trick-solutions.com.INVALID> on 2014/12/12 01:15:07 UTC
RE: How to remove VM entry from CloudStack database?
I have phpmyadmin running on my MariaDB server as I am no sql expert. Then is cloud > vm_instance and change the state be editing the row for the VM ID that you need to Stopped, Destroyed or Expunging
Not responsible for your actions :)
Matthew Midgett
Trick Solutions
143 Jenny Marie Rd
Mooresville NC,28115
336-618-7425 Office
704-728-5644 Cell
www.trick-solutions.com
CONFIDENTIAL: This electronic mail, including any attachment(s) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic email or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify me immediately by reply email so that I may correct my internal records. Please then delete the original message (including any attachments) in its entirety. Thank you.
-----Original Message-----
From: Tejas Sheth [mailto:tsheth.p@gmail.com]
Sent: Thursday, December 11, 2014 9:20 AM
To: users@cloudstack.apache.org
Subject: How to remove VM entry from cloudstack database?
Hello,
I was tring migrate vm to another cluster using storage migration option in Cloudstack 4.3.1.
unfortuanatly now it got stuck at migrating stage and don't know how to recover.
since it is test environment we can remove it from database.
Does anyone knows how to cleanup VM entry from cloudstack and its database?
Thanks,
Tejas
Re: How to remove VM entry from CloudStack database?
Posted by Tejas Sheth <ts...@gmail.com>.
Thanks John,
It worked
On Sat, Dec 13, 2014 at 3:59 AM, John Kinsella <jl...@stratosec.co> wrote:
>
> CloudStack doesn’t usually remove records from db tables. If you look t
> vm_instance (or many other tables in there) you’ll see three timestamp
> fields: created, update_time, and removed. So if you want to “remove” a
> vm/disk/nic/etc, you change the removed field from null to a timestamp, e.g.
>
> UPDATE vm_instance SET removed=now() WHERE id=105;
>
> John
>
> > On Dec 11, 2014, at 11:31 PM, Vadim Kimlaychuk <Va...@Elion.ee>
> wrote:
> >
> > Tejas,
> >
> > "Stopped" and "Destroyed" are "visible" statuses of VM at
> dashboard as well as "Expunding". You should put "Expunded" for the VM not
> to be visible. Entirely removing the raw in DB is not good option. CS does
> not ever remove data for VM-s being destroyed and expunded - they always
> remain at database.
> >
> > Vadim.
> >
> > -----Original Message-----
> > From: Tejas Sheth [mailto:tsheth.p@gmail.com]
> > Sent: Friday, December 12, 2014 9:01 AM
> > To: users@cloudstack.apache.org
> > Subject: Re: How to remove VM entry from CloudStack database?
> >
> > Hi,
> >
> > I have tried to change the vm_instance table state value to "Stopped"
> and "Destroied" but i was nither able to start nor destroy vm. so finally i
> removed entire row of that perticular VM and finally that VM was removed
> from instance deshboard.
> >
> > can anyone suggest that in order to complete cleanup activity do we need
> to delete any other entry from anyother table?
> >
> > Thanks,
> > Tejas
> >
> > On Fri, Dec 12, 2014 at 8:30 AM, Tejas Sheth <ts...@gmail.com> wrote:
> >>
> >> Hello,
> >>
> >> Its not in production so i can test the DB modification, Let me try
> >> to modify VM entry from vm_instance table and I'll let you guyz know
> >> the result.
> >>
> >> Thanks,
> >> Tejas
> >>
> >> On Fri, Dec 12, 2014 at 5:45 AM, Matthew Midgett <
> >> cloudstck@trick-solutions.com.invalid> wrote:
> >>
> >>> I have phpmyadmin running on my MariaDB server as I am no sql expert.
> >>> Then is cloud > vm_instance and change the state be editing the row
> >>> for the VM ID that you need to Stopped, Destroyed or Expunging
> >>>
> >>> Not responsible for your actions :)
> >>>
> >>> Matthew Midgett
> >>> Trick Solutions
> >>> 143 Jenny Marie Rd
> >>> Mooresville NC,28115
> >>> 336-618-7425 Office
> >>> 704-728-5644 Cell
> >>> www.trick-solutions.com
> >>>
> >>> CONFIDENTIAL: This electronic mail, including any attachment(s) may
> >>> contain information that is privileged, confidential, and/or
> >>> otherwise protected from disclosure to anyone other than its intended
> recipient(s).
> >>> Any dissemination or use of this electronic email or its contents
> >>> (including any attachments) by persons other than the intended
> >>> recipient(s) is strictly prohibited. If you have received this
> >>> message in error, please notify me immediately by reply email so that
> >>> I may correct my internal records. Please then delete the original
> >>> message (including any
> >>> attachments) in its entirety. Thank you.
> >>>
> >>>
> >>>
> >>> -----Original Message-----
> >>> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
> >>> Sent: Thursday, December 11, 2014 9:20 AM
> >>> To: users@cloudstack.apache.org
> >>> Subject: How to remove VM entry from cloudstack database?
> >>>
> >>> Hello,
> >>>
> >>> I was tring migrate vm to another cluster using storage migration
> >>> option in Cloudstack 4.3.1.
> >>> unfortuanatly now it got stuck at migrating stage and don't know how
> >>> to recover.
> >>>
> >>> since it is test environment we can remove it from database.
> >>> Does anyone knows how to cleanup VM entry from cloudstack and its
> >>> database?
> >>>
> >>> Thanks,
> >>> Tejas
> >>>
> >>>
> >>
>
>
Re: How to remove VM entry from CloudStack database?
Posted by John Kinsella <jl...@stratosec.co>.
CloudStack doesn’t usually remove records from db tables. If you look t vm_instance (or many other tables in there) you’ll see three timestamp fields: created, update_time, and removed. So if you want to “remove” a vm/disk/nic/etc, you change the removed field from null to a timestamp, e.g.
UPDATE vm_instance SET removed=now() WHERE id=105;
John
> On Dec 11, 2014, at 11:31 PM, Vadim Kimlaychuk <Va...@Elion.ee> wrote:
>
> Tejas,
>
> "Stopped" and "Destroyed" are "visible" statuses of VM at dashboard as well as "Expunding". You should put "Expunded" for the VM not to be visible. Entirely removing the raw in DB is not good option. CS does not ever remove data for VM-s being destroyed and expunded - they always remain at database.
>
> Vadim.
>
> -----Original Message-----
> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
> Sent: Friday, December 12, 2014 9:01 AM
> To: users@cloudstack.apache.org
> Subject: Re: How to remove VM entry from CloudStack database?
>
> Hi,
>
> I have tried to change the vm_instance table state value to "Stopped" and "Destroied" but i was nither able to start nor destroy vm. so finally i removed entire row of that perticular VM and finally that VM was removed from instance deshboard.
>
> can anyone suggest that in order to complete cleanup activity do we need to delete any other entry from anyother table?
>
> Thanks,
> Tejas
>
> On Fri, Dec 12, 2014 at 8:30 AM, Tejas Sheth <ts...@gmail.com> wrote:
>>
>> Hello,
>>
>> Its not in production so i can test the DB modification, Let me try
>> to modify VM entry from vm_instance table and I'll let you guyz know
>> the result.
>>
>> Thanks,
>> Tejas
>>
>> On Fri, Dec 12, 2014 at 5:45 AM, Matthew Midgett <
>> cloudstck@trick-solutions.com.invalid> wrote:
>>
>>> I have phpmyadmin running on my MariaDB server as I am no sql expert.
>>> Then is cloud > vm_instance and change the state be editing the row
>>> for the VM ID that you need to Stopped, Destroyed or Expunging
>>>
>>> Not responsible for your actions :)
>>>
>>> Matthew Midgett
>>> Trick Solutions
>>> 143 Jenny Marie Rd
>>> Mooresville NC,28115
>>> 336-618-7425 Office
>>> 704-728-5644 Cell
>>> www.trick-solutions.com
>>>
>>> CONFIDENTIAL: This electronic mail, including any attachment(s) may
>>> contain information that is privileged, confidential, and/or
>>> otherwise protected from disclosure to anyone other than its intended recipient(s).
>>> Any dissemination or use of this electronic email or its contents
>>> (including any attachments) by persons other than the intended
>>> recipient(s) is strictly prohibited. If you have received this
>>> message in error, please notify me immediately by reply email so that
>>> I may correct my internal records. Please then delete the original
>>> message (including any
>>> attachments) in its entirety. Thank you.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
>>> Sent: Thursday, December 11, 2014 9:20 AM
>>> To: users@cloudstack.apache.org
>>> Subject: How to remove VM entry from cloudstack database?
>>>
>>> Hello,
>>>
>>> I was tring migrate vm to another cluster using storage migration
>>> option in Cloudstack 4.3.1.
>>> unfortuanatly now it got stuck at migrating stage and don't know how
>>> to recover.
>>>
>>> since it is test environment we can remove it from database.
>>> Does anyone knows how to cleanup VM entry from cloudstack and its
>>> database?
>>>
>>> Thanks,
>>> Tejas
>>>
>>>
>>
Re: AW: Shared Storage for VMs
Posted by Lee Webb <nu...@gmail.com>.
On 15/12/2014 6:45 PM, "Jochim, Ingo" <In...@bautzen-it.de> wrote:
>
> Hello Lee,
>
> thanks for sharing your ideas.
> In this scenario someone needs to administer the NAS and handle all
requests, right?
Yes, that's correct
>
> In the case you have a little VM which shares the storage then all
traffic will go through this VM and not directly to the storage.
Also correct.
If your using a physical vlan and shared network then this can be a
physical nas or San device though - this is what I'm doing at the moment
>
> Is there a standard to communicate to different storage systems for
managing volumes/shares?
I'm not aware of one used to manage storage devices.
The underlying protocols to access the storage are standard though
depending on what you choose (nfs, iscsi etc)
If you want customers to manage their own acls etc in a vm then something
like an open filer template might be perfect and allows them to use
allocated cs resources normally
>
> Regards,
> Ingo
>
> -----Ursprüngliche Nachricht-----
> Von: Lee Webb [mailto:nullify005@gmail.com]
> Gesendet: Samstag, 13. Dezember 2014 02:46
> An: users@cloudstack.apache.org
> Betreff: Re: Shared Storage for VMs
>
> I have this requirement for some of the applications deployed in CS too
>
> Workaround solution (of sorts) was to create a Shared Network attached to
a Physical VLAN & then hook up a Physical NAS to the same VLAN.
> The shared network is bound to a particular account / project so that it
can't be used by everyone
>
> For me part of the attraction of using CS over OpenStack was that you
could craft the network in this way so that you an support applications /
deployments which have physical device requirements or haven't been
developed to be 100% cloudy.
>
> I notice that OpenStack is looking into a shared volume system, & I'd
also like the option of doing it 100% inside of CS if it was capable of
doing so.
>
> I do recall though that in XenServer (& ESX 4 I think) it wasn't possible
to attach a single volume to multiple machines without significant hacking
of the underlying Python - after which building things like an Oracle RAC /
GRID system or OCFS2 was possible but this is probably out of reach for
most users.
>
> Perhaps something like a Virtual NAS VM like the Virtual Routers etc.
would be sufficient - think OpenFiler but inside of CS?
>
> On Fri, Dec 12, 2014 at 10:10 PM, Jochim, Ingo <In...@bautzen-it.de>
> wrote:
> >
> > But this is completely outside of CS. I prefer to have something
> > controlled by CS to have centralized management and quota/usage
> > functionality.
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Alessandro Caviglione [mailto:c.alessandro@gmail.com]
> > Gesendet: Freitag, 12. Dezember 2014 11:44
> > An: users@cloudstack.apache.org
> > Betreff: Re: Shared Storage for VMs
> >
> > Just use a Unified Storage and export volumes to VMs...
> >
> > On Fri, Dec 12, 2014 at 11:39 AM, Andrija Panic
> > <an...@gmail.com>
> > wrote:
> >
> > > Drbd and gfs2 or something?
> > >
> > > Sent from Google Nexus 4
> > > On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de>
> > > wrote:
> > >
> > > > Hi all,
> > > >
> > > > I'd like to discuss my feature request for having shared storage
> > > > for several virtual machines controlled by ACS.
> > > > https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> > > > Any ideas about this? Are there workarounds which I can used today?
> > > >
> > > > Many thanks in advance.
> > > > Regards,
> > > > Ingo
> > > >
> > >
> >
> > --
> > This email was Virus checked by Astaro Security Gateway.
> > http://www.sophos.com
> >
>
> --
> This email was Virus checked by Astaro Security Gateway.
http://www.sophos.com
AW: Shared Storage for VMs
Posted by "Jochim, Ingo" <In...@bautzen-it.de>.
Hello Lee,
thanks for sharing your ideas.
In this scenario someone needs to administer the NAS and handle all requests, right?
In the case you have a little VM which shares the storage then all traffic will go through this VM and not directly to the storage.
Is there a standard to communicate to different storage systems for managing volumes/shares?
Regards,
Ingo
-----Ursprüngliche Nachricht-----
Von: Lee Webb [mailto:nullify005@gmail.com]
Gesendet: Samstag, 13. Dezember 2014 02:46
An: users@cloudstack.apache.org
Betreff: Re: Shared Storage for VMs
I have this requirement for some of the applications deployed in CS too
Workaround solution (of sorts) was to create a Shared Network attached to a Physical VLAN & then hook up a Physical NAS to the same VLAN.
The shared network is bound to a particular account / project so that it can't be used by everyone
For me part of the attraction of using CS over OpenStack was that you could craft the network in this way so that you an support applications / deployments which have physical device requirements or haven't been developed to be 100% cloudy.
I notice that OpenStack is looking into a shared volume system, & I'd also like the option of doing it 100% inside of CS if it was capable of doing so.
I do recall though that in XenServer (& ESX 4 I think) it wasn't possible to attach a single volume to multiple machines without significant hacking of the underlying Python - after which building things like an Oracle RAC / GRID system or OCFS2 was possible but this is probably out of reach for most users.
Perhaps something like a Virtual NAS VM like the Virtual Routers etc. would be sufficient - think OpenFiler but inside of CS?
On Fri, Dec 12, 2014 at 10:10 PM, Jochim, Ingo <In...@bautzen-it.de>
wrote:
>
> But this is completely outside of CS. I prefer to have something
> controlled by CS to have centralized management and quota/usage
> functionality.
>
> -----Ursprüngliche Nachricht-----
> Von: Alessandro Caviglione [mailto:c.alessandro@gmail.com]
> Gesendet: Freitag, 12. Dezember 2014 11:44
> An: users@cloudstack.apache.org
> Betreff: Re: Shared Storage for VMs
>
> Just use a Unified Storage and export volumes to VMs...
>
> On Fri, Dec 12, 2014 at 11:39 AM, Andrija Panic
> <an...@gmail.com>
> wrote:
>
> > Drbd and gfs2 or something?
> >
> > Sent from Google Nexus 4
> > On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de>
> > wrote:
> >
> > > Hi all,
> > >
> > > I'd like to discuss my feature request for having shared storage
> > > for several virtual machines controlled by ACS.
> > > https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> > > Any ideas about this? Are there workarounds which I can used today?
> > >
> > > Many thanks in advance.
> > > Regards,
> > > Ingo
> > >
> >
>
> --
> This email was Virus checked by Astaro Security Gateway.
> http://www.sophos.com
>
--
This email was Virus checked by Astaro Security Gateway. http://www.sophos.com
Re: Shared Storage for VMs
Posted by Lee Webb <nu...@gmail.com>.
I have this requirement for some of the applications deployed in CS too
Workaround solution (of sorts) was to create a Shared Network attached to a
Physical VLAN & then hook up a Physical NAS to the same VLAN.
The shared network is bound to a particular account / project so that it
can't be used by everyone
For me part of the attraction of using CS over OpenStack was that you could
craft the network in this way so that you an support applications /
deployments which have physical device requirements or haven't been
developed to be 100% cloudy.
I notice that OpenStack is looking into a shared volume system, & I'd also
like the option of doing it 100% inside of CS if it was capable of doing so.
I do recall though that in XenServer (& ESX 4 I think) it wasn't possible
to attach a single volume to multiple machines without significant hacking
of the underlying Python - after which building things like an Oracle RAC /
GRID system or OCFS2 was possible but this is probably out of reach for
most users.
Perhaps something like a Virtual NAS VM like the Virtual Routers etc. would
be sufficient - think OpenFiler but inside of CS?
On Fri, Dec 12, 2014 at 10:10 PM, Jochim, Ingo <In...@bautzen-it.de>
wrote:
>
> But this is completely outside of CS. I prefer to have something
> controlled by CS to have centralized management and quota/usage
> functionality.
>
> -----Ursprüngliche Nachricht-----
> Von: Alessandro Caviglione [mailto:c.alessandro@gmail.com]
> Gesendet: Freitag, 12. Dezember 2014 11:44
> An: users@cloudstack.apache.org
> Betreff: Re: Shared Storage for VMs
>
> Just use a Unified Storage and export volumes to VMs...
>
> On Fri, Dec 12, 2014 at 11:39 AM, Andrija Panic <an...@gmail.com>
> wrote:
>
> > Drbd and gfs2 or something?
> >
> > Sent from Google Nexus 4
> > On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de>
> > wrote:
> >
> > > Hi all,
> > >
> > > I'd like to discuss my feature request for having shared storage for
> > > several virtual machines controlled by ACS.
> > > https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> > > Any ideas about this? Are there workarounds which I can used today?
> > >
> > > Many thanks in advance.
> > > Regards,
> > > Ingo
> > >
> >
>
> --
> This email was Virus checked by Astaro Security Gateway.
> http://www.sophos.com
>
AW: Shared Storage for VMs
Posted by "Jochim, Ingo" <In...@bautzen-it.de>.
But this is completely outside of CS. I prefer to have something controlled by CS to have centralized management and quota/usage functionality.
-----Ursprüngliche Nachricht-----
Von: Alessandro Caviglione [mailto:c.alessandro@gmail.com]
Gesendet: Freitag, 12. Dezember 2014 11:44
An: users@cloudstack.apache.org
Betreff: Re: Shared Storage for VMs
Just use a Unified Storage and export volumes to VMs...
On Fri, Dec 12, 2014 at 11:39 AM, Andrija Panic <an...@gmail.com>
wrote:
> Drbd and gfs2 or something?
>
> Sent from Google Nexus 4
> On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de>
> wrote:
>
> > Hi all,
> >
> > I'd like to discuss my feature request for having shared storage for
> > several virtual machines controlled by ACS.
> > https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> > Any ideas about this? Are there workarounds which I can used today?
> >
> > Many thanks in advance.
> > Regards,
> > Ingo
> >
>
--
This email was Virus checked by Astaro Security Gateway. http://www.sophos.com
Re: Shared Storage for VMs
Posted by Alessandro Caviglione <c....@gmail.com>.
Just use a Unified Storage and export volumes to VMs...
On Fri, Dec 12, 2014 at 11:39 AM, Andrija Panic <an...@gmail.com>
wrote:
> Drbd and gfs2 or something?
>
> Sent from Google Nexus 4
> On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de>
> wrote:
>
> > Hi all,
> >
> > I'd like to discuss my feature request for having shared storage for
> > several virtual machines controlled by ACS.
> > https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> > Any ideas about this? Are there workarounds which I can used today?
> >
> > Many thanks in advance.
> > Regards,
> > Ingo
> >
>
Re: Shared Storage for VMs
Posted by Andrija Panic <an...@gmail.com>.
Drbd and gfs2 or something?
Sent from Google Nexus 4
On Dec 12, 2014 10:00 AM, "Jochim, Ingo" <In...@bautzen-it.de> wrote:
> Hi all,
>
> I'd like to discuss my feature request for having shared storage for
> several virtual machines controlled by ACS.
> https://issues.apache.org/jira/browse/CLOUDSTACK-7970
> Any ideas about this? Are there workarounds which I can used today?
>
> Many thanks in advance.
> Regards,
> Ingo
>
Shared Storage for VMs
Posted by "Jochim, Ingo" <In...@bautzen-it.de>.
Hi all,
I'd like to discuss my feature request for having shared storage for several virtual machines controlled by ACS.
https://issues.apache.org/jira/browse/CLOUDSTACK-7970
Any ideas about this? Are there workarounds which I can used today?
Many thanks in advance.
Regards,
Ingo
RE: How to remove VM entry from CloudStack database?
Posted by Vadim Kimlaychuk <Va...@Elion.ee>.
Tejas,
"Stopped" and "Destroyed" are "visible" statuses of VM at dashboard as well as "Expunding". You should put "Expunded" for the VM not to be visible. Entirely removing the raw in DB is not good option. CS does not ever remove data for VM-s being destroyed and expunded - they always remain at database.
Vadim.
-----Original Message-----
From: Tejas Sheth [mailto:tsheth.p@gmail.com]
Sent: Friday, December 12, 2014 9:01 AM
To: users@cloudstack.apache.org
Subject: Re: How to remove VM entry from CloudStack database?
Hi,
I have tried to change the vm_instance table state value to "Stopped" and "Destroied" but i was nither able to start nor destroy vm. so finally i removed entire row of that perticular VM and finally that VM was removed from instance deshboard.
can anyone suggest that in order to complete cleanup activity do we need to delete any other entry from anyother table?
Thanks,
Tejas
On Fri, Dec 12, 2014 at 8:30 AM, Tejas Sheth <ts...@gmail.com> wrote:
>
> Hello,
>
> Its not in production so i can test the DB modification, Let me try
> to modify VM entry from vm_instance table and I'll let you guyz know
> the result.
>
> Thanks,
> Tejas
>
> On Fri, Dec 12, 2014 at 5:45 AM, Matthew Midgett <
> cloudstck@trick-solutions.com.invalid> wrote:
>
>> I have phpmyadmin running on my MariaDB server as I am no sql expert.
>> Then is cloud > vm_instance and change the state be editing the row
>> for the VM ID that you need to Stopped, Destroyed or Expunging
>>
>> Not responsible for your actions :)
>>
>> Matthew Midgett
>> Trick Solutions
>> 143 Jenny Marie Rd
>> Mooresville NC,28115
>> 336-618-7425 Office
>> 704-728-5644 Cell
>> www.trick-solutions.com
>>
>> CONFIDENTIAL: This electronic mail, including any attachment(s) may
>> contain information that is privileged, confidential, and/or
>> otherwise protected from disclosure to anyone other than its intended recipient(s).
>> Any dissemination or use of this electronic email or its contents
>> (including any attachments) by persons other than the intended
>> recipient(s) is strictly prohibited. If you have received this
>> message in error, please notify me immediately by reply email so that
>> I may correct my internal records. Please then delete the original
>> message (including any
>> attachments) in its entirety. Thank you.
>>
>>
>>
>> -----Original Message-----
>> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
>> Sent: Thursday, December 11, 2014 9:20 AM
>> To: users@cloudstack.apache.org
>> Subject: How to remove VM entry from cloudstack database?
>>
>> Hello,
>>
>> I was tring migrate vm to another cluster using storage migration
>> option in Cloudstack 4.3.1.
>> unfortuanatly now it got stuck at migrating stage and don't know how
>> to recover.
>>
>> since it is test environment we can remove it from database.
>> Does anyone knows how to cleanup VM entry from cloudstack and its
>> database?
>>
>> Thanks,
>> Tejas
>>
>>
>
Re: How to remove VM entry from CloudStack database?
Posted by Tejas Sheth <ts...@gmail.com>.
Hi,
I have tried to change the vm_instance table state value to "Stopped" and
"Destroied" but i was nither able to start nor destroy vm. so finally i
removed entire row of that perticular VM and finally that VM was removed
from instance deshboard.
can anyone suggest that in order to complete cleanup activity do we need
to delete any other entry from anyother table?
Thanks,
Tejas
On Fri, Dec 12, 2014 at 8:30 AM, Tejas Sheth <ts...@gmail.com> wrote:
>
> Hello,
>
> Its not in production so i can test the DB modification, Let me try to
> modify VM entry from vm_instance table and I'll let you guyz know the
> result.
>
> Thanks,
> Tejas
>
> On Fri, Dec 12, 2014 at 5:45 AM, Matthew Midgett <
> cloudstck@trick-solutions.com.invalid> wrote:
>
>> I have phpmyadmin running on my MariaDB server as I am no sql expert.
>> Then is cloud > vm_instance and change the state be editing the row for the
>> VM ID that you need to Stopped, Destroyed or Expunging
>>
>> Not responsible for your actions :)
>>
>> Matthew Midgett
>> Trick Solutions
>> 143 Jenny Marie Rd
>> Mooresville NC,28115
>> 336-618-7425 Office
>> 704-728-5644 Cell
>> www.trick-solutions.com
>>
>> CONFIDENTIAL: This electronic mail, including any attachment(s) may
>> contain information that is privileged, confidential, and/or otherwise
>> protected from disclosure to anyone other than its intended recipient(s).
>> Any dissemination or use of this electronic email or its contents
>> (including any attachments) by persons other than the intended recipient(s)
>> is strictly prohibited. If you have received this message in error, please
>> notify me immediately by reply email so that I may correct my internal
>> records. Please then delete the original message (including any
>> attachments) in its entirety. Thank you.
>>
>>
>>
>> -----Original Message-----
>> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
>> Sent: Thursday, December 11, 2014 9:20 AM
>> To: users@cloudstack.apache.org
>> Subject: How to remove VM entry from cloudstack database?
>>
>> Hello,
>>
>> I was tring migrate vm to another cluster using storage migration
>> option in Cloudstack 4.3.1.
>> unfortuanatly now it got stuck at migrating stage and don't know how to
>> recover.
>>
>> since it is test environment we can remove it from database.
>> Does anyone knows how to cleanup VM entry from cloudstack and its
>> database?
>>
>> Thanks,
>> Tejas
>>
>>
>
Re: How to remove VM entry from CloudStack database?
Posted by Tejas Sheth <ts...@gmail.com>.
Hello,
Its not in production so i can test the DB modification, Let me try to
modify VM entry from vm_instance table and I'll let you guyz know the
result.
Thanks,
Tejas
On Fri, Dec 12, 2014 at 5:45 AM, Matthew Midgett <
cloudstck@trick-solutions.com.invalid> wrote:
> I have phpmyadmin running on my MariaDB server as I am no sql expert. Then
> is cloud > vm_instance and change the state be editing the row for the VM
> ID that you need to Stopped, Destroyed or Expunging
>
> Not responsible for your actions :)
>
> Matthew Midgett
> Trick Solutions
> 143 Jenny Marie Rd
> Mooresville NC,28115
> 336-618-7425 Office
> 704-728-5644 Cell
> www.trick-solutions.com
>
> CONFIDENTIAL: This electronic mail, including any attachment(s) may
> contain information that is privileged, confidential, and/or otherwise
> protected from disclosure to anyone other than its intended recipient(s).
> Any dissemination or use of this electronic email or its contents
> (including any attachments) by persons other than the intended recipient(s)
> is strictly prohibited. If you have received this message in error, please
> notify me immediately by reply email so that I may correct my internal
> records. Please then delete the original message (including any
> attachments) in its entirety. Thank you.
>
>
>
> -----Original Message-----
> From: Tejas Sheth [mailto:tsheth.p@gmail.com]
> Sent: Thursday, December 11, 2014 9:20 AM
> To: users@cloudstack.apache.org
> Subject: How to remove VM entry from cloudstack database?
>
> Hello,
>
> I was tring migrate vm to another cluster using storage migration option
> in Cloudstack 4.3.1.
> unfortuanatly now it got stuck at migrating stage and don't know how to
> recover.
>
> since it is test environment we can remove it from database.
> Does anyone knows how to cleanup VM entry from cloudstack and its database?
>
> Thanks,
> Tejas
>
>