Mailing-List: contact dev-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cloudstack.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; c=simple; d=isg.si; h=message-id:date
	:from:mime-version:to:cc:subject:references:in-reply-to
	:content-type:content-transfer-encoding; q=dns; s=postfix; b=yWU
	l5UGxq8xL4HOi9/ZbcWDsHb1sO+J49WTIqHMBzOtS2V0ADtDiyDyjoY4zht3l9qv
	q3y7BEsOlFLy//9jvnrZQn6JfJoqu1r+d1k/1WZldd4bZnbqhq+RzD0yuKMWw73s
	bn8V19CLOG70D4Z+1ZhHrrJSUuUiWGM8aPDdGL08=
Message-ID: <51CBF4D2.6050707@isg.si>
Date: Thu, 27 Jun 2013 10:16:18 +0200
From: France <mailinglists@isg.si>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6;
 rv:17.0) Gecko/20130620 Thunderbird/17.0.7
MIME-Version: 1.0
To: dev@cloudstack.apache.org
CC: Maurice Lawler <maurice.lawler@me.com>
Subject: Re: system VMS stuck in 'Starting' state.
References: <4k52i2wvmlp8y9b86ei1k5a2.1372318238073@email.android.com>
In-Reply-To: <4k52i2wvmlp8y9b86ei1k5a2.1372318238073@email.android.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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?