Hi Steffen,<div><br></div><div>Looks like you are right, a migration failed and somehow left the history records corrupted.</div><div><br></div><div>If you only need to be able to migrate, change the reason of history 7 to '<REASON>3</REASON>'. To do so, stop opennebula, do a DB backup, and update the body column of the history table. As I said, do this for history with SEQ 7.</div>
<div><br></div><div>The history seq. 8 is completely uninitialized, all the timestamps are 0, and that will show strangely in the accounting. But if you just need to migrate, changing the history 7 reason should be enough.</div>
<div><br></div><div>Regards</div><div>--<br>Carlos Martín, MSc<br>Project Engineer<br>OpenNebula - The Open-source Solution for Data Center Virtualization<div><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="http://www.OpenNebula.org" target="_blank">www.OpenNebula.org</a> | <a href="mailto:cmartin@opennebula.org" target="_blank">cmartin@opennebula.org</a> | <a href="http://twitter.com/opennebula" target="_blank">@OpenNebula</a></span><span style="border-collapse:collapse;color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px"><a href="mailto:cmartin@opennebula.org" style="color:rgb(42,93,176)" target="_blank"></a></span></div>
<br>
<br><br><div class="gmail_quote">On Tue, Sep 25, 2012 at 10:05 AM, Steffen Neumann <span dir="ltr"><<a href="mailto:sneumann@ipb-halle.de" target="_blank">sneumann@ipb-halle.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
sorry for replying to self. I found a thread from august this year,<br>
<a href="http://comments.gmane.org/gmane.comp.distributed.opennebula.user/7554" target="_blank">http://comments.gmane.org/gmane.comp.distributed.opennebula.user/7554</a><br>
which I missed in my earlier searches, where Shantanu Pavgi suggests<br>
to clean the history and vm_pool tables.<br>
<br>
To avoid messing this up, which entries in history do I sql delete ?<br>
<div class="im"> SEQ HOSTNAME REASON START TIME PTIME<br>
0 node-blc28 user 08/15 13:07:13 40 02:47:35 00 00:00:15<br>
1 node-cc08d5 none 09/24 15:54:48 00 17:40:19 00 00:00:00<br>
2 node-blc28 user 09/24 15:54:48 00 00:01:22 00 00:00:00<br>
3 node-cc08d5 none 09/24 15:56:10 00 17:38:57 00 00:00:00<br>
4 node-blc28 user 09/24 15:56:10 00 00:20:27 00 00:00:00<br>
5 node-blc07 none 09/24 16:16:37 00 17:18:30 00 00:00:00<br>
6 node-blc28 user 09/24 16:16:37 00 00:28:09 00 00:00:00<br>
7 node-blc02 none 09/24 16:44:46 00 16:50:21 00 00:00:00<br>
8 node-blc28 none - 268 07:35:0 00 00:00:00<br>
<br>
</div>So do I delete just SEQ 7 ?<br>
<br>
What do I replace in VM_POOL ?<br>
Here the <HISTORY> in column body seems to list only <SEQ>8</SEQ> ?<br>
<br>
Yours,<br>
Steffen<br>
<br>
<VM><ID>1004</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>one-1004</NAME><LAST_POLL>1348559422</LAST_POLL><STATE>3</STATE><LCM_STATE>3</LCM_STATE><STIME>1345028806</STIME><ETIME>0</ETIME><DEPLOY_ID>one-1004</DEPLOY_ID><MEMORY>33554432</MEMORY><CPU>431</CPU><NET_TX>2015720310</NET_TX><NET_RX>559760171</NET_RX><TEMPLATE><CPU><![CDATA[8.0]]></CPU><DISK><DISK_ID><![CDATA[0]]></DISK_ID><FILES><![CDATA[/cumulus/goldenimages/suse113/init.sh]]></FILES><READONLY><![CDATA[no]]></READONLY><SOURCE><![CDATA[/cumulus/goldenimages/suse113/suse113.img]]></SOURCE><TARGET><![CDATA[hda]]></TARGET></DISK><FEATURES><ACPI><![CDATA[yes]]></ACPI></FEATURES><GRAPHICS><LISTEN><![CDATA[0.0.0.0]]></LISTEN><PORT><![CDATA[6904]]></PORT><TYPE><![CDATA[vnc]]></TYPE></GRAPHICS><MEMORY><![CDATA[32768]]></MEMORY><NAME><![CDATA[one-1004]]></NAME><NIC><BRIDGE><![CDATA[br0]]></BRIDGE><IP><![CDATA[10.20.2.30]]></IP><MAC><![CDATA[02:00:0a:14:02:1e]]></MAC><MODEL><![CDATA[virtio]]><br>
</MODEL><NETWORK><![CDATA[VNET202]]></NETWORK><NETWORK_ID><![CDATA[3]]></NETWORK_ID></NIC><NIC><BRIDGE><![CDATA[br1]]></BRIDGE><IP><![CDATA[10.21.2.30]]></IP><MAC><![CDATA[02:00:0a:15:02:1e]]></MAC><MODEL><![CDATA[virtio]]></MODEL><NETWORK><![CDATA[VNET212]]></NETWORK><NETWORK_ID><![CDATA[2]]></NETWORK_ID></NIC><OS><ARCH><![CDATA[x86_64]]></ARCH><BOOT><![CDATA[hd]]></BOOT></OS><RAW><DATA><![CDATA[<devices><serial type="pty"><source path="/dev/pts/5"/><target port="0"/></serial><console type="pty" tty="/dev/pts/5"><br>
<div class="im"><source path="/dev/pts/5"/><target<br>
</div>port="0"/></console></devices>]]></DATA><TYPE><![CDATA[kvm]]></TYPE></RAW><TEMPLATE_ID><![CDATA[1]]></TEMPLATE_ID><br>
<VCPU><![CDATA[8]]></VCPU><VMID><![CDATA[1004]]></VMID></TEMPLATE><HISTORY_RECORDS><br>
<HISTORY><SEQ>8</SEQ><HOSTNAME>node-blc28</HOSTNAME><VM_DIR>/cumulus/one/var/</VM_DIR><HID>37</HID><STIME>0</STIME><ETIME>0</ETIME><VMMMAD>vmm_kvm</VMMMAD><TMMAD>tm_shared</TMMAD><PSTIME>0</PSTIME><PETIME>0</PETIME><RSTIME>0</RSTIME><RETIME>0</RETIME><ESTIME>0</ESTIME><EETIME>0</EETIME><REASON>0</REASON></HISTORY></HISTORY_RECORDS><br>
</VM><br>
<div class="HOEnZb"><div class="h5"><br>
<br>
<br>
On Tue, 2012-09-25 at 09:44 +0200, Steffen Neumann wrote:<br>
> Hi,<br>
><br>
> I have a working one-3.0 cluster, and for upgrading to 3.6<br>
> I need to move around VMs. The cluster has been up and<br>
> running for about a year now.<br>
><br>
> At least two VMs on one host are stubbornly refusing<br>
> to live-migrate:<br>
><br>
> oneadmin@cumulus:~$ onevm livemigrate 1004 55<br>
> [VirtualMachineDeploy] Wrong state to perform action<br>
><br>
> As the machine is RUNNING, I can ssh into it,<br>
> I am a bit at a loss here. Only strange thing is<br>
> that current VM monitoring reports "Net_TX: -1"<br>
> which happens since August 17th.<br>
><br>
> Any idea ?<br>
><br>
> <jfontan> sneumann: can you send onevm show of that machine to the mailing list?<br>
> <jfontan> sneumann: there could be something wrong with the history and my pals may know what it is<br>
><br>
> onehost list:<br>
> ID NAME RVM TCPU FCPU ACPU TMEM FMEM AMEM STAT<br>
> 55 node-blc02 3 2400 2393 0 94.6G 71.6G 46.6G on<br>
> 37 node-blc28 2 2400 766 800 94.6G 48.7G 30.6G on<br>
> ...<br>
><br>
> onevm show 1004:<br>
> VIRTUAL MACHINE 1004 INFORMATION<br>
> ID : 1004<br>
> NAME : one-1004<br>
> USER : oneadmin<br>
> GROUP : oneadmin<br>
> STATE : ACTIVE<br>
> LCM_STATE : RUNNING<br>
> HOSTNAME : node-blc28<br>
> START TIME : 08/15 13:06:46<br>
> END TIME : -<br>
> DEPLOY ID : one-1004<br>
><br>
> VIRTUAL MACHINE MONITORING<br>
> USED MEMORY : 33554432<br>
> NET_TX : 2015720310<br>
> USED CPU : 431<br>
> NET_RX : 559760171<br>
><br>
> VIRTUAL MACHINE TEMPLATE<br>
> CPU=8.0<br>
> DISK=[<br>
> DISK_ID=0,<br>
> FILES=/cumulus/goldenimages/suse113/init.sh,<br>
> READONLY=no,<br>
> SOURCE=/cumulus/goldenimages/suse113/suse113.img,<br>
> TARGET=hda ]<br>
> FEATURES=[<br>
> ACPI=yes ]<br>
> GRAPHICS=[<br>
> LISTEN=0.0.0.0,<br>
> PORT=6904,<br>
> TYPE=vnc ]<br>
> MEMORY=32768<br>
> NAME=one-1004<br>
> NIC=[<br>
> BRIDGE=br0,<br>
> IP=10.20.2.30,<br>
> MAC=02:00:0a:14:02:1e,<br>
> MODEL=virtio,<br>
> NETWORK=VNET202,<br>
> NETWORK_ID=3 ]<br>
> NIC=[<br>
> BRIDGE=br1,<br>
> IP=10.21.2.30,<br>
> MAC=02:00:0a:15:02:1e,<br>
> MODEL=virtio,<br>
> NETWORK=VNET212,<br>
> NETWORK_ID=2 ]<br>
> OS=[<br>
> ARCH=x86_64,<br>
> BOOT=hd ]<br>
> RAW=[<br>
> DATA="<devices><serial type=\"pty\"><source path=\"/dev/pts/5\"/><target port=\"0\"/></serial><console type=\"pty\" tty=\"/dev/pts/5\"><source path=\"/dev/pts/5\"/><target port=\"0\"/></console></devices>",<br>
> TYPE=kvm ]<br>
> TEMPLATE_ID=1<br>
> VCPU=8<br>
> VMID=1004<br>
><br>
> VIRTUAL MACHINE HISTORY<br>
> SEQ HOSTNAME REASON START TIME PTIME<br>
> 0 node-blc28 user 08/15 13:07:13 40 02:47:35 00 00:00:15<br>
> 1 node-cc08d5 none 09/24 15:54:48 00 17:40:19 00 00:00:00<br>
> 2 node-blc28 user 09/24 15:54:48 00 00:01:22 00 00:00:00<br>
> 3 node-cc08d5 none 09/24 15:56:10 00 17:38:57 00 00:00:00<br>
> 4 node-blc28 user 09/24 15:56:10 00 00:20:27 00 00:00:00<br>
> 5 node-blc07 none 09/24 16:16:37 00 17:18:30 00 00:00:00<br>
> 6 node-blc28 user 09/24 16:16:37 00 00:28:09 00 00:00:00<br>
> 7 node-blc02 none 09/24 16:44:46 00 16:50:21 00 00:00:00<br>
> 8 node-blc28 none - 268 07:35:0 00 00:00:00<br>
><br>
><br>
> oned.log:<br>
> Tue Sep 25 09:35:37 2012 [ReM][D]: HostPoolInfo method invoked<br>
> Tue Sep 25 09:35:37 2012 [ReM][D]: VirtualMachinePoolInfo method invoked<br>
> Tue Sep 25 09:35:37 2012 [ReM][D]: AclInfo method invoked<br>
> Tue Sep 25 09:35:50 2012 [ReM][D]: VirtualMachineInfo method invoked<br>
> Tue Sep 25 09:35:50 2012 [ReM][D]: VirtualMachineDeploy method invoked<br>
> Tue Sep 25 09:35:50 2012 [ReM][E]: [VirtualMachineDeploy] Wrong state to perform action<br>
><br>
><br>
> 1004/vm.log:<br>
> Tue Sep 25 09:30:22 2012 [VMM][D]: Monitor Information:<br>
> CPU : 431<br>
> Memory: 33554432<br>
> Net_TX: -1<br>
> Net_RX: -1<br>
><br>
><br>
<br>
--<br>
IPB Halle AG Massenspektrometrie & Bioinformatik<br>
Dr. Steffen Neumann <a href="http://www.IPB-Halle.DE" target="_blank">http://www.IPB-Halle.DE</a><br>
Weinberg 3 <a href="http://msbi.bic-gh.de" target="_blank">http://msbi.bic-gh.de</a><br>
06120 Halle Tel. <a href="tel:%2B49%20%280%29%20345%205582%20-%201470" value="+4934555821470">+49 (0) 345 5582 - 1470</a><br>
<a href="tel:%2B49%20%280%29%20345%205582%20-%200" value="+4934555820">+49 (0) 345 5582 - 0</a><br>
sneumann(at)IPB-Halle.DE Fax. <a href="tel:%2B49%20%280%29%20345%205582%20-%201409" value="+4934555821409">+49 (0) 345 5582 - 1409</a><br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</a><br>
<a href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org" target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
</div></div></blockquote></div><br></div>