You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Maurice Lawler <ma...@me.com> on 2013/06/27 09:30:38 UTC

system VMS stuck in 'Starting' state.

Hello,

How can I manipulate the database to tell CS that the system VMS are stopped and not 'Starting' along with that; once stopped I can then either restart them and or destroy and let then system recreate, correct?

Re: system VMS stuck in 'Starting' state.

Posted by Ahmad Emneina <ae...@gmail.com>.
In the case below, the ID is the ID column/reference and not uuid.

Ahmad

On Jun 27, 2013, at 12:25 PM, France <ma...@isg.si> wrote:

> Just do a select * and look at the data. I found mine by name.
> Everything else should be clear to you then.
> If not, learn basic SQL.
> 
> On Jun 27, 2013, at 8:02 PM, Maurice Lawler wrote:
> 
>> Is ‘ID’ the UUID, the long string of letters/numbers. If not, how would I get the correct ID?
>> 
>> 
>> 
>> - Maurice
>> On Jun 27, 2013, at 3:16 AM, France <ma...@isg.si> wrote:
>> 
>>> Your assumptions are correct.
>>> 
>>> I've done it like this. Ofcourse you must select appropriate status:
>>> use cloud
>>> update vm_instance set state='Running' where id='293';
>>> 
>>> Regards,
>>> F.
>>> 
>>> On 27/6/13 9:30 AM, Maurice Lawler wrote:
>>>> Hello,
>>>> 
>>>> How can I manipulate the database to tell CS that the system VMS are stopped and not 'Starting' along with that; once stopped I can then either restart them and or destroy and let then system recreate, correct?
>> 
> 

Re: system VMS stuck in 'Starting' state.

Posted by France <ma...@isg.si>.
Just do a select * and look at the data. I found mine by name.
Everything else should be clear to you then.
If not, learn basic SQL.

On Jun 27, 2013, at 8:02 PM, Maurice Lawler wrote:

> Is ‘ID’ the UUID, the long string of letters/numbers. If not, how would I get the correct ID?
> 
> 
> 
> - Maurice
> On Jun 27, 2013, at 3:16 AM, France <ma...@isg.si> wrote:
> 
>> Your assumptions are correct.
>> 
>> I've done it like this. Ofcourse you must select appropriate status:
>> use cloud
>> update vm_instance set state='Running' where id='293';
>> 
>> Regards,
>> F.
>> 
>> On 27/6/13 9:30 AM, Maurice Lawler wrote:
>>> Hello,
>>> 
>>> How can I manipulate the database to tell CS that the system VMS are stopped and not 'Starting' along with that; once stopped I can then either restart them and or destroy and let then system recreate, correct?
> 


Re: system VMS stuck in 'Starting' state.

Posted by Maurice Lawler <ma...@me.com>.
Is ‘ID’ the UUID, the long string of letters/numbers. If not, how would I get the correct ID?



- Maurice
On Jun 27, 2013, at 3:16 AM, France <ma...@isg.si> wrote:

> Your assumptions are correct.
> 
> I've done it like this. Ofcourse you must select appropriate status:
> use cloud
> update vm_instance set state='Running' where id='293';
> 
> Regards,
> F.
> 
> On 27/6/13 9:30 AM, Maurice Lawler wrote:
>> Hello,
>> 
>> How can I manipulate the database to tell CS that the system VMS are stopped and not 'Starting' along with that; once stopped I can then either restart them and or destroy and let then system recreate, correct?


Re: system VMS stuck in 'Starting' state.

Posted by France <ma...@isg.si>.
Your assumptions are correct.

I've done it like this. Ofcourse you must select appropriate status:
use cloud
update vm_instance set state='Running' where id='293';

Regards,
F.

On 27/6/13 9:30 AM, Maurice Lawler wrote:
> Hello,
>
> How can I manipulate the database to tell CS that the system VMS are stopped and not 'Starting' along with that; once stopped I can then either restart them and or destroy and let then system recreate, correct?