[one-users] VM Failed - how to get it running.

[Carlos Martín Sánchez]

Hi,


On Fri, Jun 13, 2014 at 12:12 PM, Leszek Master <keksior at gmail.com> wrote:

> I found it in db at table vm_pool, but can't find xml inside body column.
> Could you tell me where it is exaclly ?
>

The body columns should be an string containing xml:

> select body from vm_pool;
<VM><ID>0</ID><UID>0</UID>...........</VM>

Regards
--
Carlos Martín, MSc
Project Engineer
OpenNebula - Flexible Enterprise Cloud Made Simple
www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org |
@OpenNebula <http://twitter.com/opennebula> <cmartin at opennebula.org>


>
> 2014-06-12 11:12 GMT+02:00 Carlos Martín Sánchez <cmartin at opennebula.org>:
>
> Hi,
>>
>> On Mon, Jun 9, 2014 at 8:44 AM, Leszek Master <keksior at gmail.com> wrote:
>>
>>> Isn't there any way to change this ? In DB for example?
>>>
>>>  I can't recreate this VM it's in production state.
>>>
>>
>> Well, yes, you can force the state in the DB, but that may lead to some
>> inconsistencies.
>>
>> If you want to give it a try, do the following:
>> - stop opennebula, and do a db backup  [1]
>> - change the vm state to: state 3, lcm_state 3 [2]. This needs to be done
>> in the db table columns, and the xml inside the body column.
>> - run onedb fsck [3] to fix host allocation and usage quota numbers
>>
>> Regards,
>> Carlos
>>
>> [1]
>> http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-backup
>> [2]
>> http://docs.opennebula.org/4.6/integration/system_interfaces/api.html#schemas-for-virtual-machine
>> [3]
>> http://docs.opennebula.org/4.6/administration/references/onedb.html#onedb-fsck
>>
>> --
>> Carlos Martín, MSc
>> Project Engineer
>> OpenNebula - Flexible Enterprise Cloud Made Simple
>> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org
>>  | @OpenNebula <http://twitter.com/opennebula> <cmartin at opennebula.org>
>>
>>
>>>
>>>  2014-06-02 10:56 GMT+02:00 Carlos Martín Sánchez <
>>> cmartin at opennebula.org>:
>>>
>>> Hi,
>>>>
>>>> On Fri, May 23, 2014 at 2:02 PM, Leszek Master <keksior at gmail.com>
>>>> wrote:
>>>>
>>>>> I've got 1 VM that is in the FAILED state. I've manually got it
>>>>> working and can't get it in the OpenNebula to the running state. How can i
>>>>> do that manually, from cli or db maybe?
>>>>>
>>>>
>>>> Forcing a VM state is not supported. The only option is to delete
>>>> --recreate it, but that will clear the current vm disks.
>>>>
>>>> Regards
>>>> --
>>>> Carlos Martín, MSc
>>>> Project Engineer
>>>> OpenNebula - Flexible Enterprise Cloud Made Simple
>>>> www.OpenNebula.org <http://www.opennebula.org/> |
>>>> cmartin at opennebula.org | @OpenNebula <http://twitter.com/opennebula>
>>>>
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140616/6984cc9b/attachment-0001.htm>