Hi,<div><br></div><div>I saw in your other email that you fixed the migration, nevertheless this sql error is a bug that will be fixed in the next release [1].</div><div>The error message is unrelated to the migration action, and can be ignored as it does not really introduce any problem.</div>
<div><br></div><div>Cheers</div><div><br></div><div>[1] <a href="http://dev.opennebula.org/issues/1374">http://dev.opennebula.org/issues/1374</a></div><div><br clear="all">--<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, Jul 17, 2012 at 5:50 PM, Jan Benadik <span dir="ltr"><<a href="mailto:jan.benadik@atos.net" target="_blank">jan.benadik@atos.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hi all,<br>
<br>
I have two nodes with Ubuntu 12.04 Server (KVM) , OpenNebula 3.6.0
(SQLite), shared datastore (NFS), a small number of VM running on
that. If I try to run live migration (via Sunstone), nothing happens
and this error message in oned.log appears :<br>
<br>
<small>Tue Jul 17 19:33:26 2012 [ONE][E]: SQL command was: INSERT
INTO vm_monitoring (vmid, last_poll, body) VALUES
(45,1342546187,'<VM><ID>45</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>mint-occi</NAME><PERMISSIONS><OWNER_U>1</OWNER_U><OWNER_M>1</OWNER_M><OWNER_A>0</OWNER_A><GROUP_U>0</GROUP_U><GROUP_M>0</GROUP_M><GROUP_A>0</GROUP_A><OTHER_U>0</OTHER_U><OTHER_M>0</OTHER_M><OTHER_A>0</OTHER_A></PERMISSIONS><LAST_POLL>1342546187</LAST_POLL><STATE>3</STATE><LCM_STATE>3</LCM_STATE><RESCHED>0</RESCHED><STIME>1342543662</STIME><ETIME>0</ETIME><DEPLOY_ID>one-45</DEPLOY_ID><MEMORY>1048576</MEMORY><CPU>3</CPU><NET_TX>12055</NET_TX><NET_RX>752530</NET_RX><TEMPLATE><CPU><![CDATA[1]]></CPU><DISK><CLONE&
gt;<![
CDATA[YES]]></CLONE><DATASTORE><![CDATA[shared]]></DATASTORE><DATASTORE_ID><![CDATA[100]]></DATASTORE_ID><DEV_PREFIX><![CDATA[hd]]></DEV_PREFIX><DISK_ID><![CDATA[0]]></DISK_ID><IMAGE><![CDATA[mint-hd]]></IMAGE><IMAGE_ID><![CDATA[18]]></IMAGE_ID><READONLY><![CDATA[NO]]></READONLY><SAVE><![CDATA[NO]]></SAVE><SOURCE><![CDATA[/var/lib/one/datastores/100/1b68b74b00603522b21d45736092fb35]]></SOURCE><TARGET><![CDATA[hda]]></TARGET><TM_MAD><![CDATA[shared]]></TM_MAD><TYPE><![CDATA[FILE]]></TYPE></DISK><ERROR><MESSAGE><![CDATA[Error
live migrating VM: Could not migrate one-45 to
myto]]></MESSAGE><TIMESTAMP><![CDATA[Tue Jul 17
19:33:26
2012]]></TIMESTAMP></ERROR><FEATURES><ACPI><![CDATA[yes]]></ACPI></FEATURES><GRAPHICS><LISTEN><![CDATA[0.0.0.0]]></LISTEN><PORT><![CDATA[5945]]></PORT><TYPE><![CDATA[vnc]]></TYPE></GRAPHICS><INSTANCE_TYPE><![CDATA[small_64]]></INSTANCE_TYPE><MEMORY><![CDATA[1024]]></MEMORY><NAME><![CDATA[mint-occi]]></NAME><NIC><BRIDGE><![CDATA[br0]]></BRIDGE><IP><![CDATA[192.168.122.120]]></IP><MAC><![CDATA[02:00:c0:a8:7a:78]]></MAC><NETWORK><![CDATA[test-net]]></NETWORK><NETWORK_ID><![CDATA[3]]></NETWORK_ID><VLAN><![CDATA[NO]]></VLAN></NIC><OS><ARCH><![CDATA[x86_64]]></ARCH><BOOT><![CDATA[hd]]></BOOT></OS><RAW><TYPE><![CDATA[kvm]]></TYPE
></
RAW><VMID><![CDATA[45]]></VMID></TEMPLATE><HISTORY_RECORDS><HISTORY><OID>45</OID><SEQ>7</SEQ><HOSTNAME>one</HOSTNAME><HID>2</HID><STIME>1342546406</STIME><ETIME>0</ETIME><VMMMAD>vmm_kvm</VMMMAD><VNMMAD>dummy</VNMMAD><TMMAD>shared</TMMAD><DS_ID>0</DS_ID><PSTIME>0</PSTIME><PETIME>0</PETIME><RSTIME>1342546406</RSTIME><RETIME>0</RETIME><ESTIME>0</ESTIME><EETIME>0</EETIME><REASON>0</REASON></HISTORY></HISTORY_RECORDS></VM>'),
<b>error: columns vmid, last_poll are not unique</b><br>
Tue Jul 17 19:33:31 2012 [InM][I]: --Mark--</small><br>
<br>
Can somebody help me where I did something wrong?<span><font color="#888888"><br>
<br>
Jan<br>
<br>
<div>-- <br>
<font size="3" color="black" face="Verdana"> <img alt="" src="cid:part1.05080701.01080700@atos.net" width="252" height="15"><br>
<b>Ján Beňadik</b><br>
<font face="Verdana"> Managed Services - Solution
Design Architect<br>
<a href="tel:%2B421%2046%205151%20332" value="+421465151332" target="_blank">+421 46 5151 332</a><br>
<a href="tel:%2B421%20903%20691%20634" value="+421903691634" target="_blank">+421 903 691 634</a><br>
<a href="mailto://jan.benadik@atos.net" target="_blank">jan.benadik@atos.net</a><br>
Vinohradnícka 6, 971 01 Prievidza<br>
<a href="http://www.sk.atos.net" target="_blank">www.sk.atos.net</a><br>
__________________________________<br>
<br>
<img alt="" src="cid:part4.06080800.07050804@atos.net" width="261" height="58"><br>
</font> </font></div>
</font></span></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opennebula.org" target="_blank">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>
<br></blockquote></div><br></div>