<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Rubén,<br>
<br>
El 18/06/14 15:36, Ruben S. Montero escribió:<br>
</div>
<blockquote
cite="mid:CAGi56tccTgWgxASB02e3uvH6cT2g6TZvqBRV9v9dZRGVBO1MUA@mail.gmail.com"
type="cite">
<div dir="ltr">Hi,
<div><br>
</div>
<div>It seems more related to an optimization of the mysql
server rather than a problem because of the update process. Yo
may try to check the database size, and maybe try purge the
binary logs or optimize the tables. <br>
</div>
</div>
</blockquote>
<br>
Yes. You were right. The tables optimization seemed to do the trick
:-)<br>
It works perfect now!.<br>
<br>
Thank you very much <br>
<br>
<blockquote
cite="mid:CAGi56tccTgWgxASB02e3uvH6cT2g6TZvqBRV9v9dZRGVBO1MUA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
<div>Cheers</div>
<div><br>
</div>
<div><br>
</div>
<div>Ruben</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jun 18, 2014 at 11:43 AM,
Fernando Durá <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Fernando.Dura@uv.es" target="_blank">Fernando.Dura@uv.es</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
We tried to update to 4.6.2 from 4.6.0-1 (Debian Wheezy
system with<br>
packages obtained from <a moz-do-not-send="true"
href="http://opennebula.org" target="_blank">opennebula.org</a>),
and MySql database. The<br>
opennebula database wasn't upgraded (no "onedb upgrade..."),
as it<br>
wasn't needed, as stated in the upgrade instructions.<br>
<br>
The upgrade went apparently well, but when we tried to start
a vm via<br>
sunstone it got stuck in "boot" state, even when we checked
with "onevm<br>
top". But this wasn't the real state as we were able to
connect to the<br>
vm vía ssh (so, the vm was really running).<br>
<br>
Looking to the logs, we saw lots of messages like:<br>
<br>
Tue Jun 17 13:15:17 2014 [ONE][E]: SQL command was: REPLACE
INTO<br>
vm_monitoring (vmid, last_poll, body),...<br>
... (lots of stuff)... error 1205 : Lock wait timeout
exceeded; try<br>
restarting transaction<br>
<br>
Moreover, when we noticed that , after stopping opennebula,
a<br>
"/etc/init.d/mysql stop" needed a couple of minutes (instead
of just a<br>
few seconds).<br>
<br>
We went back to 4.6.0 and both problems dissapeared.<br>
<br>
Is this a known problem with the update? Are we missing
something? Any<br>
suggestions?<br>
<br>
Thank you for your help.<br>
Best regards.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Fernando Durá Colomina e-mail:
<a moz-do-not-send="true"
href="mailto:Fernando.Dura@uv.es">Fernando.Dura@uv.es</a><br>
Servei d'Informàtica; Univ.de València Tel:
<a moz-do-not-send="true"
href="tel:%2B34%2096%20354%2043%2010"
value="+34963544310">+34 96 354 43 10</a><br>
E-46100 Burjassot (Valencia) - SPAIN<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org"
target="_blank">http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</a><br>
</font></span></blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<div>
<div>-- <br>
</div>
</div>
Ruben S. Montero, PhD<br>
Project co-Lead and Chief Architect
<div>OpenNebula - Flexible Enterprise Cloud Made Simple<br>
<a moz-do-not-send="true" href="http://www.OpenNebula.org"
target="_blank">www.OpenNebula.org</a> | <a
moz-do-not-send="true"
href="mailto:rsmontero@opennebula.org" target="_blank">rsmontero@opennebula.org</a>
| @OpenNebula</div>
</div>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Fernando Durá Colomina e-mail: <a class="moz-txt-link-abbreviated" href="mailto:Fernando.Dura@uv.es">Fernando.Dura@uv.es</a>
Servei d'Informàtica; Univ.de València Tel: +34 96 354 43 10
E-46100 Burjassot (Valencia) - SPAIN
</pre>
</body>
</html>